ANALYSING INTERNET OF THINGS

• US 20170091277A1
• Filed: 09/30/2015
• Published: 03/30/2017
• Est. Priority Date: 09/30/2015
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: ZOCH, DANIEL
• Granted Patent: US 11,151,761 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• 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 non-transitory computer readable storage medium storing instructions, which when executed by a computer cause the computer to perform operations comprising:

through a user interface (UI), receiving input for one or more data fields configured for retrieving data from a data repository;

generating a structured query language (SQL) statement corresponding to the received input;

triggering a view layer to generate multiple views based upon the generated SQL statement;

applying at least one of one or more logical operations and arithmetical operations on the generated multiple views to retrieve data from the data repository;

based upon the received input, identify a visual representation for the retrieved data; and

render the retrieved data based upon the identified visual representation.

2. The computer readable medium of claim 1, wherein the data repository stores data related to one or more devices comprising interact 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 data is received from the one or more devices in real time or a predefined time interval and wherein the received data is stored in the data repository.

5. The computer readable medium of claim 2, wherein the data is at least one of a time stamped data and a 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. A computer-implemented method for analyzing data related to interact of things (IoT), the method comprising:

through a user interface (UI), receiving input for one or more data fields configured for retrieving data from a data repository;

generating a structured query language (SQL) statement corresponding to the received input;

triggering a view layer to generate multiple views based upon the generated SQL statement;

applying at least one of one or more logical operations and arithmetical operations on the generated multiple views to retrieve data from the data repository;

based upon the received input, identifying a visual representation for the retrieved data; and

rendering the retrieved data based upon the identified visual representation.

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

identifying;

one or more devices comprising the IoT;

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

storing the received data in the data repository.

13. A computer system for analyzing data related to internee of things (IoT), 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 input for one or more data fields configured for retrieving data from a data repository;

generate a structured query language (SQL) statement corresponding to the received input;

trigger a view layer to generate multiple e s based upon the generated SQL statement;

apply at least one of one or more logical operations and arithmetical operations on the generated multiple views to retrieve data from the data repository;

based upon the received input, identify a visual representation for the retrieved data; and

render the retrieved data based upon the identified visual representation.

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

identify one or more devices comprising the IoT;

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

store the received data in the data repository.

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

16. The system of claim 14, wherein the data is at least one of a time stamped data and a geo location stamped data.

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

18. The system of claim 13, wherein the one or more data fields comprises:

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

19. The system of claim 18, 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.

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