Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
General Questions about ElevateDB |
Mon, Dec 9 2019 11:55 AM | Permanent Link |
CJC321 | 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! |
Mon, Dec 9 2019 12:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << 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 |
Tue, Dec 10 2019 2:15 AM | Permanent Link |
CJC321 | What is the storage organization?
|
Tue, Dec 10 2019 12:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Dec 10 2019 10:56 PM | Permanent Link |
CJC321 | What index data structures and index defaults does it support?
|
Sat, Dec 14 2019 12:34 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |