SCHEMAGIC

0081999 - ÚI 2007 RIV CZ eng L - Prototype, f. module
Nagy, Miroslav - Dioszegi, Matěj
SCHEMAGIC.
[SCHEMAGIC.]
Internal code: SCHEMAGIC verze 1.0 ; 2006
Technical parameters: software pro synchronizaci relačních a jiných datových schemat
Economic parameters: nástroj pro usnadnění vývoje datových vrstev aplikací
R&D Projects: GA AV ČR 1ET200300413
Institutional research plan: CEZ:AV0Z10300504
Keywords : relational schema * schema synchronisation * diff algorithm
Subject RIV: IN - Informatics, Computer Science

Schemagic is an universal tool that is capable of synchronisation of existing database schemas and their transformation into various vendor-specific forms. Emphasis is laid on the openness of the solution, the database platform independence and extensibility. The tool can be easily extended by adding new database objects types. It is also capable of transmitting schemas of supported types without loss of data between RDBMS of the same vendor. During transmission of schemas between two DBMS of different types the tool preserves as much information as possible. The tool warns user in ambiguous situations during the synchronisation process and allows him to make a decision in which way to solve a particular synchronisation problem. The tool helps developers of database applications with the generating of the documentation of the database schema, that is beeing developed. The universality of the tool was successfully used to support synchronisation of MUDR EHR knowledge trees.

Schemagic is an universal tool that is capable of synchronisation of existing database schemas and their transformation into various vendor-specific forms. Emphasis is laid on the openness of the solution, the database platform independence and extensibility. The tool can be easily extended by adding new database objects types. It is also capable of transmitting schemas of supported types without loss of data between RDBMS of the same vendor. During transmission of schemas between two DBMS of different types the tool preserves as much information as possible. The tool warns user in ambiguous situations during the synchronisation process and allows him to make a decision in which way to solve a particular synchronisation problem. The tool helps developers of database applications with the generating of the documentation of the database schema, that is beeing developed. The universality of the tool was successfully used to support synchronisation of MUDR EHR knowledge trees.
Permanent Link: http://hdl.handle.net/11104/0145701