Database Usage in the Workplace

ABSTRACT

One of the most important elements of a computer based information system is the database. A database is a collection of records or information that is stored in a computer in a structured manner so that information can be stored, managed, and retrieved. Databases are very useful for manipulating large amounts of data and producing reports and documents. This paper takes a look at the Oracle database system and its usage within my organization.

The main objective of a database is to help an organization accomplish its goals. (Stair & Reynolds, 2006). There are a number of ways that a database can contribute to the success of the company. Managers are able to make accurate decisions based on the information that is stored within databases. This information also allows the organization to reduce costs, increase profits, and analyze statistical data to make future predictions on information of interest.

A database management system (DBMS) is a group of programs that manages the database and provides an interface between the end users and other application programs (Stair & Reynolds, 2006). Companies use DBMS systems as a single point of management for all data resources as part of the database environment. This allows for ease of use and security of the data. The database administrator (DBA) is the person whom is trained in database activities, and is responsible for administrative and security related issues referencing the database.

Companies that use database management systems use the database approach to as opposed to the traditional approach, where customer data is maintained in separate files with each file relating to the process that is specific to the organization such as billing, shipping. The database approach is very advantageous to the organization because each application uses a collection of data that is related in the database.

Another advantage of the database approach is flexibility in terms of data usage. The data is kept in the same database instead of separate files, and is therefore easier to locate and retrieve for several types of processing. Because of the sharing capabilities of a database, organizations can coordinate information across a wide range of functional areas.

My organization is a software company that