⊿ Point. {R} Glossary. ◢ Keyword: P. ▰ Sources. 〓 Books [B] ◥ University. {q} PhD. ⏫ THEMES. ⏫ Big Data. [B] Big Data. ⚫ USA. ↂ EndNote. ☝️ BD Dummies. PostgreSQL. Free and open-source object relational database management system The new project, POSTGRES, aimed to add the fewest features needed to completely support data types.[30] These features included the ability to define types and to fully describe relationships – something used widely, but maintained entirely by the user.
In POSTGRES, the database understood relationships, and could retrieve information in related tables in a natural way using rules. POSTGRES used many of the ideas of Ingres, but not its code.[31] Starting in 1986, published papers described the basis of the system, and a prototype version was shown at the 1988 ACM SIGMOD Conference. The team released version 1 to a small number of users in June 1989, followed by version 2 with a re-written rules system in June 1990.
Version 3, released in 1991, again re-wrote the rules system, and added support for multiple storage managers[32] and an improved query engine. Multiversion concurrency control (MVCC) [edit] User-defined objects.