An Efficient Algorithm for Database Query Optimization in Crowdsourcing System
Abstract & Details
Research Area
Computer Engineering
Keywords
Crowdsourcing
query optimization
select query
join query
complex queries
order by query
Abstract
Query optimization is important to crowdsourcing system as it provides declarative query interface in relational database management system. In the proposed approach, a technique called crowd optimization in which the user has to submit an SQL query and the system compiles the query, generating the execution plan and evaluating that query giving an optimized plan to the user. In relational database systems, query optimization is providing query interfaces, which are important for crowdsourcing. The system considers cost and latency in query optimization and generates query plans that give a good balance between the cost and latency. Efficient algorithms for optimizing four types of queries are used i.e. selection queries, join queries, complex queries and order-by queries.
License
This work is licensed under a Creative
Commons
Attribution-ShareAlike 4.0 International License.
Author Information
| # | Name | Institute / Affiliation |
|---|---|---|
| 1 | Miss. Pariyarath Jesnaraj | MET's IOE |
| 2 | Dr. K. V. Metre | MET'S IOE |
How to Cite
Use the following formats to cite this article in your research.
APA Style
Jesnaraj, Miss. Pariyarath & Metre, Dr. K. V. (2017). An Efficient Algorithm for Database Query Optimization in Crowdsourcing System. International Journal of Advance Research and Innovative Ideas In Education, 3(4), 808-817.
MLA Style
Jesnaraj, Miss. Pariyarath, and Dr. K. V. Metre. "An Efficient Algorithm for Database Query Optimization in Crowdsourcing System." International Journal of Advance Research and Innovative Ideas In Education, vol. 3, no. 4, 2017, pp. 808-817.
IEEE Style
Miss. Pariyarath Jesnaraj and Dr. K. V. Metre, "An Efficient Algorithm for Database Query Optimization in Crowdsourcing System," International Journal of Advance Research and Innovative Ideas In Education, vol. 3, no. 4, pp. 808-817, 2017.
Vancouver Style
Jesnaraj Miss. Pariyarath, Metre Dr. K. V.. An Efficient Algorithm for Database Query Optimization in Crowdsourcing System. International Journal of Advance Research and Innovative Ideas In Education. 2017;3(4):808-817.
Harvard Style
Jesnaraj, Miss. Pariyarath & Metre, Dr. K. V. (2017) 'An Efficient Algorithm for Database Query Optimization in Crowdsourcing System', International Journal of Advance Research and Innovative Ideas In Education, 3(4), pp. 808-817.
Chicago Style
Jesnaraj, Miss. Pariyarath and Dr. K. V. Metre. "An Efficient Algorithm for Database Query Optimization in Crowdsourcing System." International Journal of Advance Research and Innovative Ideas In Education 3, no. 4 (2017): 808-817.
Turabian Style
Jesnaraj, Miss. Pariyarath and Dr. K. V. Metre. "An Efficient Algorithm for Database Query Optimization in Crowdsourcing System." International Journal of Advance Research and Innovative Ideas In Education 3, no. 4 (2017): 808-817.
Related Research
Comprehensive Review of Existing Chatbot Systems for Career Assistance, Resume Support, and ATS-Aware Guidance
PDF Unavailable
Development of an AI-Powered Multimodal Web Assistant with Intelligent Resume Building and ATS Enhancement
PDF Unavailable
A Deep Learning-Based Framework for Mood-Oriented Music Recommendation Using Facial Expression Analysis
PDF Unavailable
Survey On : Intelligent Payroll and Human Resource Management Systems: A Systematic Review of Automation, Security, and Analytics
PDF Unavailable
Civic Engagement & Empowerment Platform
PDF Unavailable
Recent Developments in Microneedle Technology and Its Diverse Biomedical Applications
PDF Unavailable
RAG System Development with Pydantic AI ChromaDB & Groq
PDF Unavailable
Machine Learning Based Early Stage Diabetes Detection System
PDF Unavailable
A Survey on Skillsense:AI Career Analyzer App
PDF Unavailable
Employee Performance Portal
PDF Unavailable