Oracle Database Administration
The iteration will be about learning the introduction and general concepts of Oracle DB. The iteration will serve as the introduction to which I am going to understand Oracle DB before learning more in the iterations which will follow. While learning the general concepts of I will use books, journals, and relevant magazines from the library. Additionally, I will seek help from Oracle DB experts.
My plan for the research into the area of Oracle database administration I made sure that I laid down the objective for this session so that I will monitor everything as the iteration is in progress. I planned to leverage various resources that would help me to acquire the in-depth knowledge in this area of Oracle database as a way of preparing for the subsequent iterations that would take me through the process of becoming an Oracle, administrator expert. In the first two days, I planned to carry out my personal search using various resources like journals, books, and the Web and have the knowledge of the Oracle database basics. In the third day, I will then meet the Oracle experts that will guide me through the Oracle database and clarify the areas that I would be having problems.
I planned to have the iteration run for four days between May 1, 2016, and May 5, 2016. After the research and meeting the resource persons on the first day through the third day, the fourth day is when I planned to evaluate all that I had learned and then make a plan for the second iteration and how to make a follow-up of the concepts I had learned during the session. I planned to make the most use of my time so that I would accomplish my iteration within the time specified and acquire all the knowledge as planned for in my objectives.
I planned in this iteration to acquire the concepts of relational databases, the schema objects, the data access, transaction management, the Oracle database architecture, and the Oracle database documentation architecture. These will form an introduction to the Oracle database that would prepare me for the subsequent iterations in my journey towards recombining competent in this area of Oracle database administration. I planned to have an in-depth understanding of the information system as relates to relational databases, understand what is the database management system and the elements that make the DBMS. I also planned to have the knowledge of the relational model, a brief history of the Oracle database and the differences between the hierarchical database and a network database. I also planned to gain some knowledge on the schema objects, the way data is accessed in Oracle Database and have an introduction to the Oracle architecture in a nutshell.
I came up with the objectives of the areas I wanted to tackle during this iteration. On may 2, 2016 I began my research work and collected all the materials that I would be using for the iteration to avoid confusions at the last moment. I learned about the relational databases as relates to Oracle database. I learned about the database management system and the elements that make up the same including the kernel code, the repository of metadata, and the query language that enables the applications to access the data in the Oracle database. I learned that a database application interacts with the database to access as well as manipulate the data in storage in the database. I learned about the first generation database management systems that incorporate the hierarchical and the network databases, whereby the hieratical DB organizes the data in the form of a tree structure whereas the network DB is similar to the hierarchical but it has many-to-many records.
A relational database like Oracle database is the database that conforms to the relational model, and it includes the aspects such as structures, operations and integrity rules (Price, 2004). I learned the way Oracle performs the logical operations and the physical operations and also a brief history of the Oracle database. In the Oracle database history, I learned about the major areas forming the path of its evolution. Those areas include the founding of Oracle, first commercially available RDBMS, portable version of Oracle, enhancements, PL/SQL program units, objects & partitioning, Internet computing, Oracle RAC, Grid computing, manageability, diagnosability, and availability; and Plugging into the cloud.
On May 3, 2016, I got a thorough knowledge from the journals and books concerning the schema objects such as tables and indexes. A database schema in Oracle Database is a set of logical data structures that are used to refer directly to the data in the database (Greenwald, Stackowiak & Stern, 2013). On the same date, I also learned about the way SQL is used to perform data access in the Oracle Database. I also learned about the various SQL statements that are used to perform database tasks including the PL/SQL and Java. In light of database architecture, I learned about the Oracle Instance and the Database. An instance is a collection of memory structures used to manage the database files, and it comprises the shared memory area known as the system global area and background processes (Alapati, 2005). Below is the Oracle Instance and database architecture I used as a reference.
Figure 1: Oracle instance and database. Source:Oracle.com (2016). Retrieved from https://docs.oracle.com/database/121/CNCPT/intro.htm#CNCPT-GUID-2B1BADE1-C36F-4555-9867-3B15B6CE858C
On May 4, 2016, I met the Oracle administration experts who helped to clarify many issues of what I had learned in the past two days. They also helped me learn about the qualifications that are in the requirement for one to become a professional Oracle Database Administrator and how to go about acquiring those qualifications. I also used that opportunity to make more inquiries into the area of Oracle database administration especially the areas that were not tackled well in the first two days. They also helped to explain more about the Oracle Instance and database architecture shown above. I also used this iteration to come up with a plan for the next iteration.
I observed that the understanding about Oracle is essential because it is the database that is used in many organizations. Every organization has information that should be stored and managed to meet their requirements. The database is served with the collection, storage, and retrieval of related information to be used by database applications (Haan, 2014). I also observed that the preceding DBMSs stored the data in the grid and predetermined relationships and since there was no data definition language in those days, changing the data structure was something difficult to achieve. Today the widely accepted and used data model is the relational model, and the relational databases must conform to it. As a researcher, I also observed that the major characteristic of a relational database is that it stores data as a set of simple relations. A relation in the RDBMS is said to be a set of tuples; a unordered collection of attribute values (Fernandez, 2009).
I observed that RDBMs moves the data to a database, stores it, and retrieves it for the applications to manipulate. The Oracle Database, as an RDBMS implements the object-oriented features like inheritance, polymorphism, and user-defined types, making to be referred to as object-oriented DBMS or ODBMS (Connolly & Begg, 2005). It is widely used in businesses because it extends the relational database model to from an object-oriented model that makes it possible to store numerous and complex business models. I also observed that the current version of the Oracle Database is as a result of more than 38 years of innovative development since 1977 when the actual project started. I also observed that the knowledge of SQL programming is crucial because it is the programming used in the Oracle database for data access and querying of the database. The PL/SQL and Java are also other programming languages that are useful for Oracle Database data access.
The iteration on introduction to the Oracle Database was very enriching as I got to acquire much knowledge from the same. I also got to learn and appreciate my career as an Oracle Database administrator. I learned that the Oracle DB administrators can easily get a job since the database is used in many of the companies for collection, storage and retrieval of information. The plan that I made before the onset of this iteration helped me to approach the research strategically, and that helped me to get the success that I had anticipated. I came to realize that there are many areas of Oracle Database that one should get to know so as to be well versed with the administration of this database. The lack of as much knowledge as possible on the Oracle database and SQL programming, it is not possible for one to become an effective Oracle DB administrator.
The time that I had for accomplishing this iteration was not enough since there are many things that I left out due to the issue of time. In the future, I plan to make sure that I set enough time for every activity based on the amount of knowledge that I will be expecting to garner from each of these activities. I also did not have enough time with the resource persons, and they were also not enough to comprehensively inform the research areas they were to inform. I plan to include a variety of resource persons in my future research and to have enough time with them so as to acquire as comprehensive knowledge from them as possible.
Top of Form
Top of Form
Bottom of Form
Bottom of Form
Alapati, S. R. (2005). Expert Oracle database 10g administration. Dreamtech Press.
Connolly, T. M., & Begg, C. E. (2005). Database systems: a practical approach to design, implementation, and management. Pearson Education.
Fernandez, I. (2009). Beginning Oracle Database 11g administration: From novice to professional. Berkeley, CA: Apress.
Greenwald, R., Stackowiak, R., & Stern, J. (2013). Oracle essentials: Oracle database 12c. ” O’Reilly Media, Inc.”.
Haan, L. (2014). Beginning Oracle SQL: For Oracle Database 12c. Berkeley : Apress
Price, J. (2004). Oracle database 10g SQL. Tata McGraw-Hill Education.