Pyrrho Database Management System
Pyrrho is a compact and efficient relational database management system for the .NET framework. It supports the SQL2003 standard including advanced OLAP functions, and the free edition works for database files up to 8MB in size. The server has a 500KB footprint, so will run successfully on .NET enabled PDAs and mobile phones. Despite its small size it is scalable and efficient. It has been tested on high-volume scenarios, where it significantly outperforms existing commercial products, and the DataCenter edition is designed for supercomputing clusters.
Pyrrho supports the usual SQL database language, compatible with the SQL2003 standard, but including support for temporal tables. Pyrrho supports relational integrity constraints. Entity, domain and referential integrity constraints are always enforced. However, in Pyrrho the default is that all data types are variable-length. Pyrrho also supports SPARQL, and acts as a SPARQL server.
Key benefits claimed are:
* Compatible with the SQL2003 standard, including support for temporal tables
* The implementation of Pyrrho is in the C# language
* Enforces a full transaction model
* Enforces authority, user & timestamp recording for all changes to the database
* Pyrrho supports threading & clusters. The Database server uses threading internally.
Pyrrho can also scale up to large enterprise uses, although for large databases it needs a lot of main memory (RAM). For best results the computer main memory should be at least twice the size of the database. It is most suited to data that includes a regular stream of new information that is to be kept indefinitely, for example, customer data, orders or accounting transactions. It has an enhanced authorisation model and built-in auditing facilities.The server has a 500KB footprint, so will run successfully on .NET enabled PDAs and mobile phones
Free personal dowload: http://pyrrhodb.msroot.paisley.ac.uk/com/
Consultancy Website: http://www.uws.ac.uk