PostgreSQL is a way!{2}


What is PostgreSQL?

Companies are always looking for database system to take care of complex data infrastructure in order to solve specific business needs, lower the cost of operations, and reduce the deployment time. Some case studies show PostgreQL is one of useful tools. PosgresQL is an open source object-relational database system (DBMS). In term of source relational database system, it is a relation database with an object-oriented database model which supports objects, classes and inheritance. PostgresQL runs major operating systems such as Linux, UNIX(Mac OSX, Solaris as well as Windows. It also supports for foreign keys, joins, triggers and stored procedures with multiple languages.

PostgreSQL implements SQL:2011 standard; it has updateable views, data-types, operators, functions, p procedural languages etc.  Its code is available up an open source license; therefore, everyone could use, modify and distribute PostgreSQL.

History

ProgresQL has longer than 15 years history of developments, and it gained a really strong reputation for stability, data integrity as well as accuracy. It was created in 1982 by Michael StoneBraker, a project leader.

In the 1980s, the new projects called Postgres was trying to put some new features to support types. Those features made Postgres able to define types and describe relationships completely. As a database, Postgres defines relationship as well as able to retrieve information in tables. It was not using its code but the ideas of Ingres.

Until 1997, Postgres was renamed to be PostgreSQL as its support for SQL. The PostgreSQL version 6.0 was released in the same year. After that, this database system has been developed and maintained by database developers via the internet around the world.

PostgreSQL continues to release and update for version annually.

Features

There are some features of PostgreSQL. It manages concurrency. Concurrency control means ensuring that correct result for concurrent operations are generated as quickly as possible. PostgresSQL manages concurrency via a system called multiversion concurrency control which allows changes without being visible to other transactions. Besides multiversion concurrency control(MVCC), point in time recover, tablespaces, online/hot backups, query planner/, optimizer are also the features of PostgreSQL.

The PostgreSQL supports some unique and functional indexes. For examples, PostgreSQL’s indexes can uses any of its B-tree, R-tress hash, or Gist.

These years, database developers and volunteers are trying to ensure that PostgreSQL maintains the atomicity, consistence, isolation, and durability in an efficient manner. Now, PostreSQL features three levels of transaction isolation which are Read Committed, Repeatabel and Serializable. In the newest version 9.1, it supports the serializablility by the serializable snapshot isolation(SSI) technique.Postgres supports for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).

PostgreSQL  is able to store binary large objects, including  pictures, sounds and video, and it has native  programming interfaces for C/C++, Java, or. Net.

 

Case study

MySQL vs PostgreSQL: Why MySQL Is Superior To PostgreSQL is an online journal written by KASIA MIKOLUK. She compares MySQL and PostgreSQL. She finds out PostgreSQL is okay to be chosen when a developer tries to create a new project from scratch as more dependable (ACID compliance) and its built on international standard. Also,  PostgreSQL provides superior  data protection, so it is good for new development projects.

MYSQL vs PostgreSQL: Which is better? Is written by Mike Baukes, he states that although MySQL is the world’s most widely used database, PostgreSQL is more reliable due to its ACID(atomicity, consistence, isolation, and durability).Therefore, it is easy for PostgreSQL return the same result with errors.

NoSQL and SQL Databases for Mobile Applications. A Case Study: Mongo DB Versus PostgresQL was written by Professor Fotache Marin, an expert about database. The journal Article studies the usefulness and necessaries of a database be used in mobile applications. The article states that most of the mobile applications need a database which could analyze for the clients and the servers; a relational database system could maintain persistence for client platforms of mobile applications.

 

In the first part of the article, the author tries to investigate the storage options for the mobile platform. He found that mobile applications need storage options for user’s data, session data, and the requirement could be specific from simple values to user’s accounts.  The data is gathered by the sensor, and receive from the internet. The author states that a design with NoSQL has less standardization then a design with SQL database.

Why is related to this course? Why is it important?

PostgreSQL is related to this course. As we are studying database system in this class, PostgreSQL is one of the popular database systems in this world, and it is used by many database developers, school, government and big companies in different industries for years.  It is also a development platform upon which to develop in-house, web or commercial software products. So, there is a need for CIS students to get more knowledge about this database system in order to equip him/ herself more competitive.

Also, its functions and stability are its advantages compare with other SQL system. Therefore, trying to learn and use it would not be too difficult.

As we mentioned, PostgreSQL has been used by in many places including big corporations and government. If CIS students have knowledge and hand-on experience with PostgreSQL, it could become an advantages when students are trying to look for an I.T job.

 

Mikoluk,K. (Augst 16, 2013). MySQL vs PostgreSQL: Why MySQL Is Superior To PostgreSQL. Retrieved from https://www.udemy.com/blog/mysql-vs-postgresql/

Baukes, M(August 9, 2013). MySQL vs Postgres. Retrieved from https://www.scriptrock.com/articles/postgre-vs-mysql/

 

PostgreSQL English. (n.d.). Retrieved January 25, 2014 from the Wiki: http://en.wikipedia.org/wiki/PostgreSQL

FOTACHE, M. , & COGEAN, D. (2013). Nosql and sql databases for mobile applications. case study: Mongodb versus postgresql. Informatica Economica, 17(2/2013), 41-58.