3,116 Hits in 3.7 sec

Automating data warehouse conceptual schema design and evaluation

Cassandra Phipps, Karen C. Davis
2002 Design and Management of Data Warehouses  
The algorithms are illustrated using the TPC-H Benchmark schema and queries. Our algorithms provide a foundation for a software tool to create and evaluate data warehouse conceptual schemas.  ...  We propose and illustrate algorithms for automatic conceptual schema development and evaluation.  ...  The focus of this paper is the schema creation phase and its automation; while this phase includes conceptual, logical, and physical schema design, we only address conceptual design of a data warehouse  ... 
dblp:conf/dmdw/PhippsD02 fatcat:vs2g63lz4badvfqhmbkvvljsym

Modern Software Engineering Methodologies Meet Data Warehouse Design: 4WD [chapter]

Matteo Golfarelli, Stefano Rizzi, Elisa Turricchia
2011 Lecture Notes in Computer Science  
The principles underlying 4WD are risk-based iteration, evolutionary and incremental prototyping, user involvement, component reuse, formal and light documentation, and automated schema transformation.  ...  In this paper we analyze the potential advantages arising from the application of modern software engineering methodologies to a data warehouse project and we propose 4WD, a design methodology that couples  ...  To overcome these issues, in 4WD automation is specifically targeted on supply-driven conceptual design and logical design. This reasserts the key role played by conceptual schemata of facts in 4WD.  ... 
doi:10.1007/978-3-642-23544-3_6 fatcat:nkztbxslfrdcfnrpg7dqulkyue

Generating Data Warehouse Schema

Reyan Abdalaziz Ahmedl, Tarig Mohamed Ahmed
2014 International Journal in Foundations of Computer Science & Technology  
to design data warehouse schema.  ...  To overcome, the proposed method presents a new strategy to automate the multidimensional design of Data Warehouses; this algorithm uses an enterprise schema of an operational database as a starting point  ...  He has been a real source of useful support and careful guidance.  ... 
doi:10.5121/ijfcst.2014.4101 fatcat:qrau72mvbvcxtj2egc6apqjzby

Comparative Study of Data Warehouse Design Approaches : A Survey

Rajni Jindal
2012 International Journal of Database Management Systems  
In this paper, we surveyed and evaluated the literature related to the various data warehouse design approaches on the basis of design criteria and propose a generalized object oriented conceptual design  ...  The process of developing a data warehouse starts with identifying and gathering requirements, designing the dimensional model followed by testing and maintenance.  ...  Elicitation Database scheme Specifications for data warehouse Conceptual design Database scheme and Specifications Conceptual schema Logical design Conceptual schema Logical schema Physical  ... 
doi:10.5121/ijdms.2012.4104 fatcat:4nq2r4ym4ffmbnkcwupiyfdscy

A Transformation-oriented Methodology to Knowledge-based Conceptual Data Warehouse Design

Opim Salim Sitompul, Shahrul Azman Noah
2006 Journal of Computer Science  
In this paper, we proposed a design methodology for conceptual data warehouse design called the transformation-oriented methodology, which transforms an Entity-Relationship (ER) model into a multidimensional  ...  However, a similar approach to the task of data warehouse design has yet to be seriously initiated.  ...  CONCLUSION We have shown that the tedious tasks of designing the conceptual design of a data warehouse are indeed could be automated.  ... 
doi:10.3844/jcssp.2006.460.465 fatcat:igz7xvtybjdjtotpi3p4xgavyu

Conceptual Design of Data Warehouse using Hybrid Methodology

