PostgreSQL: The Advanced and Open Source Object-Relational Database Management System, Study Guides, Projects, Research of Database Management Systems (DBMS)

Download PostgreSQL: The Advanced and Open Source Object-Relational Database Management System and more Study Guides, Projects, Research Database Management Systems (DBMS) in PDF only on Docsity! PostgreSQL: Future DBMS Technology Today the most advanced open source database management system a pioneering Object-Relational Database Management System full-featured, safe, stable and powerful highly extensible PostgreSQL is: as powerful and dependable as commercial RDBMS offers commit/rollback transactions, subselects, triggers, views, foreign key referential integrity, and sophisticated record locking utilizes features that far exceed those of common relational database systems Features: What makes PostgreSQL different? supports 45 different data types data types for describing geometric objects, such as POINT, POLYGON, and CIRCLE, and user-defined data types internet age data types, such as INET and CIDR, which contains IP address and netmask information primary keys are not implemented, but a special type called OID (object identifier) keeps track of unique records Features: (continued) implements object inheritance CREATE TABLE cities ( name text, population real, altitude int ); CREATE TABLE capitals ( state char(2) ) INHERITS (cities); Advanced Features: its open source nature insures a quicker development cycle, and thus more frequent updates language interfaces for popular programming languages, including Perl, Python, PHP, and Java via JDBC, C/C++, Embedded C, and TCL can easily handle large amounts of data best of all, it's free Advantages: lack of documentation steep learning curve lack of commercial support somewhat slower that other RDBMS used in web application. Disadvantages: PostgreSQL will continue to lead database technology into the future its features and advantages greatly out-weigh its disadvantages it is a terrific platform for students to learn the ins and outs of a powerful database system Postgres will continue to evolve as we move towards the future of database technology Conclusion: