EP4226245A1

EP4226245A1 - Extension framework for data analytics

Info

Publication number: EP4226245A1
Application number: EP21801772.1A
Authority: EP
Inventors: Jamie Davidson; Wil Gieseler
Original assignee: Google LLC
Current assignee: Google LLC
Priority date: 2020-10-08
Filing date: 2021-10-07
Publication date: 2023-08-16
Also published as: US12177255B2; US20230188572A1; US20220116422A1; US11582262B2; WO2022076754A1

Abstract

Extending access to a data model (120) in a data analytics computer data processing system (130) includes loading into a programmatically isolated process address space (160 A) of a computer, an instance of an extension framework computer program (180) and executing in the framework, computer program logic configured to establish a communicative channel (174) between the isolated address space and a data analytics computer data processing system executing in a separate process address space (160B). Thereafter, within the framework a directive (166) may be received to access a data model managed in the data analytics computer data processing system. In response, a function (172) may be selected in respect to an API (170) to the data analytics computer data processing system corresponding to the received directive. Finally, the selected API function may be invoked over the communicative channel and a result derived from the data model is received in the framework.

Description

Extension Framework for Data Analytics

TECHNICAL FIELD

[0001] The present disclosure relates to the field of data analytics and more particularly to the end user extension of the functionality of a data analytics application.

BACKGROUND

[0002] Data analytics refers to the analysis of raw data in order to draw conclusions regarding the information reflected by the raw data. This information can then be used to optimize different processes in order to increase the overall efficiency of a business or system. Data analytics generally require the presence of a data store such as a database, against which different queries may be lodged in order to provide derived information which characterizes the data in the data store in a meaningful way. Oftentimes, the derived information may be presented in a user interface in a particular format such as a tabular form, or more abstractly in the form of a graphical visualization such as a chart or graph. Business intelligence (BI) is natural consequence of data analytics, in which different real-world questions regarding the data collected for a business are answered utilizing data analytics so as to provide "actionable insights" into the nature, operation and performance of a business.

[0003] BI and underlying data analytics as they pertain to a single data store, can be a relatively simplistic proposition. First connect to the data store according to a known methodology, such as through the use of a pre-existing database connector, and then format and launch queries against the data store according to a known schema for the data in the data store. Then, present the result of the queries in a meaningful way so as to provide the desired BI. Matters become more complex, however, when multiple different heterogeneous data stores form the data storage basis for the underlying data analytics. In that instance, multiple different manners of connecting to an underlying data source will be required along with a satisfactory understanding of the schema for each data source. To account for this complexity, in contemporary BI it has been proven effective to first generate a data model for the underlying data in each of the heterogeneous data stores and then conduct data analytics upon the data model, which then acts as a layer of abstraction over the underlying data sources.

[0004] Generally, a BI application and underlying data analytics application produces a workable starting point for the end user. However, it had become well-understood that as the end user becomes skilled in the use of BI, customizations become required as to the structure and presentation of the data model and the queries conducted against the data model so as to produce the actionable intelligence sought from the BI application. In a multi-user environment, though, permitting direct access by the end user to the data model opens the data model for corruption to the detriment of other end users. As well, to the extent that any extension to the logic of a BI application performs errantly during execution, the logic may disrupt the nominal function of the BI application for other end users. Consequently, so as to avoid the corruption of the data model and the disruption of the operation of the BI application, generally the end user is limited by the structure of the BI application to the mere aggregation of some basic operations provided by the BI application for assembly into what amounts to a macro, as opposed to a fully executing, programmatic module of limitless logic.

SUMMARY

[0005] Examples of the present disclosure address deficiencies of the art in respect to the extension of functionality of a data analytics application, and provide a novel and non-obvious method, system and computer program product for extending access to a data model in a data analytics computer data processing system. One aspect of the disclosure provides a method for extending access to a data model in a data analytics computer data processing system. The method includes loading, by data processing hardware, an instance of an extension framework computer program into a programmatically isolated process address space of a computer. The method further includes executing in the framework, by the data processing hardware, computer program logic configured to establish a communicative channel between the isolated process address space and a data analytics computer data processing system executing in a separate process address space. The method further include receiving in the framework, a directive to access a data model managed in the data analytics computer data processing system. The method also includes selecting an application programming interface (API) function of an API to the data analytics computer data processing system corresponding to the received directive. The method further includes invoking over the communicative channel, the selected API function and receiving in the framework from over the communicative channel in response to the selected API function, a result derived from the data model.

