Open Access Open Access  Restricted Access Subscription or Fee Access

From Description to Class and ER Diagram to Database Table Generation

Pradnya D. Bormane, Girish P. Potdar

Abstract


Natural language provides a way of communication between user and programmer or developer. Software development based on Object Oriented Modeling (OOM) encourages the use of Unified Modeling Language (UML). The Object Oriented Modeling (OOM) heavily depends on the Unified Modeling Language (UML) constructs and syntax. This requires someone to convert the user specified requirements into identified blocks of Unified Modeling Language (UML) by interpreting manually.

The key idea is to overcome the manual interpretation of converting user specified requirements into identified blocks of Unified Modeling Language (UML) to generation of database tables, we propose an automated system where user requirements are specified in natural language (NL). These requirements are further processed using paragraph chunker and classify the requirements into noun, verb and adjectives to classes, attributes, functions.

Girish P. Potdar

Keywords


Conceptual Data Modeling, Natural Language Processing, Information Extraction, Unified Modeling Language.

Full Text:

PDF

References


Priyanka More, Rashmi Phalnikar,” Generating UML Diagrams from Natural Language Specifications,” International Journal of Applied Information Systems (IJAIS), Foundation of Computer Science FCS, New York, USA, Vol 1, No.8, April 2012.

Hina Afreen, Imran Sarwar Bajwa, Behzad Bordbar,”SBVR2UML: A Challenging Transformation,” FIT 2011.

Mohd Ibrahim, Rodina Ahmad,” Class diagram extraction from textual requirements using Natural language processing (NLP) techniques,” Proceedings of Second International Conference on Computer research and Development, pp.200-204, IEEE 2010.B. Smith, “An approach to graphs of linear forms (Unpublished work style),” unpublished.

Khalid Daghameen, Nabil Arman,”Requirements Based Static Class Diagram Constructor (Scdc) Case Tool,” Journal of Theoretical and Applied Information Technology, Islamabad Pakistan, pp. 108-114, May 2010.

Deva Kumar Deeptimahanti, Muhammad Ali Babar,”Automated tool for generating UML models from Natural Language Requirements,” International Conference on Automated Software Engineering, pp.680-682, IEEE 2009.

Xiaohua Zhou, Nan Zhou,” Auto-generation of Class Diagram from Free-text Functional Specifications and Domain Ontology,” 2004.

Subhash Shinde, Varunakshi Bhojane, Pranita Mahajan,” NLP based Object Oriented Analysis and Design from Requirement Specification,” International Journal of Computer Applications, 0975-8887, Vol 47-No.21, June 2012.

Prof. Dr.S.D.Joshi, Dhanraj Deshpande,” Textual Requirement Analysis for UML Diagram Extraction,” International Journal of Computer Technology and Electronics Engineering (IJCTEE) Vol 2, Issue 3, June 2012.

Poonam R. Kothari, Prof. G.P.Potdar,” Extracting Class Diagram from Natural Language requirement (ECd-NL),” Coimbatore Institute of Information technology, July 2012.

Christian Kop, Heinrich Mayr,”From Natural language requirements to a conceptual model.

Farid Meziane and Sunil Vadera,” Obtaining E-R Diagrams Semi Automatically From Natural Language Specifications,”Iceis 2004 - Databases And Information Systems Integration.

N. Omar, P. Hanna and P. Mc Kevitt,” Semantic Analysis in the Automation of ER Modelling through Natural Language Processing,” ICOCI 2006.

Vahid Rafe, Shahram Jamali, Mohsen Rahmani, Farzaneh Mahdian, “From Class Diagrams to Relational Tables: A Graph Transformation-based Approach,” Przegląd Ektrotechniczny (Electrical Review), ISSN 0033-2097, 2011.

Ke Li, R.G.Dewar, R.J.Pooley, “Requirements capture in natural language problem Statements,” 2003.

Dr. Muhammad Shahbaz, Dr. Syed Ahsan, Muhammad Shaheen, Rao Muhammad Adeel Nawab, Syed Athar Masood, “Automatic Generation of Extended ER Diagram Using Natural Language Processing,” Journal of American Science, 2011.


Refbacks

  • There are currently no refbacks.