Oracle company was founded in 1977 by three programmers, Bob Miner, Ed Oates, and Larry Ellison, who served as CEO (Chief Executive Officer) for several years now. The company is concentrating on making the database server on the mainframe.
Oracle Corp success stories associated with the history and theory of relational databases. Relational database theory was introduced almost simultaneously by Edgar F. Codd (in a famous article Large shared data banks) and an inventor of other less well known, in 1969. IBM is the first company to implement the relational model is the SQL language, the DB2 product. IBM will unfortunately have little doubt the efficacy of SQL and the relational model (later it will affect the market behind IBM in the database-server Unix and Windows operating systems).
Larry saw the development of the theory of the relational model and the implementation of the DB2 relational database. He believes that the relational model is a "way of the future" and decided to implement the relational model in Oracle products. Previous product Oracle database using nonrelasional models. Oracle became a strong competitor to IBM in the mainframe market in the server database, especially relational database having a certain model.
Around the mid-1980s, Larry diversify its product Oracle (version 6.x) out of the mainframe, which is the Unix operating system. Further diversifying the 1996 Oracle Corp. Oracle (version 7.x) into the operating system Novell Netware, Windows NT, and Linux (versions 8.x, 1997).
Starting in the mid-1990s began to make Oracle Corp. also nondatabase products such as application server-server (WebDB, OAS), development tools (Oracle Developer, Oracle Designer), and application suite (Oracle Apps).
Relational Database Model
Relational database model is a formal model of data. As a formal model, this model specifies the structure (type) of data is formal, formal operations, and the integrity of the formal rules.
Relational database has a logical structure called a relation (relation) and on the physical level of the table (table). Attributes (attribute) represents an element of data relating to the relationship. For example, employee relations have attributes such as name, employee number, and address. A relation is conventionally denoted by:
Relation (attribute1, attribute2, ..)
Example: Employee (Name, Nomor_Pegawai, address, ..)
Data values of the attributes of a relation are stored in a tuple or row (row) of the table.
Relational Database Management System (RDBMS)
RDBMS (Relational Database Management System) is software for creating and managing databases, often referred to as the database engine. The term RDBMS, database-server software, and database engine refers to the same thing, while the RDBMS is not a database. Some examples of RDBMS such as Oracle, MS SQL Server, MySQL, DB2, MS Access.
Understanding Oracle
Oracle is a relational database management system (RDBMS) to manage information in an open, comprehensive and integrated.
Oracle Server provides an efficient and effective solutions for its ability in the following:
• Able to work in a client / server (processing spread)
• Handle database management space and a large
• Supports simultaneous data access
• High Performance Transaction processing
• Ensure availability of controlled
• A terreplikasi
SQL language
SQL (Structured Query Language) is used as an interface in data management. SQL is a comprehensive language for data bases, so it made to the SQL language standard by ANSI (American National Standard Institute) and ISO (International Standard Organization). In it there is a command for defining data, perform queries and updates to the data. Commands are grouped into two terms: DDL (Data Definition Language) for defining data and DML (Data Manipulation Language) to update and query. Most vendors of RDBMS using SQL from the ANSI / ISO, but some RDBMS vendors include some additional commands as a feature of the product. Among these are the features for granting access to data or for maintenance.
SQL * Plus
In the SQL command accepts input from the user, the RDBMS vendors have provided a library that can be used by programmers to program created to make accessing the database. In addition, the vendor also provided a program that can receive input SQL language which is then executed by the RDBMS. Oracle, for one, has provided a program called SQL * Plus. SQL * Plus can be used to perform the execution of SQL commands from the user.
SQL vs. SQL * Plus
SQL: A language that includes commands to save,
receive and maintain data in the database.
SQL * Plus: Applications that can recognize and execute SQL commands and
can display the results of the command to the user.
Data Definition Language (DDL)
DDL is a part of the SQL commands to create, modify or delete the Oracle database structure.
Creating a table in a database after going through the stages to model the data and make design data. Elements that must exist in the manufacture of a table: table name, column name and data type column.
Description : A Brief History of Oracle
URL : http://indra-combination.blogspot.com/2012/05/brief-history-of-oracle.html
Permalink : A Brief History of Oracle
URL : http://indra-combination.blogspot.com/2012/05/brief-history-of-oracle.html
Permalink : A Brief History of Oracle
