swrveengineering.wordpress.com
How we increased our EC2 event throughput by 50%, for free « Swrve Engineering
https://swrveengineering.wordpress.com/2014/10/14/how-we-increased-our-ec2-event-throughput-by-50-for-free
Posts from the Swrve engineering team. How we increased our EC2 event throughput by 50%, for free. TL;DR: using an SSD cache in front of EBS can give a massive I/O throughput boost). Internally, Swrve is built around an event-processing pipeline. Processing data sent from 100 million devices around the world each month, in real time, with an average events-per-second throughput in the tens of thousands. Each event processor (or EP) stores its aggregated, per-user state as BDB-JE. EBS supports this nicely.
dbaspects.blogspot.com
Database aspects: Relational vs non-Relational databases - paper review
http://dbaspects.blogspot.com/2010/02/relational-vs-non-relational-databases.html
Thursday, 4 February 2010. Relational vs non-Relational databases - paper review. I just finished reading of the very interesting paper “No Relation: The Mixed Blessings of Non-Relational Databases”. By Ian Thomas Varley which compares a relational and a non-relational databases. I enjoyed the reading very much. The author seems to be a bit biased towards non-relational databases, but this text still going to be very interesting to anyone exploring this new area in the database management.
dbaspects.blogspot.com
Database aspects: The Memcache vs Datastore on google app engine
http://dbaspects.blogspot.com/2010/01/memcache-vs-datastore-on-google-app.html
Sunday, 24 January 2010. The Memcache vs Datastore on google app engine. I was curious to know - what are benefits of using GAE caching mechanism, how it compares to the datastore. We have performed several tests of certain (100 bytes) data value storing and retrieving by both mechanisms. The performance time of several tries has been averaged. Results of the first calls where dismissed since they represent application warm-up and not the speed of the services being tested. Access by the key. Memcache is...
dbaspects.blogspot.com
Database aspects: Impressions from the development of the applications under Google App Engine
http://dbaspects.blogspot.com/2009/12/impressions-from-development-of.html
Tuesday, 22 December 2009. Impressions from the development of the applications under Google App Engine. Impressions from the development of the applications under Google App Engine are quite positive. It is finally java. The development on familiar j2ee platform is pleasant. It also gives the sense of freedom to move to other platform if needed. How to do analytics? How to make mailings to many users? How to perform heavy upgrade process? Subscribe to: Post Comments (Atom). A seasoned Software Architect...
dbaspects.blogspot.com
Database aspects: September 2010
http://dbaspects.blogspot.com/2010_09_01_archive.html
Friday, 24 September 2010. Nested database systems - how I see them. This article is about nested data model for the analytical DBMS systems, how I see it and why I am going to develop it open source. We were inspired by this paper describing nested data store developed by google and shared with us - mere mortals: Dremel paper. I would recommend to go through the text , at least briefly, before reading further. Alternatively you can read this:. Big Query home page. It is public frontend for the Dremel.
dbaspects.blogspot.com
Database aspects: Datastore performance
http://dbaspects.blogspot.com/2009/12/datastore-performance.html
Friday, 18 December 2009. During work on my project based on AppEngine I have made a mini benchmark of the datastore. The operation under the test was update of the object in the datastore, and read object by the key from the datastore. Subscribe to: Post Comments (Atom). View my complete profile.
dbaspects.blogspot.com
Database aspects: March 2010
http://dbaspects.blogspot.com/2010_03_01_archive.html
Monday, 8 March 2010. This article intended for the people who are somewhat familiar with the TPCH and interested to find out what are obstacles for running it on Postgresql, and how to overcome them. As a part of my research for the Petascan, I study performance of the TPCH on Postgresql. Fortunately Postgresql has an option to disable nested loops completely. It can be done by executing the following command:. Enable nestloop = false. Q17 Original query is:. Sum(l extendedprice) / 7.0 as avg yearly.
dbaspects.blogspot.com
Database aspects: December 2009
http://dbaspects.blogspot.com/2009_12_01_archive.html
Tuesday, 22 December 2009. Impressions from the development of the applications under Google App Engine. Impressions from the development of the applications under Google App Engine are quite positive. It is finally java. The development on familiar j2ee platform is pleasant. It also gives the sense of freedom to move to other platform if needed. How to do analytics? How to make mailings to many users? How to perform heavy upgrade process? Friday, 18 December 2009. Both operation took from 20 to 40 milli...
dbaspects.blogspot.com
Database aspects: Database triggers - as (almost) perfect decoupling facililty
http://dbaspects.blogspot.com/2010/10/database-triggers-as-almost-perfect.html
Saturday, 16 October 2010. Database triggers - as (almost) perfect decoupling facililty. While reading the Google's Percolator paper I have noticed that Percolator supports observers - the capability to run specific logic. When data in the particular column has changed. This reminded me of triggers. Usual database triggers. As a common knowledge - something bad to use. I will not list here the disadvantages of the triggers - they are well known. Lets look at the positive. 17 October 2010 at 10:30. Regard...
dbaspects.blogspot.com
Database aspects: February 2010
http://dbaspects.blogspot.com/2010_02_01_archive.html
Thursday, 4 February 2010. Relational vs non-Relational databases - paper review. I just finished reading of the very interesting paper “No Relation: The Mixed Blessings of Non-Relational Databases”. By Ian Thomas Varley which compares a relational and a non-relational databases. I enjoyed the reading very much. The author seems to be a bit biased towards non-relational databases, but this text still going to be very interesting to anyone exploring this new area in the database management.
SOCIAL ENGAGEMENT