1,272 Hits in 3.0 sec

Benchmarking ETL Workflows [chapter]

Alkis Simitsis, Panos Vassiliadis, Umeshwar Dayal, Anastasios Karagiannis, Vasiliki Tziovara
2009 Lecture Notes in Computer Science  
In this paper, we identify common characteristics of ETL workflows in an effort of proposing a unified evaluation method for ETL.  ...  Each ETL tool uses its own technique for the design and implementation of an ETL workflow, making the task of assessing ETL tools extremely difficult.  ...  First, we provide a principled way for constructing ETL workflows (Section 2).  ... 
doi:10.1007/978-3-642-10424-4_15 fatcat:mzyiwt6iwbgghkpsbgxhp7yo2y

HTAP With Reactive Streaming ETL

Carl Camilleri, Joseph G. Vella, Vitezslav Nezval
2021 Journal of Cases on Information Technology  
Finally, a reactive streaming ETL pipeline is implemented which connects these two DBMSs. Separate benchmarks show that OLTP events can be streamed to an OLAP database within a few seconds.  ...  Then, benchmarks on two industry standard DBMSs empirically show that, under an OLTP workload, a row-store DBMS sustains a 1000 times higher throughput than a columnar DBMS, whilst OLAP queries are more  ...  , can support actionable and reactive decisions when connected via an efficient ETL pipeline built on the principles of the Reactive Manifesto.  ... 
doi:10.4018/jcit.20211001.oa10 fatcat:b4yfkpuvkfgefkm66yixlti3cu

DIPBench: An independent benchmark for Data-Intensive Integration Processes

Matthias Bohm, Dirk Habich, Wolfgang Lehner, Uwe Wloka
2008 2008 IEEE 24th International Conference on Data Engineering Workshop  
Due to the absence of an independent and universal benchmark for data-intensive integration processes, we propose a scalable benchmark, called DIPBench (Data Intensive Integration Process Benchmark), for  ...  and Extraction Transformation Loading (ETL) tools.  ...  Further, also an ETL Benchmark with quality metrics was already discussed in [18] .  ... 
doi:10.1109/icdew.2008.4498321 dblp:conf/icde/BohmHLW08a fatcat:le2qeaggyvfi3cury6zriptxxi

DIPBench Toolsuite: A Framework for Benchmarking Integration Systems

Matthias Bohm, Dirk Habich, Wolfgang Lehner, Uwe Wloka
2008 2008 IEEE 24th International Conference on Data Engineering  
A first step towards sufficient techniques was the specification of a universal benchmark for integration systems.  ...  However, we see the requirement for providing a sophisticated toolsuite in order to minimize the effort for benchmark execution. This demo illustrates the use of the DIPBench toolsuite.  ...  ACKNOWLEDGMENT We want to thank the students Katrin Braunschweig, Romain Treboux and Dirk Alsfaßer for their efforts on extending and enhancing the Initializer tool.  ... 
doi:10.1109/icde.2008.4497630 dblp:conf/icde/BohmHLW08 fatcat:nukuichwoveipoqhckemvbh73q

Towards Equivalent Transformation of User Preferences in Cross Domain Recommendation [article]

Xu Chen and Ya Zhang and Ivor Tsang and Yuangang Pan and Jingchao Su
2022 arXiv   pre-print
Extensive experiments on three public benchmarks demonstrate the effectiveness of ETL compared with recent state-of-the-art methods. Codes and data are available online:  ...  Based on this assumption, we propose an equivalent transformation learner (ETL) which models the joint distribution of user behaviors across domains.  ...  In ETL, we do not tune hyper-parameter 𝜂 and fix it as 1.0 on the three benchmarks for simplicity.  ... 
arXiv:2009.06884v2 fatcat:aeyzv4kotbakrirf4mdhqt6luy

Using OpenStreetMap Data to Create Benchmarks for Description Logic Reasoners

Thomas Eiter, Patrik Schneider, Mantas Simkus, Guohui Xiao
2014 International Workshop on OWL Reasoner Evaluation  
The ETL Mapping Axioms define a single ETL step, where the syntax is an extension of the Ontop mapping language.  ...  Benchmarks and Results All the mapping files and test data for the introduced benchmark are available online [1] . OSM Dataset and Benchmark Ontology.  ... 
dblp:conf/ore/EiterSSX14 fatcat:mxvt2qautnfcrlcgg3f6w6oyby

A Survey of Extract–Transform–Load Technology

Panos Vassiliadis
2009 International Journal of Data Warehousing and Mining  
[Article copies are available for purchase from]  ...  triplet, and examine problems that fall within each of these stages, (c) we discuss problems that pertain to the entirety of an ETL process, and, (d) we review some research prototypes of academic origin  ...  A second approach towards a benchmark for ETL processes is presented in Vassiliadis, Karagiannis, Tziovara, Simitsis (2007) .  ... 
doi:10.4018/jdwm.2009070101 fatcat:okcajnbvabhe5fx72svcdkwrzu

GEM: Requirement-Driven Generation of ETL and Multidimensional Conceptual Designs [chapter]

Oscar Romero, Alkis Simitsis, Alberto Abelló
2011 Lecture Notes in Computer Science  
It is of great importance for the business of an enterprise to facilitate and automate such a process.  ...  The goal of our research is to provide designers with a semi-automatic means for producing conceptual multidimensional designs and also, conceptual representation of the extract-transform-load (ETL) processes  ...  For guaranteeing the MD design principles (see Section 2.2), factual and dimensional nodes must be related properly.  ... 
doi:10.1007/978-3-642-23544-3_7 fatcat:rsntllc3irbsnju5u3fwzmarru

Risk Management and Portfolio Optimization for Volatile Markets [chapter]

Svetlozar T. Rachev, Borjana Racheva-Iotova, Stoyan V. Stoyanov, Frank J. Fabozzi
2010 Handbook of Portfolio Construction  
Along with being a superior risk measure, SETL enables an elegant approach to risk budgeting and portfolio optimization Finally, we mention alternative investment performance measurement tools.  ...  We describe a framework of a system for risk estimation and portfolio optimization based on stable distributions and the average value-at-risk risk measure.  ...  If the benchmark is zero, r b = 0, and instead of ETL we use the standard deviation, which is an uncertainty measure, then the optimization problem transforms into the classical Markowitz problem.  ... 
doi:10.1007/978-0-387-77439-8_17 fatcat:tanjjtvpffbv7h5a5pqj2t3ohm

The Linked Data Benchmark Council Project

Peter Boncz, Irini Fundulaki, Andrey Gubichev, Josep Larriba-Pey, Thomas Neumann
2013 Datenbank-Spektrum  
Despite the fast growth and increasing popularity, the broad field of RDF and Graph database systems lacks an independent authority for developing benchmarks, and for neutrally assessing benchmark results  ...  recently launched a European Commision sponsored project that will offer the first comprehensive set of open and vendor-independent benchmarks for RDF and Graph technologies.  ...  Conclusions In this paper we presented the Linked Data Benchmarking Council, the initiative towards RDF/Graph benchmarking.  ... 
doi:10.1007/s13222-013-0125-y fatcat:qmqlsg23djf5dn24eavhffhuou

LOD for Data Warehouses: Managing the Ecosystem Co-Evolution

Selma Khouri, Ladjel Bellatreche
2018 Information  
Our approach is tested using: the LUBM (Lehigh University BenchMark), different LOD datasets (DBepedia, YAGO, etc.), and Oracle 12c database management system (DBMS) used for the DW deployment.  ...  The development of linked open data (LOD) as external sources is an excellent opportunity to create added value and enrich the analytical capabilities of DWs.  ...  the internal ETL flow with the external flow), and the query operator for unifying the result of an ETL flow required by a given with the internal DW.  ... 
doi:10.3390/info9070174 fatcat:f6tmnoodfbaijczogp3uqxos6e

++Spicy: an OpenSource Tool for Second-Generation Schema Mapping and Data Exchange

Bruno Marnette, Giansalvatore Mecca, Paolo Papotti, Salvatore Raunich, Donatello Santoro
2011 Proceedings of the VLDB Endowment  
Recent results in schema-mapping and data-exchange research may be considered the starting point for a new generation of systems, capable of dealing with a significantly larger class of applications.  ...  We introduce a number of scenarios from a variety of data management tasks, such as data fusion, data cleaning, and ETL, and show how, based on the system, schema mappings and data exchange techniques  ...  To give Figure 4 : 4 Figure 4: ETL graph. an intuition of the minimal input required by ++Spicy, consider that for the ETL scenario in Figure 4 only two lines and two labels are required to express the  ... 
dblp:journals/pvldb/MarnetteMPRS11 fatcat:v5gss36ijzghpkui53hgoknwhe

Case Representation, Acquisition, and Retrieval in SIROCCO [chapter]

Bruce McLaren, Kevin Ashley
1999 Lecture Notes in Computer Science  
As part of our investigation of how abstract principles are operationalized to facilitate their application to specific fact situations, we have begun to develop and experiment with SIROCCO ( S ystem for  ...  expressive language designed to represent a wide range of ethics cases in SIROCCO, a world-wide web tool developed to perform case acquisition and support a measure of consistency in representation, and an  ...  For instance, Case 92-6, figure 1, pits an obligation to one's client against an obligation to public safety.  ... 
doi:10.1007/3-540-48508-2_18 fatcat:un53pzjfhfdttop5ug77tyyxhy

Business Intelligence for Strategic Decision Making Using Balance Scorecard

Suharnam, Dyah Anggraini
2019 Zenodo  
Balance Scorecards or Key Performance Indicators is an assessment unit roomates Reflects the four perspectives the which consists of 28 indicators of measurement of data analysis dashboard.  ...  Daily periodic data transformation for ETL from LB1.  ...  The perspectives in the BSC are as follows: Financial Perspective, BSC uses financial performance benchmarks such as net income, because these benchmarks are generally used in companies to determine earnings  ... 
doi:10.5281/zenodo.3463879 fatcat:duakwkhvgzhmjmjnw3rt2fa5uq


Andrea Gaetano Chiariello, Giovanni Miano, Antonio Maffucci
2010 Electromagnetic Waves  
This full-wave transmission line model is derived from an integral formulation and is here extended to include in efficient way the layered media Green's Functions.  ...  The proposed tool is successfully benchmarked to references given in literature and case-studies of practical interest are carried out, referring to a coupled microstrip, driven either by differential  ...  Figure 2 . 2 Benchmark test: Radiation diagrams for (a) 0.08 GHz, l\λ = 0.05 and (b) 4.94 GHz, l/λ = 3.  ... 
doi:10.2528/pier09120905 fatcat:qtqopz67wvadjfauhdz3nevljy
« Previous Showing results 1 — 15 out of 1,272 results