Acquisition of entity-relationship models from natural language specifications using heuristics

N Omar, P Hanna, P McKevitt

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

Abstract

This paper describes a heuristics-based approach in the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from natural language specifications and describes 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 90% recall and 85% precision. In terms of user intervention, ER-Converter requires very little human assistance with only 1.6% in the test dataset. 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
Place of PublicationSelangor, Malaysia
Pages1-7
Number of pages7
Publication statusPublished - Nov 2005
EventProc. of the 3rd International Conference on Information Technology and Multimedia (ICIMU-05) - Universiti Tenaga Nasional (UNITEN), Selangor, Malaysia
Duration: 1 Nov 2005 → …

Conference

ConferenceProc. of the 3rd International Conference on Information Technology and Multimedia (ICIMU-05)
Period1/11/05 → …

Fingerprint

Specification languages
Intelligent systems
Teaching

Cite this

Omar, N., Hanna, P., & McKevitt, P. (2005). Acquisition of entity-relationship models from natural language specifications using heuristics. In Unknown Host Publication (pp. 1-7). Selangor, Malaysia.
Omar, N ; Hanna, P ; McKevitt, P. / Acquisition of entity-relationship models from natural language specifications using heuristics. Unknown Host Publication. Selangor, Malaysia, 2005. pp. 1-7
@inproceedings{d27697c0876b44f281df8acf4e218d9b,
title = "Acquisition of entity-relationship models from natural language specifications using heuristics",
abstract = "This paper describes a heuristics-based approach in the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from natural language specifications and describes 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 90{\%} recall and 85{\%} precision. In terms of user intervention, ER-Converter requires very little human assistance with only 1.6{\%} in the test dataset. 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 P Hanna and P McKevitt",
year = "2005",
month = "11",
language = "English",
pages = "1--7",
booktitle = "Unknown Host Publication",

}

Omar, N, Hanna, P & McKevitt, P 2005, Acquisition of entity-relationship models from natural language specifications using heuristics. in Unknown Host Publication. Selangor, Malaysia, pp. 1-7, Proc. of the 3rd International Conference on Information Technology and Multimedia (ICIMU-05), 1/11/05.

Acquisition of entity-relationship models from natural language specifications using heuristics. / Omar, N; Hanna, P; McKevitt, P.

Unknown Host Publication. Selangor, Malaysia, 2005. p. 1-7.

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

TY - GEN

T1 - Acquisition of entity-relationship models from natural language specifications using heuristics

AU - Omar, N

AU - Hanna, P

AU - McKevitt, P

PY - 2005/11

Y1 - 2005/11

N2 - This paper describes a heuristics-based approach in the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from natural language specifications and describes 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 90% recall and 85% precision. In terms of user intervention, ER-Converter requires very little human assistance with only 1.6% in the test dataset. 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 - This paper describes a heuristics-based approach in the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from natural language specifications and describes 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 90% recall and 85% precision. In terms of user intervention, ER-Converter requires very little human assistance with only 1.6% in the test dataset. 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

SP - 1

EP - 7

BT - Unknown Host Publication

CY - Selangor, Malaysia

ER -

Omar N, Hanna P, McKevitt P. Acquisition of entity-relationship models from natural language specifications using heuristics. In Unknown Host Publication. Selangor, Malaysia. 2005. p. 1-7