Fundamentals of spatial data warehousing for geographic knowledge discovery

Geographic Data Mining and Knowledge Discovery, Second Edition

Volumn , Issue , 2009, Pages 45-68

  Bédard, Yvan ^a   Han, Jiawei ^b  

^a UNIVERSITÉ LAVAL   (Canada)

^b University of Illinois at Urbana Champaign   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 85008916688     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.1201/9781420073980     Document Type: Chapter

References (44)

1. Agarwal, S., Agrawal, R., Deshpande, P.M., Gupta, A., Naughton, J.F., Ramakrishnan, R., and Sarawagi, S., 1996. On the computation of multidimensional aggregates. In Proc. 1996 Int. Conf. Very Large Data Bases, pp. 506-521, Morgan Kaufmann, Mumbai, India, September.
2. Badard, T., Bédard, Y., Hubert, F., Bernier, E., and E. Dube, 2008. Web Services Oriented Architectures for Mobile SOLAP Applications. International Journal of Web Engineering, and Technology (accepted). Inderscience Publishers, Geneva, Switzerland, p. 434-464.
3. Bédard, Y., Larrivée, S., Proulx, M-J., Caron, P-Y., and Létourneau, F., 1997. Étude de l’état actuel et des besoins de R&D relativement aux architectures et technologies des data warehouses appliquées aux données spatiales. Research report for the Canadian Defense Research Center in Valcartier, Centre for Research in Geomatics, Laval University, Quebec City, Canada, p. 98.
4. Bédard, Y., Rivest, S., and Proulx, M.-J. 2007. Spatial on-line analytical processing (SOLAP): concepts, architectures, and solutions from a geomatics engineering perspective. In Wrembel R. and Koncilia, C., Data Warehouses, and OLAP: Concepts, Architectures, and Solutions, London, UK: IRM Press, pp. 298-319.
5. Bernier, E. and Bédard, Y., 2007. A data warehouse strategy for on-demand multiscale mapping. In Mackaness, W., Ruas, A., and Sarjakoski T. (Eds.), Generalisation of Geographic Information: Cartographic Modelling, and Applications, International Cartographic Association, Elsevier, Oxford, UK, pp. 177-198.
6. Badard, T. 2008. Personal website. http://geosoa.scg.ulaval.ca/en/index.php?module=pagemaster&PAGE_user_op_view_page&PAGE_id=17. Accessed November 21, 2007.
7. Berson, A. and Smith, S.J., 1997. Data Warehousing, Data Mining & OLAP, McGraw- Hill. New York, NY, USA.
8. Beyer, K. and Ramakrishnan, R., 1999. Bottom-up computation of sparse, and iceberg cubes. Proc. 1999 ACM-SIGMOD Int. Conf. Management of Data (SIGMOD’99), Philadelphia, PA, pp. 359-370, June. On-line proceedings, Association for computing Machinery, NewYork, NY, USA, http://www.sigmod.org/sigmod99/eproceedings. Accessed, November 20, 2008.
9. Brackett M.H., 1996, The Data Warehouse Challenge: Taming Data Chaos, John Wiley & Sons, New York.
10. Caron, P.Y., 1998. Étude du potentiel de OLAP pour supporter l’analyse spatio-temporelle. M.Sc. thesis, Centre for Research in Geomatics, Laval University, Quebec City, Canada.
11. Chaudhuri, S. and Dayal, U., 1997. An overview of data warehousing, and OLAP technology. ACM SIGMOD Record, 26: 65-74. Tucson, Arizona, USA, May 13-15, ACM Press, New York, NY, USA, Association for Computing Machinery.
12. Damiani, M.L. and Spaccapietra, S., 2006. Spatial data warehouse modeling. In: Processing, and Managing Complex Data for Decision Support. Darmont, J. and Boussaid, O. (Eds.), Idea Group, Hershey, PA, USA, pp. 1-27.
13. Date, C.J., 2000. An Introduction to Database Systems, 7th ed., Addison-Wesley. Reading, MA, USA.
14. Dube, E., 2008. Developpement d’un service web de constitution en temps reel de mini cubes SOLAP pour clients mobiles. M.Sc. thesis (draft), Centre for Research in Geomatics, Department of Geomatics Sciences, Laval University, Quebec City, Canada.
15. Fayyad, U.M., Grinstein, G., and Wierse, A., 2001. Information Visualization in Data Mining, and Knowledge Discovery. Morgan Kaufmann, San Francisco, CA, USA.
16. Gill, S.H. and Rao, P.C., 1996. The Official Client/Server Computing Guide to Data Warehouse. QUE Corporation. Indianapolis, IN, USA.
17. Han, J. and Kamber, M., 2006. Data Mining: Concepts, and Techniques, 2nd ed., Morgan Kaufmann, San Francisco, CA, USA.
18. Han, J., Stefanovic, N., and Koperski, K., 1998. Selective materialization: An efficient method for spatial data cube construction, Proceedings of the Second Pacific-Asia Conference, PAKDD’98, pp. 144-158. Melbourne, Australia, April 15-17, Computer Science, Vol. 1394, Springer Berlin/Heidelbert.
19. Harinarayan, V., Rajaraman, A., and Ullman, J.D., 1996. Implementing data cubes efficiently, Proc. 1996 ACM-SIGMOD Int. Conf. Management of Data, pp. 205-216, Montreal, Canada, June 4-6, ACM Press, New York, NY, USA. Association for Computing Machinery.
20. Imhoff, C., Galemmo, N., and Geiger, J.G., 2003. Mastering Data Warehouse Design: Relational, and Dimensional Techniques, John Wiley, New York.
21. Inmon, W.H., Richard, D., and Hackathorn, D., 1996. Using the Data Warehouse, John Wiley & Sons, New York.
22. Kim, W., 1997. OLTP versus DSS/OLAP/data mining, Journal of Object-Oriented Programming, Nov.-Dec., pp. 68-77.
23. Kim, W., 1999. I/O problems in preparing data for data warehousing, and data mining, Part 1. Journal of Object-Oriented Programming, February, pp. 13-17. Sigs Publications, Van Nuys, CA, USA.
24. Kimball, R. and Ross, M., 2002. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd ed., Wiley, New York.
25. Levesque, M.-A., Bédard, Y., Gervais, M., and Devillers, R., 2007. Towards a safer use of spatial datacubes: Communicating warnings to users, Proceedings of the 5th International Symposium on Spatial Data Quality, Enschede, Netherlands, June 13-15. Online Proceedings http://www.itc.nl/ISSDQ2007/proceedings/index.html. Accessed November 20, 2008.
26. Li, X., Han, J., and Gonzalez, H., 2004. High-dimensional OLAP: A minimal cubing approach, Proc. 2004 Intl. Conf. Very Large Data Bases (VLDB’04), Toronto, Canada, pp. 528-539, August. Lecture notes in Computer Science, Springer Berlin/Heidelbert.
27. McHugh, R., 2008. Etude du potentiel de la structure matricielle pour optimizer l’analyse spatial de données géodécisionnelles. M.Sc. thesis (draft version), Department of Geomatics Sciences, Laval University, Quebec City, Canada.
28. Malinowski, E. and Zimanyi, E., 2008. Advanced Data Warehouse Design: From Conventional to Spatial, and Temporal Applications, Springer, Berlin, Heidelbert.
29. OLAP Council, 1995. OLAP council white paper, http://www.olapcounci/.org/research/resrchly.htm. Accessed November 20, 2008, Delware, USA.
30. Poe, V., 1995. Building a Data Warehouse for Decision Support, Prentice Hall, Englewood Cliffs, NJ.
31. Proulx, M., Rivest, S., and Bédard, Y., 2007. Évaluation des produits commerciaux offrant des capacités combinées d’analyse multidimensionnelle et de cartographie, Research report for the partners of the Canada NSERC Industrial Research Chair in Geospatial Databases for Decision-Support, Centre for Research in Geomatics, Laval University, Quebec City, Canada.
32. Rafanelli, M., 2003. Multidimensional Databases: Problems, and Solutions. Idea Group Publishing, London, UK.
33. Rivest, S., Bédard, Y., and Marchand, P., 2001. Towards better support for spatial decisionmaking: Defining the characteristics of spatial on-line analytical processing, Geomatica, Journal of the Canadian Institute of Geomatics, 55(4), 539-555. Ottawa, Canada
34. Rivest, S., Bédard, Y., Proulx, M.-J., Nadeau, M., Hubert, F., and Pastor, J., 2005. SOLAP: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration, and analysis of data, Journal of International Society for Photogrammetry, and Remote Sensing (ISPRS), 60(1), 17-33. Elsevier, Amsterdam, Netherlands.
35. Ross, K.A., Srivastava, D., and Chatziantoniou, D., 1998. Complex aggregation at multiple granularities, Proc. Int. Conf. of Extending Database Technology (EDBT’98), Valencia, Spain, pp. 263-277, March 23-27, Lecture notes in Computer Science Vol. 1377, Springer Berlin/Heidelbert.
36. Sarawagi, S., Agrawal, R., and Megiddo, N., 1998. Discovery-driven exploration of OLAP data cubes, Proc. Intl. Conf. of Extending Database Technology (EDBT’98), Valencia, Spain, pp. 168-182, March 23-27, Lecture notes in Computer Science Vol. 1377, Springer Berlin/Heidelbert.
37. Sboui, T., Bédard, Y., Brodeur, J., Badard, T., 2007. A conceptual framework to support semantic interoperability of geospatial datacubes, Proceedings of ER/2007 SeCoGIS Workshop, November 5-9, Auckland, New Zealand, Lecture Notes in Computer Sciences, Springer, pp. 378-387. Springer Berlin/Heidelbert.
38. Sboui, T., Bédard, Y., Brodeur, J., and Badard, T., 2008. Risk management for the simultaneous use of spatial datacubes: A semantic interoperability perspective. International Journal of Business Intelligence, and Data Mining (submitted). Interscience Publishers, Geneva, Switzerland.
39. Shekhar, S., Lu, C.T., Tan, X., Chawla, S., and Vatsavai, R., 2001. Map cube: A visualization tool for spatial data warehouses. In: Miller, H.J. and Han, J. (Eds.), Geographic Data Mining, and Knowledge Discovery, Taylor & Francis, London, UK.
40. Stefanovic, N., 1997. Design, and Implementation of On-Line Analytical Processing (OLAP) of Spatial Data. M.Sc. thesis, Simon Fraser University, Burnaby, British Columbia, Canada.
41. Thomsen, E., 2002. OLAP Solutions: Building Multidimensional Information Systems, 2nd ed., John Wiley & Sons, New York.
42. Weldon, J.L., 1997. State of the art: Warehouse cornerstones. Byte, p. 87, January.
43. Wrembel, R. and Koncilia, C., 2006. Data Warehouses, and OLAP: Concepts, Architectures, and Solutions. IRM Press (IDEA Group Publishing), London.
44. Zhou, X., Truffet, D., and Han, J., 1999. Efficient polygon amalgamation methods for spatial OLAP and spatial data mining, Proc. 6th Int. Symp. on Large Spatial Databases (SSD’99), Hong Kong, pp. 167-187, July 20-23 rd, Lecture Notes in Computer Science, vol. 1651, Springer Berlin Heidelbert.