[0006] This aspect may include one or more of the following optional features. In some implementations, the method includes fdtering the API to include only a subset of functions accessible in the framework according to a security policy. In some examples, the method includes fdtering the API to include only a subset of functions accessible in the framework according to a role of a requestor of the directive. In some configurations, the access to the model is an aggregation function. In some implementations, the framework receives the directive from over a computer communications network from a remote client.

[0007] Another aspect of the disclosure provides data analytics data processing system configured for extending access to a data model. The system includes a host computing platform comprising one or more computers, each with memory and at least one processor. The system also includes a programmatically isolated process address space defined in the memory of the host computing platform. The system further includes an instance of an extension framework computer program executing in the programmatically isolated process address space. Computer program logic executes as part of the framework and is configured to establish a communicative channel between the isolated process address space and the data analytics computer data processing system executing in a separate process address space defined in the memory of the host computing platform, the logic including computer program instructions enabled during execution in the memory of the host computing platform to perform operations including receiving in the framework, a directive to access a data model managed in the data analytics computer data processing system. The operations further include selecting an application programming interface (API) function of an API to the data analytics computer data processing system corresponding to the received directive. The operations also include invoking over the communicative channel, the selected API function and receiving in the framework from over the communicative channel in response to the selected API function, a result derived from the data model.

[0008] This aspect may include one or more of the following optional features. In some examples, the program instructions are further enabled to filter the API to include only a subset of functions accessible in the framework according to a security policy. In some examples, the program instructions are further enabled to filter the API to include only a subset of functions accessible in the framework according to a role of a requestor of the directive. In some configurations, the access to the model is an aggregation function. In some examples, the framework receives the directive from over a computer communications network from a remote client.

[0009] Another aspect of the disclosure provides a computer program product for extending access to a data model in a data analytics computer data processing system. The computer program product includes a computer readable storage medium having program instructions embodied therewith. The program instructions are executable by a device to cause the device to perform a method including loading an instance of an extension framework computer program into a programmatically isolated process address space of a computer. The method also includes executing in the framework, computer program logic configured to establish a communicative channel between the isolated process address space and a data analytics computer data processing system executing in a separate process address space. The method further includes receiving in the framework, a directive to access a data model managed in the data analytics computer data processing system. The method also includes selecting an application programming interface (API) function of an API to the data analytics computer data processing system corresponding to the received directive. The method further includes invoking over the communicative channel, the selected API function and receiving in the framework from over the communicative channel in response to the selected API function, a result derived from the data model.

[0010] This aspect may include one or more of the following optional features. In some examples, the method further includes filtering the API to include only a subset of functions accessible in the framework according to a security policy. Optionally, the method further includes filtering the API to include only a subset of functions accessible in the framework according to a role of a requestor of the directive. In some implementations, the access to the model is an aggregation function. In some configurations, the framework receives the directive from over a computer communications network from a remote client.

[0011] The details of one or more implementations of the disclosure are set forth in the accompanying drawings and the description below. Other aspects, features, and advantages will be apparent from the description and drawings, and from the claims.

DESCRIPTION OF THE DRAWINGS

[0012] The accompanying drawings, which are incorporated in and constitute part of this specification, illustrate embodiments of the disclosure and together with the description, serve to explain the principles of the disclosure. The embodiments illustrated herein are presently preferred, it being understood, however, that the disclosure is not limited to the precise arrangements and instrumentalities shown, wherein:

[0013] FIG. 1 is pictorial illustration of a process for extending access to a data model in a data analytics computer data processing system;

[0014] FIG. 2 is a schematic illustration of a data analytics computer data processing system adapted for extending access to a data model; and,

[0015] FIG. 3 is a flow chart illustration a process for extending access to a data model in a data analytics computer data processing system.

[0016] Like reference symbols in the various drawings indicate like elements.

DETAILED DESCRIPTION

[0017] Examples of the disclosure provide for extending access to a data model in a data analytics computer data processing system. In accordance with an example of the disclosure, an extension framework may be loaded into an isolated process address space of a computer, for instance within a virtual machine (VM) or a pod within a containerized environment. The extension framework provides computer program instructions that extend the functionality of a data analytics computer data processing system executing in a separate process address space, by applying directives to data in a data model of the data analytics computer data processing system as a proxy on behalf of program code of the extension framework.

[0018] As such, the extension framework includes program instructions adapted to establish a communicative channel between the isolated process address space and the data analytics computer data processing system. The program instructions are additionally adapted to receive in the framework, a directive to access the data model, to select an API function of an API to the data analytics computer data processing system corresponding to the received directive and to invoke over the communicative channel, the selected API function so as to receive in the framework from over the communicative channel in response to the selected API function, a result derived from the data model. The result may then be processed by the program instructions so as to extend the functionality of the data analytics computer data processing system. In this way, the data analytics computer data processing system can be extended without limitation while protecting the integrity of the data model and the operation of the data analytics computer data processing system.

[0019] In further illustration, FIG. 1 pictorially shows a process for extending access to a data model in a data analytics computer data processing system As shown in FIG. 1, a data analytics application 130 executes in connection with a primary process address space 160A of a computing system. The data analytics application 130 is adapted to conduct queries against a data model 120 of an underlying data store 110 which includes an architecture of one or more databases each ranging from a relational database to an object database to a flat file database and so forth. An extension tool 140 is included in connection with the data analytics application 130. The extension tool 140 is an end user accessible portion of the data analytics application 130 enabled to define a separate process address space 160B, 160N from the process address space 160A of the data analytics application 130 and to deploy into the separate process address space 160B, 160N, an extension framework 180.

[0020] The extension framework 180 includes computer program instructions supporting an API 170 for the data model 120. The API 170 includes programmatic functions 172 for issuing queries 190 to the data model 120 including read operations and aggregation functions. The computer program instructions of the extension framework 180 additionally are enabled to receive a connection with an extension 175 to the data analytics application 130 so as to receive directives (166) from the extension 175 to access the data model 120. The directives can be simple data access directives such as selecting a set of records according to a key, or more complex aggregate functions returning a value based upon a specified set of records. To that end, the extension 175 may include computer program instructions without limitation enabled to extend the functionality of the data analytics application 130, albeit within a different process address space 160B, 160N than the process address space 160A of the data analytics application 130, and with moderated access to the data model 120 (e.g., via communication channel 174) in the process address space 160A of the data analytics application 130 by way of the API 170.

[0021] Notably, the extension 175 may execute in the separate process address space 160B, 160N along with the extension framework 180, or the extension 175 may execute remotely from over a computer communications network 185 in a remote client 165. However, access to particular directives of the API 170 can be limited based upon a set of API permissions 150 defined by way of the extension tool 140. In particular, the API permissions 150 can limit access to particular directives of the API 170 according to the role of the end user or a security policy such as a time when the directives may be processed, a location from which the directives may be received, or a number of directives able to be processed by the end user within a period of time, to name just a few examples. In this way, the functionality of the data analytics application 130 can be extended in the separate process address space 160B, 160N without functional limitation while not jeopardizing the operation of the data analytics application 130 in the process address space 160A, and while protecting the integrity of the data model 120 through the use of the API 170 managed by the extension framework 180 while controlling access to the data model 120 according to a defined rules of the API permissions 150.

[0022] The process described in connection with FIG. 1 may be implemented within a data processing system. In further illustration, FIG. 2 schematically shows a data analytics computer data processing system 200 adapted for extending access to a data model. The system includes a host computing platform 210 that includes memory 220 and at least one processor 230, and fixed storage 240 including one or more databases stored in one or more storage devices. Multiple different and separate process address spaces 260 are defined in the memory 220 of the host computing platform 210. A data analytics application 270 executes in one of the process address spaces 260 and manages a data model 250 defined in the memory 220 for one or more of the databases in the fixed storage 240.

[0023] Notably, one or more extension frameworks 300 each are deployed into a correspondingly different one of the process address spaces 260 separate from the process address space 260 of the data analytics application 270. The extension framework 300 incorporates an API 280 defining an interface to the data model 250 accessible through the programmatic functionality of the extension framework 300. Consequently, an extension 290 to the data analytics application 270 may access the API 280 through the extension framework 300 within a corresponding one of the process address spaces 260 so as to access, indirectly, the data model 250 in extending the functionality of the data analytics application 270. More particularly, the program logic of the extension 290, defined by an end user and executing in the corresponding process address space 260 separate from that of the data analytics application 270, is enabled to issue directives to the extension framework 300 according to the API 280 which, if permitted by permissions associated with the extension framework 300, are transformed into queries against the data model with results from the queries being returned by the extension framework 300 to the extension 290 for use by the extension 290 in extending the functionality of the data analytics application 270.

[0024] In yet further illustration of the operation of the extension framework 300, FIG. 3 is a flow chart illustration a process for extending access to a data model in a data analytics computer data processing system. Beginning in block 310, a new process address space is created in supplement to a process address space of the data analytics application, for instance a new virtual machine in a virtualization environment, or a new container in a containerized environment. In block 320, an instance of the extension framework is then deployed into the newly created address space and in block 330, a communicative connection is established between the extension framework and an extension to the data analytics application. [0025] In block 340, a request for an API directive to be applied to the data model of the data analytics application is received in the extension framework from the extension and in block 350, an identity of the requestor is determined. Then, in block 360 one or more API permissions are applied to the identity of the requestor to determine whether or not the API directive is permitted. In decision block 370, if it is determined that the requestor is authorized according to the API permissions, in block 380 the extension framework issues the API directive to the data model in the form of a query and in response, a result set is received in block 390. Finally, in block 400 the result set is forwarded to the extension for use by the extension in extending the functionality of the data analytics application.

[0026] The present disclosure may be embodied within a system, a method, a computer program product or any combination thereof. The computer program product may include a computer readable storage medium or media having computer readable program instructions thereon for causing a processor to carry out aspects of the present disclosure. The computer readable storage medium can be a tangible device that can retain and store instructions for use by an instruction execution device. The computer readable storage medium may be, for example, but is not limited to, an electronic storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any suitable combination of the foregoing. [0027] Computer readable program instructions described herein can be downloaded to respective computing/processing devices from a computer readable storage medium or to an external computer or external storage device via a network. The computer readable program instructions may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. Aspects of the present disclosure are described herein with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to examples of the disclosure. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer readable program instructions. [0028] These computer readable program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks. These computer readable program instructions may also be stored in a computer readable storage medium that can direct a computer, a programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer readable storage medium having instructions stored therein includes an article of manufacture including instructions which implement aspects of the function/act specified in the flowchart and/or block diagram block or blocks. [0029] The computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable apparatus or other device to produce a computer implemented process, such that the instructions which execute on the computer, other programmable apparatus, or other device implement the functions/acts specified in the flowchart and/or block diagram block or blocks.

[0030] The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various examples of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of instructions, which includes one or more executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems that perform the specified functions or acts or carry out combinations of special purpose hardware and computer instructions.

[0031] Finally, the terminology used herein is for the purpose of describing particular examples only and is not intended to be limiting of the disclosure. As used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "includes" and/or "including," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.

[0032] The corresponding structures, materials, acts, and equivalents of all means or step plus function elements in the claims below are intended to include any structure, material, or act for performing the function in combination with other claimed elements as specifically claimed. The description of the present disclosure has been presented for purposes of illustration and description; but is not intended to be exhaustive or limited to the disclosure in the form disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the disclosure. The example was chosen and described in order to best explain the principles of the disclosure and the practical application, and to enable others of ordinary skill in the art to understand the disclosure for various examples with various modifications as are suited to the particular use contemplated.

[0033] A number of implementations have been described. Nevertheless, it will be understood that various modifications may be made without departing from the spirit and scope of the disclosure. Accordingly, other implementations are within the scope of the following claims.

Claims

WHAT IS CLAIMED IS:

1. A method for extending access to a data model (120) in a data analytics computer data processing system (100), the method comprising: loading an instance of an extension framework computer program (180) into a programmatically isolated process address space (160A) of a computer; executing in the framework computer program (180) logic configured to establish a communicative channel (174) between the isolated process address space (160A) and a data analytics computer data processing system (100) executing in a separate process address space (160B); receiving in the framework (180), a directive (166) to access a data model (120) managed in the data analytics computer data processing system (100); selecting an application programming interface (API) function (172) of an API (170) to the data analytics computer data processing system (100) corresponding to the received directive (166); and invoking over the communicative channel (174), the selected API function (172) and receiving in the framework (180) from over the communicative channel (174) in response to the selected API function (172), a result derived from the data model (120).

2. The method of claim 1, further comprising filtering the API (170) to include only a subset of functions (172) accessible in the framework (180) according to a security policy.

3. The method of claim 1 or 2, further comprising filtering the API (170) to include only a subset of functions (172) accessible in the framework (180) according to a role of a requestor of the directive (166).

4. The method of any of claims 1-3, wherein the access to the model (120) is an aggregation function.

5. The method of any of claims 1-4, wherein the framework (180) receives the directive (172) from over a computer communications network (185) from a remote client (165).

6. A data analytics data processing system (200) configured for extending access to a data model (250), the system (200) comprising: a host computing platform (210) comprising one or more computers, each with memory (220)and at least one processor (230); a programmatically isolated process address space (260) defined in the memory (220) of the host computing platform (210); an instance of an extension framework (300) computer program executing in the programmatically isolated process address space (260); computer program logic executing as part of the framework (300) and configured to establish a communicative channel (174) between the isolated process address space (260) and the data analytics computer data processing system (200) executing in a separate process address space (260) defined in the memory (220) of the host computing platform (210), the logic comprising computer program instructions enabled during execution in the memory (220) of the host computing platform (210) to perform operations comprising: receiving in the framework (300), a directive to access a data model (250) managed in the data analytics computer data processing system (200); selecting an application programming interface (API) function of an API (280) to the data analytics computer data processing system (200) corresponding to the received directive; and invoking over the communicative channel (174), the selected API function and receiving in the framework (300) from over the communicative channel (174) in response to the selected API function, a result derived from the data model (250).

7. The system (200) of claim 6, wherein the program instructions are further enabled to filter the API (280) to include only a subset of functions accessible in the framework (300) according to a security policy.

8. The system (200) of claim 6 or 7, wherein the program instructions are further enabled to filter the API (280) to include only a subset of functions accessible in the framework (300) according to a role of a requestor of the directive.

9. The system (200) of any of claims 6-8, wherein the access to the model (250) is an aggregation function.

10. The system (200) of any of claims 6-9, wherein the framework (300) receives the directive from over a computer communications network from a remote client.

11. A computer program product for extending access to a data model (120) in a data analytics computer data processing system (130), the computer program product including a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a device to cause the device to perform a method including: loading an instance of an extension framework computer program (180) into a programmatically isolated process address space (160A) of a computer; executing in the framework (180), computer program logic configured to establish a communicative channel (174) between the isolated process address space (160A) and a data analytics computer data processing system (130) executing in a separate process address space (160B); receiving in the framework (180), a directive (166) to access a data model (120) managed in the data analytics computer data processing system (130); selecting an application programming interface (API) function (172) of an API (170) to the data analytics computer data processing system (130) corresponding to the received directive (166); and invoking over the communicative channel (174), the selected API function (172) and receiving in the framework (180) from over the communicative channel (174) in response to the selected API function (172), a result derived from the data model (120).

14

12. The computer program product of claim 11, wherein the method further includes filtering the API (170) to include only a subset of functions (172) accessible in the framework (180) according to a security policy.

13. The computer program product of claim 11 or 12, wherein the method further includes filtering the API (170) to include only a subset of functions (172) accessible in the framework (180) according to a role of a requestor of the directive (166).

14. The computer program product of any of claims 11-13, wherein the access to the model (120) is an aggregation function.

15. The computer program product of any of claims 11-14, wherein the framework (180) receives the directive (172) from over a computer communications network (185) from a remote client (165).

15