Abstract-BACKGROUND: A data warehouse (DW) is anintegrated collection of subject-oriented data in the support of decision making. Importantly, the integration of data sources is achieved through the use of ETL (Extract, Transform, and Load) processes. It is therefore extensively recognized that the appropriate design of the ETL processes are key factors in the success of DW projects. OBJECTIVE: We assess existing research proposals about ETL process modeling for data warehouse in order to identify their main characteristics, notation, and activities. We also study if these modeling approaches are supported by some kind of prototype or tool. METHOD: We have undertaken a systematic mapping study of the research literature about modeling ETL processes. A mapping study provides a systematic and objective procedure for identifying the nature and extent of the available research by means of research questions. RESULTS: The study is based on a comprehensive set of papers obtained after using a multi-stage selection criteria and are published in international workshops, conferences and journals between 2000 and 2009. CONCLUSIONS: This systematic mapping study states that there is a clear classification of ETL process modeling approaches, but that they are not enough covered by researchers. Therefore, more effort is required to bridge the research gap in modeling ETL processes. [15]. Estas herramientas se diseñan desde la perspectiva lógica y en la mayoría de los casos, presentan algunos inconvenientes: (i) falta de especificidad, (ii) dependencia de la plataforma destino, (iii) la configuración y estructura son muy complejas, (iv) requieren grandes requerimientos de hardware y, por lo tanto, no son factibles para pequeños y medianos proyectos. Estas características pueden hacer difícil la integración en ambientes heterogéneos de ADs. Por estas razones y, además, por la larga curva de aprendizaje, y el alto costo de adquisición y mantenimiento, muchas organizaciones prefieren desarrollar sus propios procesos ETL. Keywords-Dada la importancia de los procesos ETL dentro del marco de desarrollo de ADs, en este artículo se pretende brindar una aproximación a través de un mapeo sistemático de estudios, de cuáles son los diferentes enfoques de modelado de procesos ETL, características relevantes de cada uno de ellos, actividades, notaciones y problemática presentada en cada enfoque. Es con esta motivación que el estudio actual ha surgido de nuestro trabajo para recopilar, mapear y resumir los estudios primarios sobre modelado conceptual de procesos ETL para AD de manera precisa [7]. Un mapeo sistemático ofrece una visión sistemática de un área de investigación y permite evaluar la cantidad de pruebas existentes sobre un tema de interés [7] (véase, por ejemplo de Bailey et al. mapeo de estudios [1]).El mapeo sistemático de estudios es una metodología que se utiliza con frecuencia en la investigación médica. El objetivo principal de un mapeo sistemático de estudios es
In this paper we propose a novel channel model for indoor wireless environments. Using a set of real measurements, we tune the parameters of an Auto-Regressive filter, which is the core of the proposed model; furthermore we assess that its behavior is much closer to real wireless links that those exhibited by some of the most currently used approaches. The novel channel model is integrated within the framework of the Network Simulator environment. Its goal is to mimic the "bursty" behavior that characterizes the aforementioned indoor wireless environments.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
customersupport@researchsolutions.com
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.