Discovering OLAP dimensions in semi-structured data

Information Systems

Volumn 44, Issue , 2014, Pages 120-133

  Mansmann, Svetlana ^a   Ur Rehman, Nafees ^a   Weiler, Andreas ^a   Scholl, Marc H ^a  

^a UNIVERSITY OF KONSTANZ   (Germany)

Author keywords

Data warehousing; Multidimensional data model; OLAP; Semi structured data

Indexed keywords

HARDWARE; INFORMATION SYSTEMS;

DYNAMIC CHARACTERISTICS; KNOWLEDGE DISCOVERY TECHNIQUES; MULTI-DIMENSIONAL MODEL; MULTI-DIMENSIONAL VIEW; MULTIDIMENSIONAL DATA MODELING; OLAP; SEMI STRUCTURED DATA; USER-GENERATED CONTENT;

DATA WAREHOUSES;

EID: 84900811916     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.is.2013.09.002     Document Type: Article

References (36)

1. K. Roebuck, Big Data: High-Impact Strategies - What You Need to Know: Definitions, Adoptions, Impact, Benefits, Maturity, Vendors, Emereo Pty Limited, 2011.
2. C. Strauch, Nosql Databases. Lecture Selected Topics on Software-Technology Utra-Large Scale Sites, Manuscript, Lecture Notes, Stuttgart Media University, 2011.
3. J. Han, Olap mining: an integration of olap with data mining, in: Proceedings of the 7th IFIP 2.6 Working Conference on Database Semantics (DS-7).
4. Twitter Team, Twitter Turns Six, 2012.
5. R. Krikorian, Developing for @twitterapi (techcrunch disrupt hackathon), 2012.
6. J. MacLennan, Z. Tang, B. Crivat, Mining OLAP Cubes, Wiley Publishing, 2008, pp. 429-431.
7. M. Usman, S. Asghar, S. Fong, A conceptual model for combining enhanced olap and data mining systems, in: 5th International Joint Conference on INC, IMS and IDC, 2009 (NCM'09), IEEE, pp. 1958-1963.
8. J. Han, S. Chee, J. Chiang, Issues for on-line analytical mining of data warehouses, in: Proceedings of the Workshop on Research Issues on Data Mining and Knowledge Discovery, Seattle, Washington, pp. 21-25.
9. H. Zhu, On-line analytical mining of association rules (Ph.D. thesis), Simon Fraser University, 1998.
10. S. Dzeroski, D. Hristovski, B. Peterlin, Using data mining and olap to discover patterns in a database of patients with y-chromosome deletions., in: Proceedings of the AMIA Symposium, American Medical Informatics Association, p. 215.
11. F. Dehne, T. Eavis, A. Rau-Chaplin, Coarse grained parallel on-line analytical processing (OLAP) for data mining, in: International Conference on Computational Science (ICCS 2001), 2001, pp. 589-598. (Pubitemid 33285623)
12. T.B. Pedersen, C.S. Jensen, and C.E. Dyreson A foundation for capturing and querying complex multidimensional data Inf. Syst. 26 2001 383 423
13. A. Abelló, J. Samos, F. Saltor, A framework for the classification and description of multidimensional data models, in: DEXA 2001: Proceedings of DEXA 2001, Springer-Verlag, 2001, pp. 668-677. (Pubitemid 33347261)
14. S. Lujn-Mora, J. Trujillo, and I.-Y. Song A UML profile for multidimensional modeling in data warehouses Data Knowl. Eng. 59 2006 725 769 (Pubitemid 44485258)
15. S. Mansmann, Extending the OLAP technology to handle non-conventional and complex data (Ph.D. thesis), University of Konstanz, Konstanz, Germany, 2008.
16. A. Thusoo, Z. Shao, S. Anthony, D. Borthakur, N. Jain, J. Sen Sarma, R. Murthy, H. Liu, Data warehousing and analytics infrastructure at facebook, in: Proceedings of the 2010 International Conference on Management of Data (SIGMOD'10), ACM, New York, NY, USA, 2010, pp. 1013-1020.
17. H. Kwak, C. Lee, H. Park, S. Moon, What is twitter, a social network or a news media?, in: Proceedings of the 19th International Conference on World Wide Web (WWW'10), ACM, New York, NY, USA, 2010, pp. 591-600.
18. A. Java, X. Song, T. Finin, B. Tseng, Why we twitter: understanding microblogging usage and communities, in: Proceedings of the 9th WebKDD and 1st SNA-KDD 2007 Workshop on Web Mining and Social Network Analysis, ACM, pp. 56-65.
19. M. Mathioudakis, N. Koudas, Twittermonitor: trend detection over the twitter stream, in: Proceedings of the 2010 International Conference on Management of Data, ACM, pp. 1155-1158.
20. J. Chen, R. Nairn, L. Nelson, M.S. Bernstein, E.H. Chi, Short and tweet: experiments on recommending content from information streams., in: Proceedings of CHI, ACM, pp. 1185-1194.
21. O. Phelan, K. McCarthy, B. Smyth, Using twitter to recommend real-time topical news, in: Proceedings of the 3rd ACM Conference on Recommender systems, ACM, pp. 385-388.
22. M. Michelson, S.A. Macskassy, Discovering users' topics of interest on twitter: a first look, in: Proceedings of the 4th Workshop on Analytics for Noisy Unstructured Text Data (AND 2010), Toronto, Ontario, Canada, 26th October, 2010 (in conjunction with CIKM 2010), ACM.
23. B. Hecht, L. Hong, B. Suh, E.H. Chi, Tweets from Justin Bieber's heart: the dynamics of the location field in user profiles, in: Proceedings of CHI, pp. 237-246.
24. S. Chaudhuri, U. Dayal, and V. Ganti Database technology for decision support systems Computer 34 2001 48 55
25. R. Kimball The Data Warehouse Toolkit Practical Techniques for Building Dimensional Data Warehouses 1996 John Wiley & Sons, Inc. New York, NY, USA
26. E. Saddad, A. El-Bastawissy, M. Rafea, O. Hegazy, Multiversion queries in multidimensional structures, in: Proceedings of the 6th International Conference on Informatics and Systems (INFOS'08), 2008, pp. DB42-DB50.
27. A. Holupirek, C. Grün, M.H. Scholl, BaseX & DeepFS joint storage for filesystem and database, in: Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology (EDBT'09), ACM, 2009, pp. 1108-1111.
28. M. Golfarelli, D. Maio, and S. Rizzi The dimensional fact model a conceptual model for data warehouses Int. J. Coop. Inf. Syst. 7 1998 215-247
29. N.U. Rehman, S. Mansmann, A. Weiler, M.H. Scholl, Building a data warehouse for twitter stream exploration, in: Proceedings of 1st IEEE ACM International Workshop on Multi-agent Systems and Social Networks (MASSN 2012), in conjunction with ASONAM 2012.
30. R. Kimball, and M. Ross The Data Warehouse Toolkit The Complete Guide to Dimensional Modeling 2002 John Wiley & Sons, Inc. New York, NY, USA
31. R. Florian, H. Hassan, A. Ittycheriah, H. Jing, N. Kambhatla, X. Luo, N. Nicolov, S. Roukos, T. Zhang, A statistical model for multilingual entity detection and tracking, in: HLT-NAACL.
32. S. Petrovic, M. Osborne, V. Lavrenko, Streaming first story detection with application to twitter, in: Proceedings of NAACL, vol. 10, Citeseer.
33. T. Sakaki, M. Okazaki, Y. Matsuo, Earthquake shakes twitter users: real-time event detection by social sensors, in: Proceedings of the 19th International Conference on World Wide Web, ACM, pp. 851-860.
34. M. Thelwall, K. Buckley, and G. Paltoglou Sentiment in twitter events J. Am. Soc. Inf. Sci. Technol. 62 2011 406 418
35. AlchemyAPI, Alchemyapi: Transforming Text into Knowledge http://www.alchemyapi.com, 2008 (last checked 05.03.2013).
36. T. Reuters, Opencalais: A Toolkit for Semantic Enrichment http://www.opencalais.com , 2008 (last checked 05.03.2013).