Técnicas para capturar cambios en los datos y mantener actualizado un almacén de datos
During the extraction, transformation and loading processes it is critical to keep updated the data warehouse and data marts. In practice, several techniques that can b e used to capture changes in the data are available. Although from the theoretical point of view these techniques hav...
| Main Authors: | , , , , |
|---|---|
| Format: | Article |
| Language: | Spanish |
| Published: |
Universidad de Ciencias Informáticas
2015-10-01
|
| Series: | Revista Cubana de Ciencias Informáticas |
| Subjects: | |
| Online Access: | http://rcci.uci.cu/index.php?journal=rcci&page=article&op=view&path[]=890&path[]=381 |
| _version_ | 1828757315973545984 |
|---|---|
| author | Lisandra Díaz De la Paz Juan Luis García Mendoza Beatriz Eugenia López-Porrero Luisa Manuela González-González Wilfried Lemahieu |
| author_facet | Lisandra Díaz De la Paz Juan Luis García Mendoza Beatriz Eugenia López-Porrero Luisa Manuela González-González Wilfried Lemahieu |
| author_sort | Lisandra Díaz De la Paz |
| collection | DOAJ |
| description | During the extraction, transformation and loading
processes it is critical to keep updated the data warehouse and
data marts. In practice, several techniques that can b
e used to capture changes in the data are available. Although from the theoretical point of view these techniques have been studied,in practice its form of use is not visualized in an
organized way. Therefore,it is necessary to characterize, compare them and select the most appropriated. Given the simplicity aspects, types of sources that can be used, operations
it can detect and no loss of information, it was chosen the technique based on snapshot as the most appropriate
d. In addition a set of steps was proposed to follow for
application to a real problem, suggesting the use of steps belonging to the data integration tool Pentaho Data
Integration. |
| first_indexed | 2024-12-11T00:24:19Z |
| format | Article |
| id | doaj.art-9e898a943fc841e8a95fc5ce4c5c884a |
| institution | Directory Open Access Journal |
| issn | 1994-1536 2227-1899 |
| language | Spanish |
| last_indexed | 2024-12-11T00:24:19Z |
| publishDate | 2015-10-01 |
| publisher | Universidad de Ciencias Informáticas |
| record_format | Article |
| series | Revista Cubana de Ciencias Informáticas |
| spelling | doaj.art-9e898a943fc841e8a95fc5ce4c5c884a2022-12-22T01:27:37ZspaUniversidad de Ciencias InformáticasRevista Cubana de Ciencias Informáticas1994-15362227-18992015-10-019489103Técnicas para capturar cambios en los datos y mantener actualizado un almacén de datosLisandra Díaz De la Paz0Juan Luis García Mendoza1Beatriz Eugenia López-Porrero2Luisa Manuela González-González3Wilfried Lemahieu4Universidad Central “Marta Abreu” de Las Vi llas. Carretera a Camajuaní km 5 ½. San ta Clar a, Villa Clara, Cuba. Universidad Central “Marta Abreu” de Las Vi llas. Carretera a Camajuaní km 5 ½. San ta Clar a, Villa Clara, Cuba. Universidad Central “Marta Abreu” de Las Vi llas. Carretera a Camajuaní km 5 ½. San ta Clar a, Villa Clara, Cuba. Universidad Central “Marta Abreu” de Las Vi llas. Carretera a Camajuaní km 5 ½. San ta Clar a, Villa Clara, Cuba. Department of Decision Sciences and Information Management, Katholieke Universiteit Leuven, Naamsestraat 69, B - 3000 Leuven, Belgium . During the extraction, transformation and loading processes it is critical to keep updated the data warehouse and data marts. In practice, several techniques that can b e used to capture changes in the data are available. Although from the theoretical point of view these techniques have been studied,in practice its form of use is not visualized in an organized way. Therefore,it is necessary to characterize, compare them and select the most appropriated. Given the simplicity aspects, types of sources that can be used, operations it can detect and no loss of information, it was chosen the technique based on snapshot as the most appropriate d. In addition a set of steps was proposed to follow for application to a real problem, suggesting the use of steps belonging to the data integration tool Pentaho Data Integration.http://rcci.uci.cu/index.php?journal=rcci&page=article&op=view&path[]=890&path[]=381CDC techniquesdata mart sdata warehouseETLsnapshot |
| spellingShingle | Lisandra Díaz De la Paz Juan Luis García Mendoza Beatriz Eugenia López-Porrero Luisa Manuela González-González Wilfried Lemahieu Técnicas para capturar cambios en los datos y mantener actualizado un almacén de datos Revista Cubana de Ciencias Informáticas CDC techniques data mart s data warehouse ETL snapshot |
| title | Técnicas para capturar cambios en los datos y mantener actualizado un almacén de datos |
| title_full | Técnicas para capturar cambios en los datos y mantener actualizado un almacén de datos |
| title_fullStr | Técnicas para capturar cambios en los datos y mantener actualizado un almacén de datos |
| title_full_unstemmed | Técnicas para capturar cambios en los datos y mantener actualizado un almacén de datos |
| title_short | Técnicas para capturar cambios en los datos y mantener actualizado un almacén de datos |
| title_sort | tecnicas para capturar cambios en los datos y mantener actualizado un almacen de datos |
| topic | CDC techniques data mart s data warehouse ETL snapshot |
| url | http://rcci.uci.cu/index.php?journal=rcci&page=article&op=view&path[]=890&path[]=381 |
| work_keys_str_mv | AT lisandradiazdelapaz tecnicasparacapturarcambiosenlosdatosymanteneractualizadounalmacendedatos AT juanluisgarciamendoza tecnicasparacapturarcambiosenlosdatosymanteneractualizadounalmacendedatos AT beatrizeugenialopezporrero tecnicasparacapturarcambiosenlosdatosymanteneractualizadounalmacendedatos AT luisamanuelagonzalezgonzalez tecnicasparacapturarcambiosenlosdatosymanteneractualizadounalmacendedatos AT wilfriedlemahieu tecnicasparacapturarcambiosenlosdatosymanteneractualizadounalmacendedatos |