Advantages And Disadvantages Of Database Management Systems

987 Words 4 Pages
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…
The first RDBMS was released by Relation Software in 1979 and was Oracle. A database is created with a collection of tables which have primaries and foreign keys. From tables, data can be deleted, updated or inserted. Essentially a database management system is created to store data which can later be used for a specific application. They have been a common choice to store information used for financial records, manufacturing and logistics, personal data and other applications. A major objective of a RDBMS is to provide data independence within the limitations of its data model. More modern RDBMS provide less limitations where the database system to be operational must reorganized and reloaded. Some of the benefits that RDBMS have are the Data Structure, Multi-User Access, Privileges and Network Access. First, data structure, are using simple tables formats and are easy to managed and understand. Second Multi-User Access, many users can access data in a database simultaneously. Third, privileges allow the database administrator to restrict access to unauthorized users and grant privileges to individual users based on the types of database tasks they need to perform. Finally, Network Access is provided through a server which uses a program to listen client requests and decides when or not to let someone to connect and use databases. Examples of RDBMS are Microsoft Access, Oracle, …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