InfoQ Homepage Database Content on InfoQ
-
Scaling Web Applications using Cache Farms and Read Pools
Exploring a couple of lesser known tools in the architects' scaling toolkit.
-
Cory Foy on Database Unit Testing
Cory Foy walks developers step-by-step through unit testing logic implemented at the database layer.
-
SQL Database Publishing in Visual Studio 2008 and Today
The Database Publishing Wizard is a popular add-in for Visual Studio, which supports deploying a local database to a remote host. The Visual Web Developer team announces that the wizard will be integrated in Visual Studio 2008.
-
DbFit 0.9 includes MySQL Support and Full Oracle for Java Support
DbFit has had several releases in recent months, adding better support for Oracle, support for Java and MySQL 5, and embedding DbFit tables into Java and .NET code.
-
LiquiBase adds Diff, Eclipse Plugin, Support for Additional Databases
LiquiBase, the database refactoring/migration tool, has had a busy year. Building on the momentum of the 1.0 release LiquiBase added two more minor releases and some point releases, adding support for database diffs, an Eclipse plugin and support for additional databases.
-
Abstracting Data Query in Ruby with Ambition Ambition
The .NET community is familiar with the general purpose query facilities added to the .NET Framework by the project LINQ. Ruby was missing such an abstraction layer. Chris Wanstrath brings his own solution: Ambition.
-
Michael Stonebraker: Major RDBMSes are legacy technology
Michael Stonebraker, co-founder of the Ingres and Postgres relational database management systems (RDBMS) and CTO of Vertica Systems, laid the framework for a debate in the database community by declaring that most major databases should be considered legacy technology.
-
Interview: Dan Pritchett on Architecture at eBay
Dan Pritchett gives us an inside look into the decisions behind one of the largest scale architectures in the world: eBay. In explaining how the scale of eBay turns simple requirements a complex engineering problem, he walks us through the technical and organizational challenges of managing eBay's architecture.
-
Microsoft Patterns & Practices Team publishes Repository Factory
The Repository Factory is a new guidance package from the Microsoft Patterns & Practices Team. It replaces the Data Access Guidance Package, which has been integrated into the Web Service Software Factory (WSSF).
-
Erlang's Mnesia - a distributed DBMS for highly scalable apps
Not every application has the scalability requirements of Google, Flickr or Amazon, however the ideas behind the Mnesia DBMS are compelling: a fast, in-process DBMS that takes advantage of concurrency, with the ability to replicate tables across distributed nodes for high scalability and fault tolerance.
-
Data normalization, is it really that good?
Normalization is one of the corner-stones of database design. Recently some discussion emerged on the need for normalization suggesting denormalization as a more scalable solution.
-
Gemstone OODB to support JRuby, Rubinius
Gemstone is working on Ruby support for their Object Database products, starting off with JRuby. We talked to Alan McKean from Gemstone about what's to come, technical details and Gemstone's plans with Rubinius.
-
Database Migration and Refactoring with LiquiBase
In recent years, there has been a fair amount of discussion developing databases through a series of fine-grained, trackable changes with automatic migration, sometimes called 'database refactoring'. If you're not using ActiveRecord in Ruby on Rails, and particularly if you're using Java, LiquiBase is an interesting candidate: an open-source tool for database refactoring and migration.
-
InfoQ Presentation: Scott Ambler on Database Refactoring
A sound code base is not sufficient to deliver quality software that evolves as user needs change. Some teams, ready to evolve their code, find themselves hamstrung by a hard-to-change database design. Scott Ambler, in this Agile2006 video, talked about how DBAs can use Agile's iterative and incremental approach to help make teams responsive to changing customer needs.
-
Test-Driven Database Development with DbFit
Gojko Adzic has released DbFit, an extension of the Fit testing framework enabling test-driven development against Oracle databases.