Databases in My Organization
Databases have been in use since the early days of computing programs. An Information Technology services company, such as Getronics, not only utilizes databases for information and record management, it earns revenue by providing database management services. Getronics uses Microsoft SQL Server 2000 as its database software. The clients that contract Getronics for Information Technology services rely and depend on the accuracy and currency of the database information that is stored. Databases will continue to exist and expand as more companies become more of aware of the importance of record and data management.
Databases have been in use since the early days of computing programs. In basic terms, a database is a collection of information that can be easily accessed, managed, and updated. (www.whatis.com) Regardless of the type of information that is stored in a database, it is categorized and filed. And every type of business utilizes a database for information and record management.
An Information Technology services company, such as Getronics, not only utilizes databases for information and record management, it earns revenue by providing database management services. Some of the other services that are provided by Getronics rely on a backend database that is integrated with a client facing application. These databases have tables that contain end user information such as phone numbers, employee numbers, and site addresses. As well as tables that include many application functions that directly connect with a client facing application.
Getronics is a certified Microsoft Partner; therefore, Getronics uses Microsoft technology such as Microsoft SQL Server 2000. Microsoft SQL, or structured query language, is a standard interactive and programming language for getting information from and updating a database. (www.whatis.com) Every application that is developed or purchased by Getronics uses a SQL database as its backend office application. This standard application allows for development teams to design and implement applications and utilities that can integrate with one another. This type of design is intentional based on the type of services Getronics provides to its clients.
One of the client facing applications that is heavily dependent on the database backend is the incident management system that is offered by Getronics for its clients. An incident management system tracks end user requests, problems, and changes that are recorded by a service desk, or help desk team. The application relies on over 300 tables that contain individual pieces of information the build an end user’s request. Each table is linked by a common, unique identifier, commonly known as primary key. This unique identifier exists in all tables and links the records together....