Implementing a Database from a Requirement Specification

David Wilson, Muss Omer

Research output: Contribution to journalArticle

Abstract

Creating a database scheme is essentially a manual process. From a requirement specification the information contained within has to be analyzed and reduced into a set of tables, attributes and relationships. This is a time consuming process that has to go through several stages before an acceptable database schema is achieved. The purpose of this paper is to implement a Natural Language Processing (NLP) based tool to produce a relational database from a requirement specification. The Stanford CoreNLP version 3.3.1 and the Java programming were used to implement the proposed model. The outcome of this study indicates that a first draft of a relational database schema can be extracted from a requirement specification by using NLP tools and techniques with minimum user intervention. Therefore this method is a step forward in finding a solution that requires little or no user intervention.
LanguageEnglish
Pages33-41
Number of pages9
JournalInternational Journal of Computer, Electrical, Automation, Control and Information Engineering
Volume9
Issue number1
Publication statusPublished - 2015

Fingerprint

Specifications
Processing

Cite this

@article{c184dd9bb1b84d4ca17521583f4663f9,
title = "Implementing a Database from a Requirement Specification",
abstract = "Creating a database scheme is essentially a manual process. From a requirement specification the information contained within has to be analyzed and reduced into a set of tables, attributes and relationships. This is a time consuming process that has to go through several stages before an acceptable database schema is achieved. The purpose of this paper is to implement a Natural Language Processing (NLP) based tool to produce a relational database from a requirement specification. The Stanford CoreNLP version 3.3.1 and the Java programming were used to implement the proposed model. The outcome of this study indicates that a first draft of a relational database schema can be extracted from a requirement specification by using NLP tools and techniques with minimum user intervention. Therefore this method is a step forward in finding a solution that requires little or no user intervention.",
keywords = "information extraction, Natural language processing (NLP), relation extraction",
author = "David Wilson and Muss Omer",
year = "2015",
language = "English",
volume = "9",
pages = "33--41",
journal = "International Journal of Computer, Electrical, Automation, Control and Information Engineering",
number = "1",

}

TY - JOUR

T1 - Implementing a Database from a Requirement Specification

AU - Wilson, David

AU - Omer, Muss

PY - 2015

Y1 - 2015

N2 - Creating a database scheme is essentially a manual process. From a requirement specification the information contained within has to be analyzed and reduced into a set of tables, attributes and relationships. This is a time consuming process that has to go through several stages before an acceptable database schema is achieved. The purpose of this paper is to implement a Natural Language Processing (NLP) based tool to produce a relational database from a requirement specification. The Stanford CoreNLP version 3.3.1 and the Java programming were used to implement the proposed model. The outcome of this study indicates that a first draft of a relational database schema can be extracted from a requirement specification by using NLP tools and techniques with minimum user intervention. Therefore this method is a step forward in finding a solution that requires little or no user intervention.

AB - Creating a database scheme is essentially a manual process. From a requirement specification the information contained within has to be analyzed and reduced into a set of tables, attributes and relationships. This is a time consuming process that has to go through several stages before an acceptable database schema is achieved. The purpose of this paper is to implement a Natural Language Processing (NLP) based tool to produce a relational database from a requirement specification. The Stanford CoreNLP version 3.3.1 and the Java programming were used to implement the proposed model. The outcome of this study indicates that a first draft of a relational database schema can be extracted from a requirement specification by using NLP tools and techniques with minimum user intervention. Therefore this method is a step forward in finding a solution that requires little or no user intervention.

KW - information extraction

KW - Natural language processing (NLP)

KW - relation extraction

M3 - Article

VL - 9

SP - 33

EP - 41

JO - International Journal of Computer, Electrical, Automation, Control and Information Engineering

T2 - International Journal of Computer, Electrical, Automation, Control and Information Engineering

JF - International Journal of Computer, Electrical, Automation, Control and Information Engineering

IS - 1

ER -