Back to results
US 9,311,334 B2Granted
Geospatial database integration using business models
AssigneeInternational Business Machines Corporation
InventorsRonald L. Gagnier, Michael A. Iles, Steven R. McDougall, David J. Ridgeway, Craig A. Statchuk
Life of this patent
Estimating the term…
Abstract
A mechanism is provided for automatically performing join operations. Source data is received and a metadata model is received. The metadata model includes a hierarchical structure. The source data is aligned to the hierarchical structure in the metadata model to form a source data hierarchy. Based on the source data hierarchy, the source data is joined to geocoded information.
Claims24
A method comprising:
- receiving source data comprising one or more source data elements of a database, wherein at least one first category of the source data comprises respective source address information for each of the one or more source data elements and wherein at least one second category of the source data comprises respective entity information for each of the one or more source data elements;
- receiving target data comprising a geocoded information table that includes one or more target data elements, wherein at least one first category of the target data comprises respective geocode information for each of the one or more target data elements, the respective geocode information defining a respective geographic location for each of the one or more target data elements, and wherein at least one second category of the target data comprises respective census data for the respective geographic location for each of the one or more target data elements, wherein the target data is different from the source data;
- receiving a metadata model, wherein the metadata model defines a hierarchical structure of categories of the source data;
- aligning, by a computing device comprising one or more processors, the source data to the hierarchical structure defined in the metadata model to form a source data hierarchy;
- generating, by the computing device, for at least one source data element from the one or more source data elements, a query to obtain information from the at least one second category of the one or more target data elements based at least in part on (i) the respective source address information for the at least one source data element, (ii) the source data hierarchy, and (iii) the respective geocode information for each of the one or more target data elements;
- responsive to generating the query, joining, by the computing device, the at least one second category of the at least one source data element with the information from the at least one second category of the one or more target data elements to form a joined dataset, wherein the joined dataset comprises the at least one second category of the at least one source data element combined with the information from the at least one second category of the one or more target data elements;
- and
- generating, by the computing device and based at least in part on the joined dataset, a geospatial report.
5 more elements
A device comprising:
- a memory to store computer-executable instructions;
- and
- a processor coupled to the memory,
- wherein the processor, upon execution of the computer-executable instructions, performs operations to:
- receive source data comprising one or more source data elements of a database, wherein at least one first category of the source data comprises respective source address information for each of the one or more source data elements and wherein at least one second category of the source data comprises respective entity information for each of the one or more source data elements;
- receive target data comprising a geocoded information table that includes one or more target data elements, wherein at least one first category of the target data comprises respective geocode information for each of the one or more target data elements, the respective geocode information defining a respective geographic location for each of the one or more target data elements, and wherein at least one second category of the target data comprises respective census data for the respective geographic location for each of the one or more target data elements, wherein the target data is different from the source data;
- receive a metadata model, wherein the metadata model defines a hierarchical structure of categories of the source data;
- align the source data to the hierarchical structure defined in the metadata model to form a source data hierarchy;
- generate, for at least one source data element from the one or more source data elements, a query to obtain information from the at least one second category of the one or more target data elements based at least in part on (i) the respective source address information for the at least one source data element, (ii) the source data hierarchy, and (iii) the respective geocode information for each of the one or more target data elements;
- responsive to generating the query, join the at least one second category of the at least one source data element with the information from the at least one second category of the one or more target data elements to form a joined dataset, wherein the joined dataset comprises the at least one second category of the at least one source data element combined with the information from the at least one second category of the one or more target data elements;
- and
- generate, based at least in part on the joined dataset, a geospatial report.
9 more elements
A computer program product comprising:
- a non-transitory computer readable storage medium having program instructions stored thereon, the program instructions executable by at least one processor to cause the at least one processor to:
- receive source data comprising one or more source data elements of a database wherein at least one first category of the source data comprises respective source address information for each of the one or more source data elements and wherein at least one second category of the source data comprises respective entity information for each of the one or more source data elements;
- receive target data comprising a geocoded information table that includes one or more target data elements, wherein at least one first category of the target data comprises respective geocode information for each of the one or more target data elements, the respective geocode information defining a respective geographic location for each of the one or more target data elements, and wherein at least one second category of the target data comprises respective census data for the respective geographic location for each of the one or more target data elements, wherein the target data is different from the source data;
- receive a metadata model, wherein the metadata model defines a hierarchical structure of categories of the source data;
- align the source data to the hierarchical structure defined in the metadata model to form a source data hierarchy;
- generate, for at least one source data element from the one or more source data elements, a query to obtain information from the at least one second category of the one or more target data elements based at least in part on (i) the respective source address information for the at least one source data element, (ii) the source data hierarchy, and (iii) the respective geocode information for each of the one or more target data elements;
- join, responsive to generating the query, the at least one second category of the at least one source data element with the information from the at least one second category of the one or more target data elements to form a joined dataset, wherein the joined dataset comprises the at least one second category of the at least one source data element combined with the information from the at least one second category of the one or more target data elements;
- and
- generate, based at least in part on the joined dataset, a geospatial report.
6 more elements
Dependencies are inferred from the claim text.