QUERY OPTIMIZATION IN MICROSOFT SQL SERVER

被引：0
|
作者：
Haxhijaha, Blerta [1 ]
Ajdari, Jaumin [1 ]
Raufi, Bujar [1 ]
Zenuni, Xhemal [1 ]
Ismaili, Florie [1 ]
机构：
[1] South East European Univ, Fac Comp Sci & Engn, Tetovo, Macedonia
来源：
INTERNATIONAL JOURNAL ON INFORMATION TECHNOLOGIES AND SECURITY | 2018年 / 10卷 / 02期
关键词：
Query; Optimization; SQL Server; Performance; Banking;
D O I：
暂无
中图分类号：
TP [自动化技术、计算机技术];
学科分类号：
0812 ;
摘要：
The banking software solutions depend heavily on databases, not only for storing data but also for everyday operations, which require processing of that data. Database inserts, updates, deletes; as well as calculation and retrieval operations are integral parts, and optimizing their execution is essential for an efficient business operation. This paper examines several techniques for improving database query performance, by looking at some common operations and examining ways to enhance their execution. MS SQL Server is used as an experimental approach to examine the proposed techniques.
引用
收藏
页码：13 / 22
页数：10
相关论文
共 50 条
  • [1] Distributed/heterogeneous query processing in microsoft SQL server
    Blakeley, JA
    Cunningham, C
    Ellis, N
    Rathakrishnan, B
    Wu, MC
    ICDE 2005: 21ST INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2005, : 1001 - 1012
  • [2] Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics
    Lee, Kukjin
    Konig, Arnd Christian
    Narasayya, Vivek
    Ding, Bolin
    Chaudhuri, Surajit
    Ellwein, Brent
    Eksarevskiy, Alexey
    Kohli, Manbeen
    Wyant, Jacob
    Prakash, Praneeta
    Nehme, Rimma
    Li, Jiexing
    Naughton, Jeff
    SIGMOD'16: PROCEEDINGS OF THE 2016 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2016, : 1753 - 1764
  • [3] Query-by-Example Image Retrieval in Microsoft SQL Server
    Staszewski, Pawel
    Woldan, Piotr
    Korytkowski, Marcin
    Scherer, Rafal
    Wang, Lipo
    ARTIFICIAL INTELLIGENCE AND SOFT COMPUTING, (ICAISC 2016), PT II, 2016, 9693 : 746 - 754
  • [4] Geospatial Stream Query Processing using Microsoft SQL Server StreamInsight
    Kazemitabar, Seyed Jalal
    Demiryurek, Ugur
    Ali, Mohamed H.
    Akdogan, Afsin
    Shahabi, Cyrus
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2010, 3 (02): : 1537 - 1540
  • [5] Microsoft SQL Server短讯
    软件和集成电路, 1994, (11) : 46 - 48
  • [6] Declarative Management in Microsoft SQL Server
    Guo, Hongfei
    Jones, Dan
    Beckmann, Jennifer
    Seshadri, Praveen
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2009, 2 (02): : 1294 - 1305
  • [7] Study on the security of Microsoft SQL Server
    Hou, Yijun
    Wang, Ruchuan
    Nanjing Youdian Xueyuan Xuebao/Journal of Nanjing Institute of Posts and Telecommunications, 2000, 20 (03): : 81 - 84
  • [8] Microsoft SQL Server interface for mobile devices
    Arikan, Emin
    Jenq, John
    INT CONF ON CYBERNETICS AND INFORMATION TECHNOLOGIES, SYSTEMS AND APPLICATIONS/INT CONF ON COMPUTING, COMMUNICATIONS AND CONTROL TECHNOLOGIES, VOL II, 2007, : 132 - 137
  • [9] Microsoft releases SQL server for windows CE
    不详
    CONTROL SOLUTIONS, 2000, 73 (11): : 16 - 16
  • [10] Adapting Microsoft SQL Server for Cloud Computing
    Bernstein, Philip A.
    Cseri, Istvan
    Dani, Nishant
    Ellis, Nigel
    Kalhan, Ajay
    Kakivaya, Gopal
    Lomet, David B.
    Manne, Ramesh
    Novik, Lev
    Talius, Tomas
    IEEE 27TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2011), 2011, : 1255 - 1263
12345