Mckoi SQL Database Mailing list

Tobias Downer | 4 Mar 2008 04:35

Mckoi 2.0 work in progress download

Hi all,

I have just uploaded a work in progress release of Mckoi 2.  You can 
download it here;

http://www.mckoi.com/database/ver2/mckoi20wip01.zip

I will be continuing to add releases to this directory as development 
continues.

Please be aware this release is a work in progress and it's missing some 
important features.  First I'll quickly describe what is complete and 
I'm most interested in getting feedback on at the moment.

The Mckoi 2.0 data store;  I expect the new snapshot data store engine 
and API will be the main focus of the 2 release.  The data store is the 
part of a database engine that deals with modeling structures for 
storing and indexing data in a database and mapping this data to a 
storage medium (such as in a persistent local file system or a transient 
heap).  Version 2.0 provides developers with a fairly straight forward 
API for modeling and manipulating primitive data structures freely in a 
strict snapshot transactional environment.  The problems of caching, 
memory allocation/deallocation, transaction management and structural 
representation are dealt with by the data store engine.

One way to think of the data store engine in 2.0 is a file system that 
is designed for database software and so supports strict isolation 
enforcement, discrete and controllable commit states, and supports files 
of various sizes and quantities with efficient creation and deletion. 
Most importantly, the data store supports very efficient copying of data

(Continue reading)

headers

John Garrett Smith | 4 Mar 2008 15:20

Re: Mckoi 2.0 work in progress download

Toby,

I've reviewed the work you've done for the new version of McKoi and I
found some things I like (like the new treestore, although I haven't
got how it is attached to the rest of the system) and some things I
like less (like the replacement of the interpret package with
Operation classes)...

One thing I didn't find at all was the class Database.java :D
Hope you will include in the next version...

Anyway, thank you again for the effort!
John

On Tue, Mar 4, 2008 at 4:35 AM, Tobias Downer <toby <at> mckoi.com> wrote:
> Hi all,
>
> I have just uploaded a work in progress release of Mckoi 2.  You can
> download it here;
>
> http://www.mckoi.com/database/ver2/mckoi20wip01.zip
>
> I will be continuing to add releases to this directory as development
> continues.
>
> Please be aware this release is a work in progress and it's missing some
> important features.  First I'll quickly describe what is complete and
> I'm most interested in getting feedback on at the moment.
>
> The Mckoi 2.0 data store;  I expect the new snapshot data store engine

(Continue reading)

headers

Tobias Downer | 4 Mar 2008 23:25

Re: Mckoi 2.0 work in progress download

Hi John,

The Database class does not exist in the new version.  The equivalent 
class in version 2 is com.mckoi.database.TSDatabaseSession.  For an 
example of how to create a store and wrap a TSDatabaseSession around it, 
take a look at the com.mckoi.tests.Main.

In version 2.0, all database components are backed by a 
KeyObjectDatabase which models the data stored, even the relational SQL 
part.

The design of the Operation packages for query planning was to aid in 
writing a more flexible query planner.  All functional query operations 
can now be written using an operation graph.  This allowed me to 
simplify a lot of code around the handling of primitive SQL expression, 
operation and function classes.  The interpret package may return if 
people want to write their own custom SQL queries.

In Mckoi 2.0, interpreting SQL statement is handled by the class 
com.mckoi.database.SQLStatementInterpreter.

Toby.

John Garrett Smith wrote:
> Toby,
> 
> I've reviewed the work you've done for the new version of McKoi and I
> found some things I like (like the new treestore, although I haven't
> got how it is attached to the rest of the system) and some things I
> like less (like the replacement of the interpret package with

(Continue reading)