Relational and Object-oriented Database Management...

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 databaseShow MoreRelatedTradeoffs Between Relational and Object-Oriented Database Management Systems1149 Words   |  5 Pagesthe tradeoffs between relational and object-oriented database management systems 1) Stating Position The object oriented DBMS is superior to the relational database on some specific counts, primarily because it can satisfy the complex demands of the market today better than the any other. Secondly while the relational data base stores data as tables, the object model stores data as objects and creates associations. This can create a multiple set of attributes for each object such that the data baseRead MoreInformation Storage And Management System1373 Words   |  6 Pagestechnology, information storage and management have been vital of importance. Information effectiveness and efficiency are determined by how well data is organised and processed. The term ‘data’ have been widely employed in different human activities, including science, business, education, law and the like. Here, data is a means for representation of facts, concepts, and instructions in order to communicate (Sumathi Esakkirajan 2007). Nevertheless, if data management is ineffective, and relevant inf ormationRead MoreElectronic Healthcare Information Systems Analysis1348 Words   |  6 PagesDatabases, Electronic Healthcare Information Systems, Data Sets and Data Standards Patient data is crucial to healthcare practice. Having the ability to create, modify, delete, and view patient data is the most important aspect of healthcare. A vital storage mechanism to perform the above functions is a database. A database is essential in development of Electronic Health Record system A database is an organized collection of data saved as a binary-type file on a computer (Sayles, 2013). Binary-typeRead MoreCommon Components Of Digital Database Management Applications1022 Words   |  5 Pages A DBMS can also provide many perspectives of a single database schema. A perspective characterizes what information the client sees and how that client sees the information. The DBMS gives a level of reflection between the reasonable diagram which characterizes the legitimate structure of the database and the physical construction that portrays the records, files and other physical instruments utilized by the database. At the point when a DBMS is utilized, frameworks can be adjusted all the moreRead MoreTechnology Changes Role of Database Administrator1195 Words   |  5 PagesTechnology Changes Role of Database Administrator The database administrator (DBA) is responsible for managing and coordinating all database activities. The DBAs job description includes database design, user coordination, backup, recovery, overall performance, and database security. The database administrator plays a crucial role in managing data for the employer. In the past the DBA job has required sharp technical skills along with management ability. (Shelly, Cashman, Waggoner 1992)Read MoreThe Evolution of The Database Essay example847 Words   |  4 Pagesinformation. This led to the development of systems like the dewy decimal system. Organizing books by subject and author made information retrieval a little easier. However, it was computer that revolutionized information storage and retrieval. Thus the first databases where born. Flat File Flat file databases where the first of many database models, almost as old as the computer. Flat file databases stored data in text files saved in the file system. There was little to no organization, it wasRead MoreData Model: Oodbms vs. Rdbms1067 Words   |  5 Pages1 Data model: OODBMS vs. RDBMS For this coursework two kinds of data models can be used. The object oriented data model, Object Oriented Database Management System(OODBMS), or the relational data model, Relational Database Management System(RDBMS). The differences between these two models and the data model to be used are described in this chapter. 1.1 Enumeration of some specifications of OODBMS and RDBMS RDBMS have been around for more than 20 years, OODBMS are relatively new; RDBMS canRead MoreWhat is the Purpose of a Database Management System?1474 Words   |  6 PagesThe purpose of this paper is to explain what a Database Management System (DBMS) is, the main principles of database design and to describe the features or characteristics of four prevalent database models. What is a DBMS? A database management system could be described as a file processing system that creates and administers data and or objects as information for the purpose of access and storage in a convenient way. Many types of programs have been written to add and extract information fromRead MoreKey Features Of The Database Management System1035 Words   |  5 Pagesof the database management system MongoDB. Day-to-day information is growing in gigantic amount. Generated information include predominant information and it will have to be analyzed for gathering essential expertise. On the whole, relational databases are used so as to system the data. These, ways works successfully for small amount of knowledge. What if the data is very tremendous? To avoid this problems Mongo databases are introduced. MongoDB is a cross-platform document-oriented database. ClassifiedRead Moreinformation system1255 Words   |  6 Pagesï » ¿ In all information systems, data resources must be organized and structured in some logical manner, so that they can be: D. All of the choices are correct. From a logical point of view, a(n) _______________ is the smallest data element that can be observed and manipulated. A. character A record represents a collection of _______________ that describe an entity. D. attributes All the fields used to describe the attributes of an entity are grouped to form a(n) _______________