scholarly journals Metadata for Approximate Query Answering Systems

2012 ◽  
Vol 2012 ◽  
pp. 1-13 ◽  
Author(s):  
Francesco Di Tria ◽  
Ezio Lefons ◽  
Filippo Tangorra
Keyword(s):  
Data Warehouse ◽  
Business Intelligence ◽  
Query Answering ◽  
Approximate Query Processing ◽  
Web Based ◽  
Approximate Query Answering ◽  
Business Intelligence Systems ◽  
Approximate Query ◽  
Analytical Processing ◽  
The Common

In business intelligence systems, data warehouse metadata management and representation are getting more and more attention by vendors and designers. The standard language for the data warehouse metadata representation is the Common Warehouse Metamodel. However, business intelligence systems include also approximate query answering systems, since these software tools provide fast responses for decision making on the basis of approximate query processing. Currently, the standard meta-model does not allow to represent the metadata needed by approximate query answering systems. In this paper, we propose an extension of the standard metamodel, in order to define the metadata to be used in online approximate analytical processing. These metadata have been successfully adopted in ADAP, a web-based approximate query answering system that creates and uses statistical data profiles.

Data Warehouse and Business Intelligence Systems in the Context of E-HRM

2009 ◽  
pp. 223-229
Author(s):  
Martin Burgard ◽  
Franca Piazza
Keyword(s):  
Data Mining ◽  
Information Technology ◽  
Resource Management ◽  
Human Resource Management ◽  
Data Warehouse ◽  
Human Resource ◽  
Business Intelligence ◽  
Multidimensional Data ◽  
Business Intelligence Systems ◽  
Analytical Processing

The increased use of information technology leads to the generation of huge amounts of data which have to be stored and analyzed by appropriate systems. Data warehouse systems allow the storage of these data in a special multidimensional data base. Based on a data warehouse, business intelligence systems provide different analysis methods such as online analytical processing (OLAP) and data mining to analyze these data. Although these systems are already widely used and the usage is still growing, their application in the area of electronic human resource management (e-HRM) is rather scarce. Therefore, the objective of this article is to depict the components and functionality of these systems and to illustrate the application possibilities and benefits of these systems by selected application examples in the context of e-HRM.

Data Warehouse and Business Intelligence Systems in the Context of E-HRM

2011 ◽  
pp. 1013-1020
Author(s):  
Martin Burgard ◽  
Franca Piazza
Keyword(s):  
Data Mining ◽  
Information Technology ◽  
Resource Management ◽  
Human Resource Management ◽  
Data Warehouse ◽  
Human Resource ◽  
Business Intelligence ◽  
Multidimensional Data ◽  
Business Intelligence Systems ◽  
Analytical Processing

The increased use of information technology leads to the generation of huge amounts of data which have to be stored and analyzed by appropriate systems. Data warehouse systems allow the storage of these data in a special multidimensional data base. Based on a data warehouse, business intelligence systems provide different analysis methods such as online analytical processing (OLAP) and data mining to analyze these data. Although these systems are already widely used and the usage is still growing, their application in the area of electronic human resource management (e-HRM) is rather scarce. Therefore, the objective of this article is to depict the components and functionality of these systems and to illustrate the application possibilities and benefits of these systems by selected application examples in the context of e-HRM.

Evolutionary Intelligent Data Warehousing Approach to Knowledge Discovery Systems: Dynamic Cubing

2019 ◽  
Vol 13 ◽  
Author(s):  
Harkiran Kaur ◽  
Kawaljeet Singh ◽  
Tejinder Kaur
Keyword(s):  
Knowledge Discovery ◽  
Data Warehouse ◽  
Business Intelligence ◽  
End Users ◽  
Processing Stage ◽  
Information Update ◽  
On Line ◽  
Analytical Processing ◽  
Warehouse Operations ◽  
Made In

Background: Numerous E – Migrants databases assist the migrants to locate their peers in various countries; hence contributing largely in communication of migrants, staying overseas. Presently, these traditional E – Migrants databases face the issues of non – scalability, difficult search mechanisms and burdensome information update routines. Furthermore, analysis of migrants’ profiles in these databases has remained unhandled till date and hence do not generate any knowledge. Objective: To design and develop an efficient and multidimensional knowledge discovery framework for E - Migrants databases. Method: In the proposed technique, results of complex calculations related to most probable On-Line Analytical Processing operations required by end users, are stored in the form of Decision Trees, at the pre- processing stage of data analysis. While browsing the Cube, these pre-computed results are called; thus offering Dynamic Cubing feature to end users at runtime. This data-tuning step reduces the query processing time and increases efficiency of required data warehouse operations. Results: Experiments conducted with Data Warehouse of around 1000 migrants’ profiles confirm the knowledge discovery power of this proposal. Using the proposed methodology, authors have designed a framework efficient enough to incorporate the amendments made in the E – Migrants Data Warehouse systems on regular intervals, which was totally missing in the traditional E – Migrants databases. Conclusion: The proposed methodology facilitate migrants to generate dynamic knowledge and visualize it in the form of dynamic cubes. Applying Business Intelligence mechanisms, blending it with tuned OLAP operations, the authors have managed to transform traditional datasets into intelligent migrants Data Warehouse.

Data Warehouse Maintenance, Evolution and Versioning

2010 ◽  
pp. 171-188 ◽  
Author(s):  
Johann Eder ◽  
Karl Wiggisser
Keyword(s):  
Decision Support ◽  
Data Warehouse ◽  
Building Blocks ◽  
Data Warehouses ◽  
Master Data ◽  
Analytical Processing ◽  
The Common ◽  
Instance Analysis ◽  
Transactional Data ◽  
Common Understanding

Data Warehouses typically are building blocks of decision support systems in companies and public administration. The data contained in a data warehouse is analyzed by means of OnLine Analytical Processing tools, which provide sophisticated features for aggregating and comparing data. Decision support applications depend on the reliability and accuracy of the contained data. Typically, a data warehouse does not only comprise the current snapshot data but also historical data to enable, for instance, analysis over several years. And, as we live in a changing world, one criterion for the reliability and accuracy of the results of such long period queries is their comparability. Whereas data warehouse systems are well prepared for changes in the transactional data, they are, surprisingly, not able to deal with changes in the master data. Nonetheless, such changes do frequently occur. The crucial point for supporting changes is, first of all, being aware of their existence. Second, once you know that a change took place, it is important to know which change (i.e., knowing about differences between versions and relations between the elements of different versions). For data warehouses this means that changes are identified and represented, validity of data and structures are recorded and this knowledge is used for computing correct results for OLAP queries. This chapter is intended to motivate the need for powerful maintenance mechanisms for data warehouse cubes. It presents some basic terms and definitions for the common understanding and introduces the different aspects of data warehouse maintenance. Furthermore, several approaches addressing the problem are presented and classified by their capabilities.

Approximate Query Answering with Knowledge Hierarchy

2010 ◽  
pp. 189-203
Author(s):  
Wookey Lee ◽  
Myung-Keun Shin ◽  
Soon Young Huh ◽  
Donghyun Park ◽  
Jumi Kim
Keyword(s):  
Cost Model ◽  
Numerical Data ◽  
Query Answering ◽  
Query Relaxation ◽  
Approximate Query Answering ◽  
Novel Method ◽  
Approximate Query ◽  
Semantic Distances ◽  
Ranking Measures ◽  
Knowledge Hierarchy

Approximate Query Answering is important for incorporating knowledge abstraction and query relaxation in terms of the categorical and the numerical data. By exploiting the knowledge hierarchy, a novel method is addressed to quantify the semantic distances between the categorical information as well as the numerical data. Regarding that, an efficient query relaxation algorithm is devised to modify the approximate queries to ordinary queries based on the knowledge hierarchy. Then the ranking measures work very efficiently to cope with various combinations of complex queries with respect to the number of nodes in the hierarchy as well as the corresponding cost model.

The Aqua approximate query answering system

1999 ◽  
Vol 28 (2) ◽  
pp. 574-576 ◽  
Author(s):  
Swarup Acharya ◽  
Phillip B. Gibbons ◽  
Viswanath Poosala ◽  
Sridhar Ramaswamy
Keyword(s):  
Query Answering ◽  
Approximate Query Answering ◽  
Approximate Query

scholarly journals Approximate Query Answering Based on Topological Neighborhood and Semantic Similarity in OpenStreetMap

IEEE Access ◽  
2020 ◽  
Vol 8 ◽  
pp. 87011-87030
Author(s):  
Anna Formica ◽  
Mauro Mazzei ◽  
Elaheh Pourabbas ◽  
Maurizio Rafanelli
Keyword(s):  
Semantic Similarity ◽  
Query Answering ◽  
Approximate Query Answering ◽  
Approximate Query
Sign in / Sign up

Export Citation Format

Share Document