Relational Database Management System

Introduction For decades, human was trying to implement and create better solutions how to store and manage big amounts of data. Today with the increase in knowledge how to handle that amounts of data is more possible to do it. There are lots of software in the market to use. A person who is related with Relational Databases must consider the advantages and disadvantages of them and try to get the most efficient one. Many reasons to handle data is to keep information of something important which may improve a work that you are involve. In the following paragraphs, I will talk about general information of RDBMS and I will discuss and evaluate alternatives Relational Database Management Systems and the advantages and disadvantages that each …show more content…
UNIREG did not officially release to public because was not contained SQL structure. In 23 of May 1995 was then the first official release of the well-known MySQL database. Until 2008 MySQL was owned by the Swedish company after that was bought from Sun Microsystems in 2008 and from Oracle in 2009. Moreover, the benefits that MySQL has compare to other databases are 1) Scalability&Flexibility: The user can expand the capacity of it and can control terabytes of information. With flexibility platform contains Linux, Unix and Windows support. 2) Easy in Manage: Can be easily downloaded and installed. When is install features take the whole work of the database like automatic expansion of memory, dynamic configuration, troubleshoot and control of the database which make it very simple to use. 3) Secure: Advance security feature including decryption and encryption facilities. 4) Robust Transactional: Offers features of complete ACID transaction support with full data integrity isolation level and deadlock detection. 5) Cost: It runs under GNU so is free to download and use. On the other hand, the disadvantages that have are: 1) Stability Issues: The database has problems how to handle transactions, references and auditing. 2) Poor Performance: If It has too many tasks at the same time the performance becoming poor and do not let the database to implement …show more content…
In 1986 Michael Stonebraker added object-oriented features to Ingres and changed the name of the new version to Postgres. After that the new version was commercialized by Illustra. In 1996 Postgres gain many standards like SQL92 standards and features including Multiversion Concurrency Control (MVCC). That year was the year of initial release of the new PostgreSQL by PostgreSQL Global Development Group. Some of the features of PostgreSQL are 1) Object relational: Every table can define a class and the database can implement inheritance between tables. 2) Open Source: the database is free to use worldwide and because the team which develop the interface is international this database can be used in several languages 3) It has support by a dedicated and experienced team which can be accessed for Q&A 24/7. 4)Transaction Process: PostgreSQL provides protection in data through a transaction processing 5) Managing Tools: Provides tools for designing, managing and using the management system. 6) Extensibility: Can be extended with store procedures. On the other hand, Postgres has disadvantages which are 1) Performance: In read-heavy tasks can be over kill and become less performant. 2) Popularity: Is not so popular compare to other

Related Documents