A database is a “shared collection of logically related data designed to meet the information needs of multiple users in an organization” (Hoffer 709). Databases contain data records or files, such as sales transactions, product catalogs and inventories, and customer profiles. Databases allows multiple users in an organization to easily access, manage, store, and update data when needed.
A database management system is software designed to assist in maintaining and utilization large collections of data, and the need for such systems and their use. The first general-purpose database management system (DBMS) was designed by Charles Bachman who worked for General Electric in 1960. The original system was actually called the Integrated Data Store and was used to form the basis for the network data model.
Later, IBM developed its’ own version of DBMS and called it the Information Management System (IMS) DBMS. IMS eventually formed the structure for an alternative data representation framework called the hierarchical data model. This new system allowed several people to access the same data through a computer network.
Although there may be innumerable advantages of using a DBMS to manage data, there are six worth mentioning. First, data is independent. Second, there is efficient data access. A DBMS uses a variety of techniques to store and retrieve data. This allows for data to be sorted in additional places such as external storage devices. Third, the DBMS can enforce data integrity and security by enforcing access controls that govern what data is visible to different users.
A fourth advantage of using a DBMS is centralized data administration...
... middle of paper ...
Hoffer, Jeffrey A., Joey F. George, and Joseph S. Valacich. Modern Systems Analysis & Design. 3rd edition. New York: Prentice Hall, 2002.
Mattison, Rob. Understanding Database Management Systems. New York: McGraw-Hill, 1998.
Ramakrishnan, Raghu, Johannes Gehrke. Database Management Systems. 2nd edition. Boston MA: McGraw-Hill, 2002.
Rolland, F.D. Relational Database Management with Oracle. Mass: Addison-Wesley Publishing, 1989.
Need Writing Help?
Get feedback on grammar, clarity, concision and logic instantly.Check your paper »
- Industry Standard Relational Database Management Systems In nearly all business industries a database would be required as businesses always need to sort data as they are related to finances to estimate their profits, look at revenue margins, net profits, deducting taxes these are all processes that can be done by implementing a database. Databases conclude all the financial industries as they are correlated to businesses that involve transactions of money as all organisations exist to produce an income unless they are charity or public service and even those are affiliated with a relational database to classify employees or client record.... [tags: Database, SQL, Microsoft, Relational model]
1194 words (3.4 pages)
- Relational and Object-oriented Database Management Systems A database is a “shared collection of logically related data designed to meet the information needs of multiple users in an organization” (Hoffer 709). Databases contain data records or files, such as sales transactions, product catalogs and inventories, and customer profiles. Databases allows multiple users in an organization to easily access, manage, store, and update data when needed. A database management system is software designed to assist in maintaining and utilization large collections of data, and the need for such systems and their use.... [tags: Information Management Systems IT]
2153 words (6.2 pages)
- QUESTION 1 Differentiate between database management system and information retrieval system by focusing on their functionalities. Database Management Systems or in short form called DBMS is the major component in most of the information systems. DBMS is the basic system been used in the information system. Or in the other name, DBMS is the traditional way. The Information Retrieval System or IRS is the extended function from the DBMS thus we can explain it here that IRS is came from the DBMS. There will be some differences between Database Management System and Information Retrieval System in the functionalities and uses.... [tags: relational dbms, storage, data]
1078 words (3.1 pages)
- Relational Database Management System for a Cloud Application Lakisha Griffin University of Maryland University College Abstract While a lot of research is currently taking place in technology itself, there is an equally critical requirement for understanding the cloud computing issues. This paper examines “database-as-a-service” (DBaaS) called Relational Cloud. “A DBaaS promises to move much of the operational burden of provisioning, configuration, scaling, performance tuning, backup, privacy, and access control from the database users to the service operator, offering lower overall costs to users.” (Curino, 2011) Database management systems that control web application... [tags: SQL, Database management system, Database]
1802 words (5.1 pages)
- A number of recent studies have revealed that most enterprise customers nowadays prefer open source databases over commercial databases. Based on their requirements, the enterprises also have option to choose from a number of open source relational database management systems (RDBMS) including MySQL, MangoDB, Cassandra, Redis and PostgreSQL. But the usage statistics posted on various websites indicate that MySQL is more popular than other open-source and proprietary relational database management systems.... [tags: SQL, Database, Database management system]
716 words (2 pages)
- A. Based on your understanding of the concept of integrity rules, Three (3) integrity rules must be enforced by a relational DBMS. List, and give a brief description of each of the three rules. Answer: There are three integrity rules must be enforced by the relational Database Management System (DBMS) those are as follows: I. Entity Integrity: primary key • Each table must have a (Column’s) unique values • No rows have a Missing values • Ensure traceable entities here unique means not to have a same values II. Referential Integrity: foreign keys • Column value of one table must match column table of related table.... [tags: SQL, Database management system, Relational model]
713 words (2 pages)
- COMPARATIVE ANALYSIS OF LEGACY DATABASE SYSTEMS Methods and techniques which are used in [RDBMS] Relational Data Base Management System, it was previously followed by the Database System in simple words before the introduction of RDBMS it was previously followed by the Database System. Database Management System is combination of Database Applications and Database Programs, database management system is still running in Universities and Hospitals of world in present days. Hierarchical System: In Hierarchical System a parent is the only parent of the child means child has only one parent which is called child parent relationship or it represent the... [tags: relational, hierarchical, network systems]
611 words (1.7 pages)
- Since the SQL language appeared in mid 1970s, it has been leading the relational database industry for many years. With the modern era of databases not everyone sees the advantages of using relational databases. NoSQL, was first developed in the twenty first century (MongoDB, para 19) to address the issues that the SQL language could not handle. NoSQL cannot handle pure relational database models, it can use any of five different kinds of models, including relational to solve problems. With the variety of models, designers are wondering if there is a future for the strictly relational language SQL, and it’s other disadvantages compared to that of NoSQL.... [tags: Database, Relational model, SQL]
1017 words (2.9 pages)
- Recent inventions and technical advancements have changed the appearance and indeed, the entire capability of the internet as most people know it. Many events have contributed to this change, but none so much as the processing method known as Database Management Systems (DBMS). From its birth in the last century, the way computers process information has grown and expanded to a point that would have been hard to imagine for the early programmers. This growth actually spurred on the growth of the telecommunications industry.... [tags: Database Management Systems, DBMS]
1965 words (5.6 pages)
- In the web space where vast amounts of data is processed and collected, it is typical to store this information in a database. A common form of database is an RDBMS (Relational Database Management System). The act of retrieving and/or storing data to or from an RDBMS is called a transaction (Connolly and Begg, 2014). Connoly and Begg go on to outline the process in which these transactions are applied, by way of a COMMIT or ROLLBACK SQL statement, which are also written to a transaction log and may be used in the event of a systems failure to restore the database to a point prior to the failure.... [tags: SQL, Database, Relational model]
1079 words (3.1 pages)