Dbm (discuter | contributions) m |
Dbm (discuter | contributions) m |
||
| (Une révision intermédiaire par un utilisateur est masquée) | |||
| Ligne 6 : | Ligne 6 : | ||
*'''Description''' | *'''Description''' | ||
:An active (or reactive) database is able to react to some external stimuli, such as data modification actions. Practically, the reaction mechanism relies on triggers, predicates and SQL procedures. A specific reaction can be defined through different patterns. The first one is the predicate (SQL check), which states a static property that the data must always meet. Any action that will violate this property is rejected. The second one specifies a procedure that must be executed before or after definite data modification actions (SQL trigger). The third one consists of a procedure of arbitrary complexity (SQL stored procedure) that can be called by users, by client programs or by triggers. | :An active (or reactive) database is able to react to some external stimuli, such as data modification actions. Practically, the reaction mechanism relies on triggers, predicates and SQL procedures. A specific reaction can be defined through different patterns. The first one is the predicate (SQL check), which states a static property that the data must always meet. Any action that will violate this property is rejected. The second one specifies a procedure that must be executed before or after definite data modification actions (SQL trigger). The third one consists of a procedure of arbitrary complexity (SQL stored procedure) that can be called by users, by client programs or by triggers. | ||
| − | :A short introduction to active database can be found in book [B09], chapter 9 and appendix C. A simple design methodology and a practical application are developed in technical reports [TR01-01], [TR01-02] and [TR01-03]. Building an active database that manages complex is-a hierarchies in SQL2 is described in [TR03-02]. | + | :A short introduction to active database can be found in book [B09], chapter 9 and appendix C. A simple design methodology and a practical application are developed in technical reports [TR01-01], [TR01-02] and [TR01-03]. Building an active database that manages complex is-a hierarchies in SQL2 is described in [TR03-02]. References [P90-02] and [B94]describe a decision support model coupling a database with a computing model. This application is described in more detail in the theme ''Databases and Computing Models'', which shows that such a model can be implemented as an active database. |
:Temporal databases are an important application of active databases [B02-01]. See the theme ''Special Databases > Temporal Databases'' for more detail. | :Temporal databases are an important application of active databases [B02-01]. See the theme ''Special Databases > Temporal Databases'' for more detail. | ||
*'''Keywords''' | *'''Keywords''' | ||
:active database, Is-a relation management, active rule, SQL trigger, SQL predicate, SQL stored procedure, integrity management, update propagation, decision support system, temporal database | :active database, Is-a relation management, active rule, SQL trigger, SQL predicate, SQL stored procedure, integrity management, update propagation, decision support system, temporal database | ||
*'''Resources''' | *'''Resources''' | ||
| − | :'''[B09]''' Jean-Luc Hainaut. <u>Bases de données - Concepts, utilisation et développement</u>, Dunod, Collection Sciences Sup, Paris, 2009. [http://info.fundp.ac.be/~dbm/mediawiki/index.php/DUNOD2009|[book description]] | + | :'''[B09]''' Jean-Luc Hainaut. <u>Bases de données - Concepts, utilisation et développement</u>, Dunod, Collection Sciences Sup, Paris, 2009. [http://info.fundp.ac.be/~dbm/mediawiki/index.php/DUNOD2009 | [book description]] |
| + | :'''[B94]''' Jean-Luc Hainaut. <u>Bases de données et modèles de calcul - Outils et méthodes pour l'utilisateur</u>, InterEditions (Dunod), Paris, 1994. [http://info.fundp.ac.be/~dbm/mediawiki/index.php/INTEREDITION1994 | [book description]] | ||
:'''[B02-01]''' Jean-Luc Hainaut, Virginie Detienne. <u>Introduction pratique aux bases de données temporelles</u> novembre 2002, 116 pages. [[http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/Intro-BD-temporelles/IntroPratique-BDT.pdf full text]] | :'''[B02-01]''' Jean-Luc Hainaut, Virginie Detienne. <u>Introduction pratique aux bases de données temporelles</u> novembre 2002, 116 pages. [[http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/Intro-BD-temporelles/IntroPratique-BDT.pdf full text]] | ||
| − | :'''[P90-02]''' Jean-Luc Hainaut. <u>Systèmes d’aide à la décision : une approche méthodologique intégrée</u>, in ''Actes du congrès INFORSID 1990'', pages 7-34, Eyrolles-Afcet, 1990. [http://www.fundp.ac.be/recherche/publications/page_view/41406/ [description]] [http://www.info.fundp.ac.be/~dbm/Documents/Publications-LIBD/Articles-Conferences/conferences-INFORSID/INFORSID-1990/INFORSID-1990.pdf [full text]] | + | :'''[P90-02]''' Jean-Luc Hainaut. <u>Systèmes d’aide à la décision : une approche méthodologique intégrée</u>, in ''Actes du congrès INFORSID 1990'', pages 7-34, Eyrolles-Afcet, 1990. [http://www.fundp.ac.be/recherche/publications/page_view/41406/ [description]] [http://www.info.fundp.ac.be/~dbm/Documents/Publications-LIBD/Articles-Conferences/conferences-INFORSID/INFORSID-1990/INFORSID-1990.pdf [full text]] |
| − | + | ||
:'''[TR03-02]''' Anne-France Brogneaux, Jean-Luc Hainaut. <u>Une approche complète de représentation des relations ISA en SQL2</u>, rapport final du projet ''Active Database'', mars 2003, 19 pages, [http://www.info.fundp.ac.be/~dbm/Documents/Publications-LIBD/Technical-Reports/Gestion-Relations-ISA-en-SQL.pdf [full text]] | :'''[TR03-02]''' Anne-France Brogneaux, Jean-Luc Hainaut. <u>Une approche complète de représentation des relations ISA en SQL2</u>, rapport final du projet ''Active Database'', mars 2003, 19 pages, [http://www.info.fundp.ac.be/~dbm/Documents/Publications-LIBD/Technical-Reports/Gestion-Relations-ISA-en-SQL.pdf [full text]] | ||
:'''[TR01-03]''' Anne-France Brogneaux, Jean-Luc Hainaut. <u>Générateur SQL paramétrique</u>, rapport final du projet ''Active Database'', février 2001, 57 pages, [http://www.info.fundp.ac.be/~dbm/Documents/Publications-LIBD/Technical-Reports/ActiveDB-Generateur-SQL.pdf [full text]] | :'''[TR01-03]''' Anne-France Brogneaux, Jean-Luc Hainaut. <u>Générateur SQL paramétrique</u>, rapport final du projet ''Active Database'', février 2001, 57 pages, [http://www.info.fundp.ac.be/~dbm/Documents/Publications-LIBD/Technical-Reports/ActiveDB-Generateur-SQL.pdf [full text]] | ||
<Back to Themes & Resources page>