Ameliorated Methodology For Retrieval Of Data Using Query By Example

Ameliorated Methodology For Retrieval Of Data Using Query By Example

  IJCTT-book-cover
 		 International Journal of Computer Trends and Technology (IJCTT)          
 
© 2019 by IJCTT Journal
Volume-67 Issue-5
Year of Publication : 2019
Authors : Dr. R. N. Kulkarni, Ms.Chinmayi A, Ms.Meghana A, Ms.Sai Harika K,Ms.Saraswathi Y
DOI :  10.14445/22312803/IJCTT-V67I5P126

MLA

MLA Style:Dr. R. N. Kulkarni, Ms.Chinmayi A, Ms.Meghana A, Ms.Sai Harika K,Ms.Saraswathi Y"Ameliorated Methodology For Retrieval Of Data Using Query By Example" International Journal of Computer Trends and Technology 67.5 (2019):151-154.

APA Style: Dr. R. N. Kulkarni, Ms.Chinmayi A, Ms.Meghana A, Ms.Sai Harika K,Ms.Saraswathi Y (2019) Ameliorated Methodology For Retrieval Of Data Using Query By Example International Journal of Computer Trends and Technology, 67(5), 151-154.

Abstract
Query By Example (QBE) is a database query language for relational databases. The Query By Example uses visual tables where the user enters the commands and the output is displayed in a table form. In this paper, we are proposing an automated tool where the user gives the input in the form of natural language statement (query). The tool processes the input query and retrieves the relevant matching field(s) or record(s) from the input database. The proposed tool comprises a parser where it translates the natural language statement into the tokens and retrieves the appropriate data from the database and displays the output in the form of a table. The tool takes the input from the user in the form of a natural language statement which comprises regular expression. In the proposed tool only the retrieval of data from the database is proposed which works with the print (P) command.

Reference
[1] Ahmet Soylu, Martin Giese, Ernesto Jimenez-Ruiz, Guillermo Vega-Gorgojo, Ian Horrocks, “A Multi-paradigm and Ontology-based Visual Query System for End Users”, in Universal Access in the Information Society, 2015.
[2] Ted Neward, The busy java developers guide to db4o: “QBE”, IBM, March 27, 2007.
[3] Margaret Rouse, “Oracle Definations: Query By Example”, Sept. 2005.
[4] Ramakrishnan, Raghu, Gehrke, Johannes, “ Database Management Systems, chap 6: QBE”, 3rd ed.
[5] Z.M. Ozsoyoglu ,G. Ozsoyoglu,"Summary-Table-By-Example: A database query language for manipulating summary data", IEEE First International Conference on Data Engineering, 24-27 April 1984.
[6] M. M. Zloof,"Query-by-Example: A data base language", IBM Systems Journal, Vol. 16 , No. 4, pp. 324 – 343, 1977.
[7] VipinBalachandran,"Query by example in large-scale code repositories", IEEE International Conference on Software Maintenance and Evolution (ICSME), 29 Sept-1 Oct 2015.
[8] Shamkant B.Navathe, Ramez Elmasri, “Fundamentals of Database Systems”, 7th ed., Pearson publication, 2016.
[9] Query By Example –Wikipedia.
[10] Ian Sommerville, “Software Engineering”, 9th ed., Pearson publication,2011.

Keywords
Query By Example, Tokens, Parser, query, database.