Comparing and Contrasting the Relational Database Model and OO Model The relational database model is based upon tables or relations. In this model, the physical implementation of the database is abstracted away from the user. Users query the database using a high-level query language, such as SQL. The relations are made up of columns, which have headings indicating the attribute represented by that column. Tables have key fields, which can be used to identify unique records.
In addition, any changes made in database structure will be automatically recorded in the data dictionary, thereby freeing the users from having to modify all the programs that access the changed structure. Besides, the DBMS also functioning to create and manage the complex stru... ... middle of paper ... ...nvenient data point can be called as structured data. Non-structured data is definitely more interesting and archiving data. Some other examples of structured data including database, data warehouses and also enterprise system such as CRM and ERP while the other examples of unstructured data is the excel spreadsheet and RSS feeds. According to Robert Primer, the term structured data is generally applied to database while the unstructured data is applied to everything else.
It contains all the data definitions , report format and definitions of organizations which are related and system components. Database Management System- It is a commercial software system which is used to create , maintain and provide controlled access to the repository. Database - It is a collection of logically related data which is required to meet the needs of applications or users of organizations. SQL is a special purpose programming language designed for managing data held in relational database management systems(RDBMS).  1.
The OODBMS is the product of merging object oriented programming ethics with database management ethics. Object oriented programming concepts such as encapsulation, polymorphism and inheritance are imposed as well as database management concepts such as the ACID properties (Atomicity, Consistency, Isolation and Durability) which show the way for system reliability, it also supports an ad hoc query language and secondary storage management systems, which is allocated for managing very large amounts of data. The Object Oriented Database program specially lists the following features as compulsory for a system to support before it can be called an OODBMS; Composite objects, Object uniqueness, Encapsulation, Types and Classes, Class or Type Hierarchies, Overriding, overloading and late binding, Computational fullness, Extensibility, Perseverance, Secondary storage management, Concurrency, Recuperation and an Ad Hoc Query capacity. Now from the above mentioned description, an OODBMS should be able to store objects that are nearly impossible to differentiate from the kind of objects supported by the board programming language with as little limitation as feasible. Persistent objects should belong to a class and can have one or more infinitesimal types or other objects as attributes.
Data provisioning stores the organizational structure regulations in tables in its database, so these regulations can be changed without any difficulties when management decides to modify the organization. OCF created two relational databases to support data provisioning —one to support transaction processing and another to support information delivery. They used for transaction processing technology IBM’s DB2 running on the mainframe, designed to process high transaction volumes fast. For the information delivery technology they used a TERADATA database machine - a combination of hardware and software that is optimized for answering information questions. 2.
there are data dictionary management, data storage management, data transformation and presentation, security management, multiuser access control, backup and recovery management, data integrity management, database access languages and application programming interfaces, database communication interfaces, and transaction management. The first function of database management system is data dictionary. Database management system has been perform management functions to the elements in the database and how to connect the relationships with other data. When the system requires data in a database that will facilitate DBMS via SQL to access and search data. So that users can easily handle it.
Reading and writing of the data is performed at System buffers. As for the functions of DBMS, it is a query processing (SQL) and optimization, query optimization determines the optimum strategy for a query execution. Then, security control, DBMS have includes a prevent of unauthorized access to the database. Data Integrity in DBMS includes the facility for enforcing integrity constraints whenever a change is made to the data to ensure that the database is consistent and no error. Lastly, the functionality of DBMS is recovery, the DBMS must take steps to ensure that if the database fails, it will remain at a consistent state which that the data will not be lost.
The Database Management System (DBMS) is software that enables the users to define, create, maintain and control the access to the database. It is a software that interact with the user’s applications programs and it database. Meanwhile, information retrieval system is a system that involved the activity that the systems obtain the information. The obtaining information action need the information from it resources. The DBMS has a function that can be differentiate from the information retrieval system.
Database Database is an information that consists of data related with structure, meaning, purpose, users and application, objectives and fulfil need requirement. Database management system also known as DBMS is a information that been collected to general purpose. Database application is an independent programmed that provide service, storage manageable, give an efficient interfaced and generate report. There is a few functions of database which is structure definition, population, reporting ad modification of structure. There is a database functionalities that perform consistency and efficiency of database.
Query language is near to natural language. Besides that, the differences between data and information as follow: Database deal with structured information retrieval through well-defined formal languages for representation and manipulation based on the theoretically founded data models. Efficient algorithms have been developed for operators that allow rapid execution of complex queries. IR, on the other hand, deals with unstructured search with possibly vague query or search semantics and without a well-defined logical schematic representation. Whereas databases have fixed schemas defined in some data model such as the relational model IR system has no fixed data model; it views data or documents according to some scheme, such as the vector space model, to aid in query processing.