Database Management and Information Retrieval Systems

Each distributed DB perform some procedures to protect the data from any threats may occur through transactions. First is access control methodology which prevent unauthorized access to data. Second, inference control which prohibit users from inferring confidential data of other individuals using queries. Finally, flow control to prevent information from flowing to unauthorized persons in a way that violates organization policies.

This step includes the task of describing a subset of data for each type of user based on his/her privileges and requirements. This is done to ensure that no additional information is given to the user. Views provide a level of abstraction to the database.

Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.

The database management system (DBMS) a group of programs used as interface between a database and application programs, or a database and the user. It is used to create and implement the right database system ensures that the database will support both business

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.

A database management system (DBMS) is a gathering of programs that will enables you to store, modify and source information from a database. There is many not the same types of DBMSs, reaching from small systems that run on a private computers to huge systems that will run on a mainframes

The purpose of information retrieval is to provide quality service for the right person at the right time, with all the required information in hand. Only if data is stored in a procedural manner it can be easily retrieved. Information might be retrieved for marketing purposes, for

legislation is firmly in place, it may not always prevent misuse, unethical use, or objective

The organization has a security objective of protecting the database from being altered. Since the data is held in the system, there are regulations that have been set to the users, and there are also limits to the functions that each user performs. In this case, there are three categories of users each with clearly defined responsibilities. For instance, the administration team has been given full control of the application in that they can even alter codes and perform any variations to the database objects. The other groups of users are the executives; these have the ability to access all the information

A database is used to store collections of information and easily retrieved at a later date. The larger the amount of information, the more organized a database needs to be. A database is created with the requirements and needs of current and future users and most importantly, with past users and their information. Out book defines database systems as “an organization of components that define and regulate the collection, storage, management, and use of data within a database environment”. (Database Systems, 2013)

Figure 11 shows the relationship of a database using DBMS, connecting the user with the information from the database. A database consists of many data from customers to orders, services, employees, and so on. The user can be a customer or employee. Employees use DBMS to find customer’s information, service types, and service provider information. Later in the process, the DBMS will then extract data from the database to answer the users’ questions.

- DBA security – Controlling the access on the DB level can also serve as a mechanism to protect sensitive data. In this type, there is always an administrator who controls the process of Account creation, granting access, revoking roles and assigning appropriate security level assignment.

The database itself is a compilation of information organized so that it can easily be accessed, managed, and updated. Computer databases typically contain a collection of data records or files that allow users the ability to read/write access, specify report generation,

Access control has been in use before the growth of the technology world. It could involve a simple action as locking a door. A person locks a door to prevent entry to those who are not allowed or authorize to do so. The same can be said about the security involving databases and the controlling of who can have access and what can be accessed. As far as database security is concerned, there are various categories that are involved in access control. The four main categories of access control include: Discretionary, Mandatory, Role-based, and Rule-based access control.

What is information retrieval system? Informational Retrieval System is the activity of obtaining information resources relevant to an information need from a collection of information resources. Web search engines are the most visible. Search can be based on metadata or on full-text (or other content-based) indexing. Automated information retrieval systems are used to reduce what has been called "information overload". Many universities and public libraries use IR systems to provide access to books, journals and other documents.