preface_2.htm |
Disclaimer:
This document is a brief collections of information available through old published books and internet; I did not have chance to check all cross references to validate the time lines. As a personal bias I was more curious about PostgreSQL database; I learned Oracle database first then others. Therefore, I reviewed Oracle's organizational history than structural nut-bolts. Here I document my inclinations towards these databases only, than be a critique of any system or application. |
Oracle:
"The
Oracle Database
(commonly referred to as
Oracle
RDBMS or simply as
Oracle) is an
object-relational
database management
system produced and marketed by
Oracle
Corporation." 1970s-Assembly Language , SDL To RSI Larry Ellison with Bob Miner and Ed Oates of Software Development Laboratories (SDL) started Relational Software Inc, where Oracle precursor was written in assembly language. Oracle version 1 was not released officially, Oracle version 2 was released around 1979 1980s RSI to Oracle Systems Corporation Oracle version 3 was developed with C programming language, and to run in mainframe and mini computers. It supported the execution of SQL statements and transactions. The version 5 was the land mark of introducing clustering , and in 1986 SQL*Plus was available to the users. The PL/SQL surfaced with the version 6. 1990s and 2000s: Oracle releases Oracle 7, Oracle 8, 8i, 9i were release. As a landmark Oracle 7 revisions, supported dynamic SQL Video, the version 8 started supporting Java, HTML and network computing, the version 9i RAC surfaced. Oracle release 10g was released supporting Linux 64bit, (g stands for grid computing) in which resource of each computer in a network could be accessible through one lead computer often addressed as "Node". Data
Block : Oracle manages the storage space in the datafiles of a database
in units called data |
PostgreSQL: is an
object-relational database management system (ORDBMS). It is
ACID-compliant, supports transactional (including most DDL statements)
avoiding locking issues using Multiversion Concurrency Control (MVCC),
provides strong protection against data-corruptions. (ref:
postgresql-9.3-A4.pdf) 1970s-Ingres-RDBMS PostgreSQL as a database has a long history. In the late 1970s, the University of California at Berkeley started a created of a relational database known as Ingres. Relational Technologies commercialized this DB as Ingres. Relational Technologies became Ingres Corporation, and was later acquired by Computer Associates. 1980s-Ingres To Postgres 1990s-Postgres To PostgreSQL Postgres used a specific query language known as Postquel, which was based on QUEL. Andrew Yu and Jolly Chen added SQL support to the existing Postgres database in the mid-'90s. In 1996, many new features were added, including the MVCC transaction model, more adherence to the SQL92 standard, and many performance improvements. Postgres once again acquired a new name, PostgreSQL. |
PostgreSQL: It Was then
The older versions of PostgreSQL, you could run the PostgreSQL server on
a Windows host but you had to install a Unix-like infrastructure (Cygwin)
first: PostgreSQL wasn't a native Windows application. Starting with
PostgreSQL version 8.0, the Before PostgreSQL 8.0, PostgreSQL server was required to have Unix-like infrastructure (Cygwin) in windows. The version 8.0 and onwards, PostgreSQL can be installed in windows environment. |
Useful ref:
|