Please use this identifier to cite or link to this item:
http://hdl.handle.net/10603/286976
Full metadata record
DC Field | Value | Language |
---|---|---|
dc.coverage.spatial | ||
dc.date.accessioned | 2020-03-31T10:09:39Z | - |
dc.date.available | 2020-03-31T10:09:39Z | - |
dc.identifier.uri | http://hdl.handle.net/10603/286976 | - |
dc.description.abstract | Performance monitoring in many internet packages and databases is a urgent requirement. It is a basic capacity to observe or write detailed information according to requirements and execution of requirements and retrieval of information or query. For Example Northwind Database system needs to fetch record of customer who orders more than one commodity. It s a way to make certain data persistency for software is to apply database according to software program or statistics. Huge amount of database required by websites and programs that need to do quite some statistics operations depend upon the overall performance and tuning to maintain efficient style of working under excessive load. One bottleneck for the application is the database handle situation of deadlock or deadlock prevention. This is defined as server-facet latency. On one hand its better we must have less response time and more efficient retrieval of optimized or tunned query. There is development effort and time that would lead you to pick out a database i.e. less complex for huge DB. RDBMS are current use for optimized the DB and popular one. So to solve performance problems we need to select which relational DB we select and why: Oracle, My-SQL and Microsoft Access. Need to find out which server performs all operations. In this artwork we will evaluate the 3 relational database Oracle, My-SQL and Microsoft Access to assess the time taken to do Selection, Projection and be a part of operation at the database and the way prolonged it takes to do such operations at the databases. To do the evaluation among the databases, different devices evolved, workings of each device are different. We use .Net framework as a laptop client and solve basic problems. The C#.NET primarily based utility implements strategies to insert and retrieve facts from the relational databases and to assess the general overall performance of the Select, Project and Join Operations in Oracle, My-SQL and Microsoft Access. newline | |
dc.format.extent | ||
dc.language | English | |
dc.relation | ||
dc.rights | university | |
dc.title | A Study of Query Optimization using Selection Projection and Join Statement in Generic RDBMS | |
dc.title.alternative | ||
dc.creator.researcher | DEEPTI CHOPRA (KHANNA) | |
dc.subject.keyword | Engineering and Technology,Computer Science,Computer Science Information Systems | |
dc.description.note | ||
dc.contributor.guide | V B Aggarwal and Meenu Dave | |
dc.publisher.place | Jaipur | |
dc.publisher.university | Jagannath University, Jaipur | |
dc.publisher.institution | Faculty of Engineering and Technology | |
dc.date.registered | 10/01/2012 | |
dc.date.completed | 2018 | |
dc.date.awarded | 28/11/2019 | |
dc.format.dimensions | ||
dc.format.accompanyingmaterial | DVD | |
dc.source.university | University | |
dc.type.degree | Ph.D. | |
Appears in Departments: | Faculty of Engineering and Technology |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
acknowledgements chap04.pdf | Attached File | 253.05 kB | Adobe PDF | View/Open |
candidate declaration chap02.pdf | 253.05 kB | Adobe PDF | View/Open | |
certificate of the supervisor chap03-converted.pdf | 90.25 kB | Adobe PDF | View/Open | |
conclusions and future scope chap13-converted.pdf | 11.92 kB | Adobe PDF | View/Open | |
introduction chap07.pdf | 557.65 kB | Adobe PDF | View/Open | |
list of papers published chap15.pdf | 113.63 kB | Adobe PDF | View/Open | |
literature reviewchap08.pdf | 246.87 kB | Adobe PDF | View/Open | |
preface chap05.pdf | 107.04 kB | Adobe PDF | View/Open | |
problem formulation chap09.pdf | 158.11 kB | Adobe PDF | View/Open | |
query processing and optimizationchap11.pdf | 718.58 kB | Adobe PDF | View/Open | |
relational algebra and structured query language chap10.pdf | 634.46 kB | Adobe PDF | View/Open | |
results and analysis.pdf | 709.52 kB | Adobe PDF | View/Open | |
table of contents chap06.pdf | 392.14 kB | Adobe PDF | View/Open | |
title chap01.pdf | 193.56 kB | Adobe PDF | View/Open |
Items in Shodhganga are licensed under Creative Commons Licence Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0).
Altmetric Badge: