History for SuneidoPlatform

??changed:
-
Homepage of Suneido is http://www.suneido.com

Suneido is a complete, integrated application platform - a system for developing and deploying applications without the frustrations of integrating multiple different products. Suneido incorporates an object-oriented SuneidoLanguage, client-server relational SuneidoDatabase, and application frameworks and components. It includes the SuneidoDevelopmentEnvironment used to create applications as well as the client and server required to run applications on your network.

* **not** SQL, uses a relational algebra query language

* query language includes select, project, join, left outer join, union, difference, intersect

* integrated with SuneidoLanguage to lower *impedance* mismatch, same data types, same language for rules and triggers

* allows multiple *candidate* keys, a single *primary* key is not required

* explicit foreign keys, with cascade or block

* business rules e.g. for derived fields, may be stored or calculated on demand

* rules automatically determine dependencies and recalculate when dependencies change

* standalone or **client-server** (tcp/ip)

* add, update, and delete triggers

* small footprint (executable is roughly 1mb)

* concurrency

	* fully isolated transactions with commit and rollback

	* *optimistic*, timestamp based, multi-version

	* read-only transactions see data *as-of* their start time

	* read-only transactions (e.g. long running reports) never conflict with other transactions

* recovery - database can be rolled back to last consistent state after hardware or software crash

* *on-line* backups - use a single read-only transaction to take a *snapshot* of the database

* database is a single file accessed via virtual memory mapping for fast speed

* fields and records are variable length

* fields are dynamically typed (like SuneidoLanguage)

* fields and indexes can be added and removed at any time without *rebuilding* data

* multiple btree indexes

* sophisticated cost based query optimizer that rearranges queries, chooses strategies, and selects the best index usage

* **open source** under GPL license

* sample applications, including a complete accounting system (GL, AR, AP) available