Article

Lily: A Geo-Enhanced Library for Location Intelligence

Authors:

Matteo Golfarelli,

Marco Mantovani,

Federico Ravaldi,

Stefano RizziAuthors Info & Claims

DaWaK 2013: Proceedings of the 15th International Conference on Data Warehousing and Knowledge Discovery - Volume 8057

Pages 72 - 83

https://doi.org/10.1007/978-3-642-40131-2_7

Published: 26 August 2013 Publication History

Abstract

Location intelligence is a set of tools and techniques to integrate a geographical dimension into BI platforms, aimed at enhancing their capability of better monitoring and interpreting business events. Though most commercial data warehouse tools have implemented spatial extensions to support GIS integration, the user experience with spatial data is still mostly limited to the visualization of maps labeled with numerical indicators. To overcome this limit we developed Lily , a geo-enhanced library that adds true location intelligence capabilities to existing BI platforms. Lily provides end-users with a highly-interactive interface that seamlessly achieves a bidirectional integration between the BI and the geospatial worlds, so as to enable advanced analytical features that truly take into account the spatial dimension. In this paper we describe Lily from a functional and architectural point of view, and show an example where Lily is coupled with the Oracle Suite to be used for location intelligence in the field of telecommunications.

References

[1]

Bédard, Y., Larrivée, S., Proulx, M., Létourneau, F.: Étude de l'etat actuel et des besoins de R&D relativement aux architectures et technologies des data warehouses appliquéées aux données spatiales. Tech. rep., Laval University 1997

[2]

Bédard, Y., Han, J.: Fundamentals of spatial data warehousing for geographic knowledge discovery. In: Miller, H.J., Han, J. eds. Geographic Data Mining and Knowledge Discovery, pp. 45---66. Chapman & Hall 2009

[3]

Bimonte, S., Bertolotto, M., Gensel, J., Boussaid, O.: Spatial OLAP and map generalization: Model and algebra. IJDWM 81, 24---51 2012

Digital Library

[4]

Bimonte, S., Miquel, M.: When spatial analysis meets OLAP: Multidimensional model and operators. IJDWM 64, 33---60 2010

Digital Library

[5]

Bitterer, A.: Location intelligence is expanding the scope of BI. Tech. Rep. G00239089, Gartner Research 2012

[6]

BusinessWeek Research Services, Pitney Bowes Business Insight: Location intelligence: The new geography of business. White paper 2006

[7]

Gómez, L.I., Haesevoets, S., Kuijpers, B., Vaisman, A.A.: Spatial aggregation: Data model and implementation. Inf. Syst. 346, 551---576 2009

Digital Library

[8]

Ihm, J., Lopez, X., Ravada, S.: Advanced spatial data management for enterprise applications. Oracle White Paper 2010

[9]

Katibah, E., Stojic, M.: New spatial features in SQL Server Code. Microsoft White Paper 2011

[10]

Malinowski, E., Zimányi, E.: Requirements specification and conceptual modeling for spatial data warehouses. In: Meersman, R., Tari, Z., Herrero, P. eds. OTM Workshops 2006. LNCS, vol. 4278, pp. 1616---1625. Springer, Heidelberg 2006

Digital Library

[11]

Papadias, D., Kalnis, P., Zhang, J., Tao, Y.: Efficient OLAP operations in spatial data warehouses. In: Proc. SSTD, Redondo Beach, CA, pp. 443---459 2001

Digital Library

[12]

Rao, F., Zhang, L., Yu, X., Li, Y., Chen, Y.: Spatial hierarchy and OLAP-favored search in spatial data warehouse. In: Proc. DOLAP, New Orleans, LA, pp. 48---55 2003

Digital Library

[13]

Rivest, S., Bédard, Y., Proulx, M.J., Nadeau, M.: SOLAP: a new type of user interface to support spatio-temporal multidimensional data exploration and analysis. In: Proc. ISPRS Workshop, Québec, Canada 2003

[14]

Rivest, S., Bédard, Y., Proulx, M.J., Nadeau, M., Hubert, F., Pastor, J.: SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data. ISPRS Journal of Photogrammetry & Remote Sensing 60, 17---33 2005

[15]

Scotch, M., Parmanto, B.: SOVAT: Spatial OLAP visualization and analysis tool. In: Proc. HICSS, Big Island, HI 2005

Digital Library

[16]

da Silva, J., de Oliveira, A.G., do Nascimento Fidalgo, R., Salgado, A.C., Times, V.C.: Modelling and querying geographical data warehouses. Inf. Syst. 355, 592---614 2010

Digital Library

[17]

Stefanovic, N., Han, J., Koperski, K.: Object-based selective materialization for efficient implementation of spatial data cubes. IEEE Trans. Knowl. Data Eng. 126, 938---958 2000

Digital Library

[18]

Whitehorn, M., Zare, R., Pasumansky, M.: Fast Track to MDX. Springer, Berlin 2005

Digital Library

Cited By

Golfarelli MMantovani MRavaldi FRizzi SSong ISimitsis ACuzzocrea A(2014)From Business Intelligence to Location Intelligence with the Lily LibraryProceedings of the 17th International Workshop on Data Warehousing and OLAP10.1145/2666158.2666176(33-36)Online publication date: 7-Nov-2014
https://dl.acm.org/doi/10.1145/2666158.2666176

Recommendations

From Business Intelligence to Location Intelligence with the Lily Library
DOLAP '14: Proceedings of the 17th International Workshop on Data Warehousing and OLAP

Location intelligence is a set of tools and techniques to integrate spatial features into BI platforms, aimed at better monitoring and interpreting business events related to the territory. In this demonstration we present Lily, a geo-enhanced library ...
Visualizing and quantifying the movement of vegetative drought using remote-sensing data and GIS

Remote-sensing-based drought monitoring methods provide fast and useful information for a sustainable management strategy of drought impact over a region. Common pixel-based monitoring methods are limited in the analysis of the dynamics of this impact ...
RPG Explorer

LPIS data describe agricultural landscapes in most European countries.We developed a tool to analyze the French LPIS, called RPG Explorer.RPG Explorer describes farms, fields and crop proportion dynamics.RPG Explorer also computes crop sequences and ...

Comments

Information & Contributors

Information

Published In

cover image Guide Proceedings

DaWaK 2013: Proceedings of the 15th International Conference on Data Warehousing and Knowledge Discovery - Volume 8057

August 2013

371 pages

ISBN:9783642401305

Editors:
Ladjel Bellatreche
LIAS/ISAE-ENSMA, Futuroscope Chasseneuil Cedex, France
,
Mukesh Mohania
IBM India Research Lab, New Delhi, India

Publisher

Springer-Verlag

Berlin, Heidelberg

Publication History

Published: 26 August 2013

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

1
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 18 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

Golfarelli MMantovani MRavaldi FRizzi SSong ISimitsis ACuzzocrea A(2014)From Business Intelligence to Location Intelligence with the Lily LibraryProceedings of the 17th International Workshop on Data Warehousing and OLAP10.1145/2666158.2666176(33-36)Online publication date: 7-Nov-2014
https://dl.acm.org/doi/10.1145/2666158.2666176

View Options

View options

Figures

Tables

Media

View Table of Conten