Second Iteration Oracle Database Programming

Spread the love

Iteration 2: Learning and Understanding of the Oracle Database Programming Concepts

Plan

Iteration involved meeting with Mark Infotech Inc experts, consultants, and professionals. The meeting involves seminars, workshops, and attending training hubs. Learning concepts of Oracle database was scheduled to take about two weeks. During the first half of week, Mr. Glen was to facilitate a training session involving working with relational databases. The session shall cover concepts dealing with how companies use databases to automate their information system (F. B. Glen, Personal Communication, May 08, 2016). During the second half of week, the training shall involve working in Mark Infotech research workshop to acquire data and information concerning database management systems (DBMS). Subtasks of the session shall involve understanding software used in controlling storage, organization, and retrieve of Data. The facilitator shall train interns on major characteristics and elements of DBMS.

During the second week, first half shall involve interns working in company innovation hub where Mrs. Ram shall guide interns on database schemas. Within the hub, interns shall be required to understand different types of schemas. It shall involve understanding languages that implement database structures and schemas. Through hub training interns shall understand how to access data as well as processing reports using database query language and commands (D. P. Ram, Personal Communication, May 10, 2016). The session shall also cover the structure of database architecture. The session shall facilitate implementation of database instances. The facilitator shall train interns on how to implement database designing, implementation of hardware, software and process within the design. Interns shall have a prototype of database models implemented in design view. The last half of iteration shall involve interns implementing physical and logical structures of a database.

Action

I took part in the second iteration involving an understanding of database. Mr. Glen facilitated understanding of various concepts involving development and implementation of databases.  Mr. Glen revealed how the relational database was organized in the form of tables containing rows and columns. The various attribute of objects and were introduced and main purposes of databases such as collecting, storing, and retrieving of data and information.  He also introduced the concepts, characteristics, and elements of database management systems. Major concepts covered during training session included

  1. Kernel code that is involved in managing memory, and storage locations in DBMS
  2. Repository metadata that involved storage information in repository sections called data dictionary
  3. Database applications including software involved in manipulating database at client side

Interns were capable of integrating various concepts in practical session thus providing go ahead to other training activities (F. B. Glen, Personal Communication, May 11, 2016).

I took part in the second week facilitated by Mrs. Ram. Through her directives, I managed to implement logical and physical schemas. Through her training in company hub, I performed various database tasks such as utilizing SQL commands that enabled me to perform the following tasks

  1. Insert, update and delete lows in a table.
  2. Create, replace, alter and drop objects
  3. Control access to database and its objects
  4. Guarantee database consistency and integrity

Interns were implemented a database architectural design that implemented clients interface, database tools, software, hardware, and application processes (D. P. Ram, Personal Communication, May 12, 2016). The design architecture implemented during training contained various elements of Oracle database instances as shown in figure 1.

Figure1: Oracle database design architecture

Retrieved from https://docs.oracle.com/cd/E11882_01/server.112/e40540/intro.htm#CNCPT964

 

Observation

During iteration session facilitated by Mr. Glen and Mrs. Ram, I have realized that database systems are vital and important in business transactions to facilitate various operations such as collecting, storing of, retrieving, and managing data and information. Through training session facilitated by Mr. Glen, I have gained knowledge and information based on software components that control database. I observed that database required installation of database operating systems like Oracle database operating system, Microsoft operating systems, and other platforms. Relation database model of databases included Excel database models that stored data and information through tables architecture. Through workshop training, I observed relationships between various objects in schemas. Data categories such as metadata, primary data, data warehouse, and mined data are controlled using database schemas (D. P. Ram, Personal Communication, May 16, 2016).

During training facilitated in company research hub, I was capable of observing implementation systems and technologies. Languages applied in the implementation of Oracle databases included Procedurals SQL programming language PL/SQL, hypertext markup language (HTML), cascading style sheet (CSS), Java and JavaScript. PL/SQL is applied for integrating Oracle database SQL statements, functions, and data types. You can implement data handling procedures, error handling capabilities, variables and constructs (D. P. Ram, Personal Communication, May 17, 2016). During drawing of design, I observed that various systems could be integrated into the database systems. I observed that various drawing of database design involved indicating various tools, software, and hardware components that enhance activities such as analyzing, data mining and data warehousing. I realized that design platform revealed the relationship between the software, hardware, users and application programs. Kernel software integrated client side and server side in Oracle database architecture.

Reflection

Iteration involving learning and understanding Oracle database was well covered through the intervention of Mr. Glen and Mrs. Ram. Through introduction session, I have acquired detailed data and information through understanding concepts and elements of databases. The session has involved the implementation of relation databases and how they relate with developed Oracle databases. Through the session involving training by Mr. Glen I have understood different parameters, methods, and principles that formulate basics of Oracle database model. Logic and physical schema require having a dedicated architecture of Oracle database that may either apply 3-tier or 2-tier database architecture. The architectural design of Oracle database should contain shared facilities that allow communication with other World Wide Web databases for the exchange of data and information. Oracle database architecture should clearly indicate the request client side as well server response side to ensure that end users can easily access requested data and information through the database (F. B. Glen, Personal Communication, May 18, 2016).

The session facilitated by Mrs. Ram was highly demanding and required a high level of concentration. I gained information concerning implementation of the system through the acquisition of techniques applied in developing and implementation of data and information. The system required setting and implementing background processes to facilitate processing of data and information. According to prototype architecture design, oracle database requires including client processes such as registration modules, purchases modules and other business-oriented systems (F. B. Glen, Personal Communication, May 20, 2016). Some of the activities did not go well as planned. Other processes required more time and resources. The logical architectural design was not accomplished as scheduled. However, future research shall ensure that remaining basic areas in Oracle databases are well accomplished.



© 2021: Edubirdie.website, All Rights Reserved | Innovation Theme by: D5 Creation | Powered by: WordPress
error: Content is protected !!
Whatsapp Us