…-queries-in-infinidb-early-alpha/). Addressing these issues, I took Star Schema Benchmark, which is TPC-H modification, and tried run queries…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
… OLAP analysis usually is performed on a star schema which partially denormalizes the data. A star schema about a particular subject matter, such as… cousin of the star schema in which the dimensions are normalized. This type of schema is usually called a snowflake schema. The three table… are not as popular as star schemas because they tend to not perform as well as a star schema, particularly as the volume of…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
…’ G *************************** 1. row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: sbtest OBJECT_NAME: sbtest55 COUNT_STAR: 1806932 SUM_TIMER_WAIT: 23771749557590 MIN_TIMER_WAIT… *************************** 1. row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: sbtest OBJECT_NAME: sbtest55 INDEX_NAME: PRIMARY COUNT_STAR: 1789764 SUM_TIMER_WAIT: 17671510276755 MIN…
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… is desirable to benchmark using a star schema, even though it involves work to transform the data. Star schema Transforming the data was straightforward… be made fully clear by the following schema diagram:Diagram of the ontime dimensional schema Test environment For this benchmark, a test…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… you may think you should use traditional DW methods, like star schemas. The problem is that MySQL doesn’t tend to… some cases. Not only that, but star schemas are not intended to be fast. The star schema is essentially “I admit defeat and accept… at once. Aside from star schemas, another tactic I see people try a lot is to build “flexible schemas” with tables that contain…
Post: Intro to OLAP
July 12, 2010 By 9 Comments
… structured as a STAR or snowflake type schema. To go back to the sales analysis example above, in a STAR schema the facts about…. [caption id="attachment_3264" align="aligncenter" width="293" caption="Example star schema about sales. "][/caption] Often a dimension will include redundant information…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
… 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… ) (queries and scenario to be drafted yet) So in proposed schema I have four tables: pagestat (fact table), and pages, datesinfo…
Comment: Data mart or data warehouse?
December 16, 2010 By 13 Comments
Per, indeed, solving many to many relationships in a star schema is a challenge. If you want to google for it, … customer order example works like this: For each actor that stars in a film this bridge table contains an actor_id… a query like “What is the order value for films starring a particular actor”, you can multiply the metric value from…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… of the smallest levers we can pull for server optimization. Schema and query optimization can give much greater improvements, for example… these things operate. For example, if the workload is a star schema data warehouse, it is important to know a lot about… for last. You cannot consider any one of these factors (schema, queries, indexing) in isolation, because they are tightly bound together…
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
