Database Systems and How They are Used
DBM/380 Week 1 Individual Assignment
Instructor: Kevin Judge
Database Systems and How They are used
Database systems are utilized in basically every business every day. Businesses use data to perform a multitude of functions, such as sales transactions, customer queries, and the viewing of key performance indicators. Database systems are the management tool that aids in accessing this data. “In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software (the DBMS) helps manage the cabinet’s contents”(Rob, P., Coronel, C., & Morris, S, 2013).
Database Architecture refers to the design of the database. For example, databases can be designed for a single site or multiple sites, ...view middle of the document...
Without database systems, companies would have no means by which to access the information stored in their databases. This information is required for day-to-day operations. For instance, Craig works for Verizon FiOS selling cable, phone, and Internet door-to-door. Craig utilizes a tablet to qualify a customer’s home, verify that customer’s credit, and assign the customer an installation date. Verizon uses multiple databases and database management systems to complete these tasks. First, there is a database involving addresses able to receive FiOS services. Second, there is a database linked with Equifax Credit Bureau. Last, there is a database linked with dispatch that corresponds with the dates available for installation. This Verizon FiOS database system is distributed because there are multiple sales representatives, like Craig, that utilize the system. It is also discipline specific considering it is only designed to do those particular functions. This is an Online Transaction Processing (OLTP) database system. It is used to create day-to-day business for the Verizon Company.
All companies make use of database systems. Prior to databases, companies had to utilize multiple file cabinets and keep paper copies of every transaction. Now, databases serve as the file cabinets and database systems manage those file cabinets so anything the company’s user needs is available at the touch of a button.
Rob, P., Coronel, C., & Morris, S. (2013). Chapter 1: Database Systems. In Database …..systems: Design, implementation, and management (10e. ed.). Cengage Learning.
Migration Process. (1998, January 1). Retrieved February 9, 2015, from …..http://docs.oracle.com/cd/B10501_01/win.920/a97262/ch2.htm
Vennapoosa, C. (Ed.). (2008, January 28). What is Data Architecture. Retrieved February …..10, 2015, from http://www.learn.geekinterview.com/data-warehouse/data-…..architecture/what-is-data-architecture.html