Here is the synopsis of our sample research paper on The Verizon Database. Have the paper e-mailed to you 24/7/365.
Essay / Research Paper Abstract
This 3 page paper looks at the use of the SQL Server 2000 production database by Verizon. The paper looks at the database system, how it is used and the way it operates. The bibliography cites 4 sources.
Page Count:
4 pages (~225 words per page)
File: TS14_TEverdata.rtf
Buy This Term Paper »
Unformatted sample text from the term paper:
Verizon is a large company with nearly 66 million business and residential customers (Verizon, 2008). The company needs to organize the data regarding the customers and facilitate its alteration and
amendment on a timely basis. For example, the customers addresses may remain fairly static, only changing occasionally, but records need to be updated to reflect the calls that are being
charged to the accounts. The database needs to process the call information to create the call charges and apply them to the account. When customers contact the call centre it
is essential that the employees at the facility are able to access their account details including call and charge details, as many calls are billing queries. The database used
by Verizon is a very large SQL Server 2000 production database. In 2003 this was the 6th largest OLTP database measured by the annual survey by Winter Corp data management
analysts (Bekker, 2003). The database is very large, consisting of 5.3 terabytes with more than 33 billion rows of data (Bekker, 20093). The system operates on a Hewlett Packard ProLiant
server along with EMC Symmetrix DMX storage devices (Auerbach, 2004). Produced by Microsoft SQL Server is a RDBMS (relational database management system) with Transact-SQL as the principle query language
(Microsoft, 2007). The architecture of the system is made up of three main segments; SQLOS, the relational engine and the Protocol layer. The SQLOS segment takes care of the basic
SQL server requirements which include memory and I/O management and thread scheduling and buffer pool management and resource management. This is where deadlock detection takes place. This is the segment
of the system where there is the implementation of functions that are usually associated with an operating system (Delaney, 2005). These are functions
...