Management Of Structured, Non-Structured, And Semi-Structured Data In A Multi-Tenant Environment

• US 20160350303A1
• Filed: 05/27/2015
• Published: 12/01/2016
• Est. Priority Date: 05/27/2015
• Status: Active Grant

• Current Assignee: Datto LLC
• Original Assignee: Kaseya International Limited (Kaseya Limited)
• Inventors: Arcari, Daniel Philip, Fischer, Mark, Khot, Prakash
• Granted Patent: US 10,642,863 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/9024 Graphs; Linked lists G06F16/9027 takes precedence

Abstract

Disclosed is a network of systems that includes plural disparate storage systems that store user data, the disparate storage systems including NoSQL server databases that provide storage and retrieval of data modeled in forms besides tabular relations used in relational databases, and index storage system, a relational graph storage system and one or more data storage query platforms in communication with the plural disparate storage that have queries produced in a modeling language that abstracts application programmer functionality from network functionality.

Claims

1. A network of systems, the network comprising:

plural disparate storage systems that store user data, the disparate storage systems including NoSQL server databases that provide storage and retrieval of data modeled in forms besides tabular relations used in relational databases, and index storage system, a relational graph storage system;

one or more data storage query platforms in communication with the plural disparate storage systems, with each data storage query platform comprising;

a processor device; and

a memory in communication with the processor device; and

the processor device configured to;

receive a standard syntax wrapped query language query from an application within an application level,

determine a platform type of the one or more of the plural disparate storage systems on which the received query is executable; and

translate the standard syntax wrapped query language query into the determined native query language; and

send the translated query to the determined one or more of the plural disparate storage systems, according to the determined type.

2. The network of claim 1 wherein the standard syntax wrapped query includes a parameter that is an identifier to a specific object.

3. The network of claim 1 further comprising:

one or more client systems that comprise a processor device and memory in communication with the processor device; and

the processor device configured to;

execute an event driven computing platform that produces workflows that are saved in one or more of the plural disparate storage systems.

4. The network of claim 1 further comprising:

one or more client systems that comprise a processor device and memory in communication with the processor device; and

the processor device configured to;

execute a modeling language platform that produces queries for the data storage query platform;

5. The network of claim 4 wherein the one or more client devices are further configured to produce platform independent code and artifact files to describe a logical structure of a programming entity.

6. The network of claim 1 further comprising:

one or more client systems that comprise a processor device and memory in communication with the processor device; and

the processor device configured to;

execute a programming structure platform that produces an extension structure that includes a manifest structure and executable code for remote execution on a managed device in a second network

7. The network of claim 1 wherein the one or more client devices are configured to

execute the event driven computing platform produces routines chains according to received user supplied definitions of chains of routines;

produce a workflow according to received user-supplied designation of a routine chain as a workflow; and

store the workflows in the disparate storage.

8. The network of claim 1 wherein the one or more client devices executing the programming structure platform, each comprise a processor and memory that are configured to cause the processor to:

receive executable code;

encapsulate the executable code into an extension;

upload the extension to an approval system that executes an approval process;

generate a manifest structure, the manifest structure including a document that is a human readable manifest and a machine readable manifest that is version of the human readable manifest;

package the manifest structure into the extension containing the executable code;

apply a digital signature to the extension by using a private key.

9. A method of operating a network of systems, the method comprising:

receiving by a computing system a standard syntax wrapped query language query from an application within an application level, of the network;

determining by the computing system a platform type of the one or more of the plural disparate storage systems on which the received query is executable;

translating by the computing system standard syntax wrapped query language query into the determined native query language; and

sending by the computing system, the determined native query to one or more disparate data storage query platforms in communication with the computing system, to access one or more of the plural disparate storage systems according to the determined platform type, with the disparate storage systems including NoSQL server databases that provide storage and retrieval of data modeled in forms besides tabular relations used in relational databases, and index storage system, a relational graph storage system.

10. The method of claim 9 further comprising:

executing by one or more client devices an event driven computing process to produces workflows that are saved in one or more of the plural disparate storage systems.

11. The method of claim 9 further comprising:

executing by one or more client devices a programming structure process that produces an extension structure that includes a manifest structure and executable code for remote execution on a managed device in a second network.