Differentiate between database management system and information retrieval system by focusing on their functionalities. Answer Database Management System A database management system (DBMS) is the main software tools of the database management approach because it controls the creation, maintenance and use of the databases of an organization and its end users. There are several functions that a DBMS performs to ensure data integrity and consistency of data in the database. There have ten function of database management system. 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.
PL/SQL is a combination of SQL along with the procedural features of programming languages.The PL/SQL programming language was developed by Oracle Corporation as procedural extension language for SQL and the Oracle relational database.Some of notable facts about PL/SQL: • PL/SQL is portable, high-performance transaction processing language. • PL/SQL provides a built in interpreted as well as OS independent programing environment. • PL/SQL can directly be called from the command line SQL-Plus interface. • Direct call can be made from external programming language calls to database. • PL/SQL's general syntax is based on that of ADA and Pascal programming language.
Software is application inside the computer. Lastly, the user is the one who clearly understand what it means to use the system on a daily basis. There are a number of functions that a typical DBMS will support. • Data Definition Language as known as DDL – to define a database. The DBMS must allow users to create database definitions • Data Manipulation Language as known as DML – to insert, update, delete, and query data in the database.
Every application in the real world needs to interact with databases. Java Database Connectivity (JDBC) is the Application Programming Interface (API) used to build Java applications that can interact with relational databases. There are many relational databases such as Oracle, My SQL, DB2, Java DB, Dbase, Sybase, Ingress, Informix, FoxPro and so on. The researcher will be able to use the four types of JDBC drivers to interact with any kind of database in the world. In this iteration, the researcher also learns Structured Query Language (SQL) which is the underlying language used long with JDBC API to get things done in backend (a term used to refer database).
b) DBMS (Crucial Concept): The DBMS would be responsible for all database activities (storage, retrieval, indexing, etc) and also be responsible for keeping a detailed description of the data being held. DBMS is a program that helps users to communicate with the Operating System through an interface in order to access the data from a Database in a friendly way and as soon as possible. It allows users to store retrieve and update information quick and productive. DBMS handle to recover the database in case of system error and needs to have an organized system for security issues. c) Metadata – Data that Describes Data Metadata it’s all about data being held in a Database.
(Safari Tech Books Online, 2002, chap. 2) Some of the similarities in the database model are that all three can be used in the database design process in some way. In our previous class DBM 380 we used the ER model for our projects even from our preceding projects we can create the database model in an Object or UML model. Of the three database models I find that the Entity Relationship model was the easiest to create and explain to an end user it also transforms effortlessly into relationship tables which worked well in Access. The Object model and UML model seem to be more of a language model than the ER model seems to be more for just databases although the Object model addresses both programming and databases.
Technology Changes Role of Database Administrator The database administrator (DBA) is responsible for managing and coordinating all database activities. The DBA's 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).
Difference between DBMS and IRS by focusing on their functionalities. A Database Management System (DBMS) is a software system that uses a standard way of classifying, retrieving, and running queries on data. The DBMS functions is to manage any incoming data, organize it, and provide ways for the data to be modified or extracted by users or other programs. Some examples of DBMS are PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle,Clipper and FoxPro. Since there are so many database management systems are available, so it is important to ensure that they communicate with each other.
SOFTWARE A set of instructions that directs a computer's hardware to perform a task is called a program, or software program. Software comprises the entire set of programs, procedures, and routines associated with the operation of a computer system. The two main types of software are system software and application software. System software controls a computer's internal functioning, chiefly through an operating system , and also controls such peripherals as monitors, printers, and storage devices. Utilities and compilers are also parts of system software.
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.