InfoQ Homepage Database Content on InfoQ
-
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.
-
Getting Agile with MS VSTS for Database Professionals
Last month, Microsoft released Visual Studio for Database Professionals, one of the first toolsets offered to help teams extend Agile practices to the DBA community. We tracked down some information to help teams and DBAs get started with VSTS for DB Pros.
-
Tips on query normalization with SQL Server 2005
SQL Server application developers to want to normalize the query text returned in a Profiler trace. This allows the performance of a query to be more easily tracked and measured. Ken Henderson shares his insightful thoughts through a blog post on query normalization.
-
MySpace.com uses iBATIS.NET for persistence
Popular social site MySpace.com, which is the number 5 most trafficked site on the internet according to alexa.com is running a .NET backend and uses iBatis.NET for persistence. iBATIS is an open source data mapper framework that is commonly used when projects wish to control the SQL used instead of having it generated by an ORM framework.
-
Ruby Driver for HSQLDB Released
A Ruby driver for HSQLDB has been released on RubyForge by Jared Richardson. The driver relies on Java Bridge technology (quite different than JRuby) to interop with the Java-based HSQLDB (formerly HypersonicSQL) open-source database.
-
Test Driven Database Development
Scott Ambler thinks it's time to raise the bar on data quality: he suggests teams should adapt well accepted TDD code quality practices to database development, since data is a valuable corporate asset. His article in September's TASSQuarterly magazine presents his "Test Driven Database Development" (TDDD) which, just like TDD, combines test-first practices and refactoring.
-
BLINQ Web Application Generator
The BLINQ demo allows developers to quickly develop CRUD (Create/Read/Update/Delete) style applications. With one command, an entire web site with insert, list, and detail pages is created.
-
ADO.NET vNext: Entity Data Model Designer Prototype Available
The ADO.NET team has released a demo of their Entity Data Model Designer. This tool demonstrates some of the Object-Relational Mapping (ORM) features planned for ADO.NET vNext.