Faceted Search in Business Intelligence on the Cloud

Research output: Chapter in Book/Report/Conference proceedingConference contribution

5 Citations (Scopus)

Abstract

Faceted search is a new concept in search engines for implementing a feature of direct search queries using guided navigation among the search results. In this concept, the search results are grouped and ranked under facets that guide a user on the dimensions through which the search results can be viewed. It has been implemented on web based query systems by integrating with semantic search engines (like Google, Yahoo and Bing). However, there is a significant opportunity of implementing faceted search in business intelligence (BI) frameworks to include direct searching features through BI dashboards and custom reporting interfaces. In this paper, a technology positioning map for implementing faceted search in BI framework on cloud computing has been presented. BI on the cloud is based on massively parallel processing of hardware and database resources and an XML based service oriented architecture in which the data warehouses and OLAP cubes are formed using XML data files. The architecture has been expanded to include a DOM parser and a DTD mapping system that will parse the 2D XML views (pulled from cubes formed by many-to-many XML files) and extract the database fields to be stored in a facet repository as per pre-established metadata rules. Whenever an OLAP query is invoked by a user (using a decision map), a query coordinator will fetch the relevant 2D OLAP views and group them under facets fetched from the facet repository taking the services of a metadata coordinator. The user can make use of the facets to create direct queries, generate the targeted dashboards, and hence reduce searching time.
LanguageEnglish
Title of host publication2013 IEEE International Conference on Green Computing and Communications (GreenCom) and IEEE Internet of Things (iThings), and IEEE Cyber, Physical and Social Computing (CPSCom 2013)
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages842-849
Number of pages8
ISBN (Print)9780769550466
DOIs
Publication statusPublished - 12 Dec 2013
Externally publishedYes
EventIEEE International Conference on Green Computing and Communications - Beijing, China
Duration: 20 Aug 201323 Aug 2013

Conference

ConferenceIEEE International Conference on Green Computing and Communications
CountryChina
CityBeijing
Period20/08/1323/08/13

Fingerprint

Competitive intelligence
XML
Search engines
Metadata
Data warehouses
Service oriented architecture (SOA)
Cloud computing
World Wide Web
Navigation
Semantics
Hardware
Processing

Cite this

Al-Aqrabi, H., Liu, L., Hill, R., & Cui, L. (2013). Faceted Search in Business Intelligence on the Cloud. In 2013 IEEE International Conference on Green Computing and Communications (GreenCom) and IEEE Internet of Things (iThings), and IEEE Cyber, Physical and Social Computing (CPSCom 2013) (pp. 842-849). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/GreenCom-iThings-CPSCom.2013.148
Al-Aqrabi, Hussain ; Liu, Lu ; Hill, Richard ; Cui, Lei. / Faceted Search in Business Intelligence on the Cloud. 2013 IEEE International Conference on Green Computing and Communications (GreenCom) and IEEE Internet of Things (iThings), and IEEE Cyber, Physical and Social Computing (CPSCom 2013). Institute of Electrical and Electronics Engineers Inc., 2013. pp. 842-849
@inproceedings{4dae861d3c194e76a9fb3cde29c46df0,
title = "Faceted Search in Business Intelligence on the Cloud",
abstract = "Faceted search is a new concept in search engines for implementing a feature of direct search queries using guided navigation among the search results. In this concept, the search results are grouped and ranked under facets that guide a user on the dimensions through which the search results can be viewed. It has been implemented on web based query systems by integrating with semantic search engines (like Google, Yahoo and Bing). However, there is a significant opportunity of implementing faceted search in business intelligence (BI) frameworks to include direct searching features through BI dashboards and custom reporting interfaces. In this paper, a technology positioning map for implementing faceted search in BI framework on cloud computing has been presented. BI on the cloud is based on massively parallel processing of hardware and database resources and an XML based service oriented architecture in which the data warehouses and OLAP cubes are formed using XML data files. The architecture has been expanded to include a DOM parser and a DTD mapping system that will parse the 2D XML views (pulled from cubes formed by many-to-many XML files) and extract the database fields to be stored in a facet repository as per pre-established metadata rules. Whenever an OLAP query is invoked by a user (using a decision map), a query coordinator will fetch the relevant 2D OLAP views and group them under facets fetched from the facet repository taking the services of a metadata coordinator. The user can make use of the facets to create direct queries, generate the targeted dashboards, and hence reduce searching time.",
keywords = "Business intelligence, Cloud computing, Data files, Faceted search, OLAP, OLAP cubes, XML, XML DOM parsing, XML data warehouse",
author = "Hussain Al-Aqrabi and Lu Liu and Richard Hill and Lei Cui",
year = "2013",
month = "12",
day = "12",
doi = "10.1109/GreenCom-iThings-CPSCom.2013.148",
language = "English",
isbn = "9780769550466",
pages = "842--849",
booktitle = "2013 IEEE International Conference on Green Computing and Communications (GreenCom) and IEEE Internet of Things (iThings), and IEEE Cyber, Physical and Social Computing (CPSCom 2013)",
publisher = "Institute of Electrical and Electronics Engineers Inc.",
address = "United States",

}

Al-Aqrabi, H, Liu, L, Hill, R & Cui, L 2013, Faceted Search in Business Intelligence on the Cloud. in 2013 IEEE International Conference on Green Computing and Communications (GreenCom) and IEEE Internet of Things (iThings), and IEEE Cyber, Physical and Social Computing (CPSCom 2013). Institute of Electrical and Electronics Engineers Inc., pp. 842-849, IEEE International Conference on Green Computing and Communications, Beijing, China, 20/08/13. https://doi.org/10.1109/GreenCom-iThings-CPSCom.2013.148

Faceted Search in Business Intelligence on the Cloud. / Al-Aqrabi, Hussain; Liu, Lu; Hill, Richard; Cui, Lei.

2013 IEEE International Conference on Green Computing and Communications (GreenCom) and IEEE Internet of Things (iThings), and IEEE Cyber, Physical and Social Computing (CPSCom 2013). Institute of Electrical and Electronics Engineers Inc., 2013. p. 842-849.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

TY - GEN

T1 - Faceted Search in Business Intelligence on the Cloud

AU - Al-Aqrabi, Hussain

AU - Liu, Lu

AU - Hill, Richard

AU - Cui, Lei

PY - 2013/12/12

Y1 - 2013/12/12

N2 - Faceted search is a new concept in search engines for implementing a feature of direct search queries using guided navigation among the search results. In this concept, the search results are grouped and ranked under facets that guide a user on the dimensions through which the search results can be viewed. It has been implemented on web based query systems by integrating with semantic search engines (like Google, Yahoo and Bing). However, there is a significant opportunity of implementing faceted search in business intelligence (BI) frameworks to include direct searching features through BI dashboards and custom reporting interfaces. In this paper, a technology positioning map for implementing faceted search in BI framework on cloud computing has been presented. BI on the cloud is based on massively parallel processing of hardware and database resources and an XML based service oriented architecture in which the data warehouses and OLAP cubes are formed using XML data files. The architecture has been expanded to include a DOM parser and a DTD mapping system that will parse the 2D XML views (pulled from cubes formed by many-to-many XML files) and extract the database fields to be stored in a facet repository as per pre-established metadata rules. Whenever an OLAP query is invoked by a user (using a decision map), a query coordinator will fetch the relevant 2D OLAP views and group them under facets fetched from the facet repository taking the services of a metadata coordinator. The user can make use of the facets to create direct queries, generate the targeted dashboards, and hence reduce searching time.

AB - Faceted search is a new concept in search engines for implementing a feature of direct search queries using guided navigation among the search results. In this concept, the search results are grouped and ranked under facets that guide a user on the dimensions through which the search results can be viewed. It has been implemented on web based query systems by integrating with semantic search engines (like Google, Yahoo and Bing). However, there is a significant opportunity of implementing faceted search in business intelligence (BI) frameworks to include direct searching features through BI dashboards and custom reporting interfaces. In this paper, a technology positioning map for implementing faceted search in BI framework on cloud computing has been presented. BI on the cloud is based on massively parallel processing of hardware and database resources and an XML based service oriented architecture in which the data warehouses and OLAP cubes are formed using XML data files. The architecture has been expanded to include a DOM parser and a DTD mapping system that will parse the 2D XML views (pulled from cubes formed by many-to-many XML files) and extract the database fields to be stored in a facet repository as per pre-established metadata rules. Whenever an OLAP query is invoked by a user (using a decision map), a query coordinator will fetch the relevant 2D OLAP views and group them under facets fetched from the facet repository taking the services of a metadata coordinator. The user can make use of the facets to create direct queries, generate the targeted dashboards, and hence reduce searching time.

KW - Business intelligence

KW - Cloud computing

KW - Data files

KW - Faceted search

KW - OLAP

KW - OLAP cubes

KW - XML

KW - XML DOM parsing

KW - XML data warehouse

U2 - 10.1109/GreenCom-iThings-CPSCom.2013.148

DO - 10.1109/GreenCom-iThings-CPSCom.2013.148

M3 - Conference contribution

SN - 9780769550466

SP - 842

EP - 849

BT - 2013 IEEE International Conference on Green Computing and Communications (GreenCom) and IEEE Internet of Things (iThings), and IEEE Cyber, Physical and Social Computing (CPSCom 2013)

PB - Institute of Electrical and Electronics Engineers Inc.

ER -

Al-Aqrabi H, Liu L, Hill R, Cui L. Faceted Search in Business Intelligence on the Cloud. In 2013 IEEE International Conference on Green Computing and Communications (GreenCom) and IEEE Internet of Things (iThings), and IEEE Cyber, Physical and Social Computing (CPSCom 2013). Institute of Electrical and Electronics Engineers Inc. 2013. p. 842-849 https://doi.org/10.1109/GreenCom-iThings-CPSCom.2013.148