Oracle
A database is an organized collection of data. The data can be textual, like order or inventory data, or it can be pictures, programs or anything else that can be stored on a computer in binary form.
A relational database stores the data in the form of tables and columns. A table is the category of data, like Employee, and the columns are information about the category, like name or address.
Some databases have minimal feature sets and only store data, while others include programming languages, facilities and utilities to support enterprise-level applications like ERP and data warehousing. Oracle is widely used database and has the most advanced feature set.
Oracle is the world's leading supplier of software for information management but it is best known for its sophisticated relational database products (notably Oracle9i), which are used in Fortune 1000 corporations and by many of the largest Web sites. Oracle's relational database was the world's first to support the Structured Query Language (SQL), now an industry standard. When CEO Lawrence J. Ellison and a few associates formed Oracle in 1977, they were out to prove wrong the prevailing theory that relational databases could not be commercially viable.
A relational database stores the data in the form of tables and columns. A table is the category of data, like Employee, and the columns are information about the category, like name or address.
Some databases have minimal feature sets and only store data, while others include programming languages, facilities and utilities to support enterprise-level applications like ERP and data warehousing. Oracle is widely used database and has the most advanced feature set.
Oracle is the world's leading supplier of software for information management but it is best known for its sophisticated relational database products (notably Oracle9i), which are used in Fortune 1000 corporations and by many of the largest Web sites. Oracle's relational database was the world's first to support the Structured Query Language (SQL), now an industry standard. When CEO Lawrence J. Ellison and a few associates formed Oracle in 1977, they were out to prove wrong the prevailing theory that relational databases could not be commercially viable.
Oracle Corporation is one of the major companies developing database management systems(DBMS), tools for database development, middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software. Oracle was founded in 1977, and has offices in more than 145 countries around the world. As of 2005, it employed more than 50,000 people worldwide. Lawrence J. Ellison (Larry Ellison) has served as Oracle's CEO throughout the company's history. Ellison served as the Chairman of the Board until his replacement by Jeffrey O. Henley in 2004. Ellison retains his role as CEO. Forbes magazine once judged Ellison the richest man in the world.
Oracle is made up of a set of processes running in your operating system. These processes manage how data is stored and how it is accessed. Oracle is a program that is running in the background, maintaining your data for you and figuring out where it should go on your hard drive.
In almost all relational databases, data is accessed through SQL, or Structured Query Language, and Oracle is no exception. SQL allows you to SELECT your data, INSERT new records, UPDATE existing records and DELETE records you want to get rid of. SQL can be embedded in other languages or you can run scripts of SQL directly against the database.
PL/SQL is the procedural language extension to SQL. PL/SQL is a programming language like C, Java or Pascal. In the Oracle world, there is no better way to access your data from inside a program. SQL can be natively embedded in PL/SQL programs.
PL/SQL is a feature-rich language geared toward developing database applications. PL/SQL is the procedural language of the database, but it is also the procedural language for most of Oracle's tools. Programs that run inside the database are called stored procedures. These stored procedures are almost always PL/SQL, but can be written in Java.
Oracle is made up of a set of processes running in your operating system. These processes manage how data is stored and how it is accessed. Oracle is a program that is running in the background, maintaining your data for you and figuring out where it should go on your hard drive.
In almost all relational databases, data is accessed through SQL, or Structured Query Language, and Oracle is no exception. SQL allows you to SELECT your data, INSERT new records, UPDATE existing records and DELETE records you want to get rid of. SQL can be embedded in other languages or you can run scripts of SQL directly against the database.
PL/SQL is the procedural language extension to SQL. PL/SQL is a programming language like C, Java or Pascal. In the Oracle world, there is no better way to access your data from inside a program. SQL can be natively embedded in PL/SQL programs.
PL/SQL is a feature-rich language geared toward developing database applications. PL/SQL is the procedural language of the database, but it is also the procedural language for most of Oracle's tools. Programs that run inside the database are called stored procedures. These stored procedures are almost always PL/SQL, but can be written in Java.
| Some of Oracle's tools to access the database and create programs are: | |||||||||
Java is the current hot language, especially on the web. Java is natively supported by Oracle. Technically, you could use Java to create your stored procedures if you chose. When you are working inside the database, you should only resort to Java when you cannot accomplish a task in PL/SQL. Oracle targets high-end workstations and minicomputers as the server platforms on which to run its database systems. Along with Sun Microsystems, Oracle has long been a champion of network computers. It now boasts that it was the world's first software company to develop and deploy 100 percent Internet-enabled enterprise software across its entire product line: database, server, enterprise business applications, and application development and decision support tools. |
|||||||||
Social Networking
Technologies
