Academic
Publications
How Does the Spatial Data Redundancy Affect Query Performance in Geographic Data Warehouses?

How Does the Spatial Data Redundancy Affect Query Performance in Geographic Data Warehouses?,Rodrigo Costa Mateus,Thiago Luís Lopes Siqueira,Valéria C

How Does the Spatial Data Redundancy Affect Query Performance in Geographic Data Warehouses?   (Citations: 3)
BibTex | RIS | RefWorks Download
Published in 2010.
Cumulative Annual
View Publication
The following links allow you to view full publications. These links are maintained by other sources not affiliated with Microsoft Academic Search.
    • ...Differently from a conventional DW, a SDW stores spatial data as specific attributes in dimension tables or as measures in fact tables [1, 2, 4, 8, 9]. Therefore, instead of storing alphanumeric values for regions, nations, cities and addresses, a spatial dimension table Supplier represents the values of its geographic attributes region_geo, nation_geo, city_geo Geoinformatica...

    Thiago Luís Lopes Siqueiraet al. The SB-index and the HSB-index: efficient indices for spatial data war...

    • ...Moreover, the chosen representation for spatial objects and the inclusion of the spatial attribute together with or separate from the conventional dimension table affect query processing in GDW (Mateus et al., 2010)...
    • ...Previous works identified that spatial data redundancy is associated to greater storage requirements and low query processing performance (Siqueira et al. 2009; Mateus et al., 2010)...
    • ...tion of data across multiple processors to enable parallel processing (Furtado 2004); (iv) the use of index structures (Siqueira et al., 2009); and (v) the design of efficient data schemas to reduce query response times and minimize data storage costs (Siqueira et al., 2009; Mateus et al. 2010)...
    • ...Regarding the design of data schemas, Mateus et al. (2010) examined the impact of using crisp points in the lower level of granularity, which contains the greatest amount of spatial objects...
    • ...4). This performance gain is very similar to the findings of Mateus et al. (2010) for crisp spatial locations...

    Thiago Luís Lopes Siqueiraet al. Querying Vague Spatial Information in Geographic Data Warehouses

    • ...Furthermore, differently from the conventional star schema, spatial attributes are not stored redundantly [13,6]...
    • ...Mateus et al. [6] argue that conventional and spatial Efficient Processing of Drill-across Queries over GDWs 155...
    • ...Therefore, in GDWs, materialized views maintain foreign keys to join spatial dimension tables [13,6]...

    Jaqueline Joice Britoet al. Efficient Processing of Drill-across Queries over Geographic Data Ware...

Sort by: