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

Authors

  • Anshu Kumar Dwivedi IEC College of Engineering, Greater Noida, UP
  • Ashok Kumar Sharma YMCA University of science and technology Faridabad, Haryana

Keywords:

RDBMS, Keyword Serach, Efficiency, Effectiveness

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.

References

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.

C.D Manning, P.Raghavan, H.Sch"tze. Introduction to information retrieval. ISBN 978-0-521-86571-5. Cambridge university press, Newyork, 2011.

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.

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.

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.

Margaret Dunham, "Data Mining Introductory and Advanced Topics,"Prentice Hall, 2003.

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.

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.

Downloads

Published

2014-08-30

How to Cite

[1]
A. K. Dwivedi and A. K. Sharma, “A Framework For Processing Keyword-Based Queries In Relational Databases For Exact Record”, Int. J. Comp. Sci. Eng., vol. 2, no. 8, pp. 127–130, Aug. 2014.

Issue

Vol. 2 No. 8 (2014): IJCSE August Edition

Section

Research Article

License

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors contributing to this journal agree to publish their articles under the Creative Commons Attribution 4.0 International License, allowing third parties to share their work (copy, distribute, transmit) and to adapt it, under the condition that the authors are given credit and that in the event of reuse or distribution, the terms of this license are made clear.