A meta-language for MDX queries in eLog business solution

Sonia Bergamaschi, Matteo Interlandidi, Mario Longo, Laura Po, Maurizio Vincini

Research output: Contribution to journalArticle

1 Citation (Scopus)

Abstract

The adoption of business intelligence technology in industries is growing rapidly. Business managers are not satisfied with ad hoc and static reports and they ask for more flexible and easy to use data analysis tools. Recently, application interfaces that expand the range of operations available to the user, hiding the underlying complexity, have been developed. The paper presents eLog, a business intelligence solution designed and developed in collaboration between the database group of the University of Modena and Reggio Emilia and eBilling, an Italian SME supplier of solutions for the design, production and automation of documentary processes for top Italian companies. eLog enables business managers to define OLAP reports by means of a web interface and to customize analysis indicators adopting a simple meta-language. The framework translates the user's reports into MDX queries and is able to automatically select the data cube suitable for each query. Over 140 medium and large companies have exploited the technological services of eBilling S.p.A. to manage their documents flows. In particular, eLog services have been used by the major media and telecommunications Italian companies and their foreign annex, such as Sky, Media set, H3G, Tim Brazil etc. The largest customer can provide up to 30 millions mail pieces within 6 months (about 200 GB of data in the relational DBMS). In a period of 18 months, eLog could reach 150 millions mail pieces (1 TB of data) to handle.

Original languageEnglish
Article number6228210
Pages (from-to)1417-1428
Number of pages12
JournalProceedings - International Conference on Data Engineering
DOIs
Publication statusPublished - 30 Jul 2012

Fingerprint

Industry
Competitive intelligence
Managers
telecommunication
automation
Telecommunication
industry
Automation
services
document
indicator
analysis
data analysis

ASJC Scopus subject areas

  • Information Systems
  • Signal Processing
  • Software

Cite this

Bergamaschi, S., Interlandidi, M., Longo, M., Po, L., & Vincini, M. (2012). A meta-language for MDX queries in eLog business solution. Proceedings - International Conference on Data Engineering, 1417-1428. [6228210]. https://doi.org/10.1109/ICDE.2012.100

A meta-language for MDX queries in eLog business solution. / Bergamaschi, Sonia; Interlandidi, Matteo; Longo, Mario; Po, Laura; Vincini, Maurizio.

In: Proceedings - International Conference on Data Engineering, 30.07.2012, p. 1417-1428.

Research output: Contribution to journalArticle

Bergamaschi, Sonia ; Interlandidi, Matteo ; Longo, Mario ; Po, Laura ; Vincini, Maurizio. / A meta-language for MDX queries in eLog business solution. In: Proceedings - International Conference on Data Engineering. 2012 ; pp. 1417-1428.
@article{33f9a596d90949fca3c1e89662323dc4,
title = "A meta-language for MDX queries in eLog business solution",
abstract = "The adoption of business intelligence technology in industries is growing rapidly. Business managers are not satisfied with ad hoc and static reports and they ask for more flexible and easy to use data analysis tools. Recently, application interfaces that expand the range of operations available to the user, hiding the underlying complexity, have been developed. The paper presents eLog, a business intelligence solution designed and developed in collaboration between the database group of the University of Modena and Reggio Emilia and eBilling, an Italian SME supplier of solutions for the design, production and automation of documentary processes for top Italian companies. eLog enables business managers to define OLAP reports by means of a web interface and to customize analysis indicators adopting a simple meta-language. The framework translates the user's reports into MDX queries and is able to automatically select the data cube suitable for each query. Over 140 medium and large companies have exploited the technological services of eBilling S.p.A. to manage their documents flows. In particular, eLog services have been used by the major media and telecommunications Italian companies and their foreign annex, such as Sky, Media set, H3G, Tim Brazil etc. The largest customer can provide up to 30 millions mail pieces within 6 months (about 200 GB of data in the relational DBMS). In a period of 18 months, eLog could reach 150 millions mail pieces (1 TB of data) to handle.",
author = "Sonia Bergamaschi and Matteo Interlandidi and Mario Longo and Laura Po and Maurizio Vincini",
year = "2012",
month = "7",
day = "30",
doi = "10.1109/ICDE.2012.100",
language = "English",
pages = "1417--1428",
journal = "JAPCA",
issn = "1073-161X",
publisher = "Taylor and Francis Ltd.",

}

TY - JOUR

T1 - A meta-language for MDX queries in eLog business solution

AU - Bergamaschi, Sonia

AU - Interlandidi, Matteo

AU - Longo, Mario

AU - Po, Laura

AU - Vincini, Maurizio

PY - 2012/7/30

Y1 - 2012/7/30

N2 - The adoption of business intelligence technology in industries is growing rapidly. Business managers are not satisfied with ad hoc and static reports and they ask for more flexible and easy to use data analysis tools. Recently, application interfaces that expand the range of operations available to the user, hiding the underlying complexity, have been developed. The paper presents eLog, a business intelligence solution designed and developed in collaboration between the database group of the University of Modena and Reggio Emilia and eBilling, an Italian SME supplier of solutions for the design, production and automation of documentary processes for top Italian companies. eLog enables business managers to define OLAP reports by means of a web interface and to customize analysis indicators adopting a simple meta-language. The framework translates the user's reports into MDX queries and is able to automatically select the data cube suitable for each query. Over 140 medium and large companies have exploited the technological services of eBilling S.p.A. to manage their documents flows. In particular, eLog services have been used by the major media and telecommunications Italian companies and their foreign annex, such as Sky, Media set, H3G, Tim Brazil etc. The largest customer can provide up to 30 millions mail pieces within 6 months (about 200 GB of data in the relational DBMS). In a period of 18 months, eLog could reach 150 millions mail pieces (1 TB of data) to handle.

AB - The adoption of business intelligence technology in industries is growing rapidly. Business managers are not satisfied with ad hoc and static reports and they ask for more flexible and easy to use data analysis tools. Recently, application interfaces that expand the range of operations available to the user, hiding the underlying complexity, have been developed. The paper presents eLog, a business intelligence solution designed and developed in collaboration between the database group of the University of Modena and Reggio Emilia and eBilling, an Italian SME supplier of solutions for the design, production and automation of documentary processes for top Italian companies. eLog enables business managers to define OLAP reports by means of a web interface and to customize analysis indicators adopting a simple meta-language. The framework translates the user's reports into MDX queries and is able to automatically select the data cube suitable for each query. Over 140 medium and large companies have exploited the technological services of eBilling S.p.A. to manage their documents flows. In particular, eLog services have been used by the major media and telecommunications Italian companies and their foreign annex, such as Sky, Media set, H3G, Tim Brazil etc. The largest customer can provide up to 30 millions mail pieces within 6 months (about 200 GB of data in the relational DBMS). In a period of 18 months, eLog could reach 150 millions mail pieces (1 TB of data) to handle.

UR - http://www.scopus.com/inward/record.url?scp=84864205994&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84864205994&partnerID=8YFLogxK

U2 - 10.1109/ICDE.2012.100

DO - 10.1109/ICDE.2012.100

M3 - Article

AN - SCOPUS:84864205994

SP - 1417

EP - 1428

JO - JAPCA

JF - JAPCA

SN - 1073-161X

M1 - 6228210

ER -