Differentiate between database management system and information retrieval system by focusing on their functionalities.
Database Management System (as known as DBMS) is a set of application that enable user to create, edit, update, store and retrieve data from database files. By using DBMS, data in a database can be added, deleted, changed, sorted and searched. DBMSs are usually used to manage employee information of a big company, customer information and stock information.
By using the DBMS, there are advantages and disadvantages. The advantages of a DBMS is the same information can be available to any user, minimizing redundancy can reduce the cost of storing information on other devices, the accuracy in using DBMS because of their up to date data and data is easy to access. The disadvantages of DBMS is implementing this system can be high cost and time consuming, even the training.
When we mentioned about the functionalities of DBMS, there are four main components. The four components are data, hardware, software and user. The data is something plain, raw, unorganized facts that needs to be processed to be meaningful. Hardware is physical component of the computer system and also known as peripheral. Software is application inside the computer. Lastly, the user is the one who clearly understand what it means to use the system on a daily basis.
There are a number of functions that a typical DBMS will support.
• Data Definition Language as known as DDL – to define a database. The DBMS must allow users to create database definitions
• Data Manipulation Language as known as DML – to insert, update, delete, and query data in the database.
• Concurrency control that is allows shared access to the database, with multip...
... middle of paper ...
...t, then the result will fast.
1. Joey F. George et.al. 2004 Object-Oriented System Analysis and Design 2d ed. Pearson International Edition :Pg144
2. Raghu Ramakrishnan & Johannes Gehrke 2003 Database Management System 3d ed. McGraw-Hill Higher Education : pg9.
3. Patricia Ward & George Dafoulas 2006 Database Management Systems Thomson : pg4&5
4. Ralph M. Stair & George W. Reynolds 2006 Principles of Information Systems, A Managerial Approach, 7th ed Thomson : pg5&7
5. Ramez Elmasri & Shamkant B. Navethe 1989 Fundamentals of Database Systems 6th ed Pearson : pg1000
Need Writing Help?
Get feedback on grammar, clarity, concision and logic instantly.Check your paper »
- A knowledge management (KM) implementation strategy is intended to deal with the problem of knowledge loss, in another words, is simply a plan that describes how an organization will retain its knowledge better for the benefit of that organization and its stakeholders. Herein, an organization is critically in loss knowledge position when some of its experienced workers retire or leave the organization. So the firm should seek to implement management solutions and design the structure system, tools, and processes based on these knowledge losses to retain and shared this knowledge.... [tags: loss, organization, techniques, technologies]
815 words (2.3 pages)
- People came up with the term database as the computer industry was growing in popularity. A database management system means exactly what its name is, it is computer software designed to create and manage databases. This software gives users and programmers an organized way to retrieve, create, update, and manage data. A database management system (DBMS) creates ways for end users to read data in a database as well (MindTap). The DBMS basically serves as a crossing point between databases and normal users or programs, confirming that data will constantly be organized and stay accessible pretty easily.... [tags: SQL, Database, Database management system]
1380 words (3.9 pages)
- A database management system is a collection of programs that allow users to create and maintain a database. Even though there are numerous advantages for using database management systems, there are a few disadvantages. Such disadvantages include complexity, size, performance, and the associated costs of a database management system. The advantages of a database management system outweigh the disadvantages, but one should understand the disadvantages to ensure they have a complete understanding of the system.... [tags: Database management system, SQL]
1007 words (2.9 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)
- To whom it may concern, I take immense pleasure in recommending one of my favorite former students, Harshdeep kaur. As her teacher, who was acquainted with her for 4 years during her under graduation in Computer Science, I regard her as a very keen and diligent learner. She has kept in touch even after passing out of college and communicates all her professional experiences/achievements with me. Given that I too am concerned about her welfare, I try to guide her wherever I think she requires some guidance.... [tags: Database management system, Database]
1069 words (3.1 pages)
- In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses.... [tags: Database management system, Database, Computer]
1411 words (4 pages)
- 1. Differentiate Between Database Management System And Information Retrieval System By Focusing On Their Functionalities. Database Management System According to Modern Database Management eight edition, by Jeffrey A. Hoffer, Mary B. Prescott and Fred R. McFadden database management system (DBMS) is define as a software system that is used to create, maintain, and provide controlled access to user databases. Support Concurrent Updates Concurrent updates occur when various users make updates to the database at the same time.... [tags: IT Essays]
1964 words (5.6 pages)
- Assignment 1: Analysis of database management and information retrieval systems Differentiate between database management system and information retrieval system by focusing on their functionalities. (up to one page) [30% marks] Database Management System Information Retrieval System Database management system is a computer program designed to manage a large set of structured data. Information Retrieval System is an activity that will obtain information resources that has been saved in database.... [tags: Compare and Contrast, functions]
1451 words (4.1 pages)
- Database is a collection of programs that enables users to create and maintain data. The other meaning, database some collection the related files that are usually included, concurrent referenced to one another. Good feature of a database is that data and records contains some in different files can be easily organized and save from harm in danger when using specialized database management software called a database management system (DBMS) or database manager. A database-management system (DBMS) is a group of organized data and a set of programs have access to some data.... [tags: collection of data, related files, storage]
1788 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)