Data warehouse technology by infobright

ABSTRACT

We discuss Infobright technology with respect to its main features and architectural differentiators. We introduce the upcoming research and development projects that may be of special interest to the academic and industry communities.

REFERENCES

• 1: Charu C. Aggarwal, Data Streams: Models and Algorithms (Advances in Database Systems), Springer-Verlag New York, Inc., Secaucus, NJ, 2006
• 2: Christian Böhm , Christos Faloutsos , Claudia Plant, Outlier-robust clustering using independent components, Proceedings of the 2008 ACM SIGMOD international conference on Management of data, June 09-12, 2008, Vancouver, Canada [doi>10.1145/1376616.1376638]
• 3: Mario Cannataro , Domenico Talia, The knowledge grid, Communications of the ACM, v.46 n.1, p.89-93, January 2003 [doi>10.1145/602421.602425]
• 4: Moses Charikar , Chandra Chekuri , Tomas Feder , Rajeev Motwani, Incremental Clustering and Dynamic Information Retrieval, SIAM Journal on Computing, v.33 n.6, p.1417-1440, 2004 [doi>10.1137/S0097539702418498]
• 5: Surajit Chaudhuri , Vivek Narasayya, Self-tuning database systems: a decade of progress, Proceedings of the 33rd international conference on Very large data bases, September 23-27, 2007, Vienna, Austria
• 6: Surajit Chaudhuri , Vivek Narasayya , Ravishankar Ramamurthy, Estimating progress of execution for SQL queries, Proceedings of the 2004 ACM SIGMOD international conference on Management of data, June 13-18, 2004, Paris, France [doi>10.1145/1007568.1007659]
• 7: Antonios Deligiannakis , Yannis Kotidis , Vasilis Vassalos , Vassilis Stoumpos , Alex Delis, Another Outlier Bites the Dust: Computing Meaningful Aggregates in Sensor Networks, Proceedings of the 2009 IEEE International Conference on Data Engineering, p.988-999, March 29-April 02, 2009 [doi>10.1109/ICDE.2009.100]
• 8: Stephane P. Demri , Ewa S. Orlowska, Incomplete Information: Structure, Inference, Complexity, Springer-Verlag New York, Inc., Secaucus, NJ, 2002
• 9: Amol Deshpande , Zachary Ives , Vijayshankar Raman, Adaptive query processing, Foundations and Trends in Databases, v.1 n.1, p.1-140, January 2007 [doi>10.1561/1900000001]
• 10: Joseph M. Hellerstein , Michael Stonebraker , James Hamilton, Architecture of a Database System, Foundations and Trends in Databases, v.1 n.2, p.141-259, February 2007 [doi>10.1561/1900000002]
• 11: Allison L. Holloway , Vijayshankar Raman , Garret Swart , David J. DeWitt, How to barter bits for chronons: compression and bandwidth trade offs for database scans, Proceedings of the 2007 ACM SIGMOD international conference on Management of data, June 11-14, 2007, Beijing, China [doi>10.1145/1247480.1247525]
• 12: Ying Hu , Seema Sundara , Jagannathan Srinivasan, Supporting time-constrained SQL queries in oracle, Proceedings of the 33rd international conference on Very large data bases, September 23-27, 2007, Vienna, Austria
• 13: Infobright. Corporate and community sites. www.infobright.com, www.infobright.org.
• 14: A. K. Jain , M. N. Murty , P. J. Flynn, Data clustering: a review, ACM Computing Surveys (CSUR), v.31 n.3, p.264-323, Sept. 1999 [doi>10.1145/331499.331504]
• 15: N. Kerdprasop and K. Kerdprasop. Semantic knowledge integration to support inductive query optimization. In DaWaK, pages 157--169, 2007.
• 16: Martin L. Kersten, The Database Architecture Jigsaw Puzzle, Proceedings of the 2008 IEEE 24th International Conference on Data Engineering, p.3-4, April 07-12, 2008 [doi>10.1109/ICDE.2008.4497404]
• 17: W. Klösgen and J. M. Żytkow, editors. Handbook of Data Mining and Knowledge Discovery. Oxford University Press, 2002.
• 18: J. K. Metzger, B. M. Zane, and F. D. Hinshaw. Limiting scans of loosely ordered and/or grouped relations using nearly ordered maps, 2005. US Patent 6,973,452.
• 19: MySQL. MySQL 6.0 reference manual: Storage engines. dev.mysql.com/doc/refman/6.0/en/storage-engines.html.
• 20: S. Naouali and M. Quafafou. Concepts approximation for information retrieval from databases and pragmatic OLAP. In ICTTA, pages 401--402, 2004.
• 21: Zdzislaw Pawlak, Rough Sets: Theoretical Aspects of Reasoning about Data, Kluwer Academic Publishers, Norwell, MA, 1992
• 22: Z. Pawlak and A. Skowron. Rudiments of rough sets. Inf. Sci., 177(1):3--27, 2007.
• 23: Witold Pedrycz , Andrzej Skowron , Vladik Kreinovich, Handbook of Granular Computing, Wiley-Interscience, New York, NY, 2008
• 24: A. Rasin, S. Zdonik, O. Trajman, and S. Lawande. Automatic vertical-database design, 2008. WO Patent Application, 2008/016877 A2.
• 25: D. Śezak, M. Kowalski, V. Eastwood, and J. Wróblewski. Methods and systems for database organization, 2009. US Patent Application, 2009/0106210 A1
• 26: Dominik Ślȩzak , Jakub Wróblewski , Victoria Eastwood , Piotr Synak, Brighthouse: an analytic data warehouse for ad-hoc queries, Proceedings of the VLDB Endowment, v.1 n.2, August 2008 [doi>10.1145/1454159.1454174]
• 27: Dominik Ślęzak , Jakub Wróblewski , Victoria Eastwood , Piotr Synak, Rough Sets in Data Warehousing, Proceedings of the 6th International Conference on Rough Sets and Current Trends in Computing, October 23-25, 2008, Akron, OH [doi>10.1007/978-3-540-88425-5_52]
• 28: M. Wojnarski, C. Apanowicz, V. Eastwood, D. Śezak, P. Synak, A. Wojna, and J. Wróblewski. Method and system for data compression in a relational database, 2008. US Patent Application, 2008/0071818 A1.
• 29: J. Wróblewski, C. Apanowicz, V. Eastwood, D. Śezak, P. Synak, A. Wojna, and M. Wojnarski. Method and system for storing, organizing and processing data in a relational database, 2008. US Patent Application, 2008/0071748 A1.
• 30: Marcin Zukowski , Sandor Heman , Niels Nes , Peter Boncz, Super-Scalar RAM-CPU Cache Compression, Proceedings of the 22nd International Conference on Data Engineering, p.59, April 03-07, 2006 [doi>10.1109/ICDE.2006.150]

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.4 Systems

General Terms:
Algorithms, Design

Keywords:
approximate query, column store, data clustering, data compression, data warehouse, database knowledge grid, ice, iee, mysql, open source, rough sets, two-level computing