Filters








5,826 Hits in 3.6 sec

Spatial hierarchy and OLAP-favored search in spatial data warehouse

Fangyan Rao, Long Zhang, Xiu Lan Yu, Ying Li, Ying Chen
2003 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP - DOLAP '03  
pre-aggregation and materialization in data warehouse.  ...  To process spatial OLAP query in spatial data warehouse, we propose an OLAPfavored search method which can utilize the pre-aggregation result in spatial data warehouse to improve the performance of spatial  ...  Figure 1: Star Schema in Data Warehouse In the data warehouse there are four dimension tables: Station, Gas, Vehicle and Time. The Station table is the spatial dimension in the data warehouse.  ... 
doi:10.1145/956069.956070 fatcat:qv5rcvewvnhnnjwrdwptgvr5a4

Spatial hierarchy and OLAP-favored search in spatial data warehouse

Fangyan Rao, Long Zhang, Xiu Lan Yu, Ying Li, Ying Chen
2003 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP - DOLAP '03  
pre-aggregation and materialization in data warehouse.  ...  To process spatial OLAP query in spatial data warehouse, we propose an OLAPfavored search method which can utilize the pre-aggregation result in spatial data warehouse to improve the performance of spatial  ...  Figure 1: Star Schema in Data Warehouse In the data warehouse there are four dimension tables: Station, Gas, Vehicle and Time. The Station table is the spatial dimension in the data warehouse.  ... 
doi:10.1145/956060.956070 dblp:conf/dolap/RaoZYLC03 fatcat:p7t3mlp2ybcdvb6tcme7r4lm5a

Efficient OLAP Operations in Spatial Data Warehouses [chapter]

Dimitris Papadias, Panos Kalnis, Jun Zhang, Yufei Tao
2001 Lecture Notes in Computer Science  
Driven by the non-spatial paradigm, spatial data warehouses can be constructed to accelerate spatial OLAP operations. In this paper we consider the star-schema and we focus on the spatial dimensions.  ...  Unlike the non-spatial case, the groupings and the hierarchies can be numerous and unknown at design time, therefore the wellknown materialization techniques are not directly applicable.  ...  In analogy to the non-spatial case, a spatial data warehouse can be considered, which supports OLAP operations on both spatial and non-spatial data. Han et. al.  ... 
doi:10.1007/3-540-47724-1_23 fatcat:ro7j5bbarbd53m5bz42qvdx25i

An Approach to Enabling Spatial OLAP by Aggregating on Spatial Hierarchy [chapter]

Long Zhang, Ying Li, Fangyan Rao, Xiulan Yu, Ying Chen, Dong Liu
2003 Lecture Notes in Computer Science  
A spatial index mechanism is employed to derive the spatial hierarchy for pre-aggregation and materialization, which in turn are leveraged by the OLAP system to efficiently answer spatial OLAP queries.  ...  Investigation shows that a huge number of spatial data exists in current business databases.  ...  [9, 14] are the first ones to propose a framework for spatial data warehouses.  ... 
doi:10.1007/978-3-540-45228-7_5 fatcat:3s67y7dhhnd7hg4hqmfpvrrskm

Towards a Novel OLAP Interface for Distributed Data Warehouses [chapter]

Ayman Ammoura, Osmar Zaïane, Randy Goebel
2001 Lecture Notes in Computer Science  
To support large sets of data while maintaining an interactive frame rate we propose the VOLAP-tree.  ...  We present a framework for visualizing remote distributed data sources using a multi-user immersive virtual reality environment.  ...  DIVE-ON constructs a virtual data warehouse from a set of distributed DBMS systems.  ... 
doi:10.1007/3-540-44801-2_18 fatcat:a4asyk4cl5fwvouqxfyk3sgcvy

On-Line Analysis of Utility Networks [chapter]

Zdeněk Kouba, Kamil Matoušek, Petr Mikšovský
2002 Knowledge and Technology Integration in Production and Services  
The data warehouse contains materialized views on geographical data.  ...  Its drawbacks are the spatial queries that are computationally very demanding. Therefore GIS integrated together with a data warehouse technologies profit from each other.  ... 
doi:10.1007/978-0-387-35613-6_53 fatcat:kfbrhr74rbcirl5byto4mzuyjq

A Data Management Model for Intelligent Water Project Construction Based on Blockchain

Zhoukai Wang, Kening Wang, Yichuan Wang, Zheng Wen, Qingqi Pei
2022 Wireless Communications and Mobile Computing  
Then, a distributed blockchain data structure for storing the production-related files is designed according to the model and strategy.  ...  The engineering construction-related data is essential for evaluating and tracing project quality in industry 4.0.  ...  Acknowledgments This research work is supported by the National Natural Science Funds of China (62072368), Basic Research in Natural Science and Enterprise Joint Fund of Shaanxi (2021JLM-58), and Special  ... 
doi:10.1155/2022/8482415 fatcat:oyg2sw462fh7zp3hawvfzzstwq

A comparative study analysis of materialized view for selection cost

T Nalini
2012 International Journal of Computer Science & Engineering Survey  
Materialized view selection is one of the most crucial techniques to design data warehouse in an optimal manner.  ...  Selecting views to materialize for the purpose of supporting the decision making efficiently is one of the most significant decisions in designing Data Warehouse.  ...  Again no. of items are reduced using multiple Materialized views in a Data Warehouse, IEEE, 2005. constraints, it will stored in M-tree structure. Comparing 8. Bogdan Czejdo, 2002.  ... 
doi:10.5121/ijcses.2012.3102 fatcat:pkvrynik7zdjhem54winznjn7e

An Effective Method to Answer OLAP Queries using R*-trees in Distributed Environment

F. SagayarajFrancis, P. Xavier
2014 International Journal of Computer Applications  
This paper proposes a method in a Hadoop and MapReduce distributed environment. Experimental evaluation gives improved results due to the proposed method.  ...  Evaluation of OLAP queries is one of the challenging tasks in a database system. Attempts are being continuously made to improve the efficiency of the methods that answer OLAP queries.  ...  The data in the data warehouses are modelled as structures generally referred as star schema and snowflake schema.  ... 
doi:10.5120/18859-0474 fatcat:3ypmmh6xanddngz426xldesevm

Data Mining [chapter]

2017 Encyclopedia of GIS  
Usually, regression analysis, generalized linear model, correlation analysis and decision trees are useful tools in quality prediction.  ...  With the construction of large data warehouses, data mining in data warehouse is one step beyond on-line analytic processing (OLAP) of data warehouse data 2].  ... 
doi:10.1007/978-3-319-17885-1_100249 fatcat:zjof3kzpzbcy5dsvfkhwd7cgw4

Evaluation of Top-k OLAP Queries Using Aggregate R–Trees [chapter]

Nikos Mamoulis, Spiridon Bakiras, Panos Kalnis
2005 Lecture Notes in Computer Science  
Such queries may also be applied in a spatial database context, where objects are augmented with some measures that must be aggregated according to a spatial division.  ...  For this, we make use of spatial indexes, augmented with aggregate information, like the aggregate R-tree.  ...  Overall, our method is very efficient when either the data points or the measures are skewed, a realistic case especially in spatial data warehouses (since most real spatial data are skewed by nature).  ... 
doi:10.1007/11535331_14 fatcat:rfbr2lvlpvajpm5uinfzfw4uli

Design and Key Technology of Gardening Information Management System Based on Data Center

Xi-Guang Wang, Wei-Hua Lin, Wen Zeng
2010 Journal of Geographic Information System  
This system greatly helps the daily management and plays very important role in improving urban ecological environment and investment environment. Figure 1.  ...  It also proposed to flexibly and smartly build up the system by using the secondary development design environment and running environment based on data center integration development platform.  ...  In addition to basic spatial data and urban RS image information, there are lots of other spatial data, such as, water resources, meteorology, ecology, pests and diseases.  ... 
doi:10.4236/jgis.2010.22015 fatcat:t6gsjnlfnfbybeqezskywb6zue

Spatial Datawarehousing [chapter]

Alejandro A. Vaisman, Esteban Zimányi
2017 Encyclopedia of Database Systems  
The following are just a few of the fields and challenges, which drive current and future research in data warehousing. Spatial data warehousing.  ...  Spatial data and spatio-temporal data are inherently more complex than traditional (alphanumerical) business data.  ...  Similar to materialized views in traditional data warehouses, to efficiently support analytical queries, it is necessary to materialize (that is, pre-compute) aggregated spatial data.  ... 
doi:10.1007/978-1-4899-7993-3_80810-1 fatcat:7yo63qvmhfadzn5vwn2x7bizku

Data Warehousing and Knowledge Discovery: A Chronological View of Research Challenges [chapter]

Tho Manh Nguyen, A Min Tjoa, Juan Trujillo
2005 Lecture Notes in Computer Science  
In the early 2000 the research community gradually solve the most basic issues in data warehouse design, materialized view maintenance and selection, OLAP query design and evolution.  ...  The most commonly used techniques in data mining and knowledge discovery in the late 1980s and early 1990s are artificial neural networks, decision trees, genetic algorithms, nearest neighbourhood, and  ... 
doi:10.1007/11546849_52 fatcat:sdcervokrzasvanqlcnbp4jsp4

Dynamic cubing for hierarchical multidimensional data space

Usman Ahmed, Anne Tchounikine, Maryvonne Miquel
2014 Journal of Decision Systems  
In [Papadias 2001] , authors propose an R-Tree based indexing structure for spatial data warehouses, called aggregation tree (aR-Tree).  ...  The materialization of views is achieved through data grouping structures that are stored and indexed in a tree like structure.  ...  Our prototype supports data visualization for a 3-dimensional data space and any 3 dimensions of a higher dimensional data can be selected to visualize data and tree nodes.  ... 
doi:10.1080/12460125.2014.940241 fatcat:3bwxerc4urbujhwldvrujybtre
« Previous Showing results 1 — 15 out of 5,826 results