Dealing with Data Warehouse Transaction Processing Truncated Data: Case Study of sQl Server 2000

View Free PDF

Author(s): Carin Chuang (Purdue University North Central, USA)and Kuan-Chou Chen (Purdue University North Central, USA)
Copyright: 2007
Pages: 3
Source title: Managing Worldwide Operations and Communications with Information Technology
Source Editor(s): Mehdi Khosrow-Pour, D.B.A. (Information Resources Management Association, USA)
DOI: 10.4018/978-1-59904-929-8.ch361
ISBN13: 9781599049298
EISBN13: 9781466665378

Keywords: Information Science Reference / IT Research & Theory / IT Research and Theory / Library & Information Science

Abstract

In this paper, the cause of truncated data in the transaction processing will be discussed. Specifically, the main goal of this paper is to demonstrate the function of recovery model in the SQL Server 2000. In the paragraphs to come, we will discuss in a little more detail, the truncated data that can take place, along with the importance of data integrity. Afterwards, we will discuss two scenarios cases to implement the recovery model. In the case, we will begin by discussing the transaction processing in between data warehouse. Afterwards, we will discuss the potential causes of truncated data. The last part of this case details configuration of each recovery model; more specifically what types of functions are available in this particular setting, what requirements those functions place on to deal with specific problems and few of the benefits that come with having experience. This paper has the potential to provide the recovery model needs to database administrator to do advanced support task.

IRMA Offers Over 2,500 Full Text Open Access Research Papers for Free Download Click to Start Searching Free IRM Research!

IRMA Sponsors

Encyclopedia of Information Science and Technology, Fourth Edition