The week's pick
Random Articles
Reseach Article
Elicitation of Relation Schema with Primary Key Attribute from Natural Language Text
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 71 - Number 18 |
| Year of Publication: 2013 |
| Authors: S. Geetha, G. S. Anandha Mala |
10.5120/12586-9299
|
S. Geetha, G. S. Anandha Mala . Elicitation of Relation Schema with Primary Key Attribute from Natural Language Text. International Journal of Computer Applications. 71, 18 ( June 2013), 21-24. DOI=10.5120/12586-9299
Abstract
In natural language, a word or phrase represents the concept. This paper presents an idea of extracting the key attributes of the object. The construction of the logical structure of a relation emerges from the unstructured text. It overcomes the limitation of extracting the structured information. This approach is based on extracting the key information from the scattered unstructured text. This process starts with splitting the sentence, tagging the individual words in the input document by using Parts of Speech (PoS). PoS categorize the input data into Object Oriented Elements (OOE) which includes entities, attributes, actions and builds the relations among these entities and actions. The proposed approach identifies the structure of the relation which is extracted from the Software Requirement Specification (SRS) to the user and constructs a schema of the relation by identifying primary key attributes based on adjectives and by applying mapping rules.
References
- E. Agichtein and L. Gravano. 2000. "Snowball : Extracting relations from large plain-text collections". In Proc. of the 5th ACM International Conference on Digital Libraries, ACM Digital Library.
- I. Mansuri and S. Sarawagi. 2006. "A system for integrating unstructured data into relational databases". In Proc. of the 22nd IEEE International Conference on Data Engineering (ICDE).
- Mirzanur Rahman, Sufal Das and Utpal Sharma. 2009. "Parsing of part-of-speech tagged Assamese Texts", IJCSI International Journal of Computer Science Issues, Vol. 6, No. 1.
- O. Etzioni, M. Cafarella, D. Downey, S. Kok, A. Popescu, T. Shaked, S. Soderland, D. Weld and A. Yates. 2004. "Web-Scale Information Extraction in KnowItAll". In Proc. of the 13th International Conference on WWW, ACM Digital Library, pages 100–110.
- S. Brin. 1998. " Extracting Patterns and Relations from the World Wide Web". In WebDB Workshop at 6th International Conference on Extending Database Technology, pages 172–183.
- Michael J. Cafarella,Dan Suciu, Oren Etzioni. 2007.
- " Navigating Extracted Data with Schema Discovery". In Proc. of the 10th International Workshop on Web and Databases.
- Luis Tari, Phan Huy Tu, Jorg Hakenberg, Yi Chen, Tran Cao Son, Graciela Gonzalez and Chitta Baral. 2012. "Incremental Information Extraction Using Relational Databases", IEEE Transactions on Data & Knowledge Engineering, pages 86-99, Vol. 24, No. 1.
- G. S. Anandha Mala, J. Jayaradika and G. V. Uma. 2005. "Restructuring Natural Language Text to Elicit Software Requirements". In proc. of the International Conference on Cognition and Recognition.
- Lee, S. E. , & Han, S. S. K. 2011. "Qtag : Introducing the qualitative tagging system. In Proc. of the 18th conference on Hypertext and hypermedia", pages 35–36. ACM Retrieved.
- A. Doan, J. F. Naughton, R. Ramakrishnan, A. Baid, X. Chai, F. Chen, T. Chen, E. Chu, P. DeRose, B. Gao, C. Gokhale, J. Huang,W. Shen, and B. Q. Vuong. 2008. "Information extraction challenges in managing unstructured data", SIGMOD Rec. , pages 14 – 20,Vol. 37, No. 4.
Index Terms
Keywords