Heuristic-based entity-relationship modelling through natural language processing

N Omar, JRP Hanna, P McKevitt

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Here we propose new heuristics that assist the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from a natural language description and describe the implementation of such a system called ER-Converter. Though this is a semi-automatic transformation process, ER-Converter aims to require minimal human intervention during the process. ER-Converter has been evaluated in blind trials against a set of database problems. ER-Converter has an average of 95% recall and 82% precision. The evaluation results are discussed and demonstrate that ER-Converter could be used, for example, within the domain model of a multimedia intelligent tutoring system, designed to assist in the learning and teaching of databases.
LanguageEnglish
Title of host publicationUnknown Host Publication
EditorsL McGinty, B Crean
Place of PublicationDublin, Ireland
Pages302-313
Number of pages12
Publication statusPublished - Sep 2004
EventProc. of the 15th Artificial Intelligence and Cognitive Science Conference (AICS-04) - Galway-Mayo Institute of Technology (GMIT), Castlebar, Ireland
Duration: 1 Sep 2004 → …

Conference

ConferenceProc. of the 15th Artificial Intelligence and Cognitive Science Conference (AICS-04)
Period1/09/04 → …

Fingerprint

Processing
Intelligent systems
Teaching

Cite this

Omar, N., Hanna, JRP., & McKevitt, P. (2004). Heuristic-based entity-relationship modelling through natural language processing. In L. McGinty, & B. Crean (Eds.), Unknown Host Publication (pp. 302-313). Dublin, Ireland.
Omar, N ; Hanna, JRP ; McKevitt, P. / Heuristic-based entity-relationship modelling through natural language processing. Unknown Host Publication. editor / L McGinty ; B Crean. Dublin, Ireland, 2004. pp. 302-313
@inproceedings{702c9e597c234894b1cf680752cd501f,
title = "Heuristic-based entity-relationship modelling through natural language processing",
abstract = "Here we propose new heuristics that assist the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from a natural language description and describe the implementation of such a system called ER-Converter. Though this is a semi-automatic transformation process, ER-Converter aims to require minimal human intervention during the process. ER-Converter has been evaluated in blind trials against a set of database problems. ER-Converter has an average of 95{\%} recall and 82{\%} precision. The evaluation results are discussed and demonstrate that ER-Converter could be used, for example, within the domain model of a multimedia intelligent tutoring system, designed to assist in the learning and teaching of databases.",
author = "N Omar and JRP Hanna and P McKevitt",
year = "2004",
month = "9",
language = "English",
isbn = "1-902277-89-9",
pages = "302--313",
editor = "L McGinty and B Crean",
booktitle = "Unknown Host Publication",

}

Omar, N, Hanna, JRP & McKevitt, P 2004, Heuristic-based entity-relationship modelling through natural language processing. in L McGinty & B Crean (eds), Unknown Host Publication. Dublin, Ireland, pp. 302-313, Proc. of the 15th Artificial Intelligence and Cognitive Science Conference (AICS-04), 1/09/04.

Heuristic-based entity-relationship modelling through natural language processing. / Omar, N; Hanna, JRP; McKevitt, P.

Unknown Host Publication. ed. / L McGinty; B Crean. Dublin, Ireland, 2004. p. 302-313.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

TY - GEN

T1 - Heuristic-based entity-relationship modelling through natural language processing

AU - Omar, N

AU - Hanna, JRP

AU - McKevitt, P

PY - 2004/9

Y1 - 2004/9

N2 - Here we propose new heuristics that assist the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from a natural language description and describe the implementation of such a system called ER-Converter. Though this is a semi-automatic transformation process, ER-Converter aims to require minimal human intervention during the process. ER-Converter has been evaluated in blind trials against a set of database problems. ER-Converter has an average of 95% recall and 82% precision. The evaluation results are discussed and demonstrate that ER-Converter could be used, for example, within the domain model of a multimedia intelligent tutoring system, designed to assist in the learning and teaching of databases.

AB - Here we propose new heuristics that assist the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from a natural language description and describe the implementation of such a system called ER-Converter. Though this is a semi-automatic transformation process, ER-Converter aims to require minimal human intervention during the process. ER-Converter has been evaluated in blind trials against a set of database problems. ER-Converter has an average of 95% recall and 82% precision. The evaluation results are discussed and demonstrate that ER-Converter could be used, for example, within the domain model of a multimedia intelligent tutoring system, designed to assist in the learning and teaching of databases.

M3 - Conference contribution

SN - 1-902277-89-9

SP - 302

EP - 313

BT - Unknown Host Publication

A2 - McGinty, L

A2 - Crean, B

CY - Dublin, Ireland

ER -

Omar N, Hanna JRP, McKevitt P. Heuristic-based entity-relationship modelling through natural language processing. In McGinty L, Crean B, editors, Unknown Host Publication. Dublin, Ireland. 2004. p. 302-313