Relational and Object-oriented Database Management Systems Essay
2156 Words9 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…show more content…
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 if a failure occurs. There is also a Database Systems Manager who monitors the running of the system, and managing users requests.
There are three common types of databases prevalent in the business arena: Relational, Object-Oriented, and Object-Relational.
Relational Database Management System
Edgar F. Codd at IBM invented relational database
An object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system), is a database management system (DBMS) that supports the modelling and creation of data as objects. This includes some kind of support for classes of objects and the inheritance of class properties and methods by subclasses and their objects. There is currently no widely agreed-upon standard for what constitutes an OODBMS, and OODBMS products are considered to be still in their infancy. In the meantime, the object-relational database management system (ORDBMS), the idea that object-oriented database concepts can be superimposed on relational databases, is more commonly encountered in available products. An object-oriented database interface standard is being developed by an industry group, the Object Data Management Group (ODMG). The Object Management Group (OMG) has already standardized an object-oriented data brokering interface between systems in a network.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
In their influential paper, The Object-Oriented Database Manifesto, Malcolm Atkinson and others define an OODBMS as follows:
An object-oriented database system must satisfy two criteria: it should be a DBMS, and it should be an object-oriented system, i.e., to the extent possible, it should be consistent with the current crop of object-oriented programming languages. The first criterion translates into five features: persistence, secondary storage management, concurrency, recovery and an ad hoc query facility. The second one translates into eight features: complex objects, object identity, encapsulation, types or classes, inheritance, overriding combined with late binding, extensibility and computational completeness.
Their paper describes each of these features in detail.