The “sakila” sample database was developed by MySQL AB documentation team, under the BSD license, and is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth. The original documentation about Sakila database you can find on official site, or download as pdf file.
We have take the “sakila” database, which exists as demo for mySQL, PostgreSQL, SQLite, Oracle and other databases and port it into Valentina DB model. Even more, we provide here 3 variants.
Differences in Databases
In the table below you can see amount of objects in each database:
|Schema Objects||with RDB Links||with ObjPtr Links||with Binary Links|
You can see that, amount of objects is reducing from database with RDB Links to database with ObjPtrLinks and to database with Binary Links. This is a natural consequence of using Valentina's ObjPtr & Binary Links. Except showed objects, the number of fields in tables was reduced too: for ObjPtr links was removed primary key fields from the referenced tables, and for Binary Links was removed references fields (Foreign Keys or ObjPtr). In result, from database was removed sequences, and alot of indexes. For database with binary links also was removed tables used for realization M:M relationship.
You can see difference in the database schemas on below pictures, or in the diagram “Films” in each database.
In result of deleting unused fields, the actual size of stored data is reduced:
|with RDB Links||with ObjPtr Links||with Binary Links|