The Spatial Star Schema Benchmark

نویسندگان

  • Samara Martins do Nascimento
  • Renata Miwa Tsuruda
  • Thiago Luís Lopes Siqueira
  • Valéria Cesário Times
  • Ricardo Rodrigues Ciferri
  • Cristina Dutra de Aguiar Ciferri
چکیده

Spatial Data Warehouses (SDWs) enable the simultaneous processing of multidimensional queries and spatial analysis. In the literature, little attention has been devoted to the development of benchmarks for analyzing the performance of query processing over SDWs. In this paper, we propose a novel benchmark, called Spatial SSB, designed specifically to perform controlled experimental performance evaluation of SDWs environments. The Spatial SSB proposes a non-redundant SDW schema and controls: the generation of data, the query selectivity and the data distribution in the extent. In addition, the Spatial SSB provides the increase of the data volume, varies the complexity of spatial objects geometries, and generates a certain number of objects that intersect an ad hoc spatial query window.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Star Schema Benchmark (ssb)

Big Data Analytics Benchmark (BigBench). Tags: pdgf Tags: star schema benchmark, ssb, parallel data generation framework, pdgf, benchmarking, skew. relational models which have been for a few years the most used to support classical data warehousing applications such as Star Schema Benchmark (SSB). Star. Schema Benchmark (6) is recently proposed datawarehousing benchmark that has been implement...

متن کامل

A Review of Star Schema Benchmark

This paper examines the Star Schema Benchmark, an alternative to the flawed TPC-H decision support system and presents reasons why this benchmark should be adopted over the industry standard for decision support systems. Keywords—TPC-H; databases; star schema benchmark; DBMS; profiling;

متن کامل

Star Schema Benchmark for Data Warehousing and Adjoined Dimension Column Clustering Method for Improved Star

متن کامل

ONE: A Predictable and Scalable DW Model

The star schema model has been widely used as the facto DW storage organization on relational database management systems (RDBMS). The physical division in normalized fact tables (with metrics) and denormalized dimension tables allows a trade-off between performance and storage space while, at the same time offering a simple business understanding of the overall model as a set of metrics (facts...

متن کامل

Storage Layout and I/O Performance in Data Warehouses

Defining data placement and allocation in the disk subsystem can have a significant impact on data warehouse performance. However, our experiences with data warehouse implementations show that the database storage layout is often subject to vague or even invalid assumptions about I/O performance trade-offs. Clear guidelines for the assignment of database objects to disks are a very common reque...

متن کامل

ذخیره در منابع من

ذخیره در منابع من قبلا به منابع من ذحیره شده

{@ msg_add @}


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2011