Сергей Думанский » Публикация
Поделиться публикацией:
Опубликовано
2013-04-04
Опубликовано на SciPeople2014-09-25 16:12:43
ЖурналCodePlex -Open source Project Hosting
Compuct universal data model based on EAV (CUEAV)
Аннотация
To improve EAV data model and support data transformation from arbitrary classical row model based on Walker’s scheme into CUEAV and back out. This supports capability to create changeless User Interface for implementing CRUD operations and gives ability to add new entities without additional rebuilding user forms and what is more we can observe real time value deviation monitoring because of Attribute table has guideline values.
Also this model makes it possible to get out of EAV main imperfection – complexity and low processing power of analytical queries. Most convenient CUEAV data model application will be made use of for creating automatically customized interface according updated entities for example in clinical research DB.
It is necessary to take notice of that it is enough 3 modified CUEAV’s tables: Class, Attribute, ClassLinks and some additional triggers so that to keep up execution CRUD operations in row classical DB and herewith there is no necessity changing user’s interface