…-queries-in-infinidb-early-alpha/). Addressing these issues, I took Star Schema Benchmark, which is TPC-H modification, and tried run queries against…/docs/wiki/benchmark:ssb:start and the specification of benchmarks you can get there http://www.percona.com/docs/wiki/_media/benchmark:ssb…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
… Ontime Air traffic and Star Schema Benchmark got a lot of interest (links: http://www.mysqlperformanceblog.com/2010/01/07/star-schema-bechmark-infobright-infinidb… some efforts to normalize data to have model in classic star schema and prepared queries that could be run on proposed dataset…
Comment: Air traffic queries in LucidDB
October 29, 2009 By 20 Comments
Vadim: for a more-up-to-date benchmark, see the Star Schema Benchmark. It’s a simplification of TPC-H which removes some of the joins in order to create a proper star. Still synthetic though. http://www.cs.umb.edu/~poneil/StarSchemaB.PDF
Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 6, 2009 By 26 Comments
Igor, I am going to run Star Schema Benchmarks on more powerful box 16GB, 8 cores, will see how it works. On GreenPlum, I’d like to try it, but it seems it may take some time for me to figure out how to install and load data. If one provide me instructions I will be happy to run.
Comment: Air traffic queries in LucidDB
October 29, 2009 By 20 Comments
John, Are there utils around Star Schema Benchmark ? I mean datagen or something ?
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
… benchmark on Performance Schema was mainly in memory workload and against single tables. …summary_by_table order by COUNT_STAR DESC LIMIT 5; +————-+————+ | OBJECT_NAME | COUNT_STAR | +————-+————+ | sbtest97 | 1854084 | | sbtest66 | 1837665 | | sbtest56 | 1834297 | |…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… important to test complex queries involving joins and aggregation. A star schema is the most common OLAP/DW data model, since it…, it is desirable to benchmark using a star schema, even though it involves work to transform the data. Star schema Transforming the data was straightforward…
Comment: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
This is just one benchmark. There are tons of possibilities. Most existing BI users will have a star schema, and this is a kind of worst case performance test given the schema. A fully denormalized table will be even faster.
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 8, 2010 By 46 Comments
… DynamoBI (sponsors of LucidDB). Vadim – thanks again for doing the benchmarks. They help everyone (customers, consultants, vendors) get an independent assessment…, w/o joins on large datasets. I think SSB – traditional star schema. Tests aggs, smart selectivity, joins, and aggs. I think TPCH…
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… raw input data set was 55GB before converting to a star schema (21GB) and being compressed by ICE to 2.5GB. Many… fi for i in `seq 1 $workers` do echo “Launching benchmark worker #$i with $iterations iterations” ./bench_worker $iterations $workers & done…
