Patent Grant
10719313
Any and all applications for which a foreign or domestic priority claim is identified in the Application Data Sheet as filed with the present application are hereby incorporated by reference under 37 CFR 1.57 for all purposes and for all that they contain.
The present disclosure relates to a method and systems for providing external access to processing platforms, for example for externally performing one or more tasks on one or more datasets stored in a data processing platform.
Cloud computing is a computing infrastructure for enabling ubiquitous access to shared pools of servers, storage, computer networks, applications and other data resources, which can be rapidly provisioned, often over a network, such as the Internet.
A “data resource” as used herein may include any item of data or code (e.g., a data object) that can be used by one or more computer programs. In example embodiments, data resources are stored in one or more network databases and are capable of being accessed by applications hosted by servers that share common access to the network database. A data resource may for example be a data analysis application, a data transformation application, a report generating application, a machine learning process, a spreadsheet or a database, or part of a spreadsheet or part of a database, e.g. records or datasets.
Some companies provide cloud computing services for registered customers, for example manufacturing, scientific and technology companies, to create, store, manage and execute their own resources via a network. This enables customers to offload data storage and data transformation, data analysis functions etc. to a cloud-based platform having appropriate resources and computing power for providing secure access to the data resources, potentially for many registered users of the customer.
The platform may also provide applications, services and microservices for performing additional functions, such as specific transformations or analysis on the data, thereby negating the need for the customer to install such applications, services and microservices on their own servers and provide the consequential support and maintenance.
Customers may wish to use their own applications, code or use languages in which they are fluent on their own datasets for example to perform a transformation task forming part of a data processing pipeline comprising multiple such tasks and/or datasets. For example, the customer may own a dedicated application that is not provided for by the platform, nor can be uploaded to the platform, e.g. due to its size, or due to confidentiality or licensing restrictions. For example, the customer may require the use of one or more data resources, such as a complex model, which contains a large set of data, possibly confidential data and/or requires specialist hardware to run. This may mean that it is not feasible to provide it to the integrated platform. Nonetheless, the customer may need to use one or more datasets stored on the integrated platform as input to the data resource and may need to provide the outputted data back to the integrated platform for storage or so that one or more further tasks of a pipeline can be carried out.
According to a first aspect, there is provided a method, performed by one or more processors, the method comprising: receiving a build request associated with performing an external data processing task on a first dataset, the first data set being stored in memory associated with a data processing platform to be performed at a system external to the data processing platform; generating a task identifier for the data processing task; and providing, in association with the task identifier, a build request comprising an indication of the first data set and the data processing task to an agent associated with the external system, the agent being arranged to cause performance of the task at the external system, to receive a second dataset resulting from performance of the task, and to provide the second dataset and associated metadata indicative of the transformation to the data processing platform.
The method may further comprise receiving the second dataset and associated metadata from the agent associated with the external system; and storing the second dataset and associated metadata in the data processing platform.
The method may further comprise storing the task identifier for the build request in a co-ordinator function that receives one or more build queries from the external system, or a service associated with the external system, for providing the build request to the agent.
The co-ordinator function may store multiple task identifiers for multiple other build requests for providing one or more build requests to the agent.
The co-ordinator function may remove task identifiers, or flags task identifiers as used, responsive to receiving a completion message from the agent, such that subsequent build queries from the same external system do not cause re-provision of the same datasets.
The one or more build queries may be polling queries received periodically from the external system, or a service associated with the external system.
The method may further comprise generating a token associated with the build request for enabling verification at the data processing platform that the received second dataset corresponds to the build request.
The metadata may comprise one or more of: at least part of the code used on the external system to perform the data processing task; the version number of the code used on the external system to perform the data processing task; an ontology or schema; the date the code was last updated; and a hash of the code.
The method may further comprise transmitting an update query to the external system, and responsive thereto, receiving an indication of one or more updates made to code used on the external system to perform the data processing task.
The update query may be transmitted periodically as a polling request.
The method may further comprise, responsive to receiving an indication of one or more updates made to the code on the external system, flagging the second dataset, and/or any other dataset generated as a result of performance of the data processing task, as being out of date.
The method may further comprise displaying a prompt on a user interface indicating the second and/or other datasets flagged as out of date.
The method may further comprise preventing further data processing tasks being performed on the second and/or other datasets flagged as out of date.
The method may further comprise automatically generating a new build request for performing the data processing task on the first dataset for generating a new dataset to replace the second and/or other datasets flagged as out of date.
The external data processing task may comprise one task of a data processing pipeline comprising two or more tasks, and wherein the received second dataset is provided as input to a further task which performs a further data processing task to generate a third dataset.
According to another aspect, there may be provided a method, performed by one or more processors, the method comprising: identifying, at a system external to a data processing platform, a build request derived from the data processing platform associated with performing a data processing task on a first dataset, the first dataset being stored in memory associated with the data processing platform; receiving, responsive to the identification, the build request, including an identification of the first dataset and the data processing task; receiving the first data set from the data processing platform; causing performance of the data processing task at the external system; receiving a second dataset resulting from performance of the task; and sending the second dataset and associated metadata indicative of the transformation to the data processing platform.
The method may further comprise transmitting one or more build queries to the data processing platform for causing receiving of the build request.
The one or more build queries may be polling queries periodically transmitted to the data processing platform.
The method may further comprise receiving a token associated with the build request for transmitting to the data processing platform when requesting the first dataset and/or sending the second dataset such that the data processing platform may determine that they correspond to the build request.
The metadata may comprise one or more of: at least part of the code used on the external system to perform the data processing task; the version number of the code used on the external system to perform the data processing task; an ontology or schema; the date the code was last updated; the last run date of the code, logic or dataset; logs; and a hash of the code.
The method may further comprise receiving an update query from the data processing platform, and responsive thereto, transmitting an indication of one or more updates made to code to perform the data processing task.
The method may further comprise, upon receiving the build request from the data processing platform, creating a directory for holding the first data set and the second dataset and associated metadata, and removing the directory subsequent to the second dataset and associated metadata being sent to the data processing platform.
According to another aspect, there is provided a computer program, optionally stored on a non-transitory computer readable medium program which, when executed by one or more processors of a data processing apparatus, causes the data processing apparatus to carry out a method according to any preceding method definition.
According to another aspect, there is provided an apparatus configured to carry out a method according to any preceding method definition, the apparatus comprising one or more processors or special-purpose computing hardware.
Example embodiments will now be described by way of non-limiting example with reference to the accompanying drawings, in which:
Reference will now be made in detail to specific example embodiments for carrying out the subject matter of the present disclosure. In the following description, specific details are set forth in order to provide a thorough understanding of the subject matter. It shall be appreciated that embodiments may be practiced without some or all of these specific details.
To facilitate an understanding of the systems and methods discussed herein, a number of terms are described below. The terms described below, as well as other terms used herein, should be construed to include the provided descriptions, the ordinary and customary meaning of the terms, and/or any other implied meaning for the respective terms. Thus, the descriptions below do not limit the meaning of these terms, but only provide exemplary descriptions.
Example embodiments relate to enabling external access to a data processing platform. Example embodiments also relate to performance of one or more processing tasks or operations at a system external to the data processing platform, typically remote from the data processing platform. The data processing platform may be a cloud-based platform, offering access to customers for the purposes of one or more of storage, applications, analysis and reporting via data resources. The data processing platform may be termed an integrated data processing platform on account of it providing multiple applications for multiple datasets for, potentially multiple customers having multiple users. A customer may be a company providing technology or scientific services, or indeed other services.
As mentioned, a “data resource” as used herein may include any item of data or code (e.g., a data object) that can be used by one or more computer programs. In example embodiments, data resources may be stored in one or more network databases or on external databases and may be capable of being accessed by applications hosted by servers that share common access to the network database. A data resource may for example be a data analysis application, a data transformation application, a report generating application, a machine learning process, a spreadsheet or a database, or part of a spreadsheet or part of a database, e.g. records or datasets. The term dataset is used herein generically.
A data transform may be any operation that takes one or more datasets, e.g. tables, and produces one or more datasets with some modification, e.g. by joining, merging, splitting, incrementing, decrementing or performing any computational algorithm.
A data processing task, or simply “task”, is a requested operation that may comprise performance of one or more data transforms.
A data processing pipeline is a series of two or more tasks whereby one or more datasets may provide the input to a first task and the output from the first task may provide at least part of the input to a second task. Data processing pipelines may comprise many tasks, some of which may be performed in series and some of which may be performed in parallel. A task which takes data from the output of another task may be considered dependent on the other task.
In the example of
Each of the servers 106-108 may be in communication with the network-based permissioning system 104 and external access system 120 over a network 112 (e.g. the Internet or an intranet). Each of the servers 106-108 are further shown to be in communication with a database server 114 that facilitates access to a resource database 116 over the network 112, though in other embodiments, the servers 106-108 may access the resource database 116 directly, without the need for a database server 114. The resource database 116 stores data resources that may be used by any one of the applications 109-111 hosted by the data processing platform 102.
The external access system 120 is configured to perform the co-ordination of data build requests from one or more users. A data build request may be a user or computer-initiated request to perform some task at a specified external system. The specified external system may be identified with a unique identifier, by the login details of the user (associated with a particular system, as determined by the network-based permissioning system 104), by a URL, through a user interface, through code or any combination thereof. The task may be one task of multiple tasks comprising a data processing pipeline. Therefore, in some example embodiments, the customer may wish the data processing platform 102 to perform some or most of the multiple tasks, but for various reasons, may wish for one or more other tasks to be performed at a specified other external system, e.g., a computer system or network that is remote from and/or in a different domain than the data processing platform 102.
The reasons that a customer may require this are numerous. For example, a customer may wish to use their own application or use a language in which they are fluent on their own datasets stored at the data processing platform 102, for example to perform a transformation task within part of a data processing pipeline comprising multiple such tasks and/or datasets. For example, a customer may have legacy code in their own computing infrastructure that they may not wish to migrate to the data processing platform, at least presently, although they may wish to connect to it via the data processing platform. For example, the customer may own a dedicated application that is not provided for by the data processing platform 102, nor can be uploaded to the platform, e.g. due to its size (it may be too large to transfer efficiently over a network), or due to confidentiality or licensing restrictions. For example, the customer may require the use of one or more data resources, such as a complex model, which contains a large set of data, possibly confidential data and/or requires specialist hardware to run. This may mean that it is not feasible to provide it to the data processing platform 102. For example, the customer may simply wish to retain control over their own data resources.
In overview, the external access system 120 is configured to communicate with a so-called external connector provided at the external system that handles performance of one or more tasks at the external system based on data derived from the data processing platform 102. The external access system 120 may also provide the resulting one or more datasets back to the data processing platform 102 for storage. The external connector may be provided as a custom plug-in that may be deployed to any external system of any customer associated with the data processing platform 102, and having need for performance of external tasks.
Advantageously, the external access system 120 may be application or code agnostic; that is, the external access system 120 does not need to understand the specific application or code that will be used for performance of the task. The external access system 120 provides the co-ordination functionality to handle new build requests initiated by customers (e.g., their users, if so authorised), to co-ordinate over a network with the appropriate plug-in of the customer in order to transfer one or more requested datasets to the plug-in, and subsequently to receive one or more transformed datasets that result from performance of one or more tasks performed externally.
As shown, the network system 100 also includes a client device 118 in communication with the data processing platform 102, the network-based permissioning system 104 and the external access system 120 over the network 106. The external access system 120 can reside within the data processing platform 102 in some embodiments. The client device 118 communicates and exchanges data with the data processing platform 102 and may also communicate with the network-based permissioning system 104 and the external access system 120 over the network 106.
The client device 118 may be any of a variety of types of devices that include at least a display, a processor, and communication capabilities that provide access to the network 106 (e.g., a smart phone, a tablet computer, a personal digital assistant (PDA), a personal navigation device (PND), a handheld computer, a desktop computer, a laptop or netbook, or a wearable computing device), and may be operated by a user (e.g., a person) to exchange data with other components of the network system 100 that pertains to various functions and aspects associated with the network system 100 and its users. The data exchanged between the client device 118 and the data processing platform 102 involve user-selected functions available through one or more user interfaces (UIs). The UIs may be specifically associated with a web client (e.g., a browser) or an application 109-111 executing on the client device 118 that is in communication with the data processing platform 102. For example, the network-based permissioning system 104 provides user interfaces to a user of the client device 118 (e.g., by communicating a set of computer-readable instructions to the client device 118 that cause the client device 118 to display the user interfaces) that allow the user to register policies associated with data resources stored in the resource database 116.
Referring to
Computer system 137 includes a bus 138 or other communication mechanism for communicating information, and a hardware processor 139 coupled with bus 138 for processing information. Hardware processor 139 can be, for example, a general purpose microprocessor. Hardware processor 139 comprises electrical circuitry.
Computer system 137 includes a main memory 140, such as a random access memory (RAM) or other dynamic storage device, which is coupled to the bus 138 for storing information and instructions to be executed by processor 139. The main memory 140 can also be used for storing temporary variables or other intermediate information during execution of instructions by the processor 139. Such instructions, when stored in non-transitory storage media accessible to the processor 139, render the computer system 137 into a special-purpose machine that is customized to perform the operations specified in the instructions.
Computer system 137 further includes a read only memory (ROM) 141 or other static storage device coupled to the bus 138 for storing static information and instructions for the processor1139. A storage device 142, such as a magnetic disk or optical disk, is provided and coupled to the bus 138 for storing information and instructions.
Computer system 137 can be coupled via the bus 138 to a display 143, such as a cathode ray tube (CRT), liquid crystal display, or touch screen, for displaying information to a user. An input device 144, including alphanumeric and other keys, is coupled to the bus 138 for communicating information and command selections to the processor 139. Another type of user input device is cursor control 145, for example using a mouse, a trackball, or cursor direction keys for communicating direction information and command selections to the processor 139 and for controlling cursor movement on the display 143. The input device typically has two degrees of freedom in two axes, a first axis (for example, x) and a second axis (for example, y), that allows the device to specify positions in a plane.
Computer system 137 can implement the techniques described herein using customized hard-wired logic, one or more ASICs or FPGAs, firmware and/or program logic which in combination with the computer system causes or programs computer system 137 to be a special-purpose machine. According to some embodiments, the operations, functionalities, and techniques disclosed herein are performed by computer system 137 in response to the processor 139 executing one or more sequences of one or more instructions contained in the main memory 140. Such instructions can be read into the main memory 40 from another storage medium, such as storage device 142. Execution of the sequences of instructions contained in main memory 140 causes the processor 139 to perform the process steps described herein. In alternative embodiments, hard-wired circuitry can be used in place of or in combination with software instructions.
The term “storage media” as used herein refers to any non-transitory media that stores data and/or instructions that cause a machine to operate in a specific fashion. Such storage media can comprise non-volatile media and/or volatile media. Non-volatile media includes, for example, optical or magnetic disks, such as storage device 142. Volatile media includes dynamic memory, such as main memory 140. Common forms of storage media include, for example, a floppy disk, a flexible disk, hard disk, solid state drive, magnetic tape, or any other magnetic data storage medium, a CD-ROM, any other optical data storage medium, any physical medium with patterns of holes, a RAM, a PROM, and EPROM, a FLASH-EPROM, NVRAM, any other memory chip or cartridge.
Storage media is distinct from, but can be used in conjunction with, transmission media. Transmission media participates in transferring information between storage media. For example, transmission media includes coaxial cables, copper wire and fibre optics, including the wires that comprise bus 138. Transmission media can also take the form of acoustic or light waves, such as those generated during radio-wave and infra-red data communications.
Various forms of media can be involved in carrying one or more sequences of one or more instructions to processor 139 for execution. For example, the instructions can initially be carried on a magnetic disk or solid state drive of a remote computer. The remote computer can load the instructions into its dynamic memory and send the instructions over a telephone line or other transmission medium using a modem. A modem local to computer system 137 can receive the data on the telephone line or other transmission medium and use an infra-red transmitter to convert the data to an infra-red signal. An infra-red detector can receive the data carried in the infra-red signal and appropriate circuitry can place the data on bus 138. Bus 138 carries the data to the main memory 140, from which the processor 139 retrieves and executes the instructions. The instructions received by the main memory 140 can optionally be stored on the storage device 142 either before or after execution by the processor 139.
Computer system 137 also includes a communication interface 146 coupled to the bus 138. The communication interface 146 provides a two-way data communication coupling to a network link 147 that is connected to a local network 148. For example, the communication interface 146 can be an integrated services digital network (ISDN) card, cable modem, satellite modem, or a modem to provide a data communication connection to a corresponding type of telephone line. As another example, the communication interface 146 can be a local area network (LAN) card to provide a data communication connection to a compatible LAN. Wireless links can also be implemented. In any such implementation, the communication interface 146 sends and receives electrical, electromagnetic or optical signals that carry digital data streams representing various types of information.
The network link 147 typically provides data communication through one or more networks to other data devices. For example, the network link 147 can provide a connection through the local network 148 to a host computer 149 or to data equipment operated by an Internet Service Provider (ISP) 150. The ISP 150 in turn provides data communication services through the world wide packet data communication network now commonly referred to as the “Internet” 151. The local network 148 and internet 151 both use electrical, electromagnetic or optical signals that carry digital data streams. The signals through the various networks and the signals on the network link 147 and through the communication interface 146, which carry the digital data to and from the computer system 137, are example forms of transmission media.
The computer system 137 can send messages and receive data, including program code, through the network(s), network link 147 and communication interface 146. For example, a first application server 106 may transmit data through the local network 148 to a different application server 107, 108.
Referring to
The external access system 120 and the customer system 155 are remote from one another and communicate over the network 112.
The data processing platform 102 may store one or more datasets 160, 162 associated with a particular customer, for example the customer associated with the customer system 155. For example, the one or more datasets 160, 162 may comprise any form of data, and may represent engineering data, data maintenance data, computer network status data, fault data, and the datasets 160, 162 may be represented in any suitable data structure, for example as persisted datasets or tables. For example, one dataset 160 may be referred to as dataset “B” which may require some task to be performed on it, e.g. a transformation of any of the above types. To recap, a transformation may be any of a number of operations that are performed on one or more datasets to generate yet another dataset. Each dataset transformation may be associated with an implementation that includes code for causing a particular operation to be performed. However, use of the term data processing task is not limited to the performance of transformations.
The data processing platform 102 may also comprise a data proxy/file server 178 which handles real-time or batch transfers of data to/from the customer system 155 over the network 112, depending on the size of data files or data streams. Additionally, or alternatively, input data may also come via the co-ordinator module 166 through the agent 170 and the custom plug-in 172.
The external access system 120 may comprise a co-ordinator module 166 having a run requests service 168 that may be an object which maintains build identifiers associated with build requests received from a build module 164. The build module 164 is configured to receive build requests from users, e.g. customers, and to generate build identifiers for the run requests service 168 of the co-ordinator module 166.
At the customer system 155, an agent 170 is provided which may comprise or at least include a custom plug-in 172. An external connector module 174 may also be comprised within the agent, the external connector module being configured to manage the performance of the requested one or more tasks at an external system 176, which is the module that will perform the requested one or more tasks. In some embodiments, the external connector module 174 may be provided as an independent module, e.g. as an independent REST service, or other independent service, so long as the Agent 170 and the custom plug-in 172 may communicate with the external connector module and the external connector module may communicate with the external system 176. The external system 176 may be a computer or server forming part of the customer system 155, e.g. a customer network. This may include enabling receiving and/or sending datasets from and/or to the data processing platform 102 via the proxy/file server 178. The external connector module 174 may also communicate with the external system 176, e.g. to send the fetched one or more datasets and/or to receive one or more transformed datasets for sending to the data processing platform 102. In some embodiments, the external system 176 may directly communicate with the data processing platform 102 via the proxy/file server 178.
The external system 176 may be any application or system for performing one or more tasks, e.g., externally of the data processing platform 102. For example, the external system 176 may be a computer, server, or a database controller. The external system 176 may have access to a local database 180 and/or a file system on which local datasets are stored.
Referring briefly to
A first dataset “A” 162 may be a table that is applied to a first transformation 210A. The output from the first transformation 210A, and other transformations mentioned herein, may produce an output dataset. The dataset “B” 160 may be a table that is applied to a second transformation 212 which may or may not take input from another, third dataset “C” 214. The output from the second transformation 212, e.g., an output dataset, may provide input to a further, third transformation 220. The output dataset from the third transformation 220 may provide a target dataset 230 which may be a table. Although the datasets 160, 162, 214, 230 are described as tables, this is not necessarily the case.
The dashed box 176 in
For example, the second transformation 212 may be performed within a specialised statistical application such as the Statistical Analysis System (SAS) suite, or another application such as MATLAB. For example, the third dataset “C” 214 may be a confidential set of customer data or a complex model that should not in itself leave the customer system 155.
Returning back to
First, a customer may request a new build using the client device 118. The form of request may be entered through a user interface, through a configuration file or through code, which enables identification of one or more datasets stored on the data processing platform 102 to provide as input to the customer system 155, and a destination identifier, which may refer to the task or transformation function that is to be performed externally. Additionally, in some embodiments, the request may also comprise one or more of an output dataset, code to be executed (e.g. as a reference to an internal file, an external file, or in the form of the code itself) and build parameters that are inputs to the external build. In the shown case, the second dataset “B” 160 is to be provided as input to the third transformation 212 of the
The build module 164, upon receiving the new build request, generates a build identifier, e.g. a unique numerical or alphanumerical identifier for the build request. The build identifier and build parameters are pushed to the run requests service 168 which stores a list of all active or new build requests. The list may comprise a list of parameters for the external build, and each new build request may be stored in a queue maintained by the co-ordinator module 166. Build requests may be stored for the same customer or for multiple different customers, so long as the build parameters can be identified.
The coordinator module 166 handles build queries that are received from the agent 170, specifically the custom plug-in 172 in this case. Upon receipt of a build query associated with a particular customer system 155, the coordinator module 166 determines if any new builds are present in the run requests service 168 for that customer system. If so, the build parameters, possibly including the build identifier, for the one or more identified new builds are provided to the external connector 174, either directly or via the custom plug-in 172. This may occur using a pull model whereby the new builds are pulled or fetched from the co-ordinator module 166. The agent 170/custom plug-in 172 may pull new builds or datasets from the co-ordinator module 166. The custom plug-in 172 may be configured to periodically poll the coordinator 166 to find new build requests in the run requests service 168 for that customer system 155. If no new build requests are found, nothing happens, and the process repeats at the next polling time.
The external connector 174 is software which processes the received build parameters for the one or more new builds. More specifically, the external connector 174 may reserve some local storage space, e.g. create a directory 175, for the temporary storage of the build parameters and any associated data. The external connector 174 may request receipt of the one or more datasets, e.g. the second dataset “B” 160 from the data processing platform 102 via the proxy/file server 178. The second dataset “B” 160 may be stored, at least temporarily, within the directory 175. The directory 175 may be particular to the specific build request identifier or a set of build request identifiers common to a particular customer. The build parameters for the task will determine which task is performed at the external system 176. The external connector 174 may thereafter provide the requested one or more datasets to the external system 176 for local processing, e.g. to apply the third transformation 212 using a locally stored third dataset “C” 214 as other input. For example, the third dataset “C” 214 may be received from the local database 180. For example, the external system 176 may be a computer or server running SAS and/or MATLAB or other task application.
The external connector 174 may also receive one or more output datasets 250 from the external system 176 resulting from performance of the requested one or more tasks of the build. The external connector 174 may thereafter send the one or more output datasets 250 back to the data processing platform 102, via the proxy/file server 178, for storage thereat. Alternatively, the one or more output datasets 250 may be transmitted back to the data processing platform 102 via the custom plug-in 172 and co-ordinator module 166 which may use the file server 178. The location where the one or more output datasets 250 are to be stored may be determined by, or specified in, the build parameters.
Upon completing the transfer of the one or more output datasets 250 to the data processing platform 102, or at some other time related to completion of the build request, the corresponding build parameters may be removed, e.g. the directory 175 deleted, or at least marked as closed or similar, to make way for later builds. Further, this maintains lockdown of the datasets, whereby data is not left in the directory 175 where it is harder to control permissions. In some embodiments, datasets may be encrypted when stored in the directory 175. This may be performed by the external connector 174. The external connector 174 may also signal or message to the custom plug-in 174 that the task has been completed, and the custom plug-in may signal the same back to the co-ordinator 166 such that the corresponding one or more build requests at the run requests service 168 may be removed or marked as closed, or similar, to make way for later new builds and to avoid repetition of the same task.
In some embodiments, the custom plug-in 172 and external connector 174 may be provided as one functional entity. In some embodiments, the external connector 174 may not store in non-volatile memory the datasets as they are received and transmitted. In other words, the datasets may be moved straight to and from the external system 176 and are only held for a short, finite period of time at the external connector 174.
Another function of the external connector 174 may be to generate metadata 252 for association with each of the one or more output datasets 250. The metadata 252 may represent anything relating to the output dataset 250, for example one or more of the build identifier, the destination address, the origin address, the requesting user or customer, the type of task performed, the application employed, the language employed, the timing of the task, the size of the output dataset, the one or more input datasets used, the ontology or schema of the input or output datasets, part or all of the code used in the task (if not confidential or too large), the version number of the code used to perform the task, the date the code was last updated, the last run date of the code, logic or dataset, logs and a hash of the code. The metadata 252 is received by the data processing platform 102 and is stored in association with the output dataset 250, e.g., it is somehow linked to the output dataset.
The external access system 120 and/or the data processing platform 102 may further be configured to transmit an update query to the external system 176, requesting receipt of updates made to code used on the external system to perform tasks. That is, if it is known that one or more datasets have been generated, or are derived from an external task initiated by a customer's external connector 174, then a check is made for any update to the code responsible for the task. The update queries may be transmitted periodically as polling requests. The update query may simply request a copy of the code that was used, for local comparison, or may examine the version number of the code to see if it corresponds with that in the metadata 252 for the output dataset 250, or may examine the time of update to see if it is later than the time in the metadata 252 indicating when the task was performed, or may compare a hash of the code contents.
In response to receiving an indication of one or more updates made to the code on the external system, the resulting dataset (and/or any other dataset generated as a result of performance of the data processing task) may be flagged as being out of date. This may include flagging datasets derived from an out of date dataset, processing errors or simply cause incorrect results to be returned. Remedial actions may be complex and time consuming.
As a result of detecting an out of date dataset, the external access system 120 and/or the data processing platform 102 may display a prompt on a user interface indicating the datasets flagged as out of date, and/or may prevent further data processing tasks being performed on the second and/or other datasets flagged as out of date. Additionally, or alternatively, the external access system 120 and/or the data processing platform 102 may automatically generate a new build request for entry into the run requests service 168 for re-performing the task on the original dataset for generating and receiving a new output dataset, and updated metadata, to replace the previous output dataset and metadata flagged as out of date or ‘stale’.
A first operation 500 may comprise receiving build request associated with an external data processing task on a first dataset.
A second operation 501 may comprise generating a task identifier for the data processing task.
A third operation 502 may comprise providing, which may comprise (but is not limited to) allowing data to be “pulled”, the first dataset associated with the task identifier to an agent associated with an external system.
A fourth operation 503 may comprise receiving a second dataset and metadata indicative of the transformation from the agent.
A fifth operation 504 may comprise storing the second dataset and metadata.
A first operation 600 may comprise identifying a request for an external data processing task.
A second operation 601 may comprise receiving a first dataset identified in the request. This may involve requesting the first dataset from a remote data processing platform.
A third operation 602 may comprise causing performance of the task. The task may be instructed or indicated in the request, as may an external system on which the task is to be performed, e.g. by code.
A fourth operation 603 may comprise receiving a second dataset and sending the second dataset to the data processing platform.
In some embodiments, a further operation may be provided between the third and fourth operations 602, 603, comprising checking (e.g. polling) the status of the external build, which may comprise statuses such as NOT_STARTED, STARTED, RUNNING, FAILED and/or SUCCEEDED.
A first operation 700 may comprise polling the external system 176 for code updates.
A second operation 701 may comprise comparing the latest code version with a stored version on the data processing platform 102.
A third operation 702 may comprise, if the comparison reveals one or more modifications, updating the code in the data processing platform with the latest code.
A fourth operation 703 may comprise, optionally, marking one or more corresponding datasets associated with the previous version of the code as out of date or ‘stale’.
Each of the processes, methods, and algorithms described in the preceding sections may be embodied in, and fully or partially automated by, code modules executed by one or more computer systems or computer processors comprising computer hardware. The processes and algorithms may be implemented partially or wholly in application-specific circuitry.
Advantageously, the above methods, systems and computer-readable code, according to certain embodiments, enable integration with any generic service or application which is external to the data processing platform 102. The service or application may implement a Representational State Transfer (REST) architectural style providing interoperability between networked computer systems. Alternatively, the service or application may be connected via a Java Database Connectivity (JDBC)-like interface. SAS and MATLAB are given as examples of specialised task-performing applications that may be implemented externally for generating new datasets from received or ingested datasets. By generating and storing metadata in association with externally-generated datasets, provenance and lineage of the external builds can be maintained, and issues relating to out of date or “stale” datasets can be automatically detected and, if required, action taken. The data processing platform 102 may maintain a version control system that represents all code changes on the external system 176. Further, complex code or datasets such as chemical, pharmaceutical or engineering models need not leave the external system and nor need they be re-written on a different platform.
In some embodiments, an agent 170 may be provided for respective external applications. For example, one agent may be provided for external SAS applications and other agent may be provided for MATLAB.
In some embodiments, the code that is to be executed at the external system 176 may be created via the data processing platform 102. For example, the external system 176 may not have a version control system or even a central code storage system, and hence the ‘system of record’ version or ‘master’ version of the code may be provided in the data processing platform 102. The code may be sent to the external system 176 for execution in the manner described above.
In some embodiments, the agent 170, for example the external connector 174, may only have access to a specific location on the external system 176 from where it reads code. This may enable the customer to maintain a location, e.g. one or more directories of promoted code that is considered ready and safe for execution in association with the data processing platform 102.
In some embodiments, the external connector 174 may have at least two configurations. A first, source configuration enables linking the data processing platform 102 with the external system 176, including parameters such as the external system URL and credentials. A second, build configuration may enable receipt and provision of input datasets, output datasets, code references etc.
In some embodiments, the agent 170 may reside on the same or a different server than the external system 176.
The various features and processes described above may be used independently of one another, or may be combined in various ways. All possible combinations and sub combinations are intended to fall within the scope of this disclosure. In addition, certain method or process blocks may be omitted in some implementations. The methods and processes described herein are also not limited to any particular sequence, and the blocks or states relating thereto can be performed in other sequences that are appropriate. For example, described blocks or states may be performed in an order other than that specifically disclosed, or multiple blocks or states may be combined in a single block or state. The example blocks or states may be performed in serial, in parallel, or in some other manner. Blocks or states may be added to or removed from the disclosed example embodiments. The example systems and components described herein may be configured differently than described. For example, elements may be added to, removed from, or rearranged compared to the disclosed example embodiments.
Conditional language, such as, among others, “can,” “could,” “might,” or “may,” unless specifically stated otherwise, or otherwise understood within the context as used, is generally intended to convey that certain embodiments include, while other embodiments do not include, certain features, elements and/or steps. Thus, such conditional language is not generally intended to imply that features, elements and/or steps are in any way required for one or more embodiments or that one or more embodiments necessarily include logic for deciding, with or without user input or prompting, whether these features, elements and/or steps are included or are to be performed in any particular embodiment.
Any process descriptions, elements, or blocks in the flow diagrams described herein and/or depicted in the attached figures should be understood as potentially representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps in the process. Alternate implementations are included within the scope of the embodiments described herein in which elements or functions may be deleted, executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those skilled in the art.
It should be emphasized that many variations and modifications may be made to the above-described embodiments, the elements of which are to be understood as being among other acceptable examples. All such modifications and variations are intended to be included herein within the scope of this disclosure. The foregoing description details certain embodiments of the invention. It will be appreciated, however, that no matter how detailed the foregoing appears in text, the invention can be practiced in many ways. As is also stated above, it should be noted that the use of particular terminology when describing certain features or aspects of the invention should not be taken to imply that the terminology is being re-defined herein to be restricted to including any specific characteristics of the features or aspects of the invention with which that terminology is associated. The scope of the invention should therefore be construed in accordance with the appended claims and any equivalents thereof.
| Number | Date | Country | Kind |
|---|---|---|---|
| 1818997.7 | Nov 2018 | GB | national |
| Number | Name | Date | Kind |
|---|---|---|---|
| 10079832 | Dearment | Sep 2018 | B1 |
| 20030182652 | Custodio | Sep 2003 | A1 |
| 20060059463 | Janssen et al. | Mar 2006 | A1 |
| 20110072493 | Morishita | Mar 2011 | A1 |
| 20170139952 | Arasan et al. | May 2017 | A1 |
| 20190272271 | Bhattacharjee | Sep 2019 | A1 |
| 20200050607 | Pal | Feb 2020 | A1 |
| 20200065340 | Hodge | Feb 2020 | A1 |
| 20200073865 | Jacob | Mar 2020 | A1 |
| Number | Date | Country |
|---|---|---|
| 3336690 | Jun 2018 | EP |
| WO 2017222927 | Dec 2017 | WO |
| Entry |
|---|
| Official Communication for European Patent Application No. 19152635.9 dated Apr. 1, 2019. |
| Number | Date | Country | |
|---|---|---|---|
| 20200167151 A1 | May 2020 | US |
