Relational And Object Oriented Database Management Systems

2226 words - 9 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. 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. When several users share the same data, centralizing data reduces redundancy and helps make retrieval of data more efficient. Fifth, DBMS can schedule concurrent access to the data, where when more than one user is accessing the data; users are protected from the possibility of system failures. Sixth, DBMS can reduce application development time since DBMS supports many important functions common to the many applications (Ramakrishnan 8-9).

There are some disadvantages to using a DBMS that must be taken into consideration however. For example, a DBMS is complex software best used with certain kinds of workloads. This relates to its performance not being adequate for certain specialized applications. Second, another application may have to manipulate entered data in order to manage. This can create a problem if the second application does not support the designed query language.

Developers of DBMS software are generally diverse in numbers and chosen fields. IBM and Oracle are two popular ventures for DBMS developers. Each venture has its own Database Administrator that manages DBMS for that place of business. The Database Administrator often designs schemas, provides security, and restores the system...

Find Another Essay On Relational and Object-oriented Database Management Systems

Analysis of database management and information retrieval systems

3286 words - 13 pages each. 5. Reference Question 1 Database Management System (DBMS) is a program that use by one or more computer users for create and access data to in a database or a set of software tools that control access, organize, store up, handle, retrieve and to maintain data in a database. In practical use, the terms database has a database server, database system, data server, and database management systems are often used

Database Systems And HealthCare Essay

1323 words - 5 pages market, which can be modified based on the needs of the users. The purpose of these packages is to increase efficiency and save time. Because this is such an important and delicate industry, these database systems need to be very carefully designed. A minor error can have tragic results. Use of database systems has revolutionized the healthcare industry. From scheduling to payroll to all kinds of related information are now stored in databases

Database Systems: Big Data Evolution and Efficiency

2224 words - 9 pages ] C. Ordonez, "Can We Analyze Big Data inside a DBMS?," in DOLAP '13 Proceedings of the sixteenth international workshop on Data warehousing and OLAP, San Francisco, 2013. [7] C. Bear, A. Lamb and N. Tran, "The Vertica Database: SQL RDBMS For Managing Big Data," in MBDS '12 Proceedings of the 2012 workshop on Management of big data systems, San Jose, 2012. [8] N. Tran, S. Bodagala and J. Dave, "Designing query optimizers for big data

Comparison of Message-Oriented Middleware (MOM) and Object Request Brokers (ORBs)

2336 words - 9 pages related concept about middleware, and especially analyse two types of middleware: Message-Oriented Middleware (MOM) and Object Request Brokers (ORBs), both are competing to become the network standard for linking legacy systems to the web. Finally, by comparing of their advantages and limitations, the specific type of middleware, which is better suited to do the work, is proposed.Introduction of middleware:Middleware is the wide range of services

Database Management System and Retrieval Information System

2036 words - 8 pages machines, flight reservation systems, and mechanized parts inventory systems. There are many functions a Database Management System (DBMS) serves that are key components to the operation of database management. When decide to perform a DBMS in business, first we must decide what type of DBMS we want. These are the ability to update and get back the data, Support Concurrent Updates, Recovery of Data, Security, Data Integrity. Each kind of database

Management Concepts and Systems

1856 words - 7 pages Management Concepts and Systems The National Academy of Sciences notes that the United States has many of the world’s most successful clinical research facilities and cutting edge medical technology, but there has not been as much of an effort to establish a system to measure the quality of care and the productivity of the healthcare system (National Academy of Engineering and Institute of Medicine Committee on Engineering and the Health Care

Management systems in Marks and Spencers.

1713 words - 7 pages the organisation need, and the role systems will play in providing information as part of decision-making. The initial report will be split up into 4 areas:1. Assess the role of information in management decision making and the role of technology in support of these roles2. Assess the roles of management information systems in contemporary organisations3. Establish a role of models, executive information systems, expert systems, and artificial

Leadership and Management in Healthcare Systems

1416 words - 6 pages Healthcare Systems Module 3 1. What are the legal ramifications of this case? Legally, there are elements of malpractice in this case. Negligence, or omission to do something a reasonable person would do, is evident by the supervisor, the nurse, and the LVN (Marquis & Huston, 2012). With this incident, there was not simply a failure to meet standard level of care, but there was injury to the patient since complications arose from the

This paper talking about Database Management Systems

571 words - 2 pages As ELI's system's manager it has been brought to my attention that a design development of a DBMS is necessary to create so department managers such as purchasing, operations, marketing, and personnel may be convinced DBMS is ideal. Designing a database follows a general rule of stage analysis in:Data requirementsClassification of informationRelationship between informationTransactions among data entitiesRules of identityThere are two stages in

A Fictional Case Study in Systems and Operations Management

3106 words - 12 pages Case Study in Systems and Operations ManagementAnalysis and evaluation of systems and operations managementBy applying the systems-level hierarchy and by the 4v's topology, one can evaluate and analyse systems and operation management system. An illustration is as follows. GOAL Sale of stationery and office supplies Criterion 1 Retail operations Criterion 2 Store management Criterion 3 Issues of operation Business customer Criterion 4

Devising of Optimization Models and Modelling Systems for Supply Chain Planning and Management

1847 words - 7 pages --these systems aren't generally oriented towards problem solving. Some ERPers have begun to address this issue, generally by purchasing SCMers or OPTers to provide actual modelling/solving capabilities.SCM solutionsThe SCMers, on the other hand, don't try to track all business transactions. Although sometimes misperceived as a niche ERP specialty market, supply chain management companies focus primarily on matching up supply and demand portions of

Similar Essays

Object Oriented Database Management Systems Essay

3217 words - 13 pages The construction of Object-Oriented Database Management Systems started in the middle 80's, at a prototype building level, and at the beginning of the 90's the first commercial systems appeared. The interest for the development of such systems stems from the need to cover the modeling deficiencies of their predecessors, that is the relational database management systems. They were intended to be used by applications that have to handle big and

Relational Database Management System Essay

1093 words - 4 pages on a client personal computer while accessing flight data that is conveniently managed by an Oracle Server on a central computer About Oracle8 Oracle8 is the first object-capable database developed by Oracle. It extends the data modeling capabilities of Oracle7 to support a new object relational database model. Oracle8 provides a new engine that brings object-oriented programming, complex datatypes, complex business objects, and full

Database Management Systems Essay

513 words - 2 pages A collection of programs that enables you to store, modify, and extract information from a database is considered a Database Management System. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The terms relational, network, flat, and hierarchical all refer to the way a DBMS organizes information internally. The internal organization can affect how quickly

Database Management Systems Essay

665 words - 3 pages Database Management SystemsUOPIntroductionData collection, organization, maintenance and, dissemination is crucial to our agency's daily operation and fiscal well-being. Our database management systems (DBMS) maintain data on over 1300 employees, as well as, thousands of patients. The accuracy of our data is paramount to appropriate patient care and supporting ourselves financially.Operating SystemsOur DBMS reside on two operating systems; AIX