A foundation for capturing and querying complex multidimensional data

Pedersen, Torben Bach; Jensen, Christian S.; Dyreson, Curtis E.

doi:10.1016/s0306-4379(01)00023-0

Cited by 211 publications

(220 citation statements)

References 29 publications

Supporting

Mentioning

206

Contrasting

Unclassified

Order By: Relevance

“…A hierarchy is said to be non-strict when a child of a given level can have more than a parent of the superior level [11,15].…”

Section: 1! Complex Hierarchiesmentioning

confidence: 99%

“…A hierarchy is said to be non-covering if a dimension value can have no direct upper parent [11,15]. The complex hierarchies cause summarizability issues [13,10] i.e.…”

Section: 1! Complex Hierarchiesmentioning

confidence: 99%

“…This approach requires the modification of the fact-dimension instances. Pederson and al were the first to propose a solution for this perspective [15] . Three algorithms were thus proposed, Makecover which is responsible for making the covered data.…”

Section: ! Related Workmentioning

confidence: 99%

See 2 more Smart Citations

Document-Oriented Data Warehouses: Complex Hierarchies and Summarizability

Chevalier

Malki

Kopliku

et al. 2016

Lecture Notes in Electrical Engineering

View full text Add to dashboard Cite

show abstract

“…A hierarchy is said to be non-strict when a child of a given level can have more than a parent of the superior level [11,15].…”

Section: 1! Complex Hierarchiesmentioning

confidence: 99%

“…A hierarchy is said to be non-covering if a dimension value can have no direct upper parent [11,15]. The complex hierarchies cause summarizability issues [13,10] i.e.…”

Section: 1! Complex Hierarchiesmentioning

confidence: 99%

See 1 more Smart Citation

Document-Oriented Data Warehouses: Complex Hierarchies and Summarizability

Chevalier

Malki

Kopliku

et al. 2016

Lecture Notes in Electrical Engineering

View full text Add to dashboard Cite

show abstract

“…[19] and Pedersen et.al. [20]. Though many of these models aid in the relational representation of aggregate data, contributions like the ALL operator and hierarchies are essential even from a multidimensional perspective.…”

Section: Related Workmentioning

confidence: 99%

On the Requirements for User-Centric Spatial Data Warehousing and SOLAP

Viswanathan

Schneider

2011

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract. Data warehouses and OLAP systems help to analyze complex multidimensional data and provide decision support. With the availability of large amounts of spatial data in recent years, several new models have been proposed to enable the integration of spatial data in data warehouses and to help analyze such data. This is often achieved by a combination of GIS and spatial analysis tools with OLAP and database systems, with the primary goal of supporting spatial analysis dimensions, spatial measures and spatial aggregation operations. However, this poses several new challenges related to spatial data modeling in a multidimensional context, such as the need for new spatial aggregation operations and ensuring consistent and valid results. In this paper, we review the existing modeling strategies for spatial data warehouses and SOLAP in all three levels: conceptual, logical and implementation. While studying these models, we gather the most essential requirements for handling spatial data in data warehouses and use insights from spatial databases to provide a "meta-framework" for modeling spatial data warehouses. This strategy keeps the user as the focal point and achieves a clear abstraction of the data for all stakeholders in the system. Our goal is to make analysis more user-friendly and pave the way for a clear conceptual model that defines new multidimensional abstract data types (ADTs) and operations to support spatial data in data warehouses.

show abstract

“…We presented a conceptual, user-centric approach to data warehouse design called the BigC ube model in [3]. Several other models have also been proposed to conceptually model a data warehouse using a cube metaphor as surveyed and extended in [11,12]. Moving objects, their formal data type characterizations and operations have been introduced in [13,14].…”

Section: Related Workmentioning

confidence: 99%

The Objects Interaction Graticule for Cardinal Direction Querying in Moving Objects Data Warehouses

Viswanathan

Schneider

2010

Advances in Databases and Information Systems

View full text Add to dashboard Cite

Abstract. Cardinal directions have turned out to be very important qualitative spatial relations due to their numerous applications in spatial wayfinding, GIS, qualitative spatial reasoning and in domains such as cognitive sciences, AI and robotics. They are frequently used as selection criteria in spatial queries. Moving objects data warehouses can help to analyze complex multidimensional data of a spatio-temporal nature and to provide decision support. However, currently there is no available method to query for cardinal directions between spatio-temporal objects in data warehouses. In this paper, we introduce the concept of a moving objects data warehouse (MODW) for storing and querying multidimensional spatio-temporal data. Further, we also present a novel two-phase approach to model and query for cardinal directions between moving objects by using the MODW framework. First, we apply a tiling strategy that determines the zone belonging to the nine cardinal directions of each spatial object at a particular time and then intersects them. This leads to a collection of grids over time called the Objects Interaction Graticule (OIG). For each grid cell, the information about the spatial objects that intersect it is stored in an Objects Interaction Matrix. In the second phase, an interpretation method is applied to these matrices to determine the cardinal direction between the moving objects. These results are integrated into MDX queries using directional predicates.

show abstract

A foundation for capturing and querying complex multidimensional data

Cited by 211 publications

References 29 publications

Document-Oriented Data Warehouses: Complex Hierarchies and Summarizability

Document-Oriented Data Warehouses: Complex Hierarchies and Summarizability

On the Requirements for User-Centric Spatial Data Warehousing and SOLAP

The Objects Interaction Graticule for Cardinal Direction Querying in Moving Objects Data Warehouses

Contact Info

Product

Resources

About