IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

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

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

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.

Body Bottom