Performance Issues and Query Optimization in Big Multidimensional Data
SQL queries for big-data and multidimensional data need to be carefully coded to get maximum benefit of optimization and to improve the performance of the system and the applications involved.This is especially true for online applications where there is a race against time in populating the results set.Valuable time and cost can be saved by optimizing query statements during their design process especially when they are required to perform complex process involving relationships with the other tables.The relationships with the tables vary from complex joins to sorting order which has direct impact on system performance.Transactions SQL (TSQL),stored procedures,triggers etc.can be efficiently coded to optimize a query.Queries involved in 3D databases depend on user interaction have a human element added in the optimization process.This paper addresses few of the issues using a number of potential applications.
SQL Query Optimization Query Performance Optimization Optimization issues for multidimensional & BIGData
Jay Kiruthika Souheil Khaddaj
Kingston University
国际会议
湖北咸宁
英文
24-28
2014-11-24（万方平台首次上网日期，不代表论文的发表时间）