Office Databases

Essay by candyxss07 August 2009

download word file, 3 pages 0.0

Downloaded 23 times

The need for databases is the heart of running an organization. Databases will provide an organization with an edge over the competition. The databases we use hold all the information about the daily transactions and important customer information. Databases use structured query language, SQL Server, to run security and transactions. The SQL server provides users with fast and efficient access to files on the database. The use of database programs has become a necessity to almost every business big or small. About.com stated, "Databases are designed to offer an organized mechanism for storing, managing, and retrieving information," (http://databases.about.com, 2006). There are many server-based database programs that are available. Some of these databases include IBM, Informix, Microsoft, Oracle, and Sybase, (Whiting, 2000). Server-based databases help to manage customer and employee records, inventory, and financial transaction records along with many other types of business information.

Databases are vital for almost every company in today's business world.

Databases can help us track inventory, billing, pay role, and much more, (www.devshed.com, 2006). Without the use of databases, work will take infinity longer to accomplish. If the database did not exist, we would have to revert to paperwork, which will slow down productivity. Employees would then have to hand-write everything down and make phone calls and faxes to accomplish simple tasks. Since we use a database, all users from customers to employees, will have access to the information.

My company has hundreds of databases that are all connected together in one way or another.

Information in one database is linked to another database or a spreadsheet on another network or system. Access to these databases is very limited because of security. Since these databases are linked together in many ways, each department can only see what he or she need to access to...