The Experts below are selected from a list of 12 Experts worldwide ranked by ideXlab platform
Jack E. Olson - One of the best experts on this subject based on the ideXlab platform.
-
Database Archiving Overview
Database Archiving, 2020Co-Authors: Jack E. OlsonAbstract:Archiving is the process of preserving and protecting artifacts for future use. Database archiving is the act of removing from an operational Database selected Data objects that are not expected to be referenced again and placing them in an Archive Data Store, where they can be accessed if needed. In archiving, not all Data objects are ready to be moved to the Archive at the same time. A Database contains a large collection of like Data objects. Archiving occurs on a periodic basis—once every week. At the time that a specific Archive sweep of the Database is done, only some of the objects are ready to be Archived. The policy used to select those objects that are ready needs to be defined in Data value terms using information contained within or about the objects.
-
The Archive Discard Component
Database Archiving, 2020Co-Authors: Jack E. OlsonAbstract:Publisher Summary The Archive discard component periodically reads the Archive Data Store to find business objects that have reached the end of their intended Archive lives and need to be removed. Discarding Archived Data is not as simple as discarding files for which their stipulated retention period has elapsed. Within an Archive Data Store there are Data that need to be discarded and other Data that do not. The Data that qualify at any one point of time will not be conveniently packed together within the Archive to facilitate easy removal. They will be spread out among other Data. The discard component should not leave partial business objects in the Archive. The unit of discard is a single business object—nothing less and nothing more. This is the same definition that was used for extract and Store. It makes no sense to discard only part of a business object.
-
The Archive Data Store
Database Archiving, 2020Co-Authors: Jack E. OlsonAbstract:The Data being Archived comes from Databases. It has the same characteristics in the Archive that it had in the operational Database management system (DBMS), which managed it before it was moved to the Archive. The Archive Data Store can benefit from having other desirable features that are not applicable to the operational Database environment. These features call for different optimization characteristics from those used to construct the DBMSs used for normal operations. The Data can be Stored in a DBMS, Database UNLOAD files, XML files, or what one calls a custom Archive DBMS. The custom Archive DBMS is a sketch of a Data Store that is designed to provide the most efficient capabilities for an Archive Data Store.
Alice Marques - One of the best experts on this subject based on the ideXlab platform.
-
Archiving business operational Data heritage
Procedia Technology, 2020Co-Authors: Orlando Belo, Alice MarquesAbstract:Abstract Operational Database Systems are keeping large amounts of information that are not used in any aspect on current business processes. It‟s inactive Data that is maintained only for historic reasons or to ensure Data patrimony and process heritage. Thus, Database archiving is today a critical task for companies that are worried about their Data storage devices, processing resources, and, obviously, Data preservation. Extracting selectively relevant business information from operational Database and storing it on a separate Archive Data Store for consulting it‟s a good strategy for preserving Data as well to reduce storage Database resources and improve Data processing services. In this paper we propose an archiving technique inspired on the most effective Data warehousing dimensional modelling techniques. We designed and developed a set of mechanisms with the ability to analyze and characterize a conventional relational Database, and based on a set of business preservation requirements and archiving rules, prepare it to be Archived on a multidimensional system designed automatically. We‟ll present their description and functionalities, describing the way in which they can be used and the manner how operational Data is Stored in a archiving oriented Data warehouse.
Orlando Belo - One of the best experts on this subject based on the ideXlab platform.
-
Archiving business operational Data heritage
Procedia Technology, 2020Co-Authors: Orlando Belo, Alice MarquesAbstract:Abstract Operational Database Systems are keeping large amounts of information that are not used in any aspect on current business processes. It‟s inactive Data that is maintained only for historic reasons or to ensure Data patrimony and process heritage. Thus, Database archiving is today a critical task for companies that are worried about their Data storage devices, processing resources, and, obviously, Data preservation. Extracting selectively relevant business information from operational Database and storing it on a separate Archive Data Store for consulting it‟s a good strategy for preserving Data as well to reduce storage Database resources and improve Data processing services. In this paper we propose an archiving technique inspired on the most effective Data warehousing dimensional modelling techniques. We designed and developed a set of mechanisms with the ability to analyze and characterize a conventional relational Database, and based on a set of business preservation requirements and archiving rules, prepare it to be Archived on a multidimensional system designed automatically. We‟ll present their description and functionalities, describing the way in which they can be used and the manner how operational Data is Stored in a archiving oriented Data warehouse.