{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:27:40Z","timestamp":1750307260667,"version":"3.41.0"},"reference-count":57,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2010,12,6]],"date-time":"2010-12-06T00:00:00Z","timestamp":1291593600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGMOD Rec."],"published-print":{"date-parts":[[2010,12,6]]},"abstract":"<jats:p>Data warehouses are the core of decision support systems, which nowadays are used by all kind of enterprises in the entire world. Although many studies have been conducted on the need of decision support systems (DSSs) for small businesses, most of them adopt existing solutions and approaches, which are appropriate for large-scaled enterprises, but are inadequate for small and middle-sized enterprises.<\/jats:p><jats:p>Small enterprises require cheap, lightweight architectures and tools (hardware and software) providing online data analysis. In order to ensure these features, we review web-based business intelligence approaches. For real-time analysis, the traditional OLAP architecture is cumbersome and storage-costly; therefore, we also review in-memory processing.<\/jats:p><jats:p>Consequently, this paper discusses the existing approaches and tools working in main memory and\/or with web interfaces (including freeware tools), relevant for small and middle-sized enterprises in decision making.<\/jats:p>","DOI":"10.1145\/1893173.1893180","type":"journal-article","created":{"date-parts":[[2010,12,1]],"date-time":"2010-12-01T20:18:10Z","timestamp":1291234690000},"page":"39-50","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":30,"title":["Business intelligence for small and middle-sized entreprises"],"prefix":"10.1145","volume":"39","author":[{"given":"Oksana","family":"Grabova","sequence":"first","affiliation":[{"name":"University of Lyon (ERIC Lyon2), Bron Cedex, France"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jerome","family":"Darmont","sequence":"additional","affiliation":[{"name":"University of Lyon (ERIC Lyon2), Bron Cedex, France"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jean-Hugues","family":"Chauchat","sequence":"additional","affiliation":[{"name":"University of Lyon (ERIC Lyon2), Bron Cedex, France"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Iryna","family":"Zolotaryova","sequence":"additional","affiliation":[{"name":"Kharkiv National University of Economics, Kharkov, Ukraine"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2010,12,6]]},"reference":[{"issue":"1","key":"e_1_2_1_1_1","first-page":"3","article-title":"Data Management in the Cloud","volume":"32","author":"Abadi D. J.","year":"2009","journal-title":"Limitations and Opportunities. IEEE Data Engineering Bulletin"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1109\/CONTEL.2005.185875"},{"key":"e_1_2_1_4_1","first-page":"455","volume-title":"XML Data Management: Native XML and XML-Enabled Database Systems","author":"Baril X.","year":"2003"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066215"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/583890.583891"},{"key":"e_1_2_1_7_1","first-page":"2000","article-title":"Business Process Oriented Development of Data Warehouse Structures, pages 3--21. Physica","author":"B\u00f6hnlein M.","year":"2000","journal-title":"Heidelberg"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1007\/11827252_6"},{"volume-title":"The 38th Annual Southeastern ACM Conference","year":"2001","author":"Burte P.","key":"e_1_2_1_9_1"},{"key":"e_1_2_1_10_1","first-page":"570","volume-title":"Evaluating Partitioning Techniques for Main Memory Database: Horizontal and Single Vertical. In ICCI '93: Proceedings of the 5th International Conference on Computing and Information","author":"Cheng Y. C.","year":"1993"},{"key":"e_1_2_1_11_1","first-page":"373","volume-title":"Business Computing","volume":"3","author":"Chung W.","year":"2009"},{"issue":"6","key":"e_1_2_1_12_1","first-page":"872","volume":"6","author":"Cui Y.","year":"2007","journal-title":"SQLmmdb: An Embedded Main Memory Database Management System. Information Technology Journal"},{"key":"e_1_2_1_13_1","unstructured":"S. C. E.F. Codd and C. Salley. Providing OLAP to User-Analysts: An IT Mandate 1993. S. C. E.F. Codd and C. Salley. Providing OLAP to User-Analysts: An IT Mandate 1993."},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.180602"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/512236.512242"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.5555\/100512.100515"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1416691.1416703"},{"key":"e_1_2_1_18_1","first-page":"402","volume-title":"DSS'04: The IFIP International Conference on Decision Support in an Uncertain and Complex World","author":"Hafez H. A. A.","year":"2004"},{"key":"e_1_2_1_19_1","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1080\/08874417.2003.11647078","article-title":"Web-based data warehousing: current status and perspective","volume":"43","author":"Hsieh C.","year":"2002","journal-title":"The Journal of Computer Information Systems"},{"key":"e_1_2_1_20_1","first-page":"48","volume-title":"Dal\u0131: A High Performance Main Memory Storage Manager. In VLDB '94: Proceedings of the 20th International Conference on Very Large Data Bases","author":"Jagadish H. V.","year":"1994"},{"volume-title":"Wiley Computer Publishing","year":"2002","author":"Kimball R.","key":"e_1_2_1_21_1"},{"volume-title":"Research Computer Center of Moscow State University","year":"1999","author":"Knizhnik K.","key":"e_1_2_1_22_1"},{"key":"e_1_2_1_23_1","first-page":"5","volume-title":"SYRCoDIS '06: Proceedings of the 3rd Spring Colloquium for Young Researchers in Databases and Information Sytems","author":"Kudryavcev Y.","year":"2006"},{"key":"e_1_2_1_24_1","unstructured":"Kx Systems. The kdb+ Database White Paper. A unified database for streaming and historical data 2009. Retrieved September 1 2010 from http:\/\/kx.com\/papers. Kx Systems. The kdb+ Database White Paper. A unified database for streaming and historical data 2009. Retrieved September 1 2010 from http:\/\/kx.com\/papers."},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.5555\/1287369.1287436"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1109\/MC.2009.61"},{"key":"e_1_2_1_27_1","unstructured":"I. Lee H. Y. Yeom and T. Park. A New Approach for Distributed Main Memory Database Systems: A Causal Commit Protocol. IEICE Transactions on Information and Systems E87-D(1):196--204 January 2004. I. Lee H. Y. Yeom and T. Park. A New Approach for Distributed Main Memory Database Systems: A Causal Commit Protocol. IEICE Transactions on Information and Systems E87-D(1):196--204 January 2004."},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0020-0255(03)00077-X"},{"first-page":"6","volume-title":"Wavelet-Based Relative Prefix Sum Methods for Range Sum Queries in Data Cubes. In CASCON '02: Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research","author":"Lemire D.","key":"e_1_2_1_29_1"},{"issue":"1","key":"e_1_2_1_30_1","first-page":"26","volume":"2","author":"Luo Z.","year":"2005","journal-title":"Journal of Communication and Computer"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2005.08.003"},{"volume-title":"Gartner","year":"2010","author":"McDonald M.","key":"e_1_2_1_32_1"},{"issue":"45","key":"e_1_2_1_33_1","first-page":"96","volume":"1","author":"Mehedintu A.","year":"2008","journal-title":"Web-enabled Data Warehouse and Data Webhouse. Revista Informatica Economica"},{"key":"e_1_2_1_34_1","unstructured":"R. Mullins Y. Duan D. Hamblin P. Burrell H. Jin G. Jerzy Z. Ewa and B. Aleksander. A Web Based Intelligent Training System for SMEs. The Electronic Journal of e-Learning 5:39--48 2007. R. Mullins Y. Duan D. Hamblin P. Burrell H. Jin G. Jerzy Z. Ewa and B. Aleksander. A Web Based Intelligent Training System for SMEs. The Electronic Journal of e-Learning 5:39--48 2007."},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-30076-2_1"},{"volume-title":"Proceedings of Workshop on Knowledge Foraging for Dynamic Networking of Communities and Economies(in conjunction with EurAsia-ICT'2002)","year":"2002","author":"N\u00f8rv\u00e5g K.","key":"e_1_2_1_36_1"},{"key":"e_1_2_1_37_1","doi-asserted-by":"crossref","unstructured":"K. N\u00f8rv\u00e5g M. Limstrand and L. Myklebust . TeXOR: Temporal XML Database on an Object-Relational Database System. In M. Broy and A. V. Zamulin editors Ershov Memorial Conference volume 2890 of Lecture Notes in Computer Science pages 520 -- 530 . Springer 2003 . K. N\u00f8rv\u00e5g M. Limstrand and L. Myklebust. TeXOR: Temporal XML Database on an Object-Relational Database System. In M. Broy and A. V. Zamulin editors Ershov Memorial Conference volume 2890 of Lecture Notes in Computer Science pages 520--530. Springer 2003.","DOI":"10.1007\/978-3-540-39866-0_50"},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1109\/CCGRID.2009.93"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1109\/SSDM.2002.1029721"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1109\/2.970558"},{"key":"e_1_2_1_41_1","first-page":"267","volume-title":"Baltic DB&amp;IS '02: Proceedings of the 5th International Baltic Conference on Databases and Information Systems","author":"Pokorny J.","year":"2002"},{"issue":"4","key":"e_1_2_1_42_1","first-page":"291","volume":"11","author":"Power D. J.","year":"2002","journal-title":"Building Web-based Decision Support Systems. Studies in Informatics and Control"},{"key":"e_1_2_1_43_1","first-page":"78","volume-title":"Cache Conscious Indexing for Decision-Support in Main Memory. In VLDB '99: Proceedings of the 25th International Conference on Very Large Data Bases","author":"Rao J.","year":"1999"},{"key":"e_1_2_1_44_1","first-page":"86","volume-title":"Logical and Physical Versioning in Main Memory Databases. In VLDB '97: Proceedings of the 23rd International Conference on Very Large Data Bases","author":"Rastogi R.","year":"1997"},{"volume-title":"Cengage Learning","year":"2007","author":"Rob P.","key":"e_1_2_1_45_1"},{"key":"e_1_2_1_46_1","first-page":"531","volume-title":"Intelligent Rollups in Multidimensional OLAP Data. In VLDB '01: Proceedings of the 27th International Conference on Very Large Data Bases","author":"Sathe G.","year":"2001"},{"volume-title":"Gartner","year":"2006","author":"Schlegel K.","key":"e_1_2_1_47_1"},{"key":"e_1_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.5555\/1796146"},{"key":"e_1_2_1_49_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564745"},{"volume-title":"Forrester Research","year":"2008","author":"Staten J.","key":"e_1_2_1_50_1"},{"key":"e_1_2_1_51_1","first-page":"1150","volume-title":"VLDB'07: Proceedings of the 33rd international conference on Very Large Data Bases","author":"Stonebracker M.","year":"2007"},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0160-791X(02)00061-1"},{"key":"e_1_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2009070103"},{"key":"e_1_2_1_54_1","doi-asserted-by":"publisher","DOI":"10.1145\/304181.304244"},{"key":"e_1_2_1_55_1","first-page":"916","volume-title":"IEEE 23rd International Conference on Data Engineering","author":"Wiwatwattana N.","year":"2007"},{"key":"e_1_2_1_56_1","series-title":"LNCS","first-page":"851","volume-title":"K. Aberer, K.-S. Choi, N. Noy, D. Allemang, K.-I","author":"Xie G.","year":"2007"},{"key":"e_1_2_1_57_1","first-page":"40","article-title":"A dynamic warehouse for XML data of the Web","volume":"24","author":"Xyleme L.","year":"2001","journal-title":"IEEE Data Engineering Bulletin"},{"key":"e_1_2_1_58_1","doi-asserted-by":"publisher","DOI":"10.1145\/1062745.1062786"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1893173.1893180","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1893173.1893180","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T10:52:35Z","timestamp":1750243955000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1893173.1893180"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2010,12,6]]},"references-count":57,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2010,12,6]]}},"alternative-id":["10.1145\/1893173.1893180"],"URL":"https:\/\/doi.org\/10.1145\/1893173.1893180","relation":{},"ISSN":["0163-5808"],"issn-type":[{"type":"print","value":"0163-5808"}],"subject":[],"published":{"date-parts":[[2010,12,6]]},"assertion":[{"value":"2010-12-06","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}