Automating the Multidimensional Design of Data Warehouses
Author: Óscar Romero Moral
Publisher:
Published: 2009
Total Pages: 0
ISBN-13: 9788469347058
DOWNLOAD EBOOKPosts
Automating the Multidimensional Design of Data Warehouses
Author:
Publisher:
Published: 2002
Total Pages:
ISBN-13:
DOWNLOAD EBOOKLes experiències prèvies en làmbit dels magatzems de dades (o data warehouse), mostren que lesquema multidimensional del data warehouse ha de ser fruit dun enfocament híbrid; això és, una proposta que consideri tant els requeriments dusuari com les fonts de dades durant el procés de disseny. Com a qualsevol altre sistema, els requeriments són necessaris per garantir que el sistema desenvolupat satisfà les necessitats de lusuari. A més, essent aquest un procés de reenginyeria, les fonts de dades shan de tenir en compte per: (i) garantir que el magatzem de dades resultant pot ésser poblat amb dades de lorganització, i, a més, (ii) descobrir capacitats danàlisis no evidents o no conegudes per lusuari. Actualment, a la literatura shan presentat diversos mètodes per donar suport al procés de modelatge del magatzem de dades. No obstant això, les propostes basades en un anàlisi dels requeriments assumeixen que aquestos són exhaustius, i no consideren que pot haver-hi informació rellevant amagada a les fonts de dades. Contràriament, les propostes basades en un anàlisi exhaustiu de les fonts de dades maximitzen aquest enfocament, i proposen tot el coneixement multidimensional que es pot derivar des de les fonts de dades i, conseqüentment, generen massa resultats. En aquest escenari, lautomatització del disseny del magatzem de dades és essencial per evitar que tot el pes de la tasca recaigui en el dissenyador (daquesta forma, no hem de confiar únicament en la seva habilitat i coneixement per aplicar el mètode de disseny elegit). A més, lautomatització de la tasca allibera al dissenyador del sempre complex i costós anàlisi de les fonts de dades (que pot arribar a ser inviable per grans fonts de dades). Avui dia, els mètodes automatitzables analitzen en detall les fonts de dades i passen per alt els requeriments. En canvi, els mètodes basats en lanàlisi dels requeriments no consideren lautomatització del procés, ja que treballen amb requeriments expressats en llenguatges dalt n.
Advanced Data Warehouse Design
Author: Elzbieta Malinowski
Publisher: Springer Science & Business Media
Published: 2008-01-22
Total Pages: 457
ISBN-13: 3540744053
DOWNLOAD EBOOKThis exceptional work provides readers with an introduction to the state-of-the-art research on data warehouse design, with many references to more detailed sources. It offers a clear and a concise presentation of the major concepts and results in the subject area. Malinowski and Zimányi explain conventional data warehouse design in detail, and additionally address two innovative domains recently introduced to extend the capabilities of data warehouse systems: namely, the management of spatial and temporal information.
Fundamentals of Data Warehouses
Author: Matthias Jarke
Publisher: Springer Science & Business Media
Published: 2013-03-09
Total Pages: 188
ISBN-13: 3662041383
DOWNLOAD EBOOKThe first comparative review of the state of the art and best current practice in data warehousing. It covers source and data integration, multidimensional aggregation, query optimisation, update propagation, metadata management, quality assessment, and design optimisation. Also, based on results of the European DWQ project, it offers a conceptual framework by which the architecture and quality of data warehousing efforts can be assessed and improved using enriched metadata management combined with advanced techniques from databases, business modelling, and artificial intelligence. An excellent introduction to the issues of quality and metadata usage for researchers and database professionals in academia and industry. XXXXXXX Neuer Text This book presents the first comparative review of the state-of-the-art and the best current practices of data warehouses. It covers source and data integration, multidimensional aggregation, query optimization, metadata management, quality assessment, and design optimization. A conceptual framework is presented by which the architecture and quality of a data warehouse can be assessed and improved using enriched metadata management combined with advanced techniques from databases, business modeling, and artificial intelligence.
Enterprise Information Systems
Author: Joaquim Filipe
Publisher: Springer Science & Business Media
Published: 2009-05-04
Total Pages: 1002
ISBN-13: 3642013473
DOWNLOAD EBOOKThis book contains the collection of full papers accepted at the 11th International Conference on Enterprise Information Systems (ICEIS 2009), organized by the Ins- tute for Systems and Technologies of Information Control and Communication (INSTICC) in cooperation with the Association for Advancement of Artificial Intel- gence (AAAI) and ACM SIGMIS (SIG on Management Information Systems), and technically co-sponsored by the Japanese IEICE SWIM (SIG on Software Interprise Modeling) and the Workflow Management Coalition (WfMC). ICEIS 2009 was held in Milan, Italy. This conference has grown to become a - jor point of contact between research scientists, engineers and practitioners in the area of business applications of information systems. This year, five simultaneous tracks were held, covering different aspects related to enterprise computing, including: “- tabases and Information Systems Integration,” “Artificial Intelligence and Decision Support Systems,” “Information Systems Analysis and Specification,” “Software Agents and Internet Computing” and “Human–Computer Interaction”. All tracks describe research work that is often oriented toward real-world applications and hi- light the benefits of information systems and technology for industry and services, thus making a bridge between academia and enterprise. ICEIS 2009 received 644 paper submissions from 70 countries in all continents; 81 papers were published and presented as full papers, i.e., completed research work (8 pages/30-minute oral presentation). Additional papers accepted at ICEIS, including short papers and posters, were published in the regular conference proceedings.
Building the Data Warehouse
Author: W. H. Inmon
Publisher: John Wiley & Sons
Published: 2005-10-03
Total Pages: 576
ISBN-13: 0471774235
DOWNLOAD EBOOKThe new edition of the classic bestseller that launched thedata warehousing industry covers new approaches and technologies,many of which have been pioneered by Inmon himself In addition to explaining the fundamentals of data warehousesystems, the book covers new topics such as methods for handlingunstructured data in a data warehouse and storing data acrossmultiple storage media Discusses the pros and cons of relational versusmultidimensional design and how to measure return on investment inplanning data warehouse projects Covers advanced topics, including data monitoring andtesting Although the book includes an extra 100 pages worth of valuablecontent, the price has actually been reduced from $65 to $55
The Data Warehouse Toolkit
Author: Ralph Kimball
Publisher: John Wiley & Sons
Published: 2011-08-08
Total Pages: 464
ISBN-13: 1118082141
DOWNLOAD EBOOKThis old edition was published in 2002. The current and final edition of this book is The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition which was published in 2013 under ISBN: 9781118530801. The authors begin with fundamental design recommendations and gradually progress step-by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries, including: Retail sales and e-commerce Inventory management Procurement Order management Customer relationship management (CRM) Human resources management Accounting Financial services Telecommunications and utilities Education Transportation Health care and insurance By the end of the book, you will have mastered the full range of powerful techniques for designing dimensional databases that are easy to understand and provide fast query response. You will also learn how to create an architected framework that integrates the distributed data warehouse using standardized dimensions and facts.
New Trends in Data Warehousing and Data Analysis
Author: Stanisław Kozielski
Publisher: Springer Science & Business Media
Published: 2008-11-21
Total Pages: 365
ISBN-13: 9780387874302
DOWNLOAD EBOOKMost of modern enterprises, institutions, and organizations rely on knowledge-based management systems. In these systems, knowledge is gained from data analysis. Today, knowledge-based management systems include data warehouses as their core components. Data integrated in a data warehouse are analyzed by the so-called On-Line Analytical Processing (OLAP) applications designed to discover trends, patterns of behavior, and anomalies as well as finding dependencies between data. Massive amounts of integrated data and the complexity of integrated data coming from many different sources make data integration and processing challenging. New Trends in Data Warehousing and Data Analysis brings together the most recent research and practical achievements in the DW and OLAP technologies. It provides an up-to-date bibliography of published works and the resource of research achievements. Finally, the book assists in the dissemination of knowledge in the field of advanced DW and OLAP.
Data Warehouse Systems
Author: Alejandro Vaisman
Publisher: Springer
Published: 2014-09-10
Total Pages: 639
ISBN-13: 3642546552
DOWNLOAD EBOOKWith this textbook, Vaisman and Zimányi deliver excellent coverage of data warehousing and business intelligence technologies ranging from the most basic principles to recent findings and applications. To this end, their work is structured into three parts. Part I describes “Fundamental Concepts” including multi-dimensional models; conceptual and logical data warehouse design and MDX and SQL/OLAP. Subsequently, Part II details “Implementation and Deployment,” which includes physical data warehouse design; data extraction, transformation, and loading (ETL) and data analytics. Lastly, Part III covers “Advanced Topics” such as spatial data warehouses; trajectory data warehouses; semantic technologies in data warehouses and novel technologies like Map Reduce, column-store databases and in-memory databases. As a key characteristic of the book, most of the topics are presented and illustrated using application tools. Specifically, a case study based on the well-known Northwind database illustrates how the concepts presented in the book can be implemented using Microsoft Analysis Services and Pentaho Business Analytics. All chapters are summarized using review questions and exercises to support comprehensive student learning. Supplemental material to assist instructors using this book as a course text is available at http://cs.ulb.ac.be/DWSDIbook/, including electronic versions of the figures, solutions to all exercises, and a set of slides accompanying each chapter. Overall, students, practitioners and researchers alike will find this book the most comprehensive reference work on data warehouses, with key topics described in a clear and educational style.
Data Warehouse Automation
Author: Martin Gandalson
Publisher: Pragmatic Guide
Published: 2018-07-24
Total Pages: 276
ISBN-13: 9781717829900
DOWNLOAD EBOOKThe definitive guide to actually building your data warehouse... Utilizing recent technology, small companies can finally build a data warehouse at a very affordable cost, and keep the design (and the data!) in-house. Large companies can now build and maintain their data warehouses better than ever before: faster, cheaper, more secure, and more agile. In fact, in this hands-on guide we will show the step-by-step development of an actual data warehouse prototype, using free-trial tools. This is a practical hands-on guide, and we will stick to the relevant topics that are important to someone who actually wants to build a DW as soon as possible. We won't be pontificating on academic positions, nor fluffing up the word count. We assume that you are more anxious to roll up your sleeves and get started than to debate theory with purists. Yet at the same time, we will detail the necessary planning that you must conduct in order to maximize the success of your data warehouse program. Along the way, we will identify and avoid the common pitfalls that can lead to failure. By following this step-by-step guide, you can create a data warehouse for your company or organization. You will not need a large budget. You will not need expensive outside consultants. You will not need to share your data outside your company. You will not need specialized skills beyond those of a typical database programmer or database administrator. Yes, you can build a data warehouse: on a small budget, completely in-house, using only your current database employee(s). Martin Gandalson will show you how, step by step. This toolkit can be used to build any data warehouse, data mart, or webhouse.
