Spatially integrated relational database model with dynamic segmentation (SIR-DBMS)

• US 20050209997A1
• Filed: 05/09/2005
• Published: 09/22/2005
• Est. Priority Date: 04/16/2001
• Status: Abandoned Application

• Current Assignee: Science Applications International Corporation
• Original Assignee: Science Applications International Corporation
• Inventors: Haas, Robert P., Robertson, Stephen H.
• Application Number:
  US11/124,129
• Publication Number:
  US 20050209997A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A method and system for providing an open database model that allows the combining of spatial and Attribute data in a single relational database. The integration of spatial and Attribute data allows the data to be accessed by either standard structured query language (SQL) or a GIS viewing application. The invention provides: enhanced performance by avoiding proliferation of segmentation; open dynamic segmentation; integrated temporal data; and automated database maintenance. Permanent anchor sections are provided to define spatial references. The data model allows for intersections in the interior of a link (anchor section), resulting in a more stable form of a link, or anchor section. The use of anchor sections simplifies maintenance of data associated with the anchor sections and facilitates the use of anchor sections in a distributed environment. Database views display data in a simple, tabular format. Access to a continuous archive of historical data is supported.

Claims

1-27. -27. (canceled)

28. A transportation information system, comprising:

at least one computing device having storage for data and computer code and capable of executing object oriented computer code;

a current data repository for storing current transportation network data and linear event data;

an historical data repository for storing historical transportation network data and linear event data;

a current data query program comprising computer code for querying the current data repository;

an historical data query program comprising computer code for querying the historical data repository;

a report generator comprising computer code for generating reports using data retrieved during a querying of a data repository;

a maintenance process comprising computer code for maintaining data in the historical data repository;

an anchor linear referencing system (LRS), the LRS having a collection of anchor sections, intersections, and anchored linear events, an anchor section being a defined data set representative of a linear portion of a transportation pathway, the anchored linear events comprising a set of properties and attributes further defining their qualities and relationships to elements in the transportation network, wherein the data defined by the LRM comprises the network of transportation pathways, and wherein intersections may be interior to an anchor section and defined by an offset from an end of an anchor section.

29. A system as recited in claim 28, wherein at least one anchor section connects two adjacent intersections.

30. A system as recited in claim 28, further comprising an optimized repository for query data, the optimized repository being generated by the maintenance process.

31. A system as recited in claim 28, wherein the computer code is object-oriented.

32. A system as recited in claim 28, wherein attributes and properties are associated with elements in the network and disjointed attributes of an anchor section are enabled.

33. A system as recited in claim 28, where the transportation network is a road network.

34. A system as recited in claim 28, where the transportation network is for waterway shipping lanes.