Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/31417
Título: | Archiving business operational data heritage |
Autor(es): | Belo, Orlando Marques, Alice |
Palavras-chave: | Database archiving Data warehouses Archiving Oriented Dimensional Modelling Multidimensional structures |
Data: | 2012 |
Editora: | Elsevier 1 |
Revista: | Procedia Technology |
Resumo(s): | Operational Database Systems are keeping large amounts of information that are not used in any aspect on current business processes. It’s inactive data maintained only for historic reasons or simply 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 modeling 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. |
Tipo: | Artigo em ata de conferência |
Descrição: | Series: Procedia technology, vol. 1 |
URI: | https://hdl.handle.net/1822/31417 |
ISBN: | 978-162-7485-1-80 |
DOI: | 10.1016/j.protcy.2012.02.021 |
ISSN: | 2212-0173 |
Arbitragem científica: | yes |
Acesso: | Acesso restrito UMinho |
Aparece nas coleções: |
Ficheiros deste registo:
Ficheiro | Descrição | Tamanho | Formato | |
---|---|---|---|---|
2011-Insode-PaperID-6468.pdf Acesso restrito! | Documento principal. | 609,99 kB | Adobe PDF | Ver/Abrir |