Example embodiments of the present disclosure relate generally to code generation and modification and, more particularly, to interactive automated code generation and modification for data processing. Specifically, example embodiments of the present disclosure relate to the interactive automated modification of transformed data sets.
Data which has already been processed and finalized may be difficult to enrich, adjust, change, delete, and/or the like without re-processing and/or re-coding the data. A need, therefore, exists for an automated and dynamic system to accurately and efficiently modify the already processed and transformed data without requiring a re-processing and without requiring too many computing resources to do so.
Through applied effort, ingenuity, and innovation, many of these identified problems have been solved by developing solutions that are included in embodiments of the present disclosure, many examples of which are described in detail herein.
The following presents a simplified summary of one or more embodiments of the present disclosure, in order to provide a basic understanding of such embodiments. This summary is not an extensive overview of all contemplated embodiments and is intended to neither identify key or critical elements of all embodiments nor delineate the scope of any or all embodiments. Its sole purpose is to present some concepts of one or more embodiments of the present disclosure in a simplified form as a prelude to the more detailed description that is presented later.
In an example embodiment, a system for interactive automated modification of transformed data sets is provided. In some embodiments, the system may comprise: a memory device with computer-readable program code stored thereon; at least one processing device, wherein executing the computer-readable code is configured to cause the at least one processing device to perform the following operations: identify at least one processed data set, wherein the processed data set comprises at least one processed data organized into at least one processed element; generate, based on the at least one processed data set, a processed data set interface component; transmit the processed data set interface component to a user device and configure a graphical user interface (GUI) of the user device with the processed data set interface component; identify at least one user input of the user device, wherein the at least one user input comprises at least one adjustment request for the processed data set; automatically implement the at least one adjustment request to the processed data set and generate an adjusted processed data set interface component; and transmit the adjusted processed data set interface component to the user device and configure the GUI of the user device with the adjusted processed data set interface component.
In some embodiments, the computer-readable code is configured to cause the at least one processing device to perform the following operations: receive, in response to the adjusted processed data set interface component configuring the GUI of the user device, at least one adjustment user input from the user device; and determine whether to execute the at least one adjustment request to the at least one processed data set based on the at least one adjustment user input, execute, in an instance where the at least one adjustment user input comprises an acceptable adjustment user input, the adjustment request to the at least one processed data set, or execute, in an instance where the at least one adjustment user input comprises a rejection adjustment user input, the at least one processed data set.
In some embodiments, the at least one processed element comprises at least one of a column, a row, a cell, an attribute, a function, or a value.
In some embodiments, the at least one adjustment request comprises at least one of a table merge, a table addition, a table subtraction, a column addition, a column subtraction, a column merge, a row addition, a row subtraction, a row merge, an adjusted function, a pre-generated function, a new function, an adjusted attribute, an adjusted cell, or an adjusted value.
In some embodiments, the adjusted processed data set interface component comprises at least one adjusted processed data set interface component for each adjustment request, and wherein the at least one adjusted processed data set interface component comprises a version identifier associated with the at least one adjustment request. In some embodiments, the at least one adjusted processed data set interface component comprises a plurality of adjusted processed data set interface components, and wherein the plurality of adjusted processed data set interface components configures the GUI of the user device.
In some embodiments, the computer-readable code is configured to cause the at least one processing device to perform the following operations: generate at least one pipeline interface component, wherein the pipeline interface component is associated with the at least one adjusted processed data set interface component; and transmit the at least one pipeline interface component to the user device and configure the GUI of the user device with the at least one pipeline interface component. In some embodiments, the at least one pipeline interface component comprises the at least one implemented adjustment request, and wherein the at least one pipeline interface component comprises at least one of a direct output or an indirect output from the at least one adjustment request.
In some embodiments, the computer-readable code is configured to cause the at least one processing device to perform the following operations: identify a legacy logic associated with the at least one processed data set, wherein the legacy logic is supported in a legacy application; transmit a legacy logic action request to the legacy application; receive, response to transmitting the legacy logic action request to the legacy application, a legacy logic action response from the legacy application; and configure the at least one adjusted processed data set interface component with the legacy logic action response, wherein the legacy logic action response.
Similarly, and as a person of skill in the art will understand, each of the features, functions, and advantages provided herein with respect to the system disclosed hereinabove may additionally be provided with respect to a computer-implemented method and computer program product. Such embodiments are provided for exemplary purposes below and are not intended to be limited.
The features, functions, and advantages that have been discussed may be achieved independently in various embodiments of the present disclosure or may be combined with yet other embodiments, further details of which can be seen with reference to the following description and drawings.
Having described certain example embodiments of the present disclosure in general terms above, reference will now be made to the accompanying drawings. The components illustrated in the figures may or may not be present in certain embodiments described herein. Some embodiments may include fewer (or more) components than those shown in the figures.
Embodiments of the present disclosure will now be described more fully hereinafter with reference to the accompanying drawings, in which some, but not all, embodiments of the disclosure are shown. Indeed, the various inventions may be embodied in many different forms and should not be construed as limited to the embodiments set forth herein; rather, these embodiments are provided so that this disclosure will satisfy applicable legal requirements. Where possible, any terms expressed in the singular form herein are meant to also include the plural form and vice versa, unless explicitly stated otherwise. Also, as used herein, the term “a” and/or “an” shall mean “one or more,” even though the phrase “one or more” is also used herein. Furthermore, when it is said herein that something is “based on” something else, it may be based on one or more other things as well. In other words, unless expressly indicated otherwise, as used herein “based on” means “based at least in part on” or “based at least partially on.” Like numbers refer to like elements throughout.
As used herein, an “entity” may be any institution employing information technology resources and particularly technology infrastructure configured for processing large amounts of data. Typically, these data can be related to the people who work for the organization, its products or services, the customers, or any other aspect of the operations of the organization. As such, the entity may be any institution, group, association, financial institution, establishment, company, union, authority or the like, employing information technology resources for processing large amounts of data.
As described herein, a “user” may be an individual associated with an entity. As such, in some embodiments, the user may be an individual having past relationships, current relationships or potential future relationships with an entity. In some embodiments, the user may be an employee (e.g., an associate, a project manager, an IT specialist, a manager, an administrator, an internal operations analyst, or the like) of the entity or enterprises affiliated with the entity.
As used herein, a “user interface” may be a point of human-computer interaction and communication in a device that allows a user to input information, such as commands or data, into a device, or that allows the device to output information to the user. For example, the user interface includes a graphical user interface (GUI) or an interface to input computer-executable instructions that direct a processor to carry out specific functions. The user interface typically employs certain input and output devices such as a display, mouse, keyboard, button, touchpad, touch screen, microphone, speaker, LED, light, joystick, switch, buzzer, bell, and/or other user input/output device for communicating with one or more users.
As used herein, an “engine” may refer to core elements of an application, or part of an application that serves as a foundation for a larger piece of software and drives the functionality of the software. In some embodiments, an engine may be self-contained, but externally-controllable code that encapsulates powerful logic designed to perform or execute a specific type of function. In one aspect, an engine may be underlying source code that establishes file hierarchy, input and output methods, and how a specific part of an application interacts or communicates with other software and/or hardware. The specific components of an engine may vary based on the needs of the specific application as part of the larger piece of software. In some embodiments, an engine may be configured to retrieve resources created in other applications, which may then be ported into the engine for use during specific operational aspects of the engine. An engine may be configurable to be implemented within any general purpose computing system. In doing so, the engine may be configured to execute source code embedded therein to control specific features of the general purpose computing system to execute specific computing operations, thereby transforming the general purpose system into a specific purpose computing system.
It should also be understood that “operatively coupled,” as used herein, means that the components may be formed integrally with each other, or may be formed separately and coupled together. Furthermore, “operatively coupled” means that the components may be formed directly to each other, or to each other with one or more components located between the components that are operatively coupled together. Furthermore, “operatively coupled” may mean that the components are detachable from each other, or that they are permanently coupled together. Furthermore, operatively coupled components may mean that the components retain at least some freedom of movement in one or more directions or may be rotated about an axis (i.e., rotationally coupled, pivotally coupled). Furthermore, “operatively coupled” may mean that components may be electronically connected and/or in fluid communication with one another.
As used herein, an “interaction” may refer to any communication between one or more users, one or more entities or institutions, one or more devices, nodes, clusters, or systems within the distributed computing environment described herein. For example, an interaction may refer to a transfer of data between devices, an accessing of stored data by one or more nodes of a computing cluster, a transmission of a requested task, or the like.
As used herein, “determining” may encompass a variety of actions. For example, “determining” may include calculating, computing, processing, deriving, investigating, ascertaining, and/or the like. Furthermore, “determining” may also include receiving (e.g., receiving information), accessing (e.g., accessing data in a memory), and/or the like. Also, “determining” may include resolving, selecting, choosing, calculating, establishing, and/or the like. Determining may also include ascertaining that a parameter matches a predetermined criterion, including that a threshold has been met, passed, exceeded, and so on.
Automating processing flows typically requires hard coding individual processes. As such, any changes to the processing may cause the other processes in the flow to be changed. However, such operations are time consuming and difficult to achieve.
Data which has already been processed and finalized may be difficult to enrich, adjust, change, delete, and/or the like without re-processing and/or re-coding the data. A need, therefore, exists for an automated and dynamic system to accurately and efficiently modify the already processed and transformed data without requiring a re-processing and without requiring too many computing resources to do so.
Thus, an enricher application, such as the system, method, and computer implemented method described herein is configured to enrich the data (such as the already processed data) without requiring the enriched data to be re-processed and/or only requiring minimal to no coding requirements.
Accordingly, the present disclosure provides a system, method, computer implemented method, and/or the like configured to identify at least one processed data set, wherein the processed data set (e.g., already processed data and/or already organized data) comprises at least one processed data organized into at least one processed element; generate, based on the at least one processed data set, a processed data set interface component; transmit the processed data set interface component to a user device and configure a graphical user interface (GUI) of the user device with the processed data set interface component; identify at least one user input of the user device, wherein the at least one user input comprises at least one adjustment request for the processed data set (e.g., an adjustment request to change, reformat, transform, delete, add, and/or the like of the data of the processed data set); automatically implement the at least one adjustment request to the processed data set and generate an adjusted processed data set interface component; and transmit the adjusted processed data set interface component to the user device and configure the GUI of the user device with the adjusted processed data set interface component.
What is more, the present disclosure provides a technical solution to a technical problem. As described herein, the technical problem includes the enrichment of data with minimal to no re-processing requirements of the already processed data. The technical solution presented herein allows for an enrichment program and/or enrichment application like the system, computer program product, computer implemented method like that described herein which is configured to allow for enriching data without requiring re-processing and/or requiring minimal coding of the enriched data. In particular, the enrichment program is an improvement over existing solutions to the enrichment of processed data, (i) with fewer steps to achieve the solution, thus reducing the amount of computing resources, such as processing resources, storage resources, network resources, and/or the like, that are being used, (ii) providing a more accurate solution to problem, thus reducing the number of resources required to remedy any errors made due to a less accurate solution, (iii) removing manual input and waste from the implementation of the solution, thus improving speed and efficiency of the process and conserving computing resources, (iv) determining an optimal amount of resources that need to be used to implement the solution, thus reducing network traffic and load on existing computing resources. Furthermore, the technical solution described herein uses a rigorous, computerized process to perform specific tasks and/or activities that were not previously performed. In specific implementations, the technical solution bypasses a series of steps previously implemented, thus further conserving computing resources.
In some embodiments, the system 130 and the end-point device(s) 140 may have a client-server relationship in which the end-point device(s) 140 are remote devices that request and receive service from a centralized server, i.e., the system 130. In some other embodiments, the system 130 and the end-point device(s) 140 may have a peer-to-peer relationship in which the system 130 and the end-point device(s) 140 are considered equal and all have the same abilities to use the resources available on the network(s) 110. Instead of having a central server (e.g., system 130) which would act as the shared drive, each device that is connect to the network(s) 110 would act as the server for the files stored on it.
The system 130 may represent various forms of servers, such as web servers, database servers, file server, or the like, various forms of digital computing devices, such as laptops, desktops, video recorders, audio/video players, radios, workstations, or the like, or any other auxiliary network devices, such as wearable devices, Internet-of-things devices, electronic kiosk devices, mainframes, or the like, or any combination of the aforementioned.
The end-point device(s) 140 may represent various forms of electronic devices, including user input devices such as personal digital assistants, cellular telephones, smartphones, laptops, desktops, and/or the like, merchant input devices such as point-of-sale (POS) devices, electronic payment kiosks, and/or the like, electronic telecommunications device (e.g., automated teller machine (ATM)), and/or edge devices such as routers, routing switches, integrated access devices (IAD), and/or the like.
The network(s) 110 may be a distributed network that is spread over different networks. This provides a single data communication network, which can be managed jointly or separately by each network. Besides shared communication within the network, the distributed network often also supports distributed processing. The network(s) 110 may be a form of digital communication network such as a telecommunication network, a local area network (“LAN”), a wide area network (“WAN”), a global area network (“GAN”), the Internet, satellite network, cellular network, and/or any combination of the foregoing. The network(s) 110 may be secure and/or unsecure and may also include wireless and/or wired and/or optical interconnection technology.
It is to be understood that the structure of the distributed computing environment and its components, connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the disclosure described and/or claimed in this document. In one example, the distributed computing environment 100 may include more, fewer, or different components. In another example, some or all of the portions of the distributed computing environment 100 may be combined into a single portion or all of the portions of the system 130 may be separated into two or more distinct portions.
The processor 102 can process instructions, such as instructions of an application that may perform the functions disclosed herein. These instructions may be stored in the memory 104 (e.g., non-transitory storage device) or on the storage device 106, for execution within the system 130 using any subsystems described herein. It is to be understood that the system 130 may use, as appropriate, multiple processors, along with multiple memories, and/or I/O devices, to execute the processes described herein.
The memory 104 stores information within the system 130. In one implementation, the memory 104 is a volatile memory unit or units, such as volatile random access memory (RAM) having a cache area for the temporary storage of information, such as a command, a current operating state of the distributed computing environment 100, an intended operating state of the distributed computing environment 100, instructions related to various methods and/or functionalities described herein, and/or the like. In another implementation, the memory 104 is a non-volatile memory unit or units. The memory 104 may also be another form of computer-readable medium, such as a magnetic or optical disk, which may be embedded and/or may be removable. The non-volatile memory may additionally or alternatively include an EEPROM, flash memory, and/or the like for storage of information such as instructions and/or data that may be read during execution of computer instructions. The memory 104 may store, recall, receive, transmit, and/or access various files and/or information used by the system 130 during operation.
The storage device 106 is capable of providing mass storage for the system 130. In one aspect, the storage device 106 may be or contain a computer-readable medium, such as a floppy disk device, a hard disk device, an optical disk device, or a tape device, a flash memory or other similar solid state memory device, or an array of devices, including devices in a storage area network or other configurations. A computer program product can be tangibly embodied in an information carrier. The computer program product may also contain instructions that, when executed, perform one or more methods, such as those described above. The information carrier may be a non-transitory computer- or machine-readable storage medium, such as the memory 104, the storage device 106, or memory on processor 102.
The high-speed interface 108 manages bandwidth-intensive operations for the system 130, while the low-speed interface 112 manages lower bandwidth-intensive operations. Such allocation of functions is exemplary only. In some embodiments, the high-speed interface 108 (shown as “HS Interface”) is coupled to memory 104, input/output (I/O) device 116 (e.g., through a graphics processor or accelerator), and to high-speed expansion ports 111 (shown as “HS Port”), which may accept various expansion cards (not shown). In such an implementation, low-speed interface 112 is coupled to storage device 106 and low-speed expansion port 114. The low-speed expansion port 114, which may include various communication ports (e.g., USB, Bluetooth, Ethernet, wireless Ethernet), may be coupled to one or more input/output devices, such as a keyboard, a pointing device, a scanner, or a networking device such as a switch or router, e.g., through a network adapter.
The system 130 may be implemented in a number of different forms. For example, it may be implemented as a standard server, or multiple times in a group of such servers. Additionally, the system 130 may also be implemented as part of a rack server system or a personal computer such as a laptop computer. Alternatively, components from system 130 may be combined with one or more other same or similar systems and an entire system 130 may be made up of multiple computing devices communicating with each other.
The processor 152 is configured to execute instructions within the end-point device(s) 140, including instructions stored in the memory 154, which in one embodiment includes the instructions of an application that may perform the functions disclosed herein, including certain logic, data processing, and data storing functions. The processor may be implemented as a chipset of chips that include separate and multiple analog and digital processors. The processor may be configured to provide, for example, for coordination of the other components of the end-point device(s) 140, such as control of user interfaces, applications run by end-point device(s) 140, and wireless communication by end-point device(s) 140.
The processor 152 may be configured to communicate with the user through control interface 164 and display interface 166 coupled to a display 156. The display 156 may be, for example, a TFT LCD (Thin-Film-Transistor Liquid Crystal Display) or an OLED (Organic Light Emitting Diode) display, or other appropriate display technology. The display 156 may comprise appropriate circuitry and configured for driving the display 156 to present graphical and other information to a user. The control interface 164 may receive commands from a user and convert them for submission to the processor 152. In addition, an external interface 168 may be provided in communication with processor 152, so as to enable near area communication of end-point device(s) 140 with other devices. External interface 168 may provide, for example, for wired communication in some implementations, or for wireless communication in other implementations, and multiple interfaces may also be used.
The memory 154 stores information within the end-point device(s) 140. The memory 154 can be implemented as one or more of a computer-readable medium or media, a volatile memory unit or units, or a non-volatile memory unit or units. Expansion memory may also be provided and connected to end-point device(s) 140 through an expansion interface (not shown), which may include, for example, a SIMM (Single in Line Memory Module) card interface. Such expansion memory may provide extra storage space for end-point device(s) 140 or may also store applications or other information therein. In some embodiments, expansion memory may include instructions to carry out or supplement the processes described above and may include secure information also. For example, expansion memory may be provided as a security module for end-point device(s) 140 and may be programmed with instructions that permit secure use of end-point device(s) 140. In addition, secure applications may be provided via the SIMM cards, along with additional information, such as placing identifying information on the SIMM card in a non-hackable manner.
The memory 154 may include, for example, flash memory and/or NVRAM memory. In one aspect, a computer program product is tangibly embodied in an information carrier. The computer program product contains instructions that, when executed, perform one or more methods, such as those described herein. The information carrier is a computer-or machine-readable medium, such as the memory 154, expansion memory, memory on processor 152, or a propagated signal that may be received, for example, over transceiver 160 or external interface 168.
In some embodiments, the user may use the end-point device(s) 140 to transmit and/or receive information or commands to and from the system 130 via the network(s) 110. Any communication between the system 130 and the end-point device(s) 140 may be subject to an authentication protocol allowing the system 130 to maintain security by permitting only authenticated users (or processes) to access the protected resources of the system 130, which may include servers, databases, applications, and/or any of the components described herein. To this end, the system 130 may trigger an authentication subsystem that may require the user (or process) to provide authentication credentials to determine whether the user (or process) is eligible to access the protected resources. Once the authentication credentials are validated and the user (or process) is authenticated, the authentication subsystem may provide the user (or process) with permissioned access to the protected resources. Similarly, the end-point device(s) 140 may provide the system 130 (or other client devices) permissioned access to the protected resources of the end-point device(s) 140, which may include a GPS device, an image capturing component (e.g., camera), a microphone, and/or a speaker.
The end-point device(s) 140 may communicate with the system 130 through at least one of communication interfaces 158, which may include digital signal processing circuitry where necessary. Communication interfaces 158 may provide for communications under various modes or protocols, such as the Internet Protocol (IP) suite (commonly known as TCP/IP). Protocols in the IP suite define end-to-end data handling methods for everything from packetizing, addressing, and routing, to receiving. Broken down into layers, the IP suite includes the link layer, containing communication methods for data that remains within a single network segment (link); the Internet layer, providing internetworking between independent networks; the transport layer, handling host-to-host communication; and the application layer, providing process-to-process data exchange for applications. Each layer contains a stack of protocols used for communications. In addition, the communication interfaces 158 may provide for communications under various telecommunications standards (2G, 3G, 4G, 5G, and/or the like) using their respective layered protocol stacks. These communications may occur through a transceiver 160, such as radio-frequency transceiver. In addition, short-range communication may occur, such as using a Bluetooth, Wi-Fi, or other such transceiver (not shown). In addition, GPS (Global Positioning System) receiver module 170 may provide additional navigation—and location-related wireless data to end-point device(s) 140, which may be used as appropriate by applications running thereon, and in some embodiments, one or more applications operating on the system 130. The end-point device(s) 140 may include a communication interface that is configured to operate with a satellite network.
In various embodiments, the end-point device(s) 140 may have multiple communication interfaces that are configured to operate using the various communication methods discussed herein. For example, an end-point device 140 may have a cellular network communication interface (e.g., a communication interface that provides for communication under various telecommunications standards) and a satellite network communication interface (e.g., a communication interface that provides for communication via a satellite network). Various other communication interfaces may also be provided by the end-point device (e.g., an end-point device may be capable of communicating via a cellular network, a satellite network, and/or a wi-fi connection). Various communication interfaces may share components with other communication interfaces in the given end-point device.
The end-point device(s) 140 may also communicate audibly using audio codec 162, which may receive spoken information from a user and convert it to usable digital information. Audio codec 162 may likewise generate audible sound for a user, such as through a speaker, e.g., in a handset of end-point device(s) 140. Such sound may include sound from voice telephone calls, may include recorded sound (e.g., voice messages, music files, etc.) and may also include sound generated by one or more applications operating on the end-point device(s) 140, and in some embodiments, one or more applications operating on the system 130.
Various implementations of the distributed computing environment 100, including the system 130 and end-point device(s) 140, and techniques described here can be realized in digital electronic circuitry, integrated circuitry, specially designed ASICs (application specific integrated circuits), computer hardware, firmware, software, and/or combinations thereof.
The machine learning subsystem 200 may include a data acquisition engine 202, data ingestion engine 210, data pre-processing engine 216, ML model tuning engine 222, and inference engine 236.
The data acquisition engine 202 may identify various internal and/or external data sources to generate, test, and/or integrate new features for training the machine learning model 224. These internal and/or external data sources 204, 206, and 208 may be initial locations where the data originates or where physical information is first digitized. The data acquisition engine 202 may identify the location of the data and describe connection characteristics for access and retrieval of data. In some embodiments, data is transported from each data source 204, 206, or 208 using any applicable network protocols, such as the File Transfer Protocol (FTP), Hyper-Text Transfer Protocol (HTTP), or any of the myriad Application Programming Interfaces (APIs) provided by websites, networked applications, and other services. In some embodiments, the these data sources 204, 206, and 208 may include Enterprise Resource Planning (ERP) databases that host data related to day-to-day business activities such as accounting, procurement, project management, exposure management, supply chain operations, and/or the like, mainframe that is often the entity's central data processing center, edge devices that may be any piece of hardware, such as sensors, actuators, gadgets, appliances, or machines, that are programmed for certain applications and can transmit data over the internet or other networks, and/or the like. The data acquired by the data acquisition engine 202 from these data sources 204, 206, and 208 may then be transported to the data ingestion engine 210 for further processing.
Depending on the nature of the data imported from the data acquisition engine 202, the data ingestion engine 210 may move the data to a destination for storage or further analysis. Typically, the data imported from the data acquisition engine 202 may be in varying formats as they come from different sources, including RDBMS, other types of databases, S3 buckets, CSVs, or from streams. Since the data comes from different places, it needs to be cleansed and transformed so that it can be analyzed together with data from other sources. At the data ingestion engine 210, the data may be ingested in real-time, using the stream processing engine 212, in batches using the batch data warehouse 214, or a combination of both. The stream processing engine 212 may be used to process continuous data stream (e.g., data from edge devices), i.e., computing on data directly as it is received, and filter the incoming data to retain specific portions that are deemed useful by aggregating, analyzing, transforming, and ingesting the data. On the other hand, the batch data warehouse 214 collects and transfers data in batches according to scheduled intervals, trigger events, or any other logical ordering.
In machine learning, the quality of data and the useful information that can be derived therefrom directly affects the ability of the machine learning model 224 to learn. The data pre-processing engine 216 may implement advanced integration and processing steps needed to prepare the data for machine learning execution. This may include modules to perform any upfront, data transformation to consolidate the data into alternate forms by changing the value, structure, or format of the data using generalization, normalization, attribute selection, and aggregation, data cleaning by filling missing values, smoothing the noisy data, resolving the inconsistency, and removing outliers, and/or any other encoding steps as needed.
In addition to improving the quality of the data, the data pre-processing engine 216 may implement feature extraction and/or selection techniques to generate training data 218. Feature extraction and/or selection is a process of dimensionality reduction by which an initial set of data is reduced to more manageable groups for processing. A characteristic of these large data sets is a large number of variables that require a lot of computing resources to process. Feature extraction and/or selection may be used to select and/or combine variables into features, effectively reducing the amount of data that must be processed, while still accurately and completely describing the original data set. Depending on the type of machine learning algorithm being used, this training data 218 may require further enrichment. For example, in supervised learning, the training data is enriched using one or more meaningful and informative labels to provide context so a machine learning model can learn from it. For example, labels might indicate whether a photo contains a bird or car, which words were uttered in an audio recording, or if an x-ray contains a tumor. Data labeling is required for a variety of use cases including computer vision, natural language processing, and speech recognition. In contrast, unsupervised learning uses unlabeled data to find patterns in the data, such as inferences or clustering of data points.
The ML model tuning engine 222 may be used to train a machine learning model 224 using the training data 218 to make predictions or decisions without explicitly being programmed to do so. The machine learning model 224 represents what was learned by the selected machine learning algorithm 220 and represents the rules, numbers, and any other algorithm-specific data structures required for classification. Selecting the right machine learning algorithm may depend on a number of different factors, such as the problem statement and the kind of output needed, type and size of the data, the available computational time, number of features and observations in the data, and/or the like. Machine learning algorithms may refer to programs (math and logic) that are configured to self-adjust and perform better as they are exposed to more data. To this extent, machine learning algorithms are capable of adjusting their own parameters, given feedback on previous performance in making prediction about a dataset.
The machine learning algorithms contemplated, described, and/or used herein include supervised learning (e.g., using logistic regression, using back propagation neural networks, using random forests, decision trees, etc.), unsupervised learning (e.g., using an Apriori algorithm, using K-means clustering), semi-supervised learning, reinforcement learning (e.g., using a Q-learning algorithm, using temporal difference learning), and/or any other suitable machine learning model type. Each of these types of machine learning algorithms can implement any of one or more of a regression algorithm (e.g., ordinary least squares, logistic regression, stepwise regression, multivariate adaptive regression splines, locally estimated scatterplot smoothing, etc.), an instance-based method (e.g., k-nearest neighbor, learning vector quantization, self-organizing map, etc.), a regularization method (e.g., ridge regression, least absolute shrinkage and selection operator, elastic net, etc.), a decision tree learning method (e.g., classification and regression tree, iterative dichotomiser 3, C4.5, chi-squared automatic interaction detection, decision stump, random forest, multivariate adaptive regression splines, gradient boosting machines, etc.), a Bayesian method (e.g., naïve Bayes, averaged one-dependence estimators, Bayesian belief network, etc.), a kernel method (e.g., a support vector machine, a radial basis function, etc.), a clustering method (e.g., k-means clustering, expectation maximization, etc.), an associated rule learning algorithm (e.g., an Apriori algorithm, an Eclat algorithm, etc.), an artificial neural network model (e.g., a Perceptron method, a back-propagation method, a Hopfield network method, a self-organizing map method, a learning vector quantization method, etc.), a deep learning algorithm (e.g., a restricted Boltzmann machine, a deep belief network method, a convolution network method, a stacked auto-encoder method, etc.), a dimensionality reduction method (e.g., principal component analysis, partial least squares regression, Sammon mapping, multidimensional scaling, projection pursuit, etc.), an ensemble method (e.g., boosting, bootstrapped aggregation, AdaBoost, stacked generalization, gradient boosting machine method, random forest method, etc.), and/or the like.
To tune the machine learning model, the ML model tuning engine 222 may repeatedly execute cycles of experimentation 226, testing 228, and tuning 230 to optimize the performance of the machine learning algorithm 220 and refine the results in preparation for deployment of those results for consumption or decision making. To this end, the ML model tuning engine 222 may dynamically vary hyperparameters each iteration (e.g., number of trees in a tree-based algorithm or the value of alpha in a linear algorithm), run the algorithm on the data again, then compare its performance on a validation set to determine which set of hyperparameters results in the most accurate model. The accuracy of the model is the measurement used to determine which set of hyperparameters is best at identifying relationships and patterns between variables in a dataset based on the input, or training data 218. A fully trained machine learning model 232 is one whose hyperparameters are tuned and model accuracy maximized.
The trained machine learning model 232, similar to any other software application output, can be persisted to storage, file, memory, or application, or looped back into the processing component to be reprocessed. More often, the trained machine learning model 232 is deployed into an existing production environment to make practical business decisions based on live data 234. To this end, the machine learning subsystem 200 uses the inference engine 236 to make such decisions. The type of decision-making may depend upon the type of machine learning algorithm used. For example, machine learning models trained using supervised learning algorithms may be used to structure computations in terms of categorized outputs (e.g., C_1, C_2 . . . . C_n 238) or observations based on defined classifications, represent possible solutions to a decision based on certain conditions, model complex relationships between inputs and outputs to find patterns in data or capture a statistical structure among variables with unknown relationships, and/or the like. On the other hand, machine learning models trained using unsupervised learning algorithms may be used to group (e.g., C_1, C_2 . . . . C_n 238) live data 234 based on how similar they are to one another to solve exploratory challenges where little is known about the data, provide a description or label (e.g., C_1, C_2 . . . . C_n 238) to live data 234, such as in classification, and/or the like. These categorized outputs, groups (clusters), or labels are then presented to the user input system 130. In still other cases, machine learning models that perform regression techniques may use live data 234 to predict or forecast continuous outcomes.
It will be understood that the embodiment of the machine learning subsystem 200 illustrated in
As shown in block 302, the process flow 300 may include the step of identifying at least one processed data set, wherein the processed data set comprises at least one processed data organized into at least one processed element. For instance, the data flow designer as discussed herein may be used to create a processed data set and/or processed element, whereby the processed data set and/or processed element refers to data that undergoes a manipulation, an organization, a translation, and/or the like in order to be used in computer-readable format. In this manner, the processed data set may comprise multiple pieces of data that have undergone some sort of transformation/processing (e.g., via manipulation, organization, translation, combination, and/or the like) to generate the processed data in a computer-readable format (and sometimes in a human readable format through the use of an interface component to configure a graphical user interface of a user device).
In this manner, and as described in further detail herein, the system described herein comprises an enricher application and/or enricher program that is configured to adjust the processed data sets and/or processed data without requiring the data sets and/or data to be re-processed. The enricher provides this functionality with minimal to no coding requirements.
As used herein, the processed elements refer to a component used for processing the data sets and/or data. For instance, the processed elements may comprise at least one of a column (e.g., within a table); a row (e.g., within a table); a cell (e.g., within a table which may be used for organizing the data); an attribute (e.g., an attribute of the data such as the type of data); a function (e.g., a function for processing the data, for manipulating the data, and/or for changing the data, such as where the data is value a function may comprise an algebraic function); a value (e.g., a numerical value); and/or the like. For instance, and where the processed data is organized into a table and/or a plurality of tables, the processed elements may comprise a particular row, a particular column, and/or a particular cell of the table(s) where the processed data is organized.
As shown in block 304, the process flow 300 may include the step of generating, based on the at least one processed data set, a processed data set interface component. Such a processed data set interface component may comprise a data packet of the processed data sets (including the processed element(s) and processed data) in a computer-readable format, whereby the processed data set interface component is transmitted to a user device and is used to configure a graphical user interface (GUI) of a user device to show the processed data in its associated processed element(s) in a human readable format. By way of non-limiting example, and where the processed data is organized into a table with columns, rows, and cells, the processed data set interface component may comprise the table with the processed data in a computer readable format and transmit the data packet of the computer readable format to the user device and configure the GUI to show the user of the user device the table of processed data in a human readable format. In this manner, the system may be configured to show a user of a user device the processed data as it is organized and accept user provided inputs to make changes to the processed data without requiring re-processing and/or re-coding of the data.
As shown in block 306, the process flow 300 may include the step of transmitting the processed data set interface component to a user device and configure a graphical user interface (GUI) of the user device with the processed data set interface component. Similar to the processed described above, the system may transmit the processed data set interface component to a user device, whereby the processed data set interface component may configure the GUI of the user device to show the user of the user device the data of the processed data set interface component in a human-readable format. In some embodiments, the user device described herein may comprise a user device associated with a manager of the system, a user device associated with a client of the system (e.g., such as a data specialist of the client of the system and/or entity using the system to organize its data), and/or the like.
As shown in block 308, the process flow 300 may include the step of identifying at least one user input of the user device, wherein the at least one user input comprises at least one adjustment request for the processed data set. By of example, the system may identify at least one user provided input at the user device, such as a mouse “click,” “selection,” keyboard input(s), a microphone input, and/or the like, which may be used to indicate a user's intention to select an element on the GUI of the user device. In some embodiments, such a user input may comprise at least one adjustment request for the processed data set, whereby the at least one adjustment request refers to a request and/or an indication of change to the processed data of the processed data set interface component. Such an adjustment request may comprise at least one of a table merge, a table addition, a table subtraction, a column addition, a column subtraction, a column merge, a row addition, a row subtraction, a row merge, an adjusted function, a pre-generated function, a new function, an adjusted attribute, an adjusted cell, an adjusted value, and/or the like.
By way of example, the table merge, the table addition, the table subtraction, the column addition, the column subtraction, the column merge, the row addition, the row subtraction, the row merge, and/or the like, may refer to a change to a table of processed data and/or a plurality of tables of processed data. In this manner, the adjustment request may identify at least one cell, at least one piece of data, a whole row, a whole column, a whole table, a plurality of tables, and/or the like where a change should be made without requiring a re-processing and/or re-coding of the data. In some embodiments, the adjusted value may comprise a value of the data that should be automatically updated (without the need to update a function to generate the value) for the data. For instance, and where the adjusted value comprises a single numerical value, such as a value of three, a cell of data identified for the adjusted value may be changed to comprise a value of three automatically and dynamically (e.g., after identifying the adjusted value for the adjustment request). Similarly, and where the adjustment request comprises an adjusted cell, the system may automatically and dynamically move the cell of data within a table, may delete the cell within a table, add a cell within a table, and/or the like.
As shown in block 310, the process flow 300 may include the step of automatically implementing the at least one adjustment request to the processed data set and generate an adjusted processed data set interface component. By way of example, the system may automatically implement the at least one adjustment request to the processed data set(s) upon identifying the adjustment request(s) has been received from the user device. Further, and once the adjustment request(s) have been implemented on the processed data set(s), the system may generate an adjusted processed data set interface component comprising the processed data set(s) and the updated processed data set(s) that have been changed based on the adjustment request(s). In this manner, the adjusted processed data set interface component may comprise a single view and/or single configuration of a GUI to show the user of the user device all the changes implemented on the processed data set(s) and the original processed data set(s) that were not changed based on the adjustment request(s).
In some embodiments, the adjusted processed data set interface component may comprise at least one adjusted processed data set interface component for each adjustment request, and wherein the at least one adjusted processed data set interface component comprises a version identifier associated with the at least one adjustment request. For instance, the system may generate a different adjusted processed data set interface component for each adjustment request, whereby each adjusted processed data set interface component may comprise an indication and/or an element to show the user which adjustment request has been used in generating the adjusted processed data set interface component and its affect on the processed data and updated processed data. In this manner, the adjusted processed data set interface component for each adjustment request may be shown to the user of the user device in order for the user to accept and/or reject the updated data set(s) from the adjustment request(s) before the updated data set(s) are executed within the processed data set(s). Thus, and in some embodiments, the at least one adjusted processed data set interface component may comprise a plurality of adjusted processed data set interface components, and wherein the plurality of adjusted processed data set interface components configures the GUI of the user device.
In some embodiments, and with respect to the at least one adjusted processed data set interface component(s) comprising the plurality of adjusted processed data set interface components, the plurality of adjusted processed data set interface components may configure the GUI of user device to show at least one pipeline of how the data is changed between the original processed data to the updated processed data, its directly affected data and its indirectly affected data from the adjustment request(s). Such a plurality of adjusted processed data set interface components may configure a single GUI of the user device to show all the pipelines for all the adjustment requests identified by the system, such that the user may view each of the affected data set(s) of the adjustment request(s) at a single time, at a single window, and/or at a single user interface.
In some embodiments, and where multiple adjustment requests are identified at the same time and to the same data, the system may generate a plurality of adjusted processed data set interface components to show each of the affected processed data by the adjustment requests in separate pipelines (e.g., with different outputs and at different adjusted processed data set interface components). Thus, and in some embodiments, each adjusted processed data set interface components may be identified and comprise a particular version based on the adjustment request.
As shown in block 312, the process flow 300 may include the step of transmitting the adjusted processed data set interface component to the user device and configuring the GUI of the user device with the adjusted processed data set interface component. By way of example, the system may transmit the adjusted processed data set interface component(s) to the user device and configure the GUI of the user device to show the data of the adjusted processed data set interface component(s) in a human-readable format. In this manner, the user of the user device may decide to accept and/or reject the updated data based on the adjustment request(s) before the updated data is executed in the processed data set(s). For instance, and in some embodiments, such an acceptance and/or rejection of the adjusted processed data set interface component(s) is described in further detail below with respect to
Additionally, and in some embodiments, similar processes with respect to enriching processed data sets are further described with respect to
Various operations of the system are detailed in reference to
In various embodiments, the system may include a data ingestion layer of the platform. The data ingestion layer allows configuration of a driven ingestion layer in which the connection parameters to connect with data sources of various data store types may be configured. As such, the system may be capable of loading a large number of rows of data.
In various embodiments, the system may generate a graphical user interface (e.g., part of a flow designer interface discussed herein) with a data feeds interface may be useful to define metadata about different types of input data which the system can accept. In various embodiments, the system may receive an input from the end-point device that defines the file/table structure, details about actual file and location where files are available to pull. Data can be read into the system through a File feed (
As shown in
Referring now to
As data is changed and/or updated by different plugins during a flow, the system may evaluate the data dictionary before and/or after each plugin is executed on the flow based on the user configurations to update the data dictionary. The data dictionary may be continuously evaluated. At each plugin of the flow, the data may have new fields added and/or existing fields modified or deleted, making the traceability of the fields transparent in the system.
In various embodiments, the system may source data from different upstream sources for transformations to derive new data. The data loading in the feed module is configured with an initial static data dictionary and sent to the flows for use. As such, the data dictionary is defined before the flow is executed and then updated during execution of the flow. Additionally, in an instance in which data is adjusted and/or enriched, as discussed herein, and new data is added to the data sets, the data dictionary may be updated to include the new data added. For example, an enricher plugin may add a new column to a data set and the data dictionary may be updated to include the data definition for one or more values added to the data.
In various embodiments, the system may include a flow designer that is configured to organize the operations of the system herein. For example, the flow designer is configured to perform operations relating to workflows, rules, calculations, reports, analytics and/or the like. In various embodiments, the system may include a flow designer interface that includes individual plugins that each perform a transformation on the data in the flow. The flow designer interface may allow multiple flows, where each flow is an individual transformation with a flow input and a flow output. Each flow is independent from the other flow, though in some instances, the output of a flow may be used in other flows. An example flow may consist of determining data sources, data transformation, data writing, data reporting steps, and/or the like.
In various embodiments, the flow designer interface represents each plugin as a block and allows for the blocks to be visually connected to one another to represent the transformations being completed. An example flow designer interface is shown in
In various embodiments, the system may include an end-to-end modularized data platform that enables users to digitize and optimize processes and workflows. To do this, the system combines data ingestion, data quality rules, business rules, workflows, calculation integration, testing, and/or the like, into maneuverable design environments. Additionally, the system provides an end-to-end solution from determining data sources to reporting & analytics.
In various embodiments, the system may include a flow designer assistance via AI functionality. As such, the system monitors users during operation of the flow designer platform and may provide recommendations and/or corrections to the actions by the user. For example, the system may automatically correct workflow steps in an instance in which a change is made in any plugin and/or provide suggestions for improving plugin configuration when any config changes are made. As such, the system allows for a user to make required changes at all appropriate places without having to manually scan through the configuration of every single plugin.
In various embodiments, the flow designer allows for plugins to be easily moved, added, removed, and/or changed in the system. However, the AI functionality allows for safeguards to protect the underlying data from being damaged and/or manipulated incorrectly. As such, the system is configured to monitor changes to the flow designer for functionality. For example, a user who has developed a process through 40 individual steps using 8 different data inputs on the workflow designer may want to make changes in steps 12 and 18 along with changes to the file structure for 2 input files. The system scans each workflow component (e.g., plugins) to determine which workflow components are affected, thereby reducing the time required to make adjustments (e.g., typically, the user would be required to manually scan all 40 individual workflow steps to identify which steps would be impacted by these changes). The system may provide prompts to the user via the platform interface (e.g., via a graphical user interface) that assist the user in updating any workflow components that are affected by the change in the workflow.
Referring now to
In various embodiments, the system may also include an embedded flow plugin that allows for the flow to behave like a custom function where arguments can be changed and executed for different use cases. As such, the system may allow for the input of the flow to be changed, while maintaining the operations of the flow to remain the same, allowing the flow to be executed on different data inputs. The embedded flow is unique as the system allows for a flow to be reused and/or repurposed using different inputs with the same flow operations. As such, a flow may be represented as a single plugin to be used as an embedded flow within another flow.
Referring now to
In various embodiments, multi-level grouping allows for the flow designer interface to have a simplified visual display that allows for users to view large numbers of operations within a single interface.
Referring now to
In various embodiments, different types of adjustments may be made to data in the flow. Example adjustment types include create (e.g., add rows and/or columns), filter (e.g., remove columns and/or rows), and/or update (e.g., change values in data). The adjustment plugin allows for adjustments to be applied at any step within the executed workflows in order to modify the calculated output dataset. The adjustment plugin may require multiple approvals before being implemented into a flow. For example, the system may receive an adjustment request (e.g., via a first user, such as an analyst), and an adjustment approval from an authorized approver (e.g., a second user, such as a manager) before the adjustment plugin is used in the flow. In various embodiments, the system may allow the adjustment to be toggled between applied and not applied. As such, the data may be viewable in the flow designer platform as both adjusted and not adjusted by a user.
In various embodiments, the system allows users to adjust existing flow components (e.g., plugins) on an executed workflow leveraging pre-defined adjustment types. As such, the adjustment plugin allows for the flexibility to introduce changes to the data flows, while preserving the integrity of the data. Example of adjustments include inserting new rows of data, updating sets of data by defining conditions for one or multiple columns meeting specific analytics requirements, filtering or removing unwanted rows or columns of data, and/or the like. In various embodiments, one or more adjustments may be deactivated and activated within the flow designer interface, allowing adjusted data to be reverted to an unadjusted state.
In various embodiments, the adjustment plugin supports high volumes of data, complex data transformation, and real-time analytics changes using one or multiple plugins.
Referring now to
Snippet function allows for users to create custom snippet plugins via custom code. The custom plugins may then be available across the flow network (e.g., other network users may be able to use the custom plugin in the given user's own flows). In various embodiments, the code created using the Snippet function can be made viewable to all network users or viewable to select network users. For example, a network user may be able to use a custom snippet plugin without having access to the code off the custom snippet plugin. As such, the custom snippet plugin may operate just as other plugins for a network user (e.g., the custom snippet may be a block in the plugin portion of the flow designer that can be added to a flow). Additionally, the custom snippet plugins may be used in multiple different plugins, allowing a network to customize the flow designer interface based on the specific use of the network (e.g., an entity may use the flow designer for a specific use case).
As shown in
In various embodiments, the system includes an enricher plugin tool. The enricher allows a user to carry out data manipulation tasks across one or more records. The data manipulations may include any function used to modify data. For example, the data manipulation may range from simple mathematical functions, string-based manipulation, if/else style conditional checks, and/or the like. Various different functions of the enricher may be provided via a graphical user interface. In various embodiments, the enricher may also include the functionality of the adjustment plugin discussed herein.
In various embodiments, the enricher allows for a user to take a data set that has been created (e.g., via the data flow designer discussed herein) to be adjusted without requiring the data to be re-processed. For example, a user may want to add new columns or other functions to a data set. The enricher provides this functionality with minimal to no coding requirements. Such an enricher is described in further detail herein, specifically with respect to
In various embodiments, the system may include one or more rule engines that may be designated via the flow designer interface. Example rule engines include data quality rules, transformation rules, statements rules, truth tables, matrix rules, sequential rules, and/or various other rule engines. As such, the rule engines may be used as individual plugins in the flow designer interface.
Referring now to
In various embodiments, the system may use the data quality rules to monitor data accuracy (e.g., the accuracy of data in fields), data validity (e.g., checking whether the values are in specific format or not), data completeness (e.g., completeness of values and checking if all data is present), data transmission timeliness (e.g., timeliness of files arrival), consistency of data (e.g., checking the duplicates and consistency), data integrity (e.g., checking whether reference values are populated as expected or not), and/or the like. As shown in
In various embodiments, data quality rules may be created at the feed level and/or the flow level discussed herein. In various embodiments, data quality rules may be created at feed level before file execution. As such, the system can run the data quality rules once the feed is received and identify data anomalies. In various embodiments, the data quality rules may be created, modified, and/or the like via an end-point device. Example types of data quality rules that may be created include simple column validation, cross column validation, feed level validation, and/or the like. As shown in
In various embodiments, a simple column validation may be a data quality rule used to validate the data for one field in a feed. Simple column validation may check for string pattern, date pattern, custom SQL, required field values, minimum/maximum value, unique values, and/or the like.
In various embodiments, a cross column validation may be a data quality rule used to validate the data for a combination of fields in a feed. Each row of a data set may be validated based on the data quality rules for combination of fields. For example, one can check if there are duplicates based on combination of col1, col2 and col3. Cross column validation may check for unique values, custom SQL, and/or the like.
In various embodiments, a feed level validation may be a data quality rule used to validate data at feed level. For feed level validation, a single result output may be generated for the entire feed. For example, the system may check if the total number of records in a feed is within 5 percent of 1 million. In various embodiments, the system may be able to filter the data set to perform feed level validation. For example, the system may check the threshold limits for absolute value or based on last output. Feed level validation may check for total number of records, sum of data sets, average of data sets, custom SQL, and/or the like.
Referring now to
The data quality dashboard, such as the data quality dashboard 1300 shown in
Once the feed level data quality rules are executed, the data quality dashboard may provide the overall quality of data. The system may make decisions before the data is consumed. Additionally or alternatively, a user may make decisions relating to the data. In an instance in which the data is determined to not be good enough, then actions may be executed, either automatically or manually, such as reaching out to the corresponding source team. As such, delays in file delivery of a feed may be identified. In an instance in which the data quality rule output executed at flow level data has predetermined number of bad records, the source data may be reviewed, and appropriate actions may be taken (e.g., updating the source data). As such, the data quality dashboard provides a powerful adjustment management feature that is easy to visualize, understand, design, and debug.
Data quality rules may be generated for each plugin within a flow. As such, the data quality rules may be created for the feed level and/or the flow level. As such, the data quality rules may be executed on individual feeds or across the entire flow.
In various embodiments, data quality rules allow the system to identify potential data issues by various pre-defined rules. As such, the system may detect potential weak points in processes and generate recommendations for action. Based on the DQ rule output, the system may determine that the data needs undergo cleansing and enrichment. For example, duplicates in the data may be removed, data for missing elements may be added, and/or the like.
In various embodiments, the system may include a scheduler that allows for workflow(s) to be scheduled for execution. The scheduler allows for execution to be scheduled at a pre-determined time or when a data feed/file is ready to be consumed or triggered from an upstream system. As such, the scheduler may have triggers to execute different flows.
In various embodiments, triggers for flow execution may include time-based triggers, file-based triggers, and/or manual-based triggers. In time-based triggers, the same business workflows can be made to execute under different times with different input parameters that are required for the workflows using the over-ride functionality in the scheduler. In file-based triggers, flows are executed upon arrival of at least one data file from upstream and can also be set on multiple files. In manual-based triggers, the flows are executed based on the pre-set configurations and are triggered by the user. The user can modify the input parameters before execution. This trigger also allows the user to execute a flow for days in the past.
Referring now to
After initial configuration of a flow execution is provided, the flow execution may be automated without any additional information. For example, the time-based and file-based schedulers may be automatically executed upon being triggered. The system may be capable of running the same flow executions on multiple schedules with different input parameters through the over-ride functionality within the system.
In various embodiments, a flow is a collection of steps and rules used to automate a data process. In various embodiments, the data flow may be generated by a user via the flow designer discussed herein. For example, a typical flow may consist of determining data sources, data transformation, data writing and data reporting steps. The scheduler discussed herein allows workflows to be automated without the need of manual intervention after the initial configurations are completed. The workflows can be executed using the scheduler at a predetermined time (e.g., daily at 10:00 AM), based on the arrival of any upstream data files or from a database call, and/or manually by a user.
In various embodiments, the system may cause rendering of an execution dashboard that provides transparency of end-to-end flow execution along with rules, calculations, custom plug-ins, the ability to draw lineage for each data operation, and/or the like.
As shown in
Referring now to
Data tracing allows users to review data at each step of the process in both directions. Forward tracing from input to output and backward tracing from output to input. The system may include data tracing performed at the column, row, and/or cell level.
Column tracing gives the users the ability to see where in the flow a column is used and allow for the any transformations on the column to be located. For example, in an instance in which a column is traced, the system may highlight all the plugins that use that column on the flow designer interface. In an instance in which a pivot column is traced, the system may highlight the plugins where the original column occurs.
Row tracing allows network users to follow the directions of the data. The row can be traced in the same or multiple workstreams. The system may display various data transformations and enhancement, aggregated fields, inspect filters, joins and various data enrichments, and/or the like. In various embodiments, the system may allow data tracing a row from an aggregation or a pivot plugin. In such an example, the system may highlight all the rows that compile that aggregated row or pivoted row.
Data cell tracing is a combination of row and column tracing. As such, the system traces a data cell, by highlighting all the plugins in the workflow where that given row and column of the data cell appears. Users may then be able to click on each highlighted plugin and view the data.
During data tracing, the system may enter inspection mode in which data manipulation is deactivated, such that the data may be traced without any unwanted changes to the data sets. At each step of data tracing, the system may allow the data to be exported (e.g., to local folders in a .csv file format).
In various embodiments, data tracing may be carried out on a flow that has previously been executed successfully. Execution dashboard (e.g., execution dashboard 1500 shown in
Referring now to
In various embodiments, the system may define variables to be used during flow execution. Examples of variables defined on the system include global variables, flow variables, and system variables. Global and flow variables may be defined by system users. System variables may be a set of predefined read-only dynamic variables (e.g., system date, user id, etc.) available to all the applications onboarded on the network. Global variables are available to all the flows, while the flow variables are available only in the flow it is defined and any child flows.
Global and/or flow variables allow for flows to be re-purposed and/or re-used using different variable. For example, the same flow can be used with different global variables in order to produce two different, but desired data outputs. For example, some flows may use the same data feeds but operate on only a subset of the data for each flow and variables allow a single flow to be used instead of multiple flows. Global and/or flow variables may be defined as static or dynamic. In an instance in which a variable is static, a user may provide the values of the variable that remain constant during execution of the flows. In an instance in which a variable is dynamic, a system may receive a configuration from a user for the variable, and the system may then determine the values to be used as the variable during run time on the day of execution. Dynamic type variables may be generated using various generators such as a date generator, a sequence generator, a SQL generator, and/or the like.
Referring now to
In various embodiments, the global variable generation interface 1700 may input selection for the global variable name 1705, global variable description 1710, select generator 1715, select data type 1720, global variable value 1725, select application 1730, and/or the like. Example select generator 1715 options include date generator, sequence generator, SQL generator, and/or the like. The select generator may be indicated as none in an instance in which the variable is static. Example select data type include string, integer, decimal, Boolean, date, timestamp, string array, number array, and/or the like. In various embodiments, the variables allow for the flows to be adapted and/or changed for different conditions without changing any of the actual operations of the flow.
In various embodiments, the system may generate analytics and reports based on the flow executions discussed herein. An example data quality dashboard is shown in
As shown in
The data quality component 1805 may include an accuracy indicator 1810, a completeness indicator 1815, a consistency indicator 1820, a timeliness indicator 1825, a validity indicator 1830, a uniqueness indicator 1835, and/or the like. Each of the indicators on the data quality component 1805 may relate to one or more data sets in one or more flows. As such, the percentage shown in each indicator may correspond to all of the data sets in the one or more flows.
The input data summary 1840 may include a chart of the percentages of different input data sets. As shown, the input data in the example has four different input data (e.g., input data 1, input data 2, input data 3, and input data 4). The feed load status summary 1845 may include information relating to the amount of the data received from the input sources. For example, as shown, 58% of the total input data may be received by the system.
The flow builder summary 1850 may include the total flows built, the flows that were executed, and the flows that are created, but not yet executed (e.g., draft flows). The flow builder summary 1850 may include a chart relating to the data. The flow execution summary 1855 may also include visual representations of the flow executions.
In various embodiments, analytics based on time periods may be displayed on the execution dashboard 1800. For example, today's activity 1860 may include various different statistics relating to the flow executions for a given day. Additional time periods may also have a dashboard component. For example, the month's activity may also include information relating to the flow executions for the given month.
In some embodiments, and as shown in block 1902, the process flow 1900 may include the step of receiving—in response to the adjusted processed data set interface component configuring the GUI of the user device, at least one adjustment user input from the user device. For instance, the system may receive—based on the adjusted process data set interface component configuring the GUI of the user device—at least one adjustment user input from the user device, whereby the adjustment user input may comprise an acceptance and/or a rejection of the updated data based on the adjustment request(s). In some embodiments, the at least one adjustment user input may comprise an input from the user device, such as but not limited to a mouse “click,” a keyboard input, a “click” via a touch screen, and/or the like. In some embodiments, the adjustment user input may comprise a rejection of the updated data when the user of the user device inputs a new adjustment request for an updated data, such that the updated data will be re-updated.
In some embodiments, and as shown in block 1904, the process flow 1900 may include the step of determining whether to execute the at least one adjustment request to the at least one processed data set based on the at least one adjustment user input. For instance, the system may determine whether to execute the at least one adjustment request associated with the update data of the adjusted processed data set interface component based on the adjustment user input comprising a rejection and/or an acceptance of the updated data. Such an adjustment user input may be associated with each updated data and each adjustment request, such that the adjustment user input is individualized for each updated piece of data of the processed data. In this manner, the processed data and updated data (before execution of the updated data) may be hyper-custom before execution.
In some embodiments, and as shown in block 1906, the process flow 1900 may include the step of executing—in an instance where the at least one adjustment user input comprises an acceptable adjustment user input—the adjustment request to the at least one processed data set. For example, and in some embodiments, where the at least one adjustment user input comprises an acceptable adjustment user input (i.e., an indication of an acceptance of the updated data for an adjustment request), the system may execute the updated data with the processed data. In this manner, the updated data and the processed data may be stored together as a single data set, such that the updated data and the processed data appears in the same format and in the same data storage container (e.g., database, index, and/or the like). Thus, and in some embodiments, the updated data (one executed in the processed data set) may appear the exact same to the original processed data, such that the system itself, a computer, a human, and/or the like could not tell the difference between the updated data and the original processed data.
In some embodiments, and as shown in block 1908, the process flow 1900 may include the step of executing—in an instance where the at least one adjustment user input comprises a rejection adjustment user input—the at least one processed data set. For example, and in some embodiments, where the at least one adjustment user input comprises a rejection adjustment user input (i.e., an indication of a rejection of the updated data for an adjustment request), the system may execute the original processed data set for the updated data set pieces (e.g., such that the original processed data is used in place of the updated data that was rejected). In some embodiments, and where the rejection adjustment user input comprises a new request adjustment for an updated data piece (e.g., associated with a previous adjustment request), the system may automatically update the data piece by implementing the adjustment request and update the adjusted processed data set interface component.
In some embodiments, and as shown in block 2002, the process flow 2000 may include the step of generating at least one pipeline interface component, wherein the pipeline interface component is associated with the at least one adjusted processed data set interface component. Additionally, and in some embodiments, the at least one pipeline interface component may comprise at least one implemented adjustment request, and wherein the at least one pipeline interface component comprises at least one of a direct output or an indirect output from the at least one adjustment request. For example, the system may generate a pipeline interface component to show the affected data of the adjustment request(s), including but limited to the directly affected data (e.g., the updated data identified in the adjustment request(s)) and the indirectly affected data (e.g., the updated data that was not explicitly identified in the adjustment request(s)), and/or the like. In some embodiments, the pipeline interface component may comprise the data inputs and the data outputs of each of plugins within the flow execution to show the data of each plug in, including the effects of the adjustment request(s) where they are received and/or identified.
As used herein, the pipeline may refer to the plugins described herein, whereby the pipeline is within the flow designer comprises the data at each step of the flow execution (e.g., at each step of the blocks/plugin pieces of the flow execution. Thus, and as shown herein, the pipeline interface component(s) may zoom in to show the plugins individually, including the data input, the adjustment request(s), the output data (which may comprise the adjusted processed data), and/or the like.
In some embodiments, and as shown in block 2004, the process flow 2000 may include the step of transmitting the at least one pipeline interface component to the user device and configure the GUI of the user device with the at least one pipeline interface component. For example, the system may transmit the at least one pipeline interface component to the user device and configure the GUI of the user device to show the user of the user device the pipeline(s) of the processed data set(s) and the adjusted processed data set(s). Thus, and as used herein, the pipeline interface component may comprise a data packet of computer readable code comprising the pipeline data of the processed data and updated data which is then used to configure the GUI of the user device to show the pipeline data in a human readable format.
In some embodiments, and as shown in block 2102, the process flow 2100 may include the step of identifying a legacy logic associated with the at least one processed data set, wherein the legacy logic is supported in a legacy application. For example, the system may identify a legacy logic associated with the processed data set, such as logic of a legacy application, a legacy system, legacy computer programming language, and/or the like, whereby the legacy logic may not be supported by the system described herein (e.g., understood by the system described herein). For instance, such a legacy system as used herein refers to computing software and/or hardware that comprises older technology that cannot interact with newer systems or new software.
In some embodiments, and as shown in block 2104, the process flow 2100 may include the step of transmitting a legacy logic action request to the legacy application. For example, the system may generate a legacy logic action request for the legacy application, such as a request in a legacy application readable format, and such that the legacy application itself can perform an action on the data associated with the legacy logic action request. For instance, and where an adjustment request is associated with data from a legacy application, the system may generate legacy logic action request comprising the adjustment request, such that the legacy application—upon receiving the legacy logic action request—can perform the adjustment request on the associated data.
In some embodiments, and as shown in block 2106, the process flow 2100 may include the step of receiving—in response to transmitting the legacy logic action request to the legacy application—a legacy logic action response from the legacy application. For example, and in response to the transmitting the legacy logic action request to the legacy application, the system may receive (such as via a network) a legacy logic action response based on the legacy application performing the legacy logic action of the legacy logic action request (e.g., the adjustment request). Thus, the legacy logic action response refers to a data transformation from the legacy application that the legacy application does itself and legacy logic action response may comprise the adjusted processed data set(s) like that described hereinabove, which may then be used in generating the adjusted processed data set interface component.
In some embodiments, and as shown in block 2108, the process flow 2100 may include the step of configuring the at least one adjusted processed data set interface component with the legacy logic action response. For instance, the system may configure the at least one adjusted processed data set interface component with the legacy logic action response, when necessary, based on the legacy application identified by the system for an adjustment request.
Thus, and in some embodiments, the system may configure and/or update the adjusted processed data set interface component(s) and/or generate a new legacy action response interface component so that a user can approve or disapprove the legacy action response on its own. For example, such a legacy action response interface component may comprise only the data of the legacy logic action response for each of the adjustment request(s), such that the user may view—via the configured GUI of the user device with the legacy action response interface component—the legacy logic action response and its affected data set(s) in order to determine whether to accept and/or reject the legacy logic action response(s).
As will be appreciated by one of ordinary skill in the art, various embodiments of the present disclosure may be embodied as an apparatus (including, for example, a system, a machine, a device, a computer program product, and/or the like), as a method (including, for example, a business process, a computer-implemented process, and/or the like), or as any combination of the foregoing. Accordingly, embodiments of the present disclosure may take the form of an entirely software embodiment (including firmware, resident software, micro-code, and the like), an entirely hardware embodiment, or an embodiment combining software and hardware aspects that may generally be referred to herein as a “system.” Furthermore, embodiments of the present disclosure may take the form of a computer program product that includes a computer-readable storage medium having computer-executable program code portions stored therein. As used herein, a processor may be “configured to” perform a certain function in a variety of ways, including, for example, by having one or more special-purpose circuits perform the functions by executing one or more computer-executable program code portions embodied in a computer-readable medium, and/or having one or more application-specific circuits perform the function.
It will be understood that any suitable computer-readable medium may be utilized. The computer-readable medium may include, but is not limited to, a non-transitory computer-readable medium, such as a tangible electronic, magnetic, optical, infrared, electromagnetic, and/or semiconductor system, apparatus, and/or device. For example, in some embodiments, the non-transitory computer-readable medium includes a tangible medium such as a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), a compact disc read-only memory (CD-ROM), and/or some other tangible optical and/or magnetic storage device. In other embodiments of the present disclosure, however, the computer-readable medium may be transitory, such as a propagation signal including computer-executable program code portions embodied therein.
It will also be understood that one or more computer-executable program code portions for carrying out the specialized operations of the present disclosure may be required on the specialized computer include object-oriented, scripted, and/or unscripted programming languages, such as, for example, Java, Perl, Smalltalk, C++, SAS, SQL, Python, Objective C, and/or the like. In some embodiments, the one or more computer-executable program code portions for carrying out operations of embodiments of the present disclosure are written in conventional procedural programming languages, such as the “C” programming languages and/or similar programming languages. The computer program code may alternatively or additionally be written in one or more multi-paradigm programming languages, such as, for example, F #.
It will further be understood that some embodiments of the present disclosure are described herein with reference to flowchart illustrations and/or block diagrams of systems, methods, and/or computer program products. It will be understood that each block included in the flowchart illustrations and/or block diagrams, and combinations of blocks included in the flowchart illustrations and/or block diagrams, may be implemented by one or more computer-executable program code portions. These computer-executable program code portions execute via the processor of the computer and/or other programmable data processing apparatus and create mechanisms for implementing the steps and/or functions represented by the flowchart(s) and/or block diagram block(s).
It will also be understood that the one or more computer-executable program code portions may be stored in a transitory or non-transitory computer-readable medium (e.g., a memory, and the like) that can direct a computer and/or other programmable data processing apparatus to function in a particular manner, such that the computer-executable program code portions stored in the computer-readable medium produce an article of manufacture, including instruction mechanisms which implement the steps and/or functions specified in the flowchart(s) and/or block diagram block(s).
The one or more computer-executable program code portions may also be loaded onto a computer and/or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer and/or other programmable apparatus. In some embodiments, this produces a computer-implemented process such that the one or more computer-executable program code portions which execute on the computer and/or other programmable apparatus provide operational steps to implement the steps specified in the flowchart(s) and/or the functions specified in the block diagram block(s). Alternatively, computer-implemented steps may be combined with operator and/or human-implemented steps in order to carry out an embodiment of the present disclosure.
While certain exemplary embodiments have been described and shown in the accompanying drawings, it is to be understood that such embodiments are merely illustrative of, and not restrictive on, the broad disclosure, and that this disclosure not be limited to the specific constructions and arrangements shown and described, since various other changes, combinations, omissions, modifications, and substitutions, in addition to those set forth in the above paragraphs, are possible. Those skilled in the art will appreciate that various adaptations and modifications of the just described embodiments can be configured without departing from the scope and spirit of the disclosure. Therefore, it is to be understood that, within the scope of the appended claims, the disclosure may be practiced other than as specifically described herein.
To supplement the present disclosure, this application further incorporates entirely by reference the following commonly assigned patent applications: