Valentina Database Core Features In Depth

Valentina Key-Value Database

Valentina DB allows the creation and storage of one or more Key-Value data stores.

In Memory Databases

Supports temporary in-memory databases and tables for ultra fast performance as well as blazingly fast disk based performance.

SQL Database

Valentina DB can be your SQL 92 compliant database, with or without object-relational extensions.

Calculation Functions

Valentina DB has hundreds of database calculation functions built right in, ready to use with SQL, checks and table methods.

NoSQL Database

Native API support means Valentina Database was one of the first NoSQL databases available

Standards Compliant

Best UNICODE implementation and more using standard SQL + Valentina DB Native Extensions.

Valentina DB Field Types

Valentina DB has all standard database field types plus additional ones that exploit Valentina DB advanced features.

Disk Based Databases

Disk based data storage, with over eight different modes for storing your data on disk - including temporary disk based options for tables and fields.

Indexed Text in BLOBs

Store large volumes of indexed text in BLOBs with compression

Advanced Cache System

Advanced cache with optimization to reduce disk I/O overhead. Valentina caching is the result of over a decade of performance based optimization.

Import and Export

Import and export XML or text based data - the data itself and your database schema.

Powerful Indexing

Not compromised by B-tree limitations. Create indexes based on calculated fields, or any SQL expression based on fields.

Valentina Abstraction Links

Use tiny Valentina DB Abstraction Links. 1:1, M:1 or M:M relations - without building tables. Foreign keys optional.

Database Encryption

Hierarchy of 448-bit encryption for databases, tables and fields in addition to separate encryption management for database schemas.

Rich Media Storage Features

Optimized storage for encryptable media, rich media field types. Even works from locked media devices.

Recursive Queries

Work with descendants and ancestors, ROOT records. Valentina DB queries can reduce query length and complexity by 80% or more.

Data Model Blending

Use multiple data models, including full relational, object-relational, and high performance Valentina data model. You decide.

Database Refactoring

Granular control over cloning complete databases or just their structure. Advanced API commands for refactoring and transforming link types.

Object-Relational Database

Native Valentina databases, tables, fields, links and servers can be assigned properties and work with GET/SET/SHOW Commands.

Compress and Defragment

Built in API for compacting databases. Use deframentation for chain of segments of logical files and BLOB record, pages in the page files.

DB Text Engine

REGEX search, Full Text Search, IndexStyles (such as IgnoreWords, maxLengthToIgnore).

Journaling

Record your changes so that you can more easily recover if something goes wrong.

Database Diagnostics

Diagnose inefficiencies with warning and tune logs using the advanced Valentina API or through free visual tools.