InfoQ Homepage Database Design Content on InfoQ
-
Microsoft is Making a Play for MySQL Users
Microsoft has released its first community tech preview for a MySQL to SQL Server migration tool. This tool supports SQL Server 2005, 2008, and Azure.
-
MagLev Ruby VM Now Available, Brings GemStone's Persistence to Ruby
The long awaited MagLev Ruby implementation, based on GemStone Smalltalk, is now available in a public alpha release. While not quite ready to run Rails, it does support frameworks like Rack and Sinatra. MagLev comes with full support for GemStone's mature distribution and persistence features.
-
Simplify SQL Migration Scripts with SQrbL
Managing SQL-based scripts can become a nightmare with time. Rails solved this with ActiveRecord Migration. Sam Livingston-Gray wrote a small standalone Ruby tool to generate hierarchical migration script. Based on the fact that SQL scripts can become very verbose and duplication-prone, Sam started SQrbL which is a mix of SQL and Ruby.
-
MapPoint Add-In For SQL Server Released
Microsoft released a free MapPoint 2009 Add-In for SQL Server 2008 spatial data. The add-in can be used with MapPoint to build map graphics against queries on SQL Server 2008 spatial geography columns.
-
ODBMS.ORG Adds Persistence Patterns Resources
ODBMS.ORG has added persistence patterns to its collection of resources for educators, students, professionals, and open source practitioners. Three pattern collections comprise the initial offering in this area. A Best Persistence Pattern Award, is planned for any pattern submitted prior to May 29, 2009.
-
Open Database Alliance: New Direction for mySQL
Monty Program Ab, a MySQL database engineering company, and Percona, a MySQL services and support firm, today announced the "The Open Database Alliance." This effort will fork the mySQL code base, using MariaDB as a starting point. MariaDB was created by Monty Widenius, co-founder of mySQL.
-
Hasso Plattner Touts Highly Parallel Computing and Column-Oriented Databases
In his keynote at Sapphire 2009, Hasso Plattner, co-founder of SAP, explained that he sees multi-cores, and in memory column-oriented databases in the future of enterprise applications.
-
SQL Server 2008 Major Updates
Microsoft has released significant updates for SQL Server 2008, including 2008 Service Pack 1, Express Edition Service Pack 1, large Feature Pack, Upgrade Advisor, SRS Report Builder 2.0, SharePoint integration, and data mining Office add-ins.
-
FriendFeed Implements Schema-less Storage Atop MySQL
Brett Taylor, founder of FriendFeed, describes how they overcame some limitations of MySQL to handle problems of scaling and database evolution by implementing a "schema-less" storage system on top of MySQL.
-
Presentation: Refactoring Databases
For years the norm for developers was to work in an iterative and incremental manner but for database developers to work in a more serial manner. The predominance of evolutionary development methods make it clear that the two groups need to work in the same manner to be productive as a team. Pramod presents material from "Refactoring Databases " on implementing evolutionary database development.
-
Clustered JRuby - Transparent Clustering of JRuby with Terracotta
Gemstone's Maglev Demo at RailsConf sparked a lot of interest. A new project experiments with bringing this kind of transparent clustering to JRuby using Terracotta. We talked to Fabio Kung who's been experimenting with this approach.
-
Interview: Damien Katz Relaxing on CouchDB
In this interview, Damien Katz talks about CouchDB, a distributed, fault tolerant, document oriented database developed by Apache Incubator. CouchDB is written in Erlang, and the database is accessed through an HTTP/JSON API. The database view engine is run on JavaScript, but other languages have been used like Ruby and Python.
-
Static Code Analysis for T-SQL
Static code analysis, long neglected on the Windows platform, has been becoming more and more import in the last few years. This hasn't gone unnoticed by database developers, who thanks to Ubitsoft can now analyze T-SQL just like .NET developers analyze managed code.
-
Aster In-Database MapReduce
Aster Data Systems has announced an in-database MapReduce implementation for their nCluster database platform.
-
Drizzle - a new direction for databases
Unveiled at the O'Reilly Open Source Convention (OSCON), Drizzle can be described as a "what if" project - creating a database specially for applications that include web based apps, cloud computing components, databases without business logic (aka stored procedures), and multi-core architecture.