Open Access   Article Go Back

A Framework For Processing Keyword-Based Queries In Relational Databases For Exact Record

A.K. Dwivedi1 , A.K. Sharma2

Section:Research Paper, Product Type: Journal Paper
Volume-2 , Issue-8 , Page no. 127-130, Aug-2014

Online published on Aug 31, 2014

Copyright © A.K. Dwivedi, A.K. Sharma . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

XML View
PDF Download

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: A.K. Dwivedi, A.K. Sharma, “A Framework For Processing Keyword-Based Queries In Relational Databases For Exact Record,” International Journal of Computer Sciences and Engineering, Vol.2, Issue.8, pp.127-130, 2014.

MLA Style Citation: A.K. Dwivedi, A.K. Sharma "A Framework For Processing Keyword-Based Queries In Relational Databases For Exact Record." International Journal of Computer Sciences and Engineering 2.8 (2014): 127-130.

APA Style Citation: A.K. Dwivedi, A.K. Sharma, (2014). A Framework For Processing Keyword-Based Queries In Relational Databases For Exact Record. International Journal of Computer Sciences and Engineering, 2(8), 127-130.

BibTex Style Citation:
@article{Dwivedi_2014,
author = {A.K. Dwivedi, A.K. Sharma},
title = {A Framework For Processing Keyword-Based Queries In Relational Databases For Exact Record},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {8 2014},
volume = {2},
Issue = {8},
month = {8},
year = {2014},
issn = {2347-2693},
pages = {127-130},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=242},
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=242
TI - A Framework For Processing Keyword-Based Queries In Relational Databases For Exact Record
T2 - International Journal of Computer Sciences and Engineering
AU - A.K. Dwivedi, A.K. Sharma
PY - 2014
DA - 2014/08/31
PB - IJCSE, Indore, INDIA
SP - 127-130
IS - 8
VL - 2
SN - 2347-2693
ER -

VIEWS PDF XML
3398 3356 downloads 3492 downloads
  
  
           

Abstract

Database management system a very strong concept used that is relational database management system. A relational database is often operated by means of a structured query language (SQL). When composing SQL-queries one must have an understanding of the SQL syntax to be able to produce a query the database can execute. Additionally, one must be familiar with the attributes and relations in the database to be able to retrieve the data desired. When one wants to search the available data stored in the relational database, these requirements can be discouraging. In this case keyword-based search functionality could improve the accessibility of the data. The main advantage of RDBMS is its fast accurate, standard way to store data on permanent basis extraction of data is done using SQL its secure (different level of security) data can be managed in proper manner. ACID properties are features if RDBMS stands for Accuracy Consistency Isolation Durability.

Key-Words / Index Term

RDBMS, Keyword Serach, Efficiency, Effectiveness

References

[1] B. Aditya, G. Bhalotia, S. Chakrabarti, A. Hulgeri, C. Nakhe, P. Parag, S.Sudarshan. BANKS: browsing and keyword searching in relational databases. In Proceedings of the 28th international conference on Very Large Databases, 2011.
[2] C.D Manning, P.Raghavan, H.Sch�tze. Introduction to information retrieval. ISBN 978-0-521-86571-5. Cambridge university press, Newyork, 2011.
[3] B.B. Dalvi, M. Kshirsagar, S. Sudarshan. Keyword search on external memory graphs. In Proceedings of the VLDB Endowment, Vol 1 visited on July 3th, 2010.
[4] V. Hristidis, Y Papakonstantinou. Discover: keyword search in relational databases. In Proceedings of the 28th international conference on Very Large Databases, 2002. visited on May 15th, 2009.
[5] Gaurav Bhalotia, Charuta Nakhe, Arvind Hulgeri, Soumen Chakrabarti, and Sudarshan, "Keyword Searching and Browsing in Databases UsingBANKS," In Proceedings of International Conference on Data Engineering (ICDE), pp. 431�440, 2012.
[6] Margaret Dunham, �Data Mining Introductory and Advanced Topics,�Prentice Hall, 2003.
[7] Ophir Frieder, David Grossman, Abdur Chowdhury and Gideon Frieder,�Efficiency Considerations for Scalable Information Retrieval Servers,� Journal of Digital Information (JDI), Vol. 1, No.5, 2000.
[8] Sanjay Agrawal, Surajit Chaudhuri, and Gautam Das, "DBXplorer: A system for Keyword-Based Search Over Relational Databases," In Proceedings of International Conference on Data Engineering (ICDE), pp. 5�16.