Abstract
We discuss the importance of analytic SQL statements with complex expressions in the business intelligence and knowledge discovery applications. We report the recent improvements of the execution of complex expressions in the Infobright’s RDBMS, which is based on the paradigms of columnar databases and adaptive rough computations over the granulated metadata layer.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Pawlak, Z., Skowron, A.: Rudiments of Rough Sets. Information Sciences 177(1), 3–27 (2007)
White, P., French, C.: Database System with Methodology for Storing a Database Table by Vertically Partitioning all Columns of the Table. US Patent 5,794,229 (1998)
Ślęzak, D., Eastwood, V.: Data Warehouse Technology by Infobright. In: Proc. of the 2009 ACM SIGMOD Int. Conf. on Management of Data (SIGMOD), pp. 841–846 (2009)
Pöss, M., Nambiar, R.O., Walrath, D.: Why You Should Run TPC-DS: A Workload Analysis. In: Proc. of the 33rd Int. Conf. on Very Large Data Bases (VLDB), pp. 1138–1149 (2007)
Synak, P.: Rough Set Approach to Optimisation of Subquery Execution in Infobright Data Warehouse. In: Proc. of the Int. Workshop on Soft Computing for Knowledge Technology (SCKT), Hanoi University of Technology (2008)
Davenport, T.H., Harris, J.G.: Competing on Analytics - The New Science of Winning. Harvard Business School Press (2007)
Ślęzak, D., Toppin, G.: Injecting Domain Knowledge into a Granular Database Engine: A Position Paper. In: Proc. of the 19th ACM Conf. on Information and Knowledge Management (CIKM), pp. 1913–1916 (2010)
Liu, H., Motoda, H. (eds.): Feature Extraction, Construction and Selection: A Data Mining Perspective. Kluwer Academic Publishers (1998)
Wróblewski, J.: Analyzing Relational Databases Using Rough Set Based Methods. In: Proc. of the 8th Int. Conf. on Information Processing and Management of Uncertainty (IPMU), Part I, pp. 256–262 (2000)
Nguyen, H.S., Nguyen, S.H.: Fast Split Selection Method and Its Application in Decision Tree Construction from Large Databases. International Journal of Hybrid Intelligent Systems 2(2), 149–160 (2005)
Nguyen, H.S.: From Optimal Hyperplanes to Optimal Decision Trees. Fundamenta Informaticae 34(1-2), 145–174 (1998)
Metzger, J.K., Zane, B.M., Hinshaw, F.D.: Limiting Scans of Loosely Ordered and/or Grouped Relations Using Nearly Ordered Maps. US Patent 6,973,452 (2005)
Deshpande, A., Ives, Z.G., Raman, V.: Adaptive Query Processing. Foundations and Trends in Databases 1(1), 1–140 (2007)
Hellerstein, J.M., Stonebraker, M., Hamilton, J.: Architecture of a Database System. Foundations and Trends in Databases 1(2), 141–259 (2007)
Pawlak, Z.: Information Systems - Theoretical Foundations. Information Systems 6, 205–218 (1981)
Oracle: Multithreaded Programming Guide (Beta). Online Documentation (2010)
Borkowski, J.: Performance Debugging of Parallel Compression on Multicore Machines. In: Wyrzykowski, R., Dongarra, J., Karczewski, K., Wasniewski, J. (eds.) PPAM 2009, Part II. LNCS, vol. 6068, pp. 82–91. Springer, Heidelberg (2010)
Kreinovich, V.: Towards Faster Estimation of Statistics and ODEs Under Interval, P-Box, and Fuzzy Uncertainty: From Interval Computations to Rough Set-Related Computations. In: Kuznetsov, S.O., Ślęzak, D., Hepting, D.H., Mirkin, B.G. (eds.) RSFDGrC 2011. LNCS (LNAI), vol. 6743, pp. 3–10. Springer, Heidelberg (2011)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ślęzak, D., Synak, P., Wróblewski, J., Borkowski, J., Toppin, G. (2012). Rough Optimizations of Complex Expressions in Infobright’s RDBMS. In: Yao, J., et al. Rough Sets and Current Trends in Computing. RSCTC 2012. Lecture Notes in Computer Science(), vol 7413. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-32115-3_10
Download citation
DOI: https://doi.org/10.1007/978-3-642-32115-3_10
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-32114-6
Online ISBN: 978-3-642-32115-3
eBook Packages: Computer ScienceComputer Science (R0)