We found a match
Your institution may have access to this item. Find your institution then sign in to continue.
- Title
FROM GIS DATABASE TO SPATIAL DATA WAREHOUSE.
- Authors
BORZA, Sorin
- Abstract
The research described in this paper combine a geographical information system (GIS) with a database management system, to determinate near optimal storage location in Data Warehouse. The first section provides an introduction to the field of spatial databases and data warehouses by presenting some definitions of this notion, characteristics and objectives. Section two presents specific data models for data warehouses, which are diagrams showing the design used in data warehouse and also presents concepts of cube, dimension hierarchies and OLAP operations. The third, is the design scheme of a data warehouse, followed by building the data warehouse using Oracle Warehouse Builder 10g, analyzing all the steps needed for this. We define a geographical data cube. In the four section we discuss about query language for retrieving data stored in data warehouse. Here, the fact table attributes consist of measures and a spatial measure is seen as geometry or function.
- Subjects
GEOGRAPHIC information systems; DATA warehousing; DATABASE management; QUERY languages (Computer science); INFORMATION storage &; retrieval systems
- Publication
Academic Journal of Manufacturing Engineering, 2015, Vol 13, Issue 2, p136
- ISSN
1583-7904
- Publication type
Article