Write less to do more. Maintain code that is readable and understandable by everyone on your team, especially those who weren't involved in the original specifications. Valentina DB advances database development as much as object-orientation advanced development.

Removing Unnecessary Complexity from Data Storage

Database developers struggle with mirroring real world objects and business processes within their database schema. Valentina DB isn't dependent on adding vast numbers of additional, flat tables to accomplish that; you can replace flat tables when porting to Valentina with highly efficient binary links. This reduces both size and complexity of databases. Valentina also lets you do away with rowID (when available) with Valentina RecordIDs which uniquely identify records but add nothing to the size of your database. Valentina does away with the complexity -  but you can still handle any kind of data and relationships.

Making Code Simpler and Readable

In crafting business intelligence (BI) solutions, you may need to work with hierarchical data. Here is an example you might use with MySQL or other relational datbase. This example is looking for all descendants from a first record.

WITH w1( id, ptr, f1, level ) AS 
(		SELECT 
			id, 
			ptr, 
			f1,
			0 AS level
		FROM 
			t1 
		WHERE 
			ptr IS NULL
	UNION ALL 
		SELECT 
			t1.id, 
			t1.ptr, 
			t1.f1,
			level + 1
		FROM 
			t1 JOIN w1 ON t1.ptr = w1.id 
) 
SELECT * FROM w1 WHERE id = 1

Here is how your code would look using Valentina DB advanced object-relational model:

DESCENDANTS OF 1 USING l1;