A Load-on-Demand Approach to Handling Large Networks in the Oracle Spatial Network Data Model
Network modeling, management, and analysis are common tasks for enterprise applications such as Geographic Information System (GIS), Customer Relationship Management (CRM), social network analysis, and in semantic web technologies such as the Resource Description Framework (RDF). Oracle10g introduced the Oracle Spatial Network Data Model (NDM), which lets users model and analyze networks. In Oracle10g, NDM uses an in-memory approach to pre-load the whole network into memory before analysis; however, this approach cannot handle networks that are too large to fit in memory. To address this scalability issue, the paper developed a Load-On-Demand approach (LOD) in Oracle11g. Large networks are first divided into manageable parts called network partitions. Only partitions that are needed are automatically loaded during analysis.