CIS 319 Computers and Information Processing Analyzing the Use of Databases in the Workplace

Essay by gijoe419 February 2005

download word file, 4 pages 5.0

Downloaded 630 times

Abstract

Databases are powerful tools that when used correctly will provide businesses with an edge over the competition. Databases utilize the Structured Query Language SQL Server to run security and transactions. The SQL server provides client computers with highly efficient access to database files. The use of database programs has become a necessity to almost every business big or small.

Analyzing the Use of Databases

In the IT field, the need for databases is the heart of running the business. The databases we use hold all information about the daily transactions and important customer information. I will discuss some of the major databases we use. Databases are designed to offer an organized mechanism for storing, managing, and retrieving information (www. About.com). In the IT department, we use several types of databases from Microsoft Access to the server based SQL server. Microsoft Access is a database management system from Microsoft, packaged with Office, which combines the Jet relational database engine with a graphical interface intended to make it possible for relatively unskilled programmers and non-programmer "power users" to build sophisticated "front-ends" to complex databases (http://www.technolopedia.com,

2004). Our Microsoft Access databases are custom built to suit the business needs. Access is a powerful database program that will also query SQL databases if set up correctly.

There are many server based database programs that are available some of these include, IBM, Informix, Microsoft, Oracle, and Sybase (Information Week). These manufactures make some of the most popular server bases databases. Unlike their desktop cousins, server-based databases can handle just about any data management problem you can throw at them. Developers love these systems because they have programmer-friendly application programmer interfaces (APIs) that provide for the rapid development of database oriented custom applications. If you are willing to provide the necessary hardware resources, server...