Rules engine with database triggering

• US 8,849,771 B2
• Filed: 09/02/2011
• Issued: 09/30/2014
• Est. Priority Date: 09/02/2010
• Status: Expired due to Fees

• Current Assignee: Anker Berg-Sonne
• Original Assignee: Anker Berg-Sonne
• Inventors: Berg-Sonne, Anker
• Primary Examiner(s): NGUYEN, KIM T
• Application Number:
  US13/225,402
• Publication Number:
  US 20120143810A1
• Time in Patent Office: 1,124 Days
• Field of Search: 707/687, 707/694
• US Class Current: 707/687
• CPC Class Codes: G05B 15/02 electric
• CPC Class Codes: H02J 2310/54 according to a pre-established time schedule
• CPC Class Codes: H02J 3/003 Load forecast, e.g. methods or systems for forecasting future load demand
• CPC Class Codes: Y02B 70/3225 Demand response systems, e.g. load shedding, peak shaving
• CPC Class Codes: Y02B 90/20 Smart grids as enabling technology in buildings sector smart grids supporting the management or operation of end-user stationary applications in general, or like technologies with no associated climate change mitigation effect Y04S20/00
• CPC Class Codes: Y04S 10/50 Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
• CPC Class Codes: Y04S 20/00 Management or operation of end-user stationary applications or the last stages of power distribution; Controlling, monitoring or operating thereof
• CPC Class Codes: Y04S 20/222 Demand response systems, e.g. load shedding, peak shaving

Abstract

An automated facilities management system has the ability to predict occupant behavior by identifying recurring patterns in the way that people use buildings and comparing them with environmental characteristics. This technology is not limited to human behavior patterns, but extends to any mechanical systems or data points that tend to vary in recurring patterns. The data processing is carried out by rules engines triggered by relational database modifications.

Claims

1. An automated computing system, comprising:

a receiver component configured to receive sensor data from plurality of sensors configured to monitor a space in a building;

a database system configured to store the sensor data in an organized structure, and

a rules engine component configured to;

store one or more events in an event queue upon modifications to the stored sensor data,

translate each event in the event queue into an entry in a rules execution queue, wherein each entry in the rules execution queue comprises a priority value and executable data operable to modify a setting associated with a controller in the building based on the stored sensor data; and

a processor configured to process each entry in the rules execution queue according to a rules execution process comprising;

selecting a processing thread from a plurality of processing threads based on the priority value of the respective entry, and

using the selected processing thread to process the executable data of the respective entry.

2. The system of claim 1, wherein the database system includes an ACID-compliant relational database storing the sensor data in tables with data columns.

3. The system of claim 1, wherein the rule comprises a rule definition identifying the sensor data that triggers the rule.

4. The system of claim 3, wherein the rule definition comprises a list of sensor data items that triggers the rule.

5. The system of claim 1, wherein the rule comprises an assigned priority.

6. The system of claim 1, wherein the modification of the setting can succeed or fail and a failed modification is retained and is restartable.

7. An automated computing system, comprising:

a receiver component configured to receive sensor data from a plurality of sensors configured to monitor a space in a building;

a relational database configured to store;

the sensor data in an organized structure of tables having columns of data, and

a plurality of rules, each rule including;

a list of table and column pairs in the relational database that trigger the respective rule;

a priority value; and

an executable action process operable to modify a setting associated with a controller in the building responsive to an event related to the sensor data stored in a table and column from the list of table and column pairs, the action process associated with a subset of the stored sensor data; and

a processor configured to;

trigger storage of one or more of the plurality of rules in a rules execution queue upon an occurrence of a respective event,

for each rule stored in the rules execution queue, distribute the executable action process associated with the respective rule to one of a plurality of processing threads based on the priority value of the respective rule, and

process each executable action process associated with each of the rules stored in the rules execution queue in parallel across the plurality of processing threads.

8. The system of claim 7, wherein the subset of stored sensor data includes data not in the table and column pairs.

9. The system of claim 7, wherein the relational database is ACID compliant.

10. The system of claim 7, wherein the rules execution queue comprises a plurality of respective executable action processes associated with a single rule.

11. The system of claim 10, wherein the plurality of respective executable action processes associated with the single rule are triggered by different table and column pairs.

12. The system of claim 7, wherein the respective action process can succeed or fail and a failed respective action process is retained and is restartable.

13. The system of claim 7, wherein the rules entered in the rules execution queue can be modified.

14. The system of claim 13, wherein any modified rules in the rules execution queue are consolidated.