… Data Virtualization is talked about as data source aggregation but as someone pointed out aggregating data sources should be called data transparency meaning that the source is not seen for example aggregating Oracle, SQL Server and MySQL into one source that the…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… contention… but your point lookup queries later have to be aggregates ie running SUM() or MAX() for examples you provided.
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… (which is TokuDB’s strong suit) with some roll-up aggregation, which should produce updates in-place (I will use INSERT…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… one query per line, and it will do it’s aggregation job on that. Granted, this means there is no run…
Comment: 10 years of MySQL User Conferences
April 13, 2013 By 6 Comments
…: he was the guy I contacted to have my blog aggregated into planet.mysql.com. He wrote how he likes my…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…; then add the rest later, reloading the data if needed. Aggregate Aggregation is absolutely key for most people. There are special… do. And then, you might super-aggregate too. For example, if you aggregate by day and then you do a… Store Non-Aggregated Data I’ve been talking a lot about aggregated data. What do you do with the non-aggregated data…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… disguised relational algebra mathematical expression. With relational algebraic substitution, every aggregate expression, even non-distributable ones, can be broken into distributable… of nodes) the result set is aggregated using distributable aggregate functions. The results from this aggregation get a second distributed reduce using UPSERTs…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
… help performance using aggregation. Using materialized views to automate that aggregation process. Comparing the performance of OLAP with and without aggregation over multiple… future trends. Data is often aggregated in many different ways. Aggregated data may be stored in aggregated tables so that it can be…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… pretty closely. What if we narrow the observation windows and aggregate every tenth of a second? It’ll probably look pretty… a misbehaving application. We see this echo effect because the aggregation interval is a lot shorter than the response time of…’re straddling the two worlds with the aggregation interval. So as we narrow the aggregation interval, we’ll start to find the…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
… help performance using aggregation. Using materialized views to automate that aggregation process. Comparing the performance of OLAP with and without aggregation over multiple… just another name for multidimensional analysis, consists of displaying summary aggregations of the data broken down into different groups. A typical…
