DBQA: A Comprehensive Query Performance Analyzer with Django Framework

被引：0
|
作者：
Simon, Judy [1 ]
Kapileswar, N. [1 ]
Datchinamoorthi, M. [1 ]
Devi, Keerthana G. [1 ]
Muthukumar, S. [1 ]
机构：
[1] SRM Inst Sci & Technol, Dept Elect & Commun Engn, Chennai, India
来源：
2024 INTERNATIONAL CONFERENCE ON ADVANCES IN COMPUTING, COMMUNICATION AND APPLIED INFORMATICS, ACCAI 2024 | 2024年
关键词：
Database Management Systems; SQL Query; Query optimization; MySQL; MS SQL Server; time;
D O I：
10.1109/ACCAI61061.2024.10611734
中图分类号：
TP [自动化技术、计算机技术];
学科分类号：
0812 ;
摘要：
In the ever-evolving landscape of computing, numerous methods exist for storing and retrieving databases. Commercial Database Management Systems (DBMSs) offer varied options, with performance standing out as a critical factor in their selection. This project is specifically geared towards optimizing the processing of queries and data in large-scale analytics using Python. Leveraging the Django framework, users input queries, stored in an SQLite database, to delve into processing times. Experimental results highlight the system's efficiency and enhanced performance across a spectrum of queries, fostering more effective decision-making.
引用
收藏
页数：6
相关论文
共 50 条
  • [1] Enhancing of Data Retrieval by Means of Database Query Analyzer (DBQA)
    Misal, S. B.
    Gaikwad, Ashok T.
    INFORMATION AND COMMUNICATION TECHNOLOGY FOR INTELLIGENT SYSTEMS, ICTIS 2018, VOL 2, 2019, 107 : 95 - 103
  • [2] DBQA: Multi-Environment Analyzer for Query Execution Time and Cost
    Misal, S. B.
    Yannawar, P. L.
    Gaikwad, A. T.
    2017 INTERNATIONAL CONFERENCE ON CURRENT TRENDS IN COMPUTER, ELECTRICAL, ELECTRONICS AND COMMUNICATION (CTCEEC), 2017, : 1050 - 1055
  • [3] Database Query Analyzer (DBQA) - A Data-Oriented SQL Clause Visualization Tool
    Hardt, Ryan
    Gutzmer, Esther
    PROCEEDINGS OF THE 18TH ANNUAL CONFERENCE ON INFORMATION TECHNOLOGY EDUCATION (SIGITE'17), 2017, : 147 - 152
  • [4] Continuous Assessment Analyzer Using Django
    Shriyans
    Dhoundiyal, Swati
    Rakesh, Nitin
    Tyagi, Neha
    Nand, Parma
    Kaur, Mandeep
    Lecture Notes in Electrical Engineering, 2022, 834 : 35 - 43
  • [5] A Comprehensive Framework for Controlled Query Evaluation, Consistent Query Answering and KB Updates in Description Logics
    Lembo, Domenico
    Rosati, Riccardo
    Savo, Domenico Fabio
    SIXTEENTH INTERNATIONAL CONFERENCE ON PRINCIPLES OF KNOWLEDGE REPRESENTATION AND REASONING, 2018, : 653 - 654
  • [6] (ANACON: SQL QUERY ANALYZER)
    Garrido, Piedad
    Martinez, Francisco
    Tramullas, Jesus
    Fuertes, Gabriel
    RIED-REVISTA IBEROAMERICANA DE EDUCACION A DISTANCIA, 2007, 10 (01): : 201 - 215
  • [7] VQA: Vertica Query Analyzer
    Simitsis, Alkis
    Wilkinson, Kevin
    Blais, Jason
    Walsh, Joe
    SIGMOD'14: PROCEEDINGS OF THE 2014 ACM SIGMOD INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2014, : 701 - 704
  • [8] Design on English Grammar Comprehensive Query System based on SSH Framework
    Feng, Haiyan
    PROCEEDINGS OF THE 2017 2ND INTERNATIONAL CONFERENCE ON AUTOMATION, MECHANICAL CONTROL AND COMPUTATIONAL ENGINEERING (AMCCE 2017), 2017, 118 : 1016 - 1020
  • [9] Semantic Protocol and Resource Description Framework Query Language: A Comprehensive Review
    Houssein, Essam H.
    Ibrahem, Nahed
    Zaki, Alaa M.
    Sayed, Awny
    MATHEMATICS, 2022, 10 (17)
  • [10] Information publishing system based on the framework of Django
    Li, Shenliang
    Si, Zhanjun
    Lecture Notes in Electrical Engineering, 2017, 417 : 375 - 381
12345