Ingres _ by CA_

Ingres r3 is the version which was put into opensource.

Features

  • Value based table partitioning (a-c go here d-x go here, etc)
    • can partition tables based on value of records
    • No application change required
  • parallel query execution
    • may utlize more than one cpu on MP machines for a single query.
    • single processor machines also benefit
  • Advanced query optimization techniques (query decomposition, flattening, and rewrite)
  • Federation through ingres star
    • support two phase commits for distributed transactions
  • Replication of master at one or more slaves
    • can also have multiple masters where the other master acts as a slave when doing updates to one or the other
  • next release to support grids
  • admittly driver support is lacking
  • winblows only db gui

MySQL with David and Monty

  • runs on 87 gazillion platforms
  • Connector/MXJ – embedded jdbc within java (embedded java database???)
  • Storage engine slides…
  • Special storage engines
    • Archive – logging data you don’t want to delete or update
    • Blackhole – allows replication but throws away all data
    • MyISAM for logging: prefix locking allows fully concurrent inserts and reads

MySQL 5.0

<ul>
	<li>Stored procedures</li>
	<li>Triggers</li>
	<li>Views</li>
	<li>XA &#8211; distributed commits across different databases</li>
	<li>Data dictionary</li>
	<li>Server side cursors</li>
	<li>Precision Math &#8211; exact calculations with well defined rounding and atleast 56 digits precision.  Very fast w/ static memory allocation</li>
	<li>Strict mode &#8211; ability to get rollback/errors instead of closest value/warning messages (eh? can tell you when it is a bad date, 02/31/2005)</li>
	<li>Federated storage engine</li>
	<li>greedy optimizer (fast multi table joins)</li>
	<li>instance manager (replaces mysqld_safe script)</li>
	<li>extenstion to <span class="caps">LOAD</span> <span class="caps">DATA</span> for doing transformations/calculations at time of load</li>
	<li>5.0 still has 327 bugs but 16 really bad bugs at time of this writing.</li>
</ul><ul>
<li>Upcoming features
<ul>
	<li>partitioning (needed for 20 petabytes that one user is planning)</li>
	<li>replication additions &#8211; row based (physical) replication (normal is logical) + multi source replication</li>
	<li>global backup api</li>
	<li>mysql cluster w/ disk data (non indexed columns)</li>
	<li>Hash  Merge joins</li>
</ul></li>

</ul>

Firebird w/ Ann ?

  • High concurrency, high performance
  • low administration costs
  • flexible architecture
  • active project

Development seems to be fairly slow going. Borland reniged the opensource license and Firebird is a fork. First releases were mostly bug fixes. 1.0 and 1.5 can share same data file.

Firebird Strengths

<ul>
	<li>Flexible architecture</li>
	<li>processed based (fork)</li>
	<li>multi-threaded shared server</li>
	<li>embedded</li>
	<li>low admin cost
	<ul>
		<li>self balancing indexes</li>
		<li>cooperative garbage collection</li>
		<li>single file database</li>
		<li>transportable backup</li>
	</ul></li>
</ul><p><i>Firebird future (2.0)</i></p>
  • currently in alpha 3
  • global temporary tables
  • execute block
  • physical backup

Vulcan

  • in parallel development
  • fork to work on 64bit arch
  • internal sql

Postgresql 8.1

8.1 features are frozen now. beta release in mid-august or early september.

Key New Features:

  • Indexes combined using bitmaps – index any attributes you want to query on later. then when you do a join across different attributes, the engine bitmaps the indexes and can perform very fast lookups (knows where to find pages and other data structures)
  • Two-phase commit for distributed transactions
  • Automatic vaccuum process
  • Global shared buffer lock removed, improves SMP support
  • Functions returning multiple out parameters (oracle feature)
  • Shared row locks

Pervasive, Green Plum and EnterpriseDB and Unisys building products/businesses around Postgres. Approx 1.5 million downloads of 8.0.×. and lots of new users (notable NWS and Ameritrade)