Hello! I have some general questions about ElevateDB:

How does ElevateDB take in checkpoints?
Does this product support compression and if so what algorithms does it use?
Does the database support foreign keys?
Does the database support query compilation and parallel execution?
What language does ElevateDB support to take in data?

Thanks!

<< How does ElevateDB take in checkpoints? >>

ElevateDB’s transaction/locking model is fairly primitive because ElevateDB still supports a desktop-database-oriented file-sharing model.  So, at this time, we don’t have fail-safety in the engine.

<< Does this product support compression and if so what algorithms does it use? >>

ElevateDB uses ZLib for backup/restore compression/decompression, and a custom index key compression for non-unique keys that is a form of duplicate key compression.

<< Does the database support foreign keys? >>

Yes.

<< Does the database support query compilation and parallel execution? >.

ElevateDB compiles queries into an AST, and then executes directly against the AST.  ElevateDB does not currently support parallel execution.

<< What language does ElevateDB support to take in data? >>

ElevateDB can be compiled directly into applications created with RAD Studio from Embarcadero (C++/Delphi languages), and can be used directly with any .NET application using the ElevateDB .NET Data Provider.  In addition, any language that can use ODBC can use the ElevateDB ODBC Driver for access.  We also have an ElevateDB PHP Extension, but it is currently stuck at PHP 5.x and needs to be updated for PHP 7.

Tim Young
Elevate Software
www.elevatesoft.com

What is the storage organization?

CJC321 wrote:

<< What is the storage organization? >>

The table storage is described here in more detail:

https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Architecture

under "Tables" at the bottom.

Tim Young
Elevate Software
www.elevatesoft.com

What index data structures and index defaults does it support?

<< What index data structures and index defaults does it support? >>

ElevateDB uses a B+Tree structure for indexes where all key values are stored in the leaf nodes.

I'm not quite sure what you're asking for with the "index defaults" question.  There are various aspects of the indexes that have default values, such as 4K/8K for the index page size (Ansi/Unicode) and how the compression is handled.

Tim Young
Elevate Software
www.elevatesoft.com