Object-Oriented Database Management Systems Essay

Data objects can model relational data or advanced data types such as graphics, movies, and audio. Smalltalk, C++, Java, and others are objects used in object-oriented data. The object-relational is a combination of relational and object-oriented databases. Traditional and advanced data types can be used to construct database management systems. These systems can connect to a company’s website and update records as needed. Database Approach The main purpose of a database is data storage that can be stored and retrieved when needed. A popular common language called structured query language (SQL) is used to store and retrieve data in relational database. This language enables the systems to run a report or modify data or remove the data from the database. A database management system (DBMS) controls all aspects of a database, this is not limited to the creation, maintenance, and use of database. The DBMS ensures proper applications are able to access the database. An important purpose of a DBMS is to maintain the data definitions (data dictionary) for all the data elements in the database. It also enforces data integrity and security measures. Data Models Data models provide a contextual framework and graphical representation that aid in the definition of data elements. In a relational database, the data model lays the foundation for the database and identifies important entities,

At this stage, the specifics of the scope and the general content of the project has been identified and is the first step in database development. It illustrates the overall picture of organizational data at a high level of abstraction. In addition,

Database is defined as “the collection of information organized in such way that a computer program can quickly select the desired pieces of data.” (Haithcoat, n.d.). In today’s technological world most of the processes is automated where database plays an important role to manage the data across a system. A database can be considered as an electronic filing system. Traditional databases are organized by fields, records, and files. A field is a single element of information; a record is one complete set of elements; and a file is a collection of records. To manage these data across the database system, DBMS came into play and the basic role was to create the management of information across all the data. DBMS plays a critical and integral component of most successful GIS and used to store, manipulate and retrieve data from the database. Although the range of DBMS structures used in GIS includes inverted list, hierarchical, network and relation design.

Flexibility-This aspect relates to the provision of having multiple modules.In this context the system should be compatible with different gadgets for the adaptation of different dashboard

A Database Management System or (DBMS) is an essential tool for any organization or company in today’s modern world. A DBMS is “a group of programs that manipulate the database and provide an interface between the database and its users and other application programs” (Stair & Reynolds, 2011, p. 189). So in choosing the right DBMS there are many factoring issues with choosing the right one for the company or organization. When choosing a DBMS one has to think about how the system will ultimately help the company or organization with day to day processes and the goals of the company or organization.

Database plays a major role in any organization. As a Database administrator(DBA) he/she is responsible in developing, implementing and maintaining the databases and DBA 's are also responsible in updating, backup 's and security of the databases. The first Database Management System was developed in the late 1960 's by two firms based on their network data model but in the early 1970’s a scientist of IBM introduced Relational database theory after six years IBM completed prototype on RDBMS (relational database management system). Oracle created the first versatile Relational Database Management Systems In 1983, which allowed organizations to use their DBMS on different machines including mainframes, workstations, and Pc 's. In 1993 Microsoft first created a database application called Access for Macintosh machines. Microsoft SQL server is a RDBMS which is used to store and retrieve the data by other software applications. There are 12 types of servers concentrated on various types of user 's from single computer to large networks (Microsoft SQL DBA).

While mentioned several times in the technical memorandum, the following represent important aspects that need to be considered for any and all alternatives:

Coronel, C. (2013). Database Systems: Design, Implementation, and Management, Tenth Edition. Mason, Ohio, United States: Cengage Learning.

Relational database contains data records that do not have a preset of relationships, permitting the user to define his or her relationship when accessing the data. Since users have much control over the data being accessed, relational databases can perform a variety of tasks. Such as defining the database; querying the database; adding, editing, and deleting data from the database; modifying the structure of the database; securing data from public access; communicating within the network; and exporting and importing data (Murthy, 2008).

Flexibility for implementation of national incentives, government requirements or future provisions that might affect the purchase, features or use of the new system.

The db server is a postreSql database server which contains all the databases, each of which contain all data and most elements in the odoo system configuration

Oracle provides a flexible RDBMS called Oracle7. Using its features, you can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provides you with the ability to store and execute program units. The server offers the options of retrieving data based on optimization techniques. It includes security features that control how a database is accessed and used. Other features include consistency and protection of data through locking mechanisms.

Object Database – An object database is when objects are stored instead of data types like integers or strings. Objects are given an identity so that a reference can be given to it. Objects usually contain attributes and methods. Other objects that can be used are indexes, stored procedures, sequences, and many other objects.

Object-oriented programming is a programming paradigm based on the concept of objects rather than algorithms, this may contain data in the form of fields. it aims to incorporate the advantages of modularity and

Data are raw facts of the block of information. To be reminded that all the data will not useful information. Useful information is fulfilled from processed data. Specially, data is to be explained in order to gain information.