InfoQ Homepage Database Design Content on InfoQ
-
Google Cloud Platform Recommends Strong Consistency in Data Stores
A recent post on the Google Cloud Platform blog recommends strong consistency in the data layer, which helps in creating an application platform that reduces complexity and the potential for bugs.
-
Uber Engineering Moving from Postgres to MySQL
In a recent blog post, Uber detailed why they have chosen to replace PostgreSQL with MySQL. In this article we present a high level overview of the problems they faced, how MySQL fares against them and some of the best rebuttals against the case presented by Uber.
-
Riak NoSQL Database: Use Cases and Best Practices
Riak is a key-value based NoSQL database that can be used to store user session related data. Andy Gross from Basho Technologies recently spoke at QCon SF 2011 Conference about Riak use cases. InfoQ spoke with Andy and Mark Phillips from Basho team about Riak database features and best practices when using Riak.
-
Windows Azure Gets Node.js, SQL Azure Federation, Increased DB Limits
Windows Azure team announced major updates including support for Node.js, better scalability for SQL Azure through Federation and higher individual DB Size limits (upto 150 GB), a limited preview for Hadoop and more.
-
NoSQL OODB with Smalltalk-based Ruby VM: MagLev 1.0 Released
The MagLev project has released version 1.0 of their Ruby VM. The Ruby implementation is based on the GemStone/S Smalltalk VM which comes with GemStone's distributed cache, ACID transactions, and persistence system (OODB). InfoQ caught up with Monty Williams of the MagLev project to talk about where MagLev fits on the NoSQL spectrum, and much more.
-
William McKnight on Columnar Databases
Columnar databases offer better data storage capabilities for certain business use cases compared to the traditional relational database management systems. William McKnight spoke at NoSQL Now 2011 Conference last week about the columnar databases and how they can be effective for certain data storage needs.
-
Olap4j 1.0: a Java API for OLAP Servers
Business Intelligence vendor Pentaho has announced the release of olap4j 1.0, a new, common Java API for any online analytical processing (OLAP) server.
-
Graph Database Neo4j Updates Licensing and Enhances Usability
Neo Technology has released version 1.3 GA (General Availability) of Neo4j. This release updates Neo4j's licensing and adds a number of features. The Community edition is now licensed under GPLv3, the same license as MySQL.
-
NoSQL, NewSQL and Beyond
The 451 Group has published earlier this month the conclusions of a report detailing the growing set of options in the information management space. In the process they also clarified what they meant by "NewSQL".
-
Column-based Storage in SQL Server 2011
Imagine ad hock data mining queries against a single table with 1 TB of data and 1.44 billion rows coming back in roughly a second. This is the scenario Microsoft intends to support using 32-core machines and their new column-based storage engine.
-
Preview of SQL Azure Federations Connectivity Model
Earlier this week Cihan Biyikoglu of Microsoft provided a preview of how developers will need to adapt their code for the upcoming SQL Azure Federations to supports its connectivity model. The intent is to provide a safe model for developers to work with federated data and/or multi-tenant applications.
-
DB2 Debugging in Visual Studio 2010
IBM is offering a demo of their DB2 Add-ins for Visual Studio 2010. In addition to "full end to end debugging for SQL procedures for VB and C# apps”, it includes ADO.NET and Entity Framework providers for many of the DB2 variants.
-
A Case for Graph Databases
We talk with Daniel Kirstenpfad, founder and CTO of sones GmbH, about Graph Databases and how they can better model some types of data such as relations in a social networking application. A graph database can offer performance benefits over other types of databases because they explicitly represent a graph and are organized to have index free adjacency.
-
Facebook on Hadoop, Hive, HBase, and A/B Testing
The Hadoop Summit of 2010 included presentations from a number of large scale users of Hadoop and related technologies. Notably, Facebook presented a keynote and details information about their use of Hive for analytics. Mike Schroepfer, Facebook's VP of Engineering delivered a keynote describing the scale of their data processing with Hadoop.
-
Emergent Data Architectures Highlights From GigaOm Structure Conference
The GigaOM Stucture conference a couple of weeks ago addressed many areas of cloud computing. One of the key themes of the event was the emergence of new data architectures. Throughout the panels, interviews, and presentations many speakers identified significant changes in how data gets handled that will be coming.