Analysing Internet of Things

• US 11,151,761 B2
• Filed: 09/30/2015
• Issued: 10/19/2021
• Est. Priority Date: 09/30/2015
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Zoch, Daniel
• Primary Examiner(s): Kindred, Alford W
• Assistant Examiner(s): Davanlou, Soheila (Gina)
• Application Number:
  US14/870,018
• Publication Number:
  US 20170091277A1
• Time in Patent Office: 2,211 Days
• Field of Search: None
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

Various embodiments of systems and methods for internet of things (IoT) data analysis are described herein. In an aspect, the method includes receiving user'"'"'s input for data fields which are configured for retrieving data from a data repository. The data repository stores data related to one or more IoT devices. A structured query language (SQL) statement corresponding to the received user'"'"'s input is generated. Based upon the generated SQL statement, data from the data repository is retrieved. A visual representation for displaying the retrieved data is identified. The retrieved data is rendered based upon the identified visual representation.

Claims

1. A computer-implemented method for analyzing time-stamped internet of things (IoT) data, the method comprising:

through a user interface (UI), receiving a user input for one or more data fields including one or more conditions prerequisite to retrieval of the time-stamped IoT data from a data repository;

converting the received user input into a structured query language (SQL) query;

generating multiple views based upon the generated SQL query without modifying the data repository;

performing logical operations and arithmetical operations in parallel on the generated multiple views to determine whether the one or more conditions are satisfied, wherein each view of the multiple views is a result set of the generated SQL query;

retrieving the time-stamped IoT data from the data repository if it is determined that the one or more conditions are satisfied;

based upon the received user input for the one or more data fields, identifying a visual representation including a format for rendering the retrieved time-stamped IoT data; and

rendering the retrieved time-stamped IoT data based upon the identified visual representation.

2. The computer readable medium of claim 1, wherein the data repository stores the time-stamped IoT data related to one or more devices comprising internet of things (IoT) and wherein the generated multiple views are stored in a view library of the data repository.

3. The computer readable medium of claim 2, wherein the one or more devices is selected by the user and wherein the one or more devices include one or more sensors in communication with the data repository.

4. The computer readable medium of claim 2, wherein the time-stamped IoT data is received from the one or more devices in real time or a predefined time interval and wherein the received time-stamped IoT data is stored in the data repository.

5. The computer readable medium of claim 2, wherein the time-stamped IoT data further comprises geo location stamped data.

6. The computer readable medium of claim 1, wherein visual representation comprises one of a Venn diagram, a pie chart, a table, and a graph.

7. The computer readable medium of claim 1, wherein the one or more data fields comprises:

a pattern field, an object field, a property field, and a visualization field.

8. The computer readable medium of claim 7, wherein the object field represents a device which is to be analyzed, the property field represents a property of the device which is to be analyzed, the pattern field represents a feature of the property to be analyzed, and the visualization field represents a template in which pattern is to be displayed on the user interface.

9. The computer readable medium of claim 8, wherein a value in the pattern field is selected through a drop down menu including one or more predefined patterns.

10. The computer readable medium of claim 1, wherein based upon the received input for one or more data fields, a query is generated in a natural language and the structured query language (SQL) statement is generated corresponding to the generated query.

11. The computer-implemented method of claim 1, wherein each of the multiple views comprises a result set of a database query.

12. A computer-implemented method for analyzing time-stamped internet of things (IoT) data, the method comprising:

through a user interface (UI), receiving a user input for one or more data fields including one or more conditions configured for retrieving the time-stamped IoT data from a data repository;

converting the received user input into a structured query language (SQL) query;

generating multiple views based upon the generated SQL query without modifying the data repository;

performing logical operations and arithmetical operations in parallel on the generated multiple views to determine whether the one or more conditions are satisfied, wherein each view of the multiple views is a result set of the generated SQL query;

retrieving the time-stamped IoT data from the data repository when the one or more conditions are satisfied;

based upon the received user input for the one or more data fields, identifying a visual representation including a format for rendering the retrieved time-stamped IoT data; and

rendering the retrieved time-stamped IoT data based upon the identified visual representation.

13. The computer-implemented method of claim 12 further comprising:

identifying one or more devices comprising the IoT;

receiving data related to the identified one or more devices; and

storing the received time-stamped IoT data in the data repository.

14. A computer system for analyzing time-stamped internet of things (IoT) data, the system comprising:

at least one memory to store executable instructions; and

at least one processor communicatively coupled to the at least one memory, the at least one processor configured to execute the executable instructions to;

through a user interface (UI), receive a user input for one or more data fields including one or more conditions configured for retrieving time-stamped IoT data from a data repository;

convert the received user input into a structured query language (SQL) query;

generate multiple views based upon the generated SQL query without modifying the data repository;

perform logical operations and arithmetical operations in parallel on the generated multiple views to determine whether the one or more conditions are satisfied, wherein each view of the multiple views is a result set of the generated SQL query;

retrieve time-stamped IoT data from the data repository when the one or more conditions are satisfied;

based upon the received user input for the one or more data fields, identify a visual representation including a format for rendering the retrieved time-stamped IoT data; and

render the retrieved time-stamped IoT data based upon the identified visual representation.

15. The system of claim 14, wherein the processor is further configured to execute the executable instructions to:

identify one or more devices comprising the IoT;

receive time-stamped IoT data related to the identified one or more devices; and

store the received data in the data repository.

16. The system of claim 15, wherein the time-stamped IoT data is received from the one or more devices in real time or a predefined time interval and stored in the data repository.

17. The system of claim 15, wherein the time-stamped IoT data is at least one of a time stamped data and a geo location stamped data.

18. The system of claim 14, wherein the visual representation comprises one of a Venn diagram, a pie chart, a table, and a graph.

19. The system of claim 14, wherein the one or more data fields comprises:

a pattern field, an object field, a property field, and a visualization field.

20. The system of claim 19, wherein the object field represents a device which is to be analyzed, the property field represents a property of the device which is to be analyzed, the pattern field represents a feature of the property to be analyzed, and the visualization field represents a template in which pattern is to be displayed on the user interface.

21. The system of claim 20, wherein a value in the pattern field is selected through a drop down menu including one or more predefined patterns.