SQL Query optimalization

被引：0
|
作者：
Cerna, Eva [1 ]
Herold, Petr [1 ]
Tyrychtr, Jan [1 ]
机构：
[1] Ceska Zemedelska Univ Praze, PEF, Katedra Informacnich Technol, Kamycka 129, Prague 16521 6, Czech Republic
来源：
AGRARIAN PERSPECTIVES XVIII, VOL 3 | 2009年
关键词：
SQL optimization; SQL query; database; time complexity; code; design; longer response from application;
D O I：
暂无
中图分类号：
F3 [农业经济];
学科分类号：
0202 ; 020205 ; 1203 ;
摘要：
The paper deals with: slow speed of application, removal of unsuitable parts of base code scripts and wrong designed queries. To solve the speed of application is difficult for programmers. Most of programmers have not relevant information to solve the problem. This research paper provides information on possibilities of design patterns of queries, theirs optimization and interaction with databases.
引用
收藏
页码：71 / 74
页数：4
相关论文
共 50 条
  • [1] SQL Query optimalization
    Cerna, Eva
    Herold, Petr
    Tyrychtr, Jan
    [J]. AGRARIAN PERSPECTIVES XVIII, VOLS 1 AND 2, 2009,
  • [2] (ANACON: SQL QUERY ANALYZER)
    Garrido, Piedad
    Martinez, Francisco
    Tramullas, Jesus
    Fuertes, Gabriel
    [J]. RIED-REVISTA IBEROAMERICANA DE EDUCACION A DISTANCIA, 2007, 10 (01): : 201 - 215
  • [3] Using Ontologies for SQL Query Reformulation
    Ines, Fayech
    Habib, Ounalli
    [J]. 2015 WORLD CONGRESS ON INFORMATION TECHNOLOGY AND COMPUTER APPLICATIONS (WCITCA), 2015,
  • [4] Query translation from XSLT to SQL
    Liu, JX
    Vincent, M
    [J]. SEVENTH INTERNATIONAL DATABASE ENGINEERING AND APPLICATIONS SYMPOSIUM, PROCEEDINGS, 2003, : 87 - 96
  • [5] Query Translation from SQL to XPath
    Vidhya, P. M.
    Samuel, Philip
    [J]. 2009 WORLD CONGRESS ON NATURE & BIOLOGICALLY INSPIRED COMPUTING (NABIC 2009), 2009, : 1748 - +
  • [6] Cleaning Antipatterns in an SQL Query Log
    Arzamasova, Natalia
    Schaeler, Martin
    Boehm, Klemens
    [J]. 2018 IEEE 34TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2018, : 1751 - 1752
  • [7] SPATIAL SQL - A QUERY AND PRESENTATION LANGUAGE
    EGENHOFER, MJ
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1994, 6 (01) : 86 - 95
  • [8] Containerized SQL Query Evaluation in a Cloud
    Zhang, Weining
    Holland, David
    [J]. 2015 IEEE INTERNATIONAL CONFERENCE ON SMART CITY/SOCIALCOM/SUSTAINCOM (SMARTCITY), 2015, : 1010 - 1017
  • [9] Query Processing: Beyond SQL and Relations
    Novikov, Boris
    [J]. ADVANCES IN DATABASES AND INFORMATION SYSTEMS, ADBIS 2015, 2015, 9282
  • [10] A Novel Approach for SQL Query Optimization
    Mithani, Fazal
    Machchhar, Sahista
    Jasdanwala, Fernaz
    [J]. 2016 IEEE INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND COMPUTING RESEARCH, 2016, : 898 - 901
12345