IP Library Granted Patent US 11,037,250
Granted Patent B1
US 11,037,250 · App. 16/373,509 · Granted Jun 15, 2021

Custom data

Inventors: John Lorne Campbell Seybold (Aspen, CO); Eugene Lee (Albany, CA)
Assignee: Guidewire Software, Inc.
G06Q40/08
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,037,250
App. No.
16/373,509
Granted
Jun 15, 2021
Kind
B1
Abstract

A technique of obtaining update data from a database includes accessing configuration data associated with a particular entity in a plurality of entities. The configuration data includes a specification of how to extract a set of entity generated data records from a remote data store associated with the particular entity. The remote data store associated with the particular entity comprises common data elements shared by the plurality of entities and entity-specific data elements specified by the particular entity. It further includes determining whether values for a data field specified in the configuration data have been previously extracted from the remote data store. It further includes generating, according to the specification included in the configuration data, a query for values associated with the data field. Generating the query comprises determining a range indicator that indicates a time period of data values to be extracted. The range indicator is determined based at least in part on the determination of whether values for the data field have been previously extracted. It further includes, based at least in part on the generated query, extracting, from the remote data store, values for the data field corresponding to the determined range indicator. It further includes storing the extracted values to a data store of a central host component that provides services to the plurality of entities.

Claims (30)

1. A system, comprising:

a processor configured to:

access configuration data associated with a particular entity in a plurality of entities, wherein the configuration data includes a specification of how to extract a set of entity generated data records from a remote data store associated with the particular entity, and wherein the remote data store associated with the particular entity comprises common data elements shared by the plurality of entities and entity-specific data elements specified by the particular entity;

determine that values for a data field specified in the configuration data have been previously extracted from the remote data store;

in response to determining that values for the data field have been previously extracted, facilitate incremental data extraction at least in part by generating, according to the specification included in the configuration data, a query for values associated with the data field, wherein generating the query comprises determining an associated range indicator that indicates a time period of data values to be extracted, wherein the range indicator associated with the query includes a timestamp representing a starting point of the time period, and wherein the timestamp is based at least in part on a previous retrieval timestamp;

based at least in part on the generated query, extract, from the remote data store, values for the data field corresponding to the determined range indicator; and

store the extracted values to a data store of a central host component that provides services to the plurality of entities; and

a memory coupled to the processor and configured to provide the processor with instructions.

2. The system recited in claim 1 , wherein in response to determining that values for a second data field specified in the configuration data have not been previously extracted, the processor is configured to generate a second query associated with an unlimited range.

3. The system recited in claim 2 , wherein extracting values for the second data field corresponding to the unlimited range comprises extracting all historical data associated with the second data field.

4. The system recited in claim 1 wherein in response to determining that values for a second data field specified in the configuration have not been previously extracted, the processor is further configured to generate a new column in the data store of the central host component.

5. The system recited in claim 4 wherein the processor is configured to store the extracted values for the second data field in the new column generated in the data store of the central host component.

6. The system recited in claim 1 wherein generating the query comprises constructing the query based at least in part on at least one of a template query and a characteristic of the remote data store.

7. A method, comprising:

accessing configuration data associated with a particular entity in a plurality of entities, wherein the configuration data includes a specification of how to extract a set of entity generated data records from a remote data store associated with the particular entity, and wherein the remote data store associated with the particular entity comprises common data elements shared by the plurality of entities and entity-specific data elements specified by the particular entity;

determining that values for a data field specified in the configuration data have been previously extracted from the remote data store;

in response to determining that values for the data field have been previously extracted, facilitating incremental data extraction at least in part by generating, according to the specification included in the configuration data, a query for values associated with the data field, wherein generating the query comprises determining an associated range indicator that indicates a time period of data values to be extracted, wherein the range indicator associated with the query includes a timestamp representing a starting point of the time period, and wherein the timestamp is based at least in part on a previous retrieval timestamp;

based at least in part on the generated query, extracting, from the remote data store, values for the data field corresponding to the determined range indicator; and

storing the extracted values to a data store of a central host component that provides services to the plurality of entities.

8. The method of claim 7 further comprising, in response to determining that values for a second data field specified in the configuration data have not been previously extracted, generating a second query associated with an unlimited range.

9. The method of claim 8 , wherein extracting values for the second data field corresponding to the unlimited range comprises extracting all historical data associated with the second data field.

10. The method of claim 7 further comprising, in response to determining that values for a second data field specified in the configuration have not been previously extracted, generating a new column in the data store of the central host component.

11. The method of claim 10 further comprising storing the extracted values for the second data field in the new column generated in the data store of the central host component.

12. The method of claim 7 wherein generating the query comprises constructing the query based at least in part on at least one of a template query and a characteristic of the remote data store.

13. A computer program product embodied in a non-transitory computer readable storage medium and comprising computer instructions for:

accessing configuration data associated with a particular entity in a plurality of entities, wherein the configuration data includes a specification of how to extract a set of entity generated data records from a remote data store associated with the particular entity, and wherein the remote data store associated with the particular entity comprises common data elements shared by the plurality of entities and entity-specific data elements specified by the particular entity;

determining that values for a data field specified in the configuration data have been previously extracted from the remote data store;

in response to determining that values for the data field have been previously extracted, facilitating incremental data extraction at least in part by generating, according to the specification included in the configuration data, a query for values associated with the data field, wherein generating the query comprises determining an associated range indicator that indicates a time period of data values to be extracted, wherein the range indicator associated with the query includes a timestamp representing a starting point of the time period, and wherein the timestamp is based at least in part on a previous retrieval timestamp;

based at least in part on the generated query, extracting, from the remote data store, values for the data field corresponding to the determined range indicator; and

storing the extracted values to a data store of a central host component that provides services to the plurality of entities.

Assignments (1)
PATENT SECURITY AGREEMENT Recorded Dec 3, 2024
From: GUIDEWIRE SOFTWARE, INC.
To: BANK OF AMERICA, N.A., AS ADMINISTRATIVE AGENT
Reel/Frame 069476/0488 →
Continuity (3)
Continuation 14202851 · Mar 10, 2014
Provisional Application 61791899 · Mar 15, 2013
Provisional Application 61792100 · Mar 15, 2013