Global ETD Search

Search theses and dissertations gathered from participating repositories worldwide. Every result links back to the library that holds it. No account is needed.

Results

Showing 1 to 18 of 18 for “"star schema"”.

  1. INVESTIGATING THE STAR SCHEMA BENCHMARK AS A REPLACEMENT FOR THE TPC-H DECISION SUPPORT SYSTEM

    … Services cloud computing power, we evaluate the Star Schema Benchmark (SSB), as an alternative to TPC-H. We successfully identify and demonstrate several previously undefined problems in the TPC-H benchmark. Our results conclude that the SSB not only resolves the issues inherent in TPC-H, and …

    ecu Repository record for INVESTIGATING THE STAR SCHEMA BENCHMARK AS A REPLACEMENT FOR THE TPC-H DECISION SUPPORT SYSTEM (opens in a new tab)

  2. Design and Implementation of a Dimensional Model for a Data Warehouse

    … of a DW, a Dimensional Model (DM), with star schema, has become the basic standard model and element of DW designs because of the structural simplicity of the star schema. The job of designing DMs is mainly classified into two categories: conversion and creation. Both conversion and …

    sdstate Repository record for Design and Implementation of a Dimensional Model for a Data Warehouse (opens in a new tab)

  3. Návrh databázového systému pro řízení plánování ve firmě

    … IDS1 division of Company XY. The solution uses a star schema, automated processing of source data from Microsoft Dynamics 365 using VBA macros, and a published report in the Power BI Service cloud platform. The system is in pilot operation and brings the division time savings amounting to hundreds …

    brno-tech Repository record for Návrh databázového systému pro řízení plánování ve firmě (opens in a new tab)

  4. A data warehousing and OLAP application for the Naval Reserve Force (CNRF) assessment process

    … approach to a relational data warehouse and a star schema development for data mining. NaRSDAT employs Microsoft Visual Basic, Microsoft Access, and Cognos PowerPlay to provide a complete data warehouse and OLAP solution. The NaRSDAT prototype will serve as the basis for a comprehensive …

    nps Repository record for A data warehousing and OLAP application for the Naval Reserve Force (CNRF) assessment process (opens in a new tab)

  5. Efficient Data Query Execution as Serverless Workflows

    … the Dandelion programming model by running the Star Schema Benchmarks queries with gigabytes of data among other workloads. Using roughly 700 MB of input data and a single Dandelion worker, we achieve SSB query latencies ranging from 1.9 to 3.5 seconds, outperforming DuckDB in a comparable setup …

    ethz Repository record for Efficient Data Query Execution as Serverless Workflows (opens in a new tab)

  6. Design issues in data warehousing : a case study

    … of the data warehouse. By combining ER model, Star Schema and aggregate table in one architecture, we are able to maximize on both storage capacity and query performance. In addition to the selection of data models, the choice between MOLAP and ROLAP is discussed. When the objectives of the …

    concordia Download PDF for Design issues in data warehousing : a case study (opens in a new tab)

  7. Development of new data partitioning and allocation algorithms for query optimization of distributed data warehouse systems

    … that allows fragmentation at early stages of schema design is presented. The thesis also, investigates the performance of the data warehouse after implementing a combination of Genetic Algorithm (GA) and Simulated Annealing (SA) techniques to horizontally partition the data warehouse star …

    london-metro Download PDF for Development of new data partitioning and allocation algorithms for query optimization of distributed data warehouse systems (opens in a new tab)

  8. Managing Incomplete Data in the Patient Discharge Summary to Support Correct Hospital Reimbursements

    … in two artifacts: the patient discharge summary star schema and a patient visit entity relationship diagram. To evaluate those artifacts, seven structured interviews were conducted with highly knowledgeable stakeholders. During the implementation phase that took place at one of the hospitals, an …

    usf Repository record for Managing Incomplete Data in the Patient Discharge Summary to Support Correct Hospital Reimbursements (opens in a new tab)

  9. Advancing the design and implementation of Big Data Warehousing Systems

    … systems; 3) a custom-made extension of the Star Schema Benchmark (SSB), named the SSB+, in which several workloads were developed to benchmark a BDW implemented using the proposed approach, comparing its performance against a traditional dimensional DW; 4) a real-world instantiation based on …

    minho-thes Repository record for Advancing the design and implementation of Big Data Warehousing Systems (opens in a new tab)

  10. A Practical Approach to Merging Multidimensional Data Models

    Schema merging is the process of incorporating data models into an integrated, consistent schema from which query solutions satisfying all incorporated models can be derived. The efficiency of such a process is reliant on the effective semantic representation of the chosen data models, as well as …

    ottawa-retro Repository record for A Practical Approach to Merging Multidimensional Data Models (opens in a new tab)

  11. Trilhas para auditoria aplicada ao sistema único de saúde no contexto das órteses, próteses e materiais especiais (OPMES): estruturação de uma base de dados integrada a partir do projeto fiscalizasus

    … the tables were organized oriented towards a star schema, containing fact and dimension tables, which enable the integration of different data from various sources, also concerning the goals of each audit trail and assessing the presence of common values between the databases. Nevertheless, …

    brazil-ufrn Repository record for Trilhas para auditoria aplicada ao sistema único de saúde no contexto das órteses, próteses e materiais especiais (OPMES): estruturação de uma base de dados integrada a partir do projeto fiscalizasus (opens in a new tab)

  12. Analytical Query Processing Based on Continuous Compression of Intermediates

    … Our end-to-end evaluation using the famous Star Schema Benchmark shows that our envisioned compression of intermediates can improve both the memory footprint and the runtime of complex analytical queries significantly.

    qucosa-diss

  13. Resiliency Mechanisms for In-Memory Column Stores

    … and with an end-to-end evaluation using the Star Schema Benchmark. To the best of our knowledge, we are the first to present such holistic and fast bit flip detection in a large software infrastructure such as in-memory data management systems. Finally, most of the source code fragments used …

    qucosa-diss

  14. Design and Implementation of an Enterprise Data Warehouse

    … (ETL) process and loaded into an actual set of star schemas then makes the reporting easier. Separately, an important piece of this thesis takes an actual example of data and compares the performance between them by running the same queries against separate databases, one transactional and one …

    marquette Repository record for Design and Implementation of an Enterprise Data Warehouse (opens in a new tab)

  15. Integrating customer relationship management with data warehousing technology: a banking industry perspective

    This research studies the integration of customer relationship management -CRM-with modern data warehousing -DW- technology in the banking industry. The severe competition within the global financial service industry urges banks to upgrade their business intelligence systems, which ultimately …

    auckland-tech Repository record for Integrating customer relationship management with data warehousing technology: a banking industry perspective (opens in a new tab)

  16. Extending dimensional modeling through the abstraction of data relationships and development of the semantic data warehouse

    The Kimball methodology, often referred to as dimensional modelling, is well established in data warehousing and business intelligence as a highly successful means for turning data into information. Yet weaknesses exist in the Kimball approach that make it difficult to rapidly extend or interrelate …

    uvic Repository record for Extending dimensional modeling through the abstraction of data relationships and development of the semantic data warehouse (opens in a new tab)

  17. Získávání znalostí z datových skladů

    Diplomová práce se zabývá principy procesu získávání znalostí se zaměřením na asociační pravidla. Je vybudován teoretický aparát obecného popisu a principů tvorby datových skladů. Na základě těchto teoretických poznatků je implementována aplikace pro získávání asociačních pravidel. Aplikace očekává …

    brno-tech Repository record for Získávání znalostí z datových skladů (opens in a new tab)

  18. Dolování z dat v prostředí informačního systému K2

    Tento projekt vznikl jako firemní zadání společnosti K2 atmitec Brno s.r.o. Jeho výsledkem je modul pro dolování dat v prostředí informačního systému K2. Navrhovaný modul implementuje asociační analýzu nad daty datového skladu informačního systému K2. Analyzovaná data obsahují informace z prodejů …

    brno-tech Repository record for Dolování z dat v prostředí informačního systému K2 (opens in a new tab)