List of articles   Choose language


SQL5 or SQL:2011 - driven scene, hierarchical data sets, distributed requests, full-value BLOB

Difficulties related to the usage of 3D-objects appear because of inferior quantity of interface, instead of difficulty of three-dimensional task. The best is

It is enough for user to call one function, e.g. 'printg("select ...")', in which user specify what 3D-objects from database must appear on a screen. It is enough to call it with other query, e.g. 'requst("update ...")', to change position of an object in database and on screen. And this function can be called in any program. We propose to name new interface as Driven Scene.


Îutput fields of a programs are bound by relations IDEF1: screen of program has scheme, and this scheme completely repeats scheme of database. But client cannot separate in Cartesian products, what fields belong to one table, or another. So taking information from database, we lose a part of information. Instead of inserting lost information by machine, we make it manually, taking one record at a time to find records, bound with it. It occupies up to 50% of working time. And this problem until now is not addressed by industry. We propose strong decision. Besides this, input fields are bound by relations IDEF1 too - DBMS itself must accept hierarchical data sets, and place data from it into tables under some agreements.


SQL would be more flexible and convenient for distributed request (gathering data from several databases and scattering them into several databases), than branded programs; including more convenient for replication, than branded programs. But there is no necessary syntax. In purpose of security, distributed requests must satisfy some requirements: we propose concept of whole mistrust of one database to another, concept of client simplicity, and syntax for it.


Modern tendency - to store multimedia data in database, instead of in file system.

Let's consider, what sets of meanings must field contain, and what operators we need.


SQL5
New step in office technologies: Driven scene
Bringing DBMS in line with modern communication requirements - SQL:2009
Own concept vs. foreign: scheme of screen is scheme of data
Why BLOB-field is under-field, and how to make it field
Whole control for access


Dmitry Turin, dmitryturin@yandex.ru



List of articles   Choose language