Oracle New Material-Modified.docx

Oracle New Material-Modified.docx - ORACLE 12C SQL PL/SQL...

This preview shows page 1 - 4 out of 332 pages.

ORACLE 12C SQL & PL/SQL DURGA SOFTWARE SOLUTIONS Mythrivanam,Hyderabad By Dinesh
Image of page 1

Subscribe to view the full document.

ORACLE Oracle Database 12c is a significant upgrade from prior releases of Oracle. New features give developers, database administrators, and end users greater control over the storage, processing, and retrieval of their data. A relational database management system (RDBMS) such as Oracle gives you a way of doing these tasks in an understandable and reasonably uncomplicated way. i) Lets you put data into it Keeps the data ii) Lets you get the data out iii) and work with it Oracle supports this in/keep/out approach and provides clever tools that allow you considerable sophistication in how the data is captured, edited, modified, and put in; how you keep it securely; and how you get it out to manipulate and report on it. Oracle is a RELATIONAL DATA BASE MANAGEMENT SYSTEM (RDBMS) Oracle data base is a software where we can store and process (fetch / insert / change / delete) business data. Oracle is an RDBMS s/w from oracle corp. A Timeline of Database History Ancient Times : Human beings began to store information very long ago. In the ancient times, elaborate database systems were developed by
Image of page 2
government offices, libraries, hospitals, and business organizations, and some of the basic principles of these systems are still being used today. 1960s : Computerized database started in the 1960s, when the use of computers became a more cost-effective option for private organizations. There were two popular data models in this decade: a network model called CODASYL and a hierarchical model called IMS . One database system that proved to be a commercial success was the SABRE system that was used by IBM to help American Airlines manage its reservations data . Heirarchical Model In a hierarchical model , data is organized into a tree-like structure , implying a single parent for each record. A sort field keeps sibling records in a particular order. Hierarchical structures were widely used in the early mainframe database management systems, such as the Information Management System (IMS) by IBM , and now describe the structure of XML documents. This structure allows one one-to-many relationship between two types of data. This structure is very efficient to describe many relationships in the real world; recipes, table of contents, ordering of paragraphs/verses, any nested and sorted information. This hierarchy is used as the physical order of records in storage. Record access is done by navigating downward through the data structure using pointers combined with sequential accessing. Because of this, the hierarchical structure is inefficient for certain database operations when a full path (as opposed to upward link and sort field) is not also included for each record. Such limitations have been compensated for in later IMS versions by additional logical hierarchies imposed on the base physical hierarchy.
Image of page 3

Subscribe to view the full document.

Image of page 4
You've reached the end of this preview.
  • Winter '19
  • Santhosh Danalakota
  • Oracle Database, Oracle Corporation, Database management system

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern