|
Valentina DB is the advanced, object-relational columnar database and the result of 15 years of research and constant optimization. With so much continuous development and optimization, it is hard to pick among the hundreds of features available.
Here are just 18 features of the Valentina DB Core - shared by all products that include Valentina DB, including Valentina Studio, Valentina Server as well as all developer products.
|
|
Work with descendants and ancestors, ROOT records. Valentina DB queries can reduce query length and complexity by 80% or more. |
|
Built in API for compacting databases. Use deframentation for chain of segments of logical files and BLOB record, pages in the page files. |
|
Not compromised by B-tree limitations. Create indexes based on calculated fields, or any SQL expression based on fields. |
|
Valentina Abstraction Links |
|
Eliminate massive tables dedicated to foreign keys by leveraging Valentina DB Abstraction Links. 1:1, M:1 or M:M relations - without building tables.
|
|
Optimized storage for encryptable media, BLOB storage of indexable text. Even works from locked media devices.
|
|
Disk based data storage, with over eight different modes for storing your data on disk - including temporary disk based options for tables and fields.
|
|
Valentina DB has close to 100 database calculation functions built right in, ready to use with SQL, checks and table methods. |
|
Valentina DB databases can be stored in up to four different logical volumes; each file can have a unique extension. |
|
UTF-16, UTF-8 and 200+ individual encodings provides best platform for multi-language searching, sorting and storage.
|
|
|
Granular control over cloning complete databases or just their structure. Advanced API commands for refactoring and transforming link types. |
|
Advanced cache with optimization to reduce disk I/O overhead. Valentina caching is the result of over a decade of performance based optimization. |
|
Hierarchy of 448-bit encryption for databases, tables and fields in addition to separate encryption management for database schemas. |
|
Diagnose inefficiencies by leveraging warning and tune logs using the advanced Valentina API or through free visual tools.
|
|
Supports temporary in-memory databases and tables for ultra fast performance as well as blazingly fast disk based performance.
|
|
Use multiple data models, including full relational, object-relational, and high performance Valentina data model. You decide.
|
|
Native Valentina databases, tables, fields, links and servers can be assigned properties and work with GET/SET/SHOW Commands.
|
|
REGEX search, Full Text Search, IndexStyles (such as IgnoreWords, maxLengthToIgnore) and Text/XML import and export of data and schema.
|
|
Utilize Stored Procedures, Views, Triggers, complex sub-queries, return XML and more using standard SQL + Valentina DB Native Extensions.
|
|
|
|
|
|
