System For Database Model Selection Computer Science Essay

Published: Last Edited:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Database is a main and necessary software part in all over the organizations in any case of its production for its skin and hi-tech functions in addition to the reward it provide for business's day to day life such as in rank storing, retrieving and updating, Object Relational and XML's features as well as relevance is discussed as well as also all the these models are compared in the paragraphs below.

A Database representation or Database model is the arrangement of a database, which explain in a proper language called management system. And also a database model is the application of a model of the data model when merger with a database management system. A database model is a measurement describing how a database is used. There are several models have been suggested.

A Data model is not just a way of used data its also defines a set of a act that can be performed on the data. For example defines action such a join as well as project. These actions are many not be in cleat in a exacting query language; they provide the foundation on which quires can be structured. Data structures are used in various models. Most database system are built just one particular data model, even if it is common for the products to push more that one models. Logical models are a range of objectives implementations many be possible, as well as most products will offer some level of control in Turing implementation which is objectives models. A relational model is the one of a good example and relational models are allow the creation which provides fast admission to work in a table if the values of columns are knows.

A relational database model and database is based on the relational model which is developed by E.F. Codd. Relational database allows the definition of the formation of the data, retrieval operation, integrity and storage. In the database the relational database and data between then are planned in the table wise. A table is set of records. And a field which is each record in tables contains fields.

Relational Tables Properties are:

Each rows is unique

Values area atomic

The sequence of columns in insignificant

And column values are of the dame kind

Keys are calculated in the certain fields, like wise and for the specific search values of the fields. An order table force contain (customer -ID, Product-code) which the pairs as well as the others yields of the tables contain (product-code, price) which can work out and given customer's bill you would calculate the price of the customers products which are taken by the customers, which join the products cost of the tables, this can be total to join multiple fields. These associations are only definite at recovery time, and relational database are classed as active database management system. As well relational Algebra is based on the Relational Database models.

All relational tables in a relational database cover to join here with some basic rules to order the relational. Columns are makes no difference ordering in a table. And there can be impossible to tell apart rows in a table. Each rows are contain single values of an characteristics. A primary key is one the key which can be individually identifying In a row what we called as a primary key. Keys are usually used to combine the data from table which are two tables or more than that. Each table may hold a column named Products which hold the values that complex the keys of products tables. That keys has outer and real word meaning such as book name and person name or bike serial number, these are sometimes called as nature keys as well as which keys are suitable of the attribute key and it can be assigned. Most databases have tighter generated keys while using those keys it can be also used.

The object relational model is generally designed to supply the relational database management that are allows to creates the ingrate database with their data types. It is a relational model which allows user to integrate objects oriented features to it. These types of designers are mostly shown in the relational/object model. The role which is primary use to the object relational model is to more power, grater data integrity and good flexibility and better performance.

Profit of Object-Relational Model includes:

Organizing the data on a structure made up of columns and tables.


A field may also contain an object with attributes and operation.

Complex objects can be stored in relational tables.

Extensibility - Users are able to extend the capability of the database server; this can be done by defining new data types, as well as user-defined patterns. This allows the user to store and manage data..

Complex types - It allows users to define new data types that combine one or more of the currently existing data types. Complex types aid in better flexibility in

The object-relational database management system which are also know as a ORDBMS, these kind of system are offer an addition of new and wide object storage capabilities to the relational models at the center of the more current information systems of today. These kind of services are learn the management of square fielded data, more complex object such as a time-period of geospatial data and the mixed dualistic media like wise, video, video, images and applets.

Functions and advantages to the Object-Relational Model is:

However, the relational model has to be drastically modified in order to support the classic features of the object oriented programming. This creates some specific characteristics for the object-relational model.

It can be said that the object relational model is an evolutionary technology, this approach has take on the robust transaction and performance management aspects of its predecessors and the flexibility of the object-oriented model.

Database developers can now work with somewhat familiar tabular structures and data definition but with more power and capabilities. This also allows them to perform such task all the while assimilating new object management possibilities.

Object-Relational mapping is a encoding method which we used to alter the data between incompatible data kind which systems are In relational database and object oriented languages. There are few basic mapping when its comes use. Java classes can mapped in to the relational database management system tables. The closest away to start the mapping amid and enduring class and a table is one-to-one. In this case there are all this, attributes in the enduring class are represented by all of the columns of the table.

Object Oriented Database Management System, also known as OODBMS focuses on Object Oriented Programming Concepts which is often called as OOP where each object is capable of receiving messages, processing data, and sending messages to other objects. Each object can be viewed as an independent 'machine' with a distinct role or responsibility. In Object Oriented databases, the values of complex objects may be constructed from other objects. The basic constructors are the atom, tuple, set, list, and array constructors. There is also a domain D that contains all basic atomic values that are directly available in the system. OODBMS have the capacity to offer better transparency and object oriented programming concepts and technologies.

The Object Oriented Model often called as Object models focuses on Object oriented model focuses on the concepts such as data hiding or encapsulation, inheritance and polymorphism.; it focuses on data rather than processes as it follows the object oriented technology, with programs composed of self-sufficient modules, each instance of which contains all the information needed to manipulate its own data structure. This is in contrast to the existing modular programming that had been dominant for many years that focused on the function of a module, rather than specifically the data, but equally provided for code reuse, and self-sufficient reusable units of programming logic, enabling collaboration through the use of linked modules. With object modeling we can manage large and complex data, and there is always an advanced modeling offered by object model as well as it supports advanced database applications.

The XML database is most commonly described as a data determination system which enables data to be accessed, imported and exported. XML stand for Extensible Markup Languages. The XML database is a Meta, Markup language that was developed by W3C to handle the inadequacies of HTML. XML does not in fact support any data types, even if by chance it does stand for another data type; this would be rather like a date or integer, two methods are most common in determining which transfer to do. The fist of these kind of methods in that the software determines the type of data that is since the database plan, this works out well because it is always on hand at run time.

Which we look for it Features of the XML Database, not all of the database are the same as we think, there are enough features among them that is the similar to give us a jagged idea of some of the basic structure, it impotent to note it down when its come to business entity model with the XML document so main, which not the storage system, in order to work with hat actually data you will be working and having to the basic knowledge of the XML. Another attribute of the database worth mentioning is quires. At presents situation XPath is the main query language which we choice, to task the database query language XPath is extended some quires across compilations of the documents.

Advantages that the XML model is:

Repair errors than with preceding data storage formats.

The extensibility the method that enables developers to put in additional information without breaching applications that were created from older versions of the arrangement.

Built-in support for internationalization due to the reality that it utilizes Unicode.

If we are planning to compare all these data models, in constant to a relational DBMS and relational model where a simple data structure must be flattened out to fit into the tables or joined tighter from the those tables to memory structure. This one of the one-to-one mapping structure of the object programming languages which entity to the database objects has two profits over other storage approach; its simply gives higher performance management of the object, as well as the it enables better management of the complex o d the interrelationship of the entity/object. This makes entity/object DBMSs better suited to hold up application such as financial portfolio risk analysis system, telecommunication service application, which are the World Wide Web document structure, its manufacturing and design system, and fro the newly hospital patient records system and complex relationship between data are combine with the DBMS.

Nowadays people are touching toward the object oriented/entity approach in many more fields. These fields include encoding/programming, software engineering, development technologies, database and implementation, etc.

Object oriented concept have their own creation and own roots in the object oriented programming languages. Which are Object Oriented Programming Models are systematically persistent about the system, the control of the OODB comes from the seamless treatment as well as the both persist data, as found in the database and transits of the data, which found from the exciting programs.

As an evolutionary technology, the entity/object relational approach has inborn the robust transaction- and the performance of the management features of its relational ancestor and the give of its object-oriented cousin. Database designers can work with familiar tabular structure and data deification, and JDBC, ODBC are callas interface which are extensions of RDBMS languages and interface. The Object Relational Models are work fro no other models before it could do than other models. By combing the strongest point of those which its comes before it, this kind of models are has surpasses prospect, and its taken on a best role in database technology.