The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
Dealing with Data Warehouse Transaction Processing Truncated Data: Case Study of sQl Server 2000
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.
|
|