Extracting entity-relationship schemas from relational databases: a form-driven approach Export

@proceedings{citeulike:4001296, abstract = {The paper presents a framework for extracting an entity-relationship schema from a set of form model schemas of an operational relational database. Form model schemas gather information, i.e., structural information and constraints among data, extracted from both form structures and instances and then generalized into database semantics using an inference process guided by human activity. The approach uses these schemas to supplement low-level schemas to help reconstruct a conceptual schema, in this case an entity-relationship schema}, author = {Mfourga, N.}, booktitle = {Reverse Engineering, 1997. Proceedings of the Fourth Working Conference on}, citeulike-article-id = {4001296}, citeulike-linkout-0 = {http://dx.doi.org/10.1109/WCRE.1997.624589}, citeulike-linkout-1 = {http://ieeexplore.ieee.org/xpls/abs_all.jsp?arnumber=624589}, comment = {* Input: rel db, forms (to present db data to users), db data * Output: ER model of the DB * Process: \# from db and forms, create a forms model schema, which exploits additional info in forms to re-create ER model \# additionally also uses instances of forms (with instance data) that the designer (human) uses to validate and add some constraints to the model (like range of attributes) * No eval}, doi = {10.1109/WCRE.1997.624589}, journal = {Reverse Engineering, 1997. Proceedings of the Fourth Working Conference on}, keywords = {data, db, entityguides, schema}, pages = {184--193}, posted-at = {2009-02-03 15:59:23}, priority = {0}, title = {Extracting entity-relationship schemas from relational databases: a form-driven approach}, url = {http://dx.doi.org/10.1109/WCRE.1997.624589}, year = {1997} }

TY - CONF ID - citeulike:4001296 L3 - citeulike-article-id:4001296 N2 - The paper presents a framework for extracting an entity-relationship schema from a set of form model schemas of an operational relational database. Form model schemas gather information, i.e., structural information and constraints among data, extracted from both form structures and instances and then generalized into database semantics using an inference process guided by human activity. The approach uses these schemas to supplement low-level schemas to help reconstruct a conceptual schema, in this case an entity-relationship schema JF - Reverse Engineering, 1997. Proceedings of the Fourth Working Conference on EP - 193 TI - Extracting entity-relationship schemas from relational databases: a form-driven approach T2 - Reverse Engineering, 1997. Proceedings of the Fourth Working Conference on SP - 184 KW - data KW - db KW - entityguides KW - schema N1 - * Input: rel db, forms (to present db data to users), db data * Output: ER model of the DB * Process: # from db and forms, create a forms model schema, which exploits additional info in forms to re-create ER model # additionally also uses instances of forms (with instance data) that the designer (human) uses to validate and add some constraints to the model (like range of attributes) * No eval AU - Mfourga, N PY - 1997/// UR - http://dx.doi.org/10.1109/WCRE.1997.624589 ER -