relational on SWiK

Interoperability Happens - The Vietnam of Computer Science

Fri, 05 Sep 2008 15:58:13 -0700

hyperjaxb2: Hyperjaxb2 - relational persistence for JAXB objects

Sun, 31 Aug 2008 00:59:02 -0700

hyperjaxb2: Hyperjaxb2 - relational persistence for JAXB objects

Sun, 31 Aug 2008 00:56:03 -0700

Pro SQL Server 2008 Relational Database Design and Implementation Pro

Sat, 30 Aug 2008 20:59:47 -0700

Pro SQL Server 2008 Relational Database Design and Implementation Pro Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everyt...

HIBERNATE - Relational Persistence for Idiomatic Java

Fri, 29 Aug 2008 15:55:24 -0700

rpbourret.com - Papers about XML

Mon, 18 Aug 2008 11:06:19 -0700

First-Class Relationships for Object-Orientated Programming Languages

Tue, 22 Jul 2008 02:51:07 -0700

EclipseLink - Eclipsepedia

Thu, 10 Jul 2008 13:50:56 -0700

Class-Relational Approach to Tabular and XML Data Representation

Sun, 06 Jul 2008 10:49:57 -0700

MySQL :: Guide to Choosing an Embedded Relational Database

Sun, 22 Jun 2008 19:59:10 -0700

Google Directory - Computers > Programming > Languages > Java > Databases and Persistence > Object Persistence

Fri, 20 Jun 2008 11:59:15 -0700

Object/Relational Mapper & Code Generator in Net 2.0 for Relational & XML Schema - Home

Thu, 19 Jun 2008 11:17:49 -0700

relational database storage vs XML based data storage

Fri, 13 Jun 2008 05:19:35 -0700

<sep/>techniques for storing structured data and high-performance query evaluation. On the other hand, XML is a newer, portable data forma

XML and Relational Storage–Are they mutually exclusive?

Wed, 04 Jun 2008 15:52:34 -0700

Duro - open-source relational database management system

Mon, 26 May 2008 07:15:24 -0700

Caché Technology Guide

Sun, 11 May 2008 02:18:35 -0700

PostgreSQL can be used in a lot of different ways

Thu, 06 Mar 2008 07:49:33 -0800

The relational DBMS industry is filled with startups. In some way or other, most of them are based on or make use of the open source project PostgreSQL. (Not all, of course; exceptions include DATAllegro and Infobright, which are based on Ingres and MySQL respectively.) But how they use PostgreSQL varies greatly.

EnterpriseDB is at one extreme. It hired a number of the top PostgreSQL developers, and is widely credited in the industry for major enhancements in PostgreSQL 8.3. Look in the future for EnterpriseDB to be less “The Oracle-compatible database company” and more “The PostgreSQL company that offers great features, including Oracle compatibility.”

Vertica is at the other pole. I still have the impression that Vertica emulates PostgreSQL to gain various tool compatibility benefits. But upon checking I learned, to my surprise, that Vertica uses no actual PostgreSQL code whatsoever.

Greenplum is somewhere in between. Greenplum started from PostgreSQL, and said it was supporting something open source called Bizgres. But Seth Grimes calls Greenplum’s commitment to Bizgres into serious question. But then, given how silent Greenplum has been recently (some PR around an investment round excepted), I’m not sure what to think of anything I previously heard from the company.

Please subscribe to our feed!

Database management system choices ? 4 categories of relational

Fri, 15 Feb 2008 12:44:54 -0800

This is the second of a five-part series on database management system choices. For the first post in the series, please click here.

For the most part, relational database management systems divide into four major classes:

High-end OLTP (OnLine Transaction Processing) relational DBMS. Oracle is the flagship for this category, followed by DB2.
Specialty data warehouse DBMS. Teradata is the leader here, followed by Netezza, DATAllegro, ParAccel, Vertica, Infobright, Greenplum, Kognitio, Sybase IQ, and a host of others.
Mid-range relational database management systems. Most of the contenders here fall into one or more of three categories: Open-source-based relational DBMS (MySQL, PostgreSQL, EnterpriseDB); reseller-focused relational DBMS (Progress OpenEdge, Pervasive PSQL); or crippled ?editions? of high-end systems. Microsoft SQL Server was once a clear mid-range system, but now is better classified as high-end OLTP.
Embedded relational database management systems. The leader of this category is Sybase’s SQL Anywhere. Also significant are memory-centric products Oracle TimesTen and solidDB.

High-end OLTP relational database management systems are complex and mature products, differentiated mainly on reliability, availability, performance, scalability, security, license cost, maintenance cost, programming/administration cost, and datatype support. All except the last point can be evaluated pretty effectively on an outside-in basis. That is, is suffices to look at proven results, without worrying a whole lot about architecture or product futures. Just remember that a lot of the high-end features come through extra-cost add-ins, which need to be included in any evaluation.

That said — most evaluations of high-end OLTP RDBMS are pretty moot anyway. Large enterprises usually have one favored vendor, who provides a significant quantity discount on license and maintenance costs. Using the OLTP RDBMS you already have also usually leads to significant efficiencies in administration expense. Thus, the high-end OLTP is the one part of the DBMS market that truly is as mature as conventional wisdom would have us believe ? at least, that is, until something like H-Store comes to fruition.

Even so, high-end relational OLTP DBMS vendors face two major competitive challenges, which are taking significant share of new applications within those vendors’ installed bases. For more about those, please see the next two posts in this series.

The complete series

Please subscribe to our feed!

Database Design - Many-to-many

Mon, 21 Jan 2008 12:55:09 -0800

The blogosphere writes about Sun buying MySQL

Thu, 17 Jan 2008 03:38:44 -0800

More from me soon, but first here is a survey of what other people are saying about Sun’s billion-dollar deal to acquire MySQL:

Jeremy Cole, evidently a very experienced high-end MySQL user, itemizes some serious problems with MySQL — optimizer, memory management, replication, and so on. (Uh, Jeremy — what part of the product do you like?) He also echoes a theme I’ve seen elsewhere, and to some extent noticed myself; MySQL has had a lot of management issues as a company.
Jeffrey McManus calls out Sun’s promise to continue to support non-Java programming languages in MySQL. Kaj Arnö of MySQL makes the point emphatically, reciting a list of operating systems and development environments/languages MySQL will continue to support.
Matt Asay quite reasonably interprets Sun’s move as a bid for overall leadership and development of the open source software platform industry. I would add that Sun CEO Jonathon Schwartz came up through the software side of the business. I would further add that Sun has a dismal track record with closed-source software acquisitions, including Forte’, NetDynamics, and the enterprise side of Netscape.
Matt also has selected quotes from the press conference, including Sun saying the coopetitionally obvious “Yeah, we’ll continue serious support for PostgreSQL and Oracle too.” Brian Aker also supports the PostgreSQL point.
Zack Urlocker of MySQL implies that Jonathon Schwartz was very involved in the deal personally. That makes all kinds of sense.
451 Group has some interesting links, and don’t miss the short comment thread.
The official MySQL and Sun company lines are summarized in this Zack Urlocker post on Infoworld (as well as some of the links above) and this post from Jonathon Schwartz of Sun.

Mapping objects to relational databases

Sat, 05 Jan 2008 07:14:53 -0800

MySQL AB :: Using XML in MySQL 5.1 and 6.0

Tue, 18 Dec 2007 02:05:47 -0800

Storing RDF in a relational database

Tue, 11 Dec 2007 19:47:36 -0800

Comparing Formats

Mon, 10 Dec 2007 04:47:39 -0800

Comparing Formats

Mon, 10 Dec 2007 04:42:10 -0800

Apache Database Open Source

Fri, 07 Dec 2007 12:40:45 -0800

davidbau.com: XML and Relational Thinking

Sat, 24 Nov 2007 07:36:56 -0800

Daversy - Trac

Wed, 21 Nov 2007 10:42:14 -0800

Daversy is a source control tool for relational databases. * Keep a history of changes... * Instantly create a database for any version of your software. * Merge changes made by different developers ... * Monitor structural changes ...

Alchemy - Open Source AI

Mon, 19 Nov 2007 18:30:14 -0800

Welcome to the Alchemy system! Alchemy is a software package providing a series of algorithms for statistical relational learning and probabilistic logic inference, based on the Markov logic representation. Alchemy allows you to easily develop a wide rang

Python: Mother - Object Relational Mapper with strong introspection

Thu, 15 Nov 2007 19:25:22 -0800