English (United Kingdom)

https://curated-unify.zendy.io/wp-json/zendy-region/v1/featured_content/oa?rat=en

https://curated-unify.zendy.io/wp-json/zendy-region/v1/highlighted_journal/

Global: Zendy Tools annual

Presents the keyphrase highlighting as premium feature

Keyphrase Highlighting

Presents the summarisation as premium feature

Summarisation

Insights

Presents the pdf analysis as premium feature

PDF Analysis

Presents the zaia usage as premium feature

ZAIA

Global: Zendy Tools monthly

Global: Zendy Plus monthly

Presents the access of premium content as premium feature

Premium Content

Global: Zendy Plus annual

Global: Zendy Free Plan

Utility network analysis is an established area of research in Geographic Information Science (GIS), but it is yet to feature in a Business Intelligence (BI) environment. Inclusion of this capability in BI can be achieved by modelling a utility network as a star schema. Star schema, which is a well-known data model used in data warehousing for BI solutions, organizes data into several fact tables referencing one or more dimension tables. This simplifies joins to provide fast execution of queries. Furthermore, star schema enables the analysis of data from multiple angles (slicing and dicing). However, modelling spatial data as star schema is still in its infancy for two main reasons, (a) only very recently have researchers started appreciating the importance of GIS capabilities in BI, (b) specific challenges associated with introducing geometry data with complex topological relationships into star schema. In this paper, we present a star schema to model geometric utility networks such as electricity, water and sewer systems. Our schema provides two-way benefits; it brings in an important new capability to BI in terms of spatial data analysis, and it gives non-technical users an opportunity carry out complex utility network analysis in an easy-to-use BI environment. Finally, we present an application of the star schema in service vulnerability assessment for electricity networks.

A Star Schema for Utility Network Analysis and Visualisation in a Geo-Business Intelligence Environment