Database Management System vs Information Retrieval System

1964 Words4 Pages
bulb-icon

Recommended: The purpose of database management system

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. Supporting concurrent updates is also critical to database management as this component ensures that updates are made appropriately and the end result is precise. Without DBMS interference important data could be lost and or imprecise data stored.
DBMS uses features to bear concurrent updates such as batch processing, locking, two-phase locking, and time stamping to help make certain that updates are done correctly. Again, the user is not alert all this is incident as it is the database management system’s liability to make sure all updates are stored appropriately

Recovery of Data
In the event a misfortune occurs, DBMS must offer ways to pull through a database so that data is not eternally lost. There are times computers may break down, a fire or other natural disaster may occur, or a user may enter inaccurate information invalidating or making records conflicting
If the database is cracked or spoiled in any way, the DBMS must be able to recover the correct state of the database, and this process is called Recovery. The easiest way to do this is to make standard backups of information. This can be done at a set controlled time so in the event a catastrophe occurs, the database can be restored to the state that it was last at prior to backup.

Security
Security is the avoidance of illegal users accessing the database. DBMS uses features such as encryption, authentication, authorization and views to provide security to the database. Encryption is when DBMS converts the data in a database to an unreadable format. No illegal person trying to access this information will be able to read it. Authorized users will be able to see it in normal form.
Authentication is a technique in which the database officer can identify the person accessing the database. Authorized users are given passwords and successful entry of a legitimate password will allow the user entry into the database, if a password is not effectively entered, the user will be denied access. Authorization is a set of rules that the database administrator (DBA) sets up to specify levels of practice that individuals or groups are allowed to have.

Show More
Related

  • Essay On Career Options In Information System

    1001 Words  | 3 Pages

    DBA deals with all of this by finding user needs, set the database, and test the system. DBA should enable editing any system he or she created. At the same time DBA should ensure the security of the data and guarantee data integrity and backup. Moreover, DBAs should know the database management systems (DBMS) that include the knowledge of Oracle, IBM DB2, and Microsoft SQL server (“Database Administrator,” 2010). Oracle is one of the most important platforms that DBA must know and have experience with. According to Kanaracus “The database experience we look for most of the time is Oracle”, says Tom Hart, executive vice president of the operations and technology group at Veritude. “SQL Server is more of a nice-to-have"

    Read More

  • Privacy and Security Issues in Data Mining

    1885 Words  | 4 Pages

    [7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.

    Read More

  • Advantages of MySQL over Oracle

    1332 Words  | 3 Pages

    Concurrency is a feature that allow multiple users of a database to read, modify or updat...

    Read More

  • Database

    761 Words  | 2 Pages

    Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.

    Read More

  • Normalization and Integrity

    1055 Words  | 3 Pages

    Normalization, Integrity and Security are the important role for a DBA, Normalization helps to avoid data redundancy by reviewing data base structure at certain level. It helps to build an effective data model. Data Integrity provide some level of assurance over the information getting store and retrieved from database, DBA has to understand all DBMS features use them correctly for Data Integrity. Data Security is toughest part for DBA, auditing and multiple level security can protect data but none of them provide complete security, security can also be managed by encrypting and masking the organization data.

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.

    Read More

  • Database Concepts

    1204 Words  | 3 Pages

    Database Concepts, what are Databases all about? I am writing this paper to answer a few questions as part of my first assignment in a class designed to provide a better understanding of Database Concepts. There are many different types of databases, different implementations of databases, and different database software applications. So how does all this database stuff work? I have worked with databases for most of my professional career at many different levels. Sometimes as the user, entering data, retrieving information, and compiling reports. I have also provided service and support to help maintain a database system. More recently I perform both types of tasks. I have never stopped to think about what was really going on the background when I was using these systems. I aim to learn more about what databases are and how they function.

    Read More

  • Threats To Information Security Essay

    2828 Words  | 6 Pages

    Confidentiality: is about making sensitive information reach right people and prevents wrong people from getting it.

    Read More

  • Difference Between Database System and Information Retrieval System

    524 Words  | 2 Pages

    Information Retrieval is simply a field concerned with organizing information. In other terms, IR is emphasizing the range of different materials that need to be searched. Others researcher said that IR is the contrast between the strong structure and typing a database system with the lack of structure in the objects typically searched in IR. The actual process in information retrieval systems is it has to deal with incomplete or under specified information in the form of the queries issued by users. IR uses the techniques of storing and recovering and often disseminating recorded data especially through the use of a computerized system.

    Read More

  • Essay On Database Security

    650 Words  | 2 Pages

    Database security is a critical Domain of Computer and Information Security that deals with protection of an individual database or group of database from illegal access, injections or possible destruction. Data can be a customer's information, intellectual property, financial asset or any number of other records that can be maintained and managed on a system. Without Database security people are at risk of identity fraud, theft, destruction of property and much worse. The global costs of such security breaches runs from over a billions of dollars yearly, and the cost to individual companies can be extreme, sometimes disastrous.

    Read More

  • Advantages And Disadvantages Of GIS

    1670 Words  | 4 Pages

    On the software level, versioning capabilities in the selected Esri ArcGIS allows users to simultaneously create multiple, persistent representations of the database without the overhead of data replication. Users can edit the same features or rows without explicitly applying locks to prohibit other users from modifying the same

    Read More

  • The Database Management System (DBMS)

    1438 Words  | 3 Pages

    Another function of the DBMS is the concurrency control services. Database Management System must ensure that the database is updated correctly because the database can be used by many multiple users. The DMS enable many user to access the data concurrently. The database managements system will help from ay data loss. It have the features which that can support the updates like batch processing, locking, two-phase locking and the time stamping.

    Read More

  • database management system and information retrieval system

    1069 Words  | 3 Pages

    A database management system in the main software tool of the database management approach because it controls the creation, maintenance, and use of the database of an organization and its users. The three major functions of a database management system are first to create new database and database application. Second to maintain the quality of the data in an organized database. And last to use the database of an organization to provide the information that its end users need. An example of a database management approach in a banking information system. Note how the savings, checking and installment loan programs use a database management system to share a customer database. Note also that the database management system allows a user to make direct, ad hoc interrogations of the database without using application programs.

    Read More

  • The Importance Of A Database Administrator

    721 Words  | 2 Pages

    Computer software is always evolving and getting better. It is essential that a DBA have the most updated software to make-work easier. Another part of the job is planning future storage requirements for the database system’s hardware. Since new data is always being entered, eventually you will need a bigger database, which means you will need a bigger computer to hold the data. DBAs also will have to modify the databases if a new category of information needs to be recorded. And the most important duty of a DBA is protecting the data. Security is of paramount importance for a database administrator. Hackers will go to extreme lengths to breach private information. Part of security involves controlling and monitoring use access on the database, as well as periodically backing up the database’s information and offering technical support for customers having difficulty accessing data. A DBA must also be able to use the Oracle programming language to communicate with the computers he or she is working

    Read More

  • The Importance Of Database Management Systems

    1411 Words  | 3 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. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.

    Read More

More about Database Management System vs Information Retrieval System

Open Document