Wednesday, January 17, 2007

What is Oracle?

Oracle (in ancient Greece, someone in touch with the deities; from Latin, oraculum or divine announcement) says it 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. Today, as proof of their success, they've parlayed an initial $2,000 investment in the company into an annual revenue exceeding $9.7 billion.
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. In fact, Oracle CEO Ellison has said, "If the Internet turns out not to be the future of computing, we're toast. But if it is, we're golden."
Based in Redwood Shores, California, it has more than 43,000 employees worldwide and does business in over 150 countries. Oracle (ORCL) is publicly traded on the Nasdaq.

What is a Relational Database?
Databases have been a staple of business computing from the very beginning of the digital era. In fact, the relational database was born in 1970 when E.F. Codd, a researcher at IBM, wrote a paper outlining the process. Since then, relational databases have grown in popularity to become the standard.
Originally, databases were flat. This means that the information was stored in one long text file, called a tab delimited file. Each entry in the tab delimited file is separated by a special character, such as a vertical bar (). Each entry contains multiple pieces of information (fields) about a particular object or person grouped together as a record. The text file makes it difficult to search for specific information or to create reports that include only certain fields from each record.

You can see that you have to search sequentially through the entire file to gather related information, such as age or salary. A relational database allows you to easily find specific information. It also allows you to sort based on any field and generate reports that contain only certain fields from each record. Relational databases use tables to store information. The standard fields and records are represented as columns (fields) and rows (records) in a table. More Details..

No comments: