US 10,372,614 B1Granted

Smart data engine system and method

AssigneeBizNet Software, Inc.

InventorGeorge McMann

Life of this patent

Estimating the term…

Loading patent…

Abstract

The Smart Data Engine may cache data in an intelligent way which may minimize retrieval times and simplify authentication. A data cache may be maintained on the local computer that is ready to be retrieved and is tailored to the user. This avoids repeated requests of the same set of data. An additional cache may be maintained and tailored for Aggregations on the local computer ready to be retrieved. End users may retrieve data in a usable format and then easily create ad hoc reporting or perform analysis on the exposed data on the fly. An end user may select from defined ready-to-use SmartViews of data and determine policies of the cached data as needed. This solution may simplify connectivity to multiple types of data sources, including but not limited to, cloud data, relational databases, as well as on-premise/off-premise data.

Claims29

Dependent claims

A method for using cached data from external sources to create, store, and update aggregations of the cached data, the method comprising:

receiving a first Engine Request, the Engine Request including a Request Type of Aggregation;
querying whether a DataCache item exists for the first Engine Request;
issuing a Data Request to execute SmartView when no DataCache item exists for the first Engine Request;
returning a DataCache item in response to the Data Request;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
executing Aggregation against the DataCache item when the ReadyCache item does not exist;
adding the DataCache item returned in response to the Data Request to DataCache;
adding the ReadyCache item returned in response to the Aggregation to an in-memory ReadyCache;
fetching the ReadyCache item from the in-memory ReadyCache;
making a second Engine Request, the second Engine Request having an identical Request Type of Aggregation and Filter/Criteria as the first Engine Request;
querying whether a DataCache item exists matching the second Engine Request;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
fetching the ReadyCache item from the in-memory ReadyCache when the ReadyCache item exists for the Request Type of Aggregation;
and
making an additional Engine Request,
wherein when the additional Engine Request has an identical Request Type of Aggregation but different Filter/Criteria as the first Engine Request,
querying whether a DataCache item exists matching the additional Engine Request;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
executing Aggregation against the DataCache item to return the ReadyCache item when no ReadyCache item exists for the Request Type of Aggregation;
adding the returned ReadyCache item to ReadyCache;
fetching the ReadyCache item from the in-memory ReadyCache;
wherein when the additional Engine Request has an identical Request Type and Filter/Criteria as the first Engine Request,
querying whether a DataCache item exists matching the additional Engine Request;
adding a resultant DataCache item to DataCache overwriting an existing DataCache item and disposing of existing ReadyCache items associated with the existing DataCache item;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
executing Aggregation against the resultant DataCache item when no ReadyCache item exists for the Request Type of Aggregation;
adding a resultant ReadyCache item to the in-memory ReadyCache;
fetching the resultant ReadyCache item from the in-memory ReadyCache;
and
returning the resultant ReadyCache item to a user.

27 more elements

A method for using cached data from external sources to create, store and update aggregations of the cached data, the method comprising:

receiving a first Engine Request, the first Engine Request including a Request Type of Aggregation;
querying whether a DataCache item exists for the first Engine Request;
issuing a Data Request to execute SmartView when no DataCache item exists for the first Engine Request;
returning a DataCache item in response to the Data Request;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
executing Aggregation against the DataCache item when the ReadyCache item does not exist;
adding the DataCache item returned in response to the Data Request to DataCache;
adding the ReadyCache item returned in response to the Aggregation to an in-memory ReadyCache;
fetching the ReadyCache item from the in-memory ReadyCache;
making a second Engine Request, the second Engine Request having an identical Request Type of Aggregation and Filter/Criteria as the first Engine Request;
querying whether a DataCache item exists matching the second Engine Request;
querying whether the DataCache item is valid and needs Sync, when a DataCache item exists matching the second Engine Request;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
fetching the ReadyCache item from the in-memory ReadyCache when a ReadyCache item exists for the Request Type of Aggregation;
making an additional Engine Request;
and
wherein when the additional Engine Request has an identical Request Type but different Filter/Criteria as the first Engine Request,
querying whether a DataCache item exists matching the additional Engine Request;
querying whether the DataCache item is valid and needs Sync when a DataCache item exists matching the second Engine Request;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
executing Aggregation against the DataCache item to return a ReadyCache item when a ReadyCache item does not exist for the Request Type of Aggregation;
adding the returned ReadyCache item to ReadyCache;
and fetching the ReadyCache item from the in-memory ReadyCache;
wherein the additional Engine Request has an identical Request Type and Filter/Criteria as the first Engine Request,
querying whether a DataCache item exists matching the additional Engine Request;
querying whether the DataCache item is valid and needs Sync;
issuing a Data Request to execute SmartView when the DataCache item is not valid and needs Sync;
adding a resultant DataCache item to DataCache overwriting an existing DataCache item and disposing of existing ReadyCache items associated with the existing DataCache item;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
executing Aggregation against the resultant DataCache item when no ReadyCache item exists for the Request Type of Aggregation;
adding a resultant ReadyCache item to the in-memory ReadyCache;
fetching the resultant ReadyCache item from the in-memory ReadyCache;
and
returning the resultant ReadyCache item to a user.

31 more elements

A method for using cached data from external sources to create, store and update aggregations of the cached data, the method comprising:

receiving a first Engine Request, the Engine Request including a Request Type of Aggregation;
querying whether a DataCache item exists for the first Engine Request;
issuing a Data Request to execute SmartView when no DataCache item exists for the first Engine Request;
returning a DataCache item in response to the Data Request;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
executing Aggregation against the DataCache item when no ReadyCache item exists;
adding the DataCache item returned in response to the Data Request to DataCache;
adding the ReadyCache item returned in response to the Aggregation to an in-memory ReadyCache;
fetching the ReadyCache item from the in-memory ReadyCache;
making a second Engine Request, the second Engine Request having an identical Request Type of Aggregation and Filter/Criteria as the first Engine Request;
querying whether a DataCache item exists matching the second Engine Request;
querying whether the DataCache item is valid and needs Sync, when a DataCache item exists matching the second Engine Request;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
fetching the ReadyCache item from the in-memory ReadyCache when a ReadyCache item exists for the Request Type of Aggregation;
and
making an additional Engine Request,
wherein when the additional Engine Request has an identical Request Type but different Filter/Criteria as the first Engine Request,
querying whether a DataCache item exists matching the additional Engine Request;
querying whether the DataCache item is valid and needs Sync, when a DataCache item exists matching the second Engine Request;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
and executing Aggregation against the DataCache item to return a ReadyCache item when a ReadyCache item does not exist for the Request Type of Aggregation;
adding the returned ReadyCache item to ReadyCache;
and fetching the ReadyCache item from the in-memory ReadyCache;
wherein when the additional Engine Request has an identical Request Type and Filter/Criteria as the first Engine Request,
querying whether a DataCache item exists matching the additional Engine Request;
querying whether the DataCache item is valid and needs Sync;
issuing a Data Request to execute SmartView when the DataCache item is not valid and needs Sync;
adding a resultant DataCache item to DataCache overwriting an existing DataCache item and disposing of existing ReadyCache items associated with the existing DataCache item;
querying whether a ReadyCache item exists for the Request Type of Aggregation;
executing Aggregation against the resultant DataCache item when no ReadyCache item exists for the Request Type of Aggregation;
adding a resultant ReadyCache item to the in-memory ReadyCache;
fetching the resultant ReadyCache item from the in-memory ReadyCache;
and
returning the resultant ReadyCache item to a user.

31 more elements

Dependencies are inferred from the claim text.

Facts

Application: 15/296,659Filed 18 Oct 2016
Granted: 6 Aug 2019
Term ends: Not estimatedThe source records don’t support an estimate.

Classification7 codes

G06F 12/0888
Addressing of a memory level in which the access to the desired data or data block requires associative addressing means, e.g. caches: using…
G06F 16/252
Integrating or interfacing systems involving database management systems: between a Database Management System and a front-end application
G06F 16/24552
Query execution: database cache management
G06F 16/24575
With adaptation to user needs: using context

Family

No related US applications are recorded in the indexed filing history.

Timeline

Citations

Open elsewhere

Building an agent or pulling many patents? Use the API or MCP server instead of scraping pages. Get an API key