Category : Database » PostgreSQL
PostgreSQL offers substantial additional power by incorporating the following . understanding of the topics without having to refer forward too many times. .
Download File
Free PDF eBooks Download
Database
PostgreSQL
Content Summary :
1. What is PostgreSQL? PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES,Version 4.2 1 , developed at the University of California at Berkeley Computer Science Department. The POSTGRES project, led by Professor Michael Stonebraker, was sponsored by the Defense Ad-vanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National ScienceFoundation (NSF), and ESL, Inc. PostgreSQL is an open-source descendant of this original Berkeley code. It provides SQL92/SQL99language support and other modern features. POSTGRES pioneered many of the object-relational concepts now becoming available in some com-mercial databases. Traditional relational database management systems (RDBMS) support a datamodel consisting of a collection of named relations, containing attributes of a specific type. In currentcommercial systems, possible types include floating point numbers, integers, character strings, money,and dates. It is commonly recognized that this model is inadequate for future data-processing appli-cations. The relational model successfully replaced previous models in part because of its “Spartansimplicity”. However, this simplicity makes the implementation of certain applications very difficult.PostgreSQL offers substantial additional power by incorporating the following additional concepts insuch a way that users can easily extend the system: