… seen my posts on Ontime Air traffic and Star Schema Benchmark got a lot of interest (links: http://www.mysqlperformanceblog.com… details on our Percona Wikistat benchmark Wiki. I have next goals with proposed benchmark: Compare engines in OLAP queries for planning, predicting growth… in fact table. Example of query ( again, full list on Benchmark Wiki) SELECT project, sum(page_count) sm FROM pagestat JOIN…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
Comment: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 29, 2010 By 16 Comments
… CMS suitable for OLAP benchmarks. Either I do not think OLTP oriented FireBird and PostgresSQL will be good for proposed benchmark. I expect…
Comment: Air traffic queries in LucidDB
October 26, 2009 By 20 Comments
John, Thanks for comment. I am going to look more in direction you are working. Would be “APB-1 OLAP Benchmark” http://www.olapcouncil.org/research/bmarkly.htm interesting for you ? The company, that developed it, seems dead, but the ideas of benchmark is worth to consider.
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… joins and aggregation. A star schema is the most common OLAP/DW data model, since it typically represents a data mart…:Diagram of the ontime dimensional schema Test environment For this benchmark, a test environment consisting of a single commodity database server… author has previously worked in cooperation with Infobright, including on benchmarking. These particular tests were performed independently of Infobright, without their…
Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 10, 2009 By 26 Comments
… the case of an OLAP workload….TokuDB is supposed to be good for OLTP too, and you benchmarked that. I just don… much time to do — seems simple, no? (I have some benchmarks coming out on TokuDB very soon, so if you can…
Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 6, 2009 By 26 Comments
… benchmark TokuDB against InnoDB? Or was the last paragraph meant to say “even though TokuDB is better at this benchmark of an OLAP…