Sekhar Reddy G
2020 International Journal of Advanced Trends in Computer Science and Engineering  
schemas that are reconciled with data sources to improvise the conceptual quality.  ...  In addition, it is established on the basis of i* framework and Dimensional Fact Model (DFM) which is used to design the actions of actors, and the relationship existing among the agents in DW (Data Warehouse  ...  Automatic Approach Automatic approach/mixed approach uses automated designing of data marts and formation of DW schema.  ... 
doi:10.30534/ijatcse/2020/13932020 fatcat:wgejc3mgbrf25bmgeypy3xmy2y

A Framework for Semi-Automated Implementation of Multidimensional Data Models

Ilona Mariana NAGY
2012 Database Systems Journal  
Thus, we present a framework for semi-automated implementation of multidimensional data models and introduce an automation prototype intended to reduce the time of data structures generation in the warehousing  ...  Our research is focused on the design of an automation component and the development of a corresponding prototype from technical metadata.  ...  In [15] the authors propose two algorithms: one for automating DW conceptual schema derivation from OLTP schemas and another one for the evaluation of candidate conceptual schemas with user queries;  ... 
doaj:f9637b058a08414d864bd540a79bff1e fatcat:kufj46vpbnfv3oqj3hxrcxqxgq

Towards the Automation of Data Warehouse Logical Design: a Rule-Based Approach

Verónika Peralta, Alvaro Illarze, Raúl Ruggia
2003 International Conference on Advanced Information Systems Engineering  
Data Warehouse logical design involves the definition of structures that enable an efficient access to information.  ...  The designer builds relational or multidimensional structures taking into account a conceptual schema representing the information requirements, the source databases, and non-functional requirements.  ...  for the CMDM conceptual model.  ... 
dblp:conf/caise/PeraltaIR03a fatcat:lzcmr7y4qzeofc4hno5zzcaypu

DW4SN: A Tool for Dynamic Data Warehouse Building from Social Network

Rania Yangui, Ahlem Nabli, Faiez Gargouri
2017 Research in Computing Science  
This work presents DW4SN (Data Warehouse for Social Network) tool for building data warehouse from social network, where clustering methods are used to define the DW schema and NoSQL systems are used to  ...  However, due to their scale, complexity and dynamics, these networks are difficult to be processed by means of traditional warehouse systems.  ...  The proposed system provides a high degree of automation that enables designers to quickly and easily designing and building conceptual DW schema and to reduce the deployment costs.  ... 
doi:10.13053/rcs-134-1-15 fatcat:aqoxg5paunhtpceenokewlmkjq

A Survey of Multidimensional Modeling Methodologies

Oscar Romero, Alberto Abelló
2009 International Journal of Data Warehousing and Mining  
design of a data warehouse.  ...  up-to-date con-ceptual schemas to the data warehouse designer motivated that many methodologies worked over relational schemas instead of conceptual schemas.  ... 
doi:10.4018/jdwm.2009040101 fatcat:7jspq7faebczppdxlou6t6n3x4

A comprehensive approach to data warehouse testing

Matteo Golfarelli, Stefano Rizzi
2009 Proceeding of the ACM twelfth international workshop on Data warehousing and OLAP - DOLAP '09  
Nevertheless, while most phases of data warehouse design have received considerable attention in the literature, not much has been said about data warehouse testing.  ...  In this paper we introduce a number of data martspecific testing activities, we classify them in terms of what is tested and how it is tested, and we discuss how they can be framed within a reference design  ...  One of the advantages of adopting a data warehouse methodology that entails a conceptual design phase is that the conceptual schema produced can be thoroughly tested for user requirements to be effectively  ... 
doi:10.1145/1651291.1651295 dblp:conf/dolap/GolfarelliR09 fatcat:3yeyoeva7jhrvagylm6b5o4lmi

Automating the Conceptual Modeling of Data Warehouse in Information System ERP Type

Ayoub Elotmani, Pr. Halima Bouden
2017 Transactions on Machine Learning and Artificial Intelligence  
On the order hand, to study the proposals of the automation of the phases of the design of the warehouse.  ...  This feasible with the introduction of the business intelligence, which allowing storing historical data and organized in storage space: data warehouse (DWH), reduced to data mart (DM) that are an extract  ...  We have studied the three bottom-up, top-down and mixed-design approaches of the data warehouse, and discuss the boundaries of each.  ... 
doi:10.14738/tmlai.54.3330 fatcat:k2624idwhnhoxl445c7iwflnuy

A direct approach to physical Data Vault design

Dragoljub Krneta, Vladan Jovanovic, Zoran Marjanovic
2014 Computer Science and Information Systems  
based) data warehouse designs.  ...  The paper presents a novel agile approach to large scale design of enterprise data warehouses based on a Data Vault model.  ...  In addition, this approach can be used to evaluate candidates for the conceptual schema using custom queries. Peralta (et al.  ... 
doi:10.2298/csis130523034k fatcat:gabfvgqwfffqjcjvhg6zn2y7uq

Integration of Data Mining and Data Warehousing: A Practical Methodology

Muhammad Usman, Russel Pears
2010 International Journal of Advancements in Computing Technology  
Automated techniques are required to generate warehouse schema to overcome the existing dependencies.  ...  visual data exploration, automatic warehouse schema generation and integration of data mining and warehousing.  ...  of data warehouse schema; and integration of data mining methods into data warehousing design.  ... 
doi:10.4156/ijact.vol2.issue3.4 fatcat:jsmrrhak3vhefl2psd6wewstta

Ontology-Based Conceptual Design of ETL Processes for Both Structured and Semi-Structured Data

Dimitrios Skoutas, Alkis Simitsis
2007 International Journal on Semantic Web and Information Systems (IJSWIS)  
In this paper, we propose an ontology-based approach to facilitate the conceptual design of the back stage of a Data Warehouse.  ...  One of the main tasks in the early stages of a Data Warehouse project is the identification of the appropriate transformations and the specification of inter-schema mappings from the data sources to the  ...  This work is co-funded by the European Social Fund (75%) and National Resources (25%) -Operational Program for Educational and Vocational Training II (EPEAEK II) and particularly the Program PYTHAGORAS  ... 
doi:10.4018/jswis.2007100101 fatcat:nxu2tt6adrav7bpaarl4r7d2fe
« Previous Showing results 1 — 15 out of 3,116 results