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. The object Model of Oracle 8i, supported the user defined ( table and column) data type, in this system OID (Identifying Each Object) was integrated. However did not support any inheritance (it was then , for now please refer this linkType Inhertance 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:
|