CrowdOp: College Finder Web Application using Query Optimization

Computer Engineering

In Academic Education system while applying for Bachelor of Engineering Education, students lack knowledge of colleges that they are eligible for, according to their JEE marks. Many times students filled incorrect option form with blind approximation and missed chance to get best eligible college that they deserve. This web based application will predict more accurate colleges according to students score, rank, category and cut-off marks of last year admission process. Using query optimization technique system will provide results in very less time, and with more efficiency. Crowdsourcing is a sourcing model in which individuals or organizations use contributions from Internet users to obtain needed services or ideas. Crowd - sourcing enables user not having SQL knowledge to get desired result by _ring query in his terms and his expected conditions. The system provides the capability to optimize and provide a near optimal query execution plan for each query. CROWDOP is a query optimization technique that selects the optimal query plan among several plans for execution of a query considering both cost and latency. CROWDOP is capable of finding the query plan with low latency given a user- defined budget which nicely balances the cost and time requirement of users. A cost-based query optimization, a cheapest execution plan is created for each SQL condition (cost is with respect to predefined function). These plans use least amount of resources to get desired output. Supporting multiple crowdsourcing operators gives a cost based optimization for all operators involved in the query and derives best query plan for execution.

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