conference paper · International Joint Conference on Computational Sciences and Optimization (CSO) · 2011

Query Performance Tuning in Supply Chain Analytics

Cited by 12Abstract and details only

Abstract

Data explosion with knowledge shortage is becoming increasingly prominent. By utilizing business intelligence technology, supply chain analytics turns data into business insights and optimizes supply chain management decisions. Firstly, this paper describes the levels of Business Intelligence analytics, and formulates the architecture of supply chain analytics topics, then explains the analytics details of each topic. Furthermore, as OLAP is the most important decision support analysis tools of which query performance directly impacts the quality of analytics system end user experience, this paper proposes a variety of tuning technologies to accelerate query performance, including optimizing design of dimension, table aggregations, partitions, column store and tuning server resources technologies etc. A use scenario shows performance can be dramatically improved by dropping the processing time from previous 6-8 seconds to less than 0.1 seconds when aggregating 20+ million business transaction records.

Cite this paper

APA 7

Zeng, X., Lin, D., & Xu, Q. (2011). Query Performance Tuning in Supply Chain Analytics. International Joint Conference on Computational Sciences and Optimization (CSO), 327–331. https://doi.org/10.1109/cso.2011.212

MLA 9

Zeng, Xiaoqing, et al. “Query Performance Tuning in Supply Chain Analytics.” International Joint Conference on Computational Sciences and Optimization (CSO), 2011, pp. 327–31, https://doi.org/10.1109/cso.2011.212.

Chicago

Zeng, Xiaoqing, Dahan Lin, and Qin Xu. 2011. “Query Performance Tuning in Supply Chain Analytics.” International Joint Conference on Computational Sciences and Optimization (CSO): 327–31. https://doi.org/10.1109/cso.2011.212.

Harvard

Zeng, X., Lin, D. and Xu, Q. (2011) ‘Query Performance Tuning in Supply Chain Analytics’, International Joint Conference on Computational Sciences and Optimization (CSO), pp. 327–331. Available at: https://doi.org/10.1109/cso.2011.212.

BibTeX

@article{zeng2011query,
  title = {{Query Performance Tuning in Supply Chain Analytics}},
  author = {Zeng, Xiaoqing and Lin, Dahan and Xu, Qin},
  journal = {International Joint Conference on Computational Sciences and Optimization (CSO)},
  pages = {327--331},
  year = {2011},
  doi = {10.1109/cso.2011.212}
}

Made from the index record. Check names, capitalisation and page numbers against the paper. Need another style? AI for Research has over 10,000.