Database Management System and Retrieval Information System

Answer Structured data is defined as a data that are record and being filed in the database to make it can be used efficiently. frequent the case with the selection of the type of detailed data structures should be used to allow efficient algorithms can be used. Good design data structure allows a variety of critical operations carried out by using the time and little memory space, as possible. structured data will be represent in discrete form which is in column and row form. this can make the data in the database more organized.

According to Robert Primer, the term structured data is generally applied to database while the unstructured data is applied to everything else. Mostly, the unstructured data is related to information that is not to be in column-row database and not to be stored in database. This type of data often including the text and multimedia such as email, video, audio file and photo. Nowadays, there are lots of company that use the unstructured data as it helps the company to manage their storage space including software and hardware efficiently.

Question 1. Differentiate between database management system and information retrieval system by focusing on their functionalities. Database Management System (as known as DBMS) is a set of application that enable user to create, edit, update, store and retrieve data from database files. By using DBMS, data in a database can be added, deleted, changed, sorted and searched. DBMSs are usually used to manage employee information of a big company, customer information and stock information.

Data provisioning receives, stores, and manages all validated transaction data from transaction processing. It also provides data back to transaction processing and information-to-information delivery when requested. Data dictionary and data catalog keep way of what data exists, where it is stored, what it means, and who has authority to access it. That helps data provisioning to protect the data and to provide access to data and information to those who need it. 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.

b. Data Manipulation Language . c. Data Control Language . Data Definition Language (DDL): This component is used to CREATE and ALTER (or) modify the tables and the objects of that database. CREATE TABLE 'TABLENAME' , DROP TABLE 'TABLENAME' and ALTER TABLE ... ... middle of paper ... ...tandards and the role they play in business By following SQL standards there is greater role of compatibility between similar kind of databases.

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.

There is a database functionalities that perform consistency and efficiency of database. This function can be achieved by using the DBMS. First and foremost is DBMS as a data dictionary management that consist of definition for each data element and the relationship that been stored in a data dictionary. Means that all programs that access the data into database will work through the DBMS. The data dictionary will be used by DBMS to the require data component structure and its relationship.

1. Differentiate between database management system and information retrieval system by focusing on their functionalities. Database management system Information retrieval Database management system can provide access to all of the data, alleviating many of the problems associated with data file environment, and data can be shared among data users. Information retrieval can provide the techniques of storing and recovering data and often disseminating Recorded Especially through the use of a computerized system storage techniques and recovery and often disseminate especially through the use of recorded computer data. Types of database management system is centralized and distributed.

The DBMS will protect the structure of the data structure. Another function of the DBMS is the concurrency control services. Database Management System must ensure that the database is updated correctly because the database can be used by many multiple users. The DMS enable many user to access the data concurrently. The database managements system will help from ay data loss.

A computerized database is an updated, organized file of machine readable information that is rapidly searched and retrieved by computer. A Data Base Management System is a collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications: · computerized library systems · automated teller machines · flight reservation systems · computerized parts inventory systems From a technical standpoint, DBMSs can differ widely. The terms relational, network, flat, and hierarchical all refer to the way a DBMS organizes information internally.