Data Extraction, Transformation, And Loading (etl) Patents (Class 707/602)
-
Patent number: 11651245Abstract: Embodiments relate to learning and determining user interface (UI) compliance with design guidelines. Those guidelines may enforce operability with requirements of an external UI platform. Embodiments receive as an input, a UI comprising a plurality of elements. An image of the UI is rendered, and a plurality of elements of the UI are identified from the image according to a recursive procedure. The plurality of elements are stored in a first logic tree exhibiting a first hierarchical structure having the plurality of elements as leaf nodes. The first logic tree is compared to a second logic tree exhibiting a second hierarchical structure, that is labeled with semantic metadata and stored within a knowledge base of a database. Input for the comparison may comprise the tree and/or additional meta information. Based upon the comparing, an output is generated indicating a similarity between the first logic tree and the second logic tree.Type: GrantFiled: December 12, 2018Date of Patent: May 16, 2023Assignee: SAP SEInventor: Daniel Defiebre
-
Patent number: 11647026Abstract: Aspects of the disclosure relate to account lineage tracking and automatically executing responsive actions upon detecting an account lineage. A computing platform may receive a first account-change message from a source-level interceptor. The first account-change message may include information identifying a source account associated with a first computing device and identifying a first target account. The first target account may be associated with a target application configured to access the target database. The computing platform may receive a second account-change message from a database-level interceptor. The second account-change message may include information identifying the first target account as a database-level source account and identifying a second target account associated with one or more target databases.Type: GrantFiled: December 8, 2021Date of Patent: May 9, 2023Assignee: Bank of America CorporationInventors: George Albero, Edward Lee Traywick, Scot L. Daniels
-
Patent number: 11645298Abstract: Techniques for configuring managed event tables include generating at a first process of an execution node, log data associated with execution of user-defined function (UDF) code. The log data is provided from the first process to a second process of the execution node. The first process is configured as a sub-process of the second process. The log data is formatted using the second process of the execution node, to generate formatted log data. The formatting is based on a configuration of a managed event table that is external to the execution node. The formatted log data is communicated from the second process of the execution node into a managed event table maintained at a computing node that is external to the execution node.Type: GrantFiled: September 23, 2022Date of Patent: May 9, 2023Assignee: Snowflake Inc.Inventors: Benoit Dageville, Ganeshan Ramachandran Iyer, Unmesh Jagtap, Subramanian Muralidhar
-
Patent number: 11645273Abstract: A method for execution by at least one processor of a database system includes indexing a first column via a probabilistic indexing scheme. An IO pipeline that includes a probabilistic index-based IO construct for access of the first column is determined based on a query including a query predicate indicating the first column. The probabilistic index-based IO construct is applied in conjunction with execution of the query via the IO pipeline by applying an index element of the probabilistic index-based IO construct to identify a first subset of rows based on index data of the probabilistic indexing scheme for the first column. A filter element of the probabilistic index-based IO construct is applied to identify ones of a first subset of the plurality of column values corresponding to the first subset of rows that compare favorably to the query predicate.Type: GrantFiled: May 28, 2021Date of Patent: May 9, 2023Assignee: Ocient Holdings LLCInventors: Greg R. Dhuse, Matthew Ashbeck
-
Patent number: 11636002Abstract: An information processing device that detects an anomaly in an in-vehicle network provided in a vehicle includes: a local rule storage in which at least an individual rule which is a rule generated for the vehicle is stored; a global rule storage in which an integrated rule which is a rule generated for a plurality of vehicles including the vehicle is stored; and a processing unit that performs, using a rule stored in at least one of the local rule storage or the global rule storage, an anomaly detection process on a frame transmitted on the in-vehicle network.Type: GrantFiled: May 6, 2022Date of Patent: April 25, 2023Assignee: PANASONIC INTELLECTUAL PROPERTY MANAGEMENT CO., LTD.Inventors: Akihito Takeuchi, Toshihisa Nakano, Kaoru Yokota, Yuishi Torisaki
-
Patent number: 11630870Abstract: An apparatus and method for academic search and analytics insights have been provided. The apparatus includes an ingestion component, obtaining data from external heterogeneous sources, to produce ingested data; a processing component for processing the ingested data; a search and analytics component for executing search queries on the ingested data and generating analytics insights on returned search result; and a storage component for storing the ingested data, the storage component acting as a communication data bus for the ingestion component, the processing component and the search and analytics component. Corresponding server and network system are have been provided.Type: GrantFiled: January 6, 2021Date of Patent: April 18, 2023Inventor: Tarek A. M. Abdunabi
-
Patent number: 11625371Abstract: Systems and methods are described herein for performing automated audit balance control (ABC) procedures for data that has moved between data stores within an enterprise or other organization. The systems and methods inspect the data at a target data store and determine the quality of the movement of the data to the target data store based on the inspection. For example, the systems and methods can inspect row or record counts for the data in a data store, aggregate numeric sums within the data at the target data store, perform key data value comparisons between different locations that contained the data, perform full data comparisons between different locations that contained the data, perform checksum comparisons, apply complex business rules, and so on, when determining or verifying the completeness and accuracy of data as it arrives to a temporary or permanent location.Type: GrantFiled: September 21, 2021Date of Patent: April 11, 2023Assignee: T-Mobile USA, Inc.Inventors: Jeffrey Scott, Venkata Reddy Donthireddy
-
Patent number: 11609711Abstract: Techniques for configuring and processing control path commands may include: partitioning control path components of a control path into a plurality of portions; performing first processing that configures a federation of a plurality of appliances, wherein each of the plurality of appliances includes a plurality of processing nodes, and wherein the first processing includes: for each of the plurality of appliances, configuring each of the plurality of processing nodes of said each appliance to run one portion of the plurality of portions of control path components; and selecting one of the plurality of appliances as a primary appliance of the federation; receiving a first management command at the primary appliance of the federation; and servicing the first management command by one or more of the plurality of appliances of the federation.Type: GrantFiled: April 9, 2021Date of Patent: March 21, 2023Assignee: EMC IP Holding Company LLCInventor: Richard Hicks
-
Patent number: 11609904Abstract: In accordance with an embodiment, described herein is a system and method for providing extensibility in an analytic applications environment, including a semantic layer that enables the use of custom semantic extensions to extend a semantic data model (semantic model). In accordance with an embodiment, customizations to the out-of-the-box semantic model are performed using a layered approach, wherein the factory code for the semantic model remains intact, with changes/delta editable by the customer layered on top of that model, such that the changes can be patched/reversed if necessary.Type: GrantFiled: July 15, 2021Date of Patent: March 21, 2023Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Pavan Ananthamurthy, Joseph Kuttikat, Ananth Venkata, Balaji Krishnan
-
Patent number: 11609971Abstract: A novel distributed method for machine learning is described, where the algorithm operates on a plurality of data silos, such that the privacy of the data in each silo is maintained. In some embodiments, the attributes of the data and the features themselves are kept private within the data silos. The method includes a distributed learning algorithm whereby a plurality of data spaces are co-populated with artificial, evenly distributed data, and then the data spaces are carved into smaller portions whereupon the number of real and artificial data points are compared. Through an iterative process, clusters having less than evenly distributed real data are discarded. A plurality of final quality control measurements are used to merge clusters that are too similar to be meaningful. These distributed quality control measures are then combined from each of the data silos to derive an overall quality control metric.Type: GrantFiled: July 14, 2022Date of Patent: March 21, 2023Inventors: Paul Green, Jerzy Bala
-
Patent number: 11593342Abstract: The present application is directed towards systems and methods for automated analysis and transformation of databases and related applications and functions from a row-oriented syntax to a column-oriented syntax. An analyzer client executed by a processor of a client device may analyze a first database of a business management system comprising a plurality of arrays in a row-oriented syntax. A transformer executed by the processor may execute a first array of a second database having a column-oriented syntax. Iteratively, for each array of the plurality of arrays of the first database, the transformer may read an element at a first position of said array, and write the element to a next position of the first array of the second database.Type: GrantFiled: February 1, 2016Date of Patent: February 28, 2023Assignee: SMARTSHIFT TECHNOLOGIES, INC.Inventors: Albrecht Gass, Nikolaos Faradouris, Oliver Flach, Stefan Hetges
-
Patent number: 11593681Abstract: A device retrieves historical data and new data each a respective hardware component identifier and a respective associated value. The device creates a synthesized set of data by having subsets for anomalous data, data that is associated with an attenuation signal, and other data. The device discards the anomalous data and weights the data associated with an attenuation signal. The device generates a searchable database, the searchable database including each hardware component named by an entry of the synthesized set of data, along with an associated value determined based on the weighted value of the entry. The device receives user input of a search query, and outputs search results based on a comparison of the user input of the search query to entries of the searchable database.Type: GrantFiled: March 25, 2021Date of Patent: February 28, 2023Assignee: CAMP Systems International, Inc.Inventors: Heather O Levesque, James E Allman, Jr., Lisa K Garcia, Jason W Buhro, Sean M Lanagan, John P Herrman
-
Patent number: 11586582Abstract: A device automatically extracts a data file from an upstream source based on ingestion parameters. The data file is in a first format that is not readable by a downstream data analysis utility and includes a plurality of data records. Each record includes one or more entries. The ingestion parameters include a file identifier, transformation instructions, and storage instructions for the extracted data file. The device generates table(s) based on the extracted data file by, determining, based on the transformation instructions, a table in which to store each entry and a row and column of the determined table in which to store the entry. Entries are input into the determined tables, rows, and columns. The table(s) are stored in a second format that is readable by the downstream data analysis utility.Type: GrantFiled: June 11, 2021Date of Patent: February 21, 2023Assignee: Bank of America CorporationInventors: Thiruvadi Natarajan Sundaramoorthy, Kenneth L. Gommel
-
Patent number: 11580961Abstract: Embodiments are directed to organizing conversation information. A tracker vocabulary may be provided to a universal model to predict a generalized vocabulary associated with the tracker vocabulary. A tracker model may be generated based on the portions of the universal model activated by the tracker vocabulary such that a remainder of the universal model may be excluded from the tracker model. Portions of a conversation stream may be provided to the tracker model. A match score may be generated based on the track model and the portions of the conversation stream such that the match score predicts if the portions of the conversation stream may be in the generalized vocabulary predicted for the tracker vocabulary. Tracker metrics may be collected based on the portions of the conversation and the match scores such that the tracker metrics may be included in reports or notifications.Type: GrantFiled: April 9, 2022Date of Patent: February 14, 2023Assignee: Rammer Technologies, Inc.Inventors: Toshish Arun Jawale, Anthony Claudia, Surbhi Rathore
-
Patent number: 11570267Abstract: A message system may use publish-subscribe techniques to process messages for several applications. In situations where an application requires an output, it may need to wait for a response message back from a service via the message system. However, in certain implementations, the message system may not be able to determine that a particular message involves request-response communication. The efficient response communication techniques described herein receive the response message having a routing key and a payload including a correlation identifier and then generate a second response having a routing key that includes the correlation identifier. This message may then be efficiently routed to an application based on the correlation identifier.Type: GrantFiled: March 16, 2021Date of Patent: January 31, 2023Assignee: SAP SEInventor: Nivetha G
-
Patent number: 11570259Abstract: Embodiments of the present disclosure may provide a streamlined process for performing operations, such as data sharing and data replication, using multiple accounts. A global identity (also referred to as an organization user) may be employed, where the global identity may have access to multiple accounts across the same or different deployments. The global identity may switch between accounts from its login session and perform various tasks in the context of different accounts without undergoing further authentication.Type: GrantFiled: April 28, 2022Date of Patent: January 31, 2023Assignee: Snowflake Inc.Inventors: Khalid Zaman Bijon, Damien Carru, Christopher Peter Child, Eric Karlson, Zheng Mi
-
Patent number: 11544239Abstract: A method and system may be implemented for automatically analyzing data in a database. A method for use in a low-latency database analysis system may include generating a schema. The schema may be based on a portion of an external database. The method may include storing the schema in an in-memory database. The method may include receiving a data-query. The method may include generating a resolved-request. The resolved-request may be based on the data-query and the stored schema. The stored schema may be used for executing the query on the external database. The method may include receiving results data responsive to the data-query from the external database. The method may include outputting the results data for display on a user interface.Type: GrantFiled: November 12, 2019Date of Patent: January 3, 2023Assignee: ThoughtSpot, Inc.Inventors: Sandeep Kumar, Siva Singaram, Rakesh Kothari, Naresh Kumar, Jasmeet Singh Jaggi, Manikanta Balakavi, Tushar Mahale, Rahul Paliwal
-
Patent number: 11544260Abstract: A transaction processing method and system, and a server. The method includes: after a first node obtains at least one statement corresponding to a first transaction, the first node may classify each statement, and send the at least one statement to at least one second node according to the type of each statement, respectively, so that the at least one second node generates an execution plan corresponding to the received statement according to the statement; then the first node may process the first transaction according to the received execution plan which corresponds to the at least one statement of the first transaction and is sent by the at least one second node. In this way, embodiments can process statements of multiple types at the same time, thereby effectively improving the processing efficiency of the system, reducing the operating burden of the system, and ensuring the transactionality of the system.Type: GrantFiled: January 25, 2019Date of Patent: January 3, 2023Assignee: CHINA UNIONPAY CO., LTD.Inventors: Jiajing Zhou, Hao Miao, Jien Zhou
-
Patent number: 11537276Abstract: The method receives a visual specification, which specifies a data source, visual variables, and data fields from the data source. Each visual variable is associated with data fields and each data field is a dimension or a measure. The method forms dimension tuples comprising distinct ordered combinations of data values for the dimensions D. For each measure, the method: forms a set S of the dimensions D plus dimensions from a primary key corresponding to the measure; retrieves intermediate tuples containing the fields in S and the measure, without aggregation; and aggregates the intermediate tuples according to the dimensions D. For each dimension tuple, the method forms an extended tuple by appending the aggregated data values corresponding to each measure field. The method then builds and displays a data visualization according to the extended tuples and the visual variables to which the data fields are associated.Type: GrantFiled: December 30, 2018Date of Patent: December 27, 2022Assignee: TABLEAU SOFTWARE, INC.Inventors: Justin Talbot, Roger Hau, Daniel Cory, Jiyoung Oh, Teresa Roberts
-
Patent number: 11531674Abstract: Systems and methods for supporting rollback of changes made to target systems via an integration platform. Systems and methods can support reverting changes made to target applications via an integration platform (e.g., integration platform as a service (iPaaS)) with the help of a rollback activity. In order to aid the development and design of integration orchestrations, the integration platform can provide suggested rollback actions. In case of a failure in integration runtime, this rollback activity will revert changes made to the target applications prior to the point of fault. This helps ensure that systems remain in consistent state.Type: GrantFiled: January 22, 2021Date of Patent: December 20, 2022Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Prakash Kumar Devta, Anuj Kaushal
-
Patent number: 11526771Abstract: A big data analysis system may include a big data repository communicatively coupled to a data accumulation server and a predictive graph processing system. The data accumulation server may be configured to receive information from a plurality of data sources, the information corresponding to user interaction with one or more computing devices associated with an organization via a networked computing system, store the information received from the plurality of sources in the big data repository; and monitor the plurality of data sources to update the data stored in the big data repository. The predictive graph processing system is configured to receive information stored in the big data repository, transform the information received from the big data repository into a predictive graph data set based on a predictive model, and store the predictive graph data set to a visualization data repository.Type: GrantFiled: July 20, 2020Date of Patent: December 13, 2022Assignee: Bank of America CorporationInventors: Harish Ragavan, Srinivasan Shanmugam
-
Patent number: 11520781Abstract: A computer-implemented system and method process insertions into a target table of a target database system. A single query language INSERT statement is received that is related to a source partition of a source table in a source database system that identifies a block of data (BOD), having a partition identifier (PID), to be inserted into the target table. The INSERT statement contains no literal PID. Responsive to receiving the INSERT statement, a processor receives the BOD from the source table via a data stream, and inserts the BOD into the target table. This reduces the overhead associated with using an INSERT statement to insert multiple rows of data into a target table.Type: GrantFiled: September 17, 2020Date of Patent: December 6, 2022Assignee: International Business Machines CorporationInventors: Knut Stolze, Felix Beier, Luis Eduardo Oliveira Lizardo, Reinhold Geiselhart
-
Patent number: 11520635Abstract: Techniques are disclosed for implementing, by a computer infrastructure orchestration service (CIOS) changes to a first service. The CIOS may manage a declarative infrastructure provisioner to deploy infrastructure resources and artifacts based at least in part on declarative instructions. CIOS may detect a first modification to a first service (e.g., a sidecar application). CIOS may identify that configuration data of a second service references (e.g., via a git submodule) the first service. In response to identifying a second modification to the second service, CIOS may present, via a graphical interface, changes comprising the first modification to the first service. User input may be received indicating acceptance or rejection of the changes of the first modification. CIOS may then implement the changes to the first service according to the user input. For example, CIOS may ensure that the first service, as modified, is deployed alongside the second service in subsequent deployments.Type: GrantFiled: November 24, 2020Date of Patent: December 6, 2022Assignee: ORACLE INTERNATIONAL CORPORATIONInventor: Eric Tyler Barsalou
-
Patent number: 11507544Abstract: Techniques for efficiently storing client data blocks on a distributed-computing system are provided. The system includes a fast performance tier and a large capacity tier. The capacity tier stores the client data blocks in erasure encoded data stripes. The performance tier stores logical map data including an address map indicating a correspondence between logical addresses associated with a first layer of the system and physical addresses associated with a second layer. A method includes receiving a request to include additional client data blocks in the client blocks. The request indicates logical addresses for additional blocks. Corresponding physical addresses for additional block are determined. Each additional block is stored at the physical address. Additional logical map data is stored in the performance tier. Storing the additional logical map data includes updating the address map to indicate the correspondence between the logical addresses and the physical addresses for the additional blocks.Type: GrantFiled: June 5, 2020Date of Patent: November 22, 2022Assignee: VMware, Inc.Inventors: Wenguang Wang, Vamsidhar Gunturu, Eric Knauft, Pascal Renauld
-
Patent number: 11500829Abstract: In a computer-implemented method for adapting time series database schema of a time series database, time series data ingested into a time series database according to a time series database schema is accessed over a time period, wherein time series data comprises a plurality of dimensions. The time series data of the time period is analyzed to determine a data shape of the time series data of the time period. It is determined whether to adapt the time series database schema based at least in part on the data shape of the time series data of the time period. In some embodiments, the time series database schema is adapted based at least in part on the data shape of the time series data of the time period. Time series data is then ingested into the time series database according to the adapted time series database schema.Type: GrantFiled: July 19, 2019Date of Patent: November 15, 2022Assignee: VMware, Inc.Inventor: Clement Pang
-
Patent number: 11500849Abstract: A computer-implemented method for transferring changes made to data from a data source to a data destination may be provided. The method involves using a message broker with streaming channels for transferring data changes from a data source to a data consumer. To determine if data has changed, a portion of data labeled with a key is sent through a hash function. A hash value with the corresponding key that has already been sent to the data consumer is retrieved from a streaming channel and compared to the newly created hash value. If the newly created hash value is different the data is sent to data consumers by the message broker via one streaming channel, while the new hash value is stored in the other streaming channel.Type: GrantFiled: December 2, 2019Date of Patent: November 15, 2022Assignee: International Business Machines CorporationInventors: Luis Garcés Erice, John G. Rooney, Peter Urbanetz, Daniel Nikolaus Bauer
-
Patent number: 11494688Abstract: Embodiments provide systems and methods for learning extract, transform, and load mappings by example. A plurality of features can be extracted from a source schema and a target schema. Example ETL mappings can be provided to a machine learning algorithm that comprise definitions for extracting data from source tables and loading the extracted data into target tables. Using the machine learning algorithm and based on the source schema, target schema, and extracted features, one or more ETL rules can be predicted that define logic for extracting data from the source schema and loading the extracted data into the target schema. Additional ETL mappings can be generated based on the predicted ETL rules, the additional ETL mappings providing additional definitions for extracting data from the source schema and loading the extracted data into the target schema.Type: GrantFiled: April 16, 2018Date of Patent: November 8, 2022Assignee: Oracle International CorporationInventor: Michael Sassin
-
Patent number: 11494499Abstract: Disclosed are various embodiments for searching encrypted data stores. A first computing device can send a message authentication code (MAC) to a second computing device the MAC representing a tuple of a name of a data table, an identifier of a column of the data table, and a valid value for the column. Then, an encrypted bitmap can be received from the second computing device and decrypted to generate a decrypted bitmap. Bitwise operations can be performed on the decrypted bitmap to identify a plurality of encrypted rows of the data table containing a cell that comprises the valid value. Then, at least the plurality of at least partially encrypted rows of the data table can be requested from the second computing device and decrypted to generate a respective plurality of decrypted rows.Type: GrantFiled: February 23, 2021Date of Patent: November 8, 2022Assignee: AMAZON TECHNOLOGIES, INC.Inventors: Cristi Ursachi, Amanda Gray, Priti Marappan, Dan Mutescu
-
Patent number: 11487776Abstract: Managing ETL (extract-transform-load) operation execution by receiving an updated ETL (extract-transform-load) job flow, determining affected stages of a current ETL job flow, sending a message to stop data flow for all stages of the current ETL job flow, sending a switch message along the current ETL job flow through the affected stages, receiving notice of receipt of the switch message downstream from the affected stages of the current ETL job flow, moving an affected stage of the current ETL job flow from a first ETL section to a second ETL section; and resuming data flow according to the updated ETL job flow.Type: GrantFiled: February 26, 2020Date of Patent: November 1, 2022Assignee: International Business Machines CorporationInventors: Michal Bodziony, Lukasz Stanislaw Studzienny, Andrzej Laskawiec, Monika Piatek, Marcin Luczynski, Marcin Filip, Tomasz Zatorski
-
Patent number: 11487777Abstract: A data movement system is provided for moving data using a data-to-file-to-data movement path. The data movement system includes a source database, a target database, a configuration database, and a data movement server. The data movement is in communication with the source database, the target database, and the configuration database. The processor is configured to receive a configuration record including source details and target details. The processor is also configured to define an extraction query based on the source details and to apply the extraction query to the source database to obtain an extraction load. The processor is further configured to generate a load file based on the extraction load, to define a load script based on the target details, and to apply the load script to the load file to obtain a load query. The processor is also configured to update the target database with the load query.Type: GrantFiled: August 20, 2020Date of Patent: November 1, 2022Assignee: Cigna Intellectual Property, Inc.Inventors: Saktheeswaran Bose, Manickavasagam Kumar
-
Patent number: 11481364Abstract: Embodiments of the present disclosure provide methods and devices for formatting a database. The method can include clustering, into each block, a set of sequence of elements from each column of a database; generating a file storing one or more blocks having the clustered set of sequences of elements; providing a first table storing file schema information that associates the elements with the file; and providing a second table for storing block schema information that associates the columns with the one or more blocks.Type: GrantFiled: December 16, 2019Date of Patent: October 25, 2022Assignee: Alibaba Group Holding LimitedInventors: Cheng Zhu, Fang Zheng, Congnan Luo, Xiaowei Zhu, Huaizhi Li, Ruiping Li
-
Patent number: 11475151Abstract: In an approach, a processor obtains a plurality of security policies for managing security of a database, the security policies defining respective sets of items to be monitored. A processor stores, respectively, the sets of items defined by the plurality of security policies in one or more item tables based on a predetermined criterion, the predetermined criterion comprising security policy relevance, security policy structure, and available space in the one or more item tables. A processor creates, for each of the one or more item tables, one or more respective index tables associated with the items in the respective item table. A processor creates, for each of the one or more item tables, a fast traverse block (FTB) associated with the created one or more respective index tables.Type: GrantFiled: September 1, 2020Date of Patent: October 18, 2022Assignee: International Business Machines CorporationInventors: Sheng Yan Sun, Shuo Li, Xiaobo Wang, Hong Mei Zhang
-
Patent number: 11461351Abstract: The subject technology receives raw input data from a source table, the raw input data including data comprising input features for a machine learning model, the raw input data being in a first format including at least multiple rows with each row including multiple columns of values. Based at least in part on the source table, the subject technology generates table metadata corresponding to the source table. Based at least in part on the received raw input data, the subject technology generates column metadata corresponding to values from the source table. The subject technology generates cell data for a feature store table based at least in part on the values from the source table. The subject technology performs at least one database operation to generate the feature store table including at least the generated table metadata, the generated column metadata, and the generated cell data.Type: GrantFiled: July 31, 2021Date of Patent: October 4, 2022Assignee: Snowflake Inc.Inventors: Simon A. Field, Stuart Ozer
-
Patent number: 11455305Abstract: Alternative portions of a query plan to perform a query may be selected for processing partial results of a query. A query engine may generate a plan to perform a query that includes an operation that selects between different portions of the plan according to input data. The input data may be a partial result of the query generated by the data store instead of the query engine and provided to the query engine. The input data may be an individual item of the data set that is modified to a different version within a consistent view of the data set for the query.Type: GrantFiled: June 28, 2019Date of Patent: September 27, 2022Assignee: Amazon Technologies, Inc.Inventors: Sangyong Hwang, Yongsik Yoon, Kamal Kant Gupta, Saileshwar Krishnamurthy
-
Patent number: 11436134Abstract: Various methods, apparatuses/systems, and media for integrating data are provided. A processor implements a data processing framework configured to run native on a big data platform and abstracts data processing constructs to a user friendly template, thereby eliminating necessity of user initiated tasks of instantiating language level objects. The processor also implements a core set of data pipeline configurations on the template configured to initiate a chain of user defined data transformations. A receiver operatively connected with the processor via a communication network receives input of the chain of the user defined data transformations. The processor tests each transformation independently of each other and outputs data integration solutions on the big data platform based on a positive test result.Type: GrantFiled: July 9, 2020Date of Patent: September 6, 2022Assignee: JPMORGAN CHASE BANK, N.A.Inventors: Vivek Mukherjee, Chia-Ling Wang, David Fu, Rajeswari Karuppasamy, Tara J Paider
-
Patent number: 11429578Abstract: A method includes generating a table in a relational database, the table comprising an empty column reserved for a custom tag. The column has a default column name. The method also includes, in response to an instruction to create the custom tag, generating a column mapping that maps a name of the custom tag to the column name. The column mapping is stored outside the relational database and is used by a parser to translate between the name of the custom tag and the column name.Type: GrantFiled: November 19, 2020Date of Patent: August 30, 2022Assignee: International Business Machines CorporationInventors: Raul E. Saba, Scott Brewer, Gregory T. Kishi, Sara Megan Coronado, Drew Olson, Joseph W. Dain, Theodore Timothy Harris, Jr.
-
Patent number: 11422687Abstract: A building energy management includes building equipment, one or more data platform services, a timeseries database, and an energy management application. The building equipment operate to monitor and control a variable and provide raw data samples of a data point associated with the variable. The timeseries database stores a plurality of timeseries associated with the data point. The plurality of timeseries include a timeseries of the raw data samples and the one or more optimized data timeseries generated by the data platform services based on the raw data timeseries. The energy management application generates an ad hoc dashboard including a widget and associates the widget with the data point. The widget displays a graphical visualization of the plurality of timeseries associated with the data point and includes interactive user interface options for switching between the plurality of timeseries associated with the data point.Type: GrantFiled: June 14, 2021Date of Patent: August 23, 2022Assignee: JOHNSON CONTROLS TECHNOLOGY COMPANYInventors: Youngchoon Park, Vijaya S. Chennupati, Sudhi Sinha, Justin Ploegert
-
Patent number: 11422911Abstract: In an approach to determine performance information of a target item operating under a particular set of context information, a method, in response to receiving a request for performance information of a target item, and operating with a first computing device, identifies context information of the first computing device. The method determines whether a knowledge base includes a response that correlates to the request for performance information of the target item operating within context information similar to the first computing device. The method, in response to determining that the knowledge base includes the response that correlates to the request for performance information of the target item, sends the performance information to the first computing device, and initiates a communication channel between the first computing device and a second computing device operating the target item and having similar context information of the first computing device.Type: GrantFiled: March 14, 2019Date of Patent: August 23, 2022Assignee: International Business Machines CorporationInventors: Lee A. Carbonell, Jeff Edgington, Tsz S. Cheng, Pandian Mariadoss
-
Patent number: 11416713Abstract: A novel distributed method for machine learning is described, where the algorithm operates on a plurality of data silos, such that the privacy of the data in each silo is maintained. In some embodiments, the attributes of the data and the features themselves are kept private within the data silos. The method includes a distributed learning algorithm whereby a plurality of data spaces are co-populated with artificial, evenly distributed data, and then the data spaces are carved into smaller portions whereupon the number of real and artificial data points are compared. Through an iterative process, clusters having less than evenly distributed real data are discarded. A plurality of final quality control measurements are used to merge clusters that are too similar to be meaningful. These distributed quality control measures are then combined from each of the data silos to derive an overall quality control metric.Type: GrantFiled: March 18, 2019Date of Patent: August 16, 2022Assignee: Bottomline Technologies, Inc.Inventors: Jerzy Bala, Paul Green
-
Patent number: 11403161Abstract: A data processing framework suitable for use with data stores is described. The data processing framework identifies which data stores are storing corrupt or invalid data that may cause end user software applications to malfunction or crash altogether. Data parsing, validation and transformation may be performed as parts of a single operation to increase speed and reduce computing overhead.Type: GrantFiled: May 8, 2020Date of Patent: August 2, 2022Assignee: Walmart Apollo, LLCInventor: Divakant Pandey
-
Patent number: 11397744Abstract: Systems and methods for processing data are provided. The system may include at least a processor and a non-transient data memory storage, the data memory storage containing machine-readable instructions for execution by the processor, the machine-readable instructions configured to, when executed by the processor, provide an information delivery platform configured to: extract raw data from a plurality of source systems; load and store the raw data at a non-transient data store; receive a request to generate data for consumption for a specific purpose; in response to the request, select a set of data from the raw data based on a data map; transform the selected set of data into a curated set of data based on the data map; and transmit the curated set of data to a channel for consumption.Type: GrantFiled: July 19, 2019Date of Patent: July 26, 2022Assignee: BANK OF MONTREALInventors: Ching Leong Wan, Jun Wang
-
Patent number: 11392605Abstract: A computer implemented method includes establishing, by a data intake and query system, a network connection between the data intake and query system and an application and infrastructure monitoring platform. The data intake and query system receives a data stream from the application and infrastructure monitoring platform. The computer implemented method further includes transforming the data stream while receiving the data stream to obtain a transformed data stream. Further, the transformed data stream is analyzed while receiving the data stream to generate analysis results, which are presented.Type: GrantFiled: September 30, 2020Date of Patent: July 19, 2022Assignee: Splunk Inc.Inventors: Subramaniam Baskaran, Syam Bollu, Tristan Fletcher, Michael Margulis, Joel Schoenberg, Omprakaash Thoppai
-
Patent number: 11379500Abstract: Technologies are described for performing automated data integration, reconciliation, and/or self-healing using machine learning. For example, data integration can be checked using a reconciliation procedure. The number of times that the reconciliation is performed can be determined dynamically by a machine learning model. For each iteration, reconciliation can be performed to check integrated data against source data. If any reconciliation errors are found, then self-healing operations can be performed. Results of the reconciliation can be output. The reconciliation results can be used to update the machine learning model so that the machine learning model can dynamically adjust the number of iterations to perform based at least in part on reconciliation results.Type: GrantFiled: May 20, 2020Date of Patent: July 5, 2022Assignee: SAP SEInventors: Apoorv Bhargava, Daniel Zimmermann, Markus Goeppert, Syed Aleemuddin Noor, Gowthami Agumamidi
-
Patent number: 11372828Abstract: Computer-implemented methods and systems for migrating business data from source business system to target business system are described. The method performed by server system includes receiving request from user device to migrate source data from source business system to target business system and accessing source metadata associated with source business system and target metadata associated with target business system. The method includes generating one or more source staging tables based on source metadata. The one or more source staging tables include information of a plurality of source columns that is to be mapped. The method includes creating mapping sets for mapping source data to the target metadata, transforming the source data stored in the one or more source staging tables into a target data structure based on the target metadata, and loading a target staging table associated with target business system based, at least in part, on the transforming step.Type: GrantFiled: August 18, 2021Date of Patent: June 28, 2022Assignee: Rite Software Solutions and Services LLCInventor: Krishna Bendapudi
-
Patent number: 11372840Abstract: An aspect of the present disclosure facilitates validation of responses received from server systems. In one embodiment, data values are maintained in a data source. Upon sending a request containing a query criteria to a server system, the server system retrieves data values satisfying the query criteria from the data source. A (actual) response is received from the server system, the actual response containing data values retrieved by the server system. Data values satisfying the query criteria are also retrieved directly from the data source and an expected response is constructed by incorporating the directly retrieved data values. The data values contained in the expected and the actual responses are then compared to determine a difference between the expected and actual responses as a basis for validating the actual response received from the server system for the request.Type: GrantFiled: November 1, 2018Date of Patent: June 28, 2022Assignee: Oracle International CorporationInventors: Rohit Johry, Somashekar Gudiputi, Allamaprabhu Gangavathi, Kokilavani Chandrasekaran
-
Patent number: 11372883Abstract: A method for calculating a size of a processing unit in a system, the system being configured to perform a reflection process that includes reflecting information on an operation performed in a row-type database on a column-type database in a predetermined processing unit, the method includes: executing a first calculation process for calculating a reference value based on processing costs of multi-version concurrency control performed in the processing unit by the database management system and information on processing costs of a process of converting the information on the operation performed in the row-type database into a form of the column-type database after the reflection process is executed in a previous time; and executing a second calculation process for calculating a size of a processing unit based on the reference value calculated by the first calculation process and information on a deviation of the number of valid rows.Type: GrantFiled: April 3, 2019Date of Patent: June 28, 2022Assignee: FUJITSU LIMITEDInventor: Eiji Seki
-
Patent number: 11347730Abstract: Aspects of the present disclosure address systems, methods, and devices for tracking object dependencies in a cloud database system. An object dependency created between a referencing object and a referenced object is detected. Based on detecting the object dependency, a dependency record is generated. The dependency record includes dependency information describing the object dependency between the reference object and the referenced object. The dependency record is stored in a database of dependency records.Type: GrantFiled: July 28, 2021Date of Patent: May 31, 2022Assignee: Snowflake Inc.Inventors: Raja Balakrishnan, Khalid Zaman Bijon, Subramanian Muralidhar, David Schultz, Jian Xu
-
Patent number: 11341131Abstract: Systems and methods are described for scheduling a query for execution. The system receives and parses a query to identify one or more portions of the query. The system determines a resource allocation for each portion of the query, and determines an availability of compute resources for the different portions of the query. Based on the resource allocation and the availability of compute resources, the system schedules the query.Type: GrantFiled: April 29, 2019Date of Patent: May 24, 2022Assignee: Splunk Inc.Inventors: Sourav Pal, Arindam Bhattacharjee, Nikhil Roy
-
Patent number: 11334589Abstract: Aspects of the present disclosure involve systems, methods, devices, and the like for creating a unified analytics platform for big data analytics, visualization and data store. In one embodiment the unified analytics platform can include at least a computer platform, core data platform, and integration platform. The unified analytics platform is designed to provide visibility into datasets, provide operational metrics, and provide the integration of notebooks and tools for big data analysis.Type: GrantFiled: September 13, 2018Date of Patent: May 17, 2022Assignee: PAYPAL, INC.Inventors: Romit Mehta, Andrew Alves, Prabhu Kasinathan, Ayushi Agarwal, Thilak Raj Balasubramanian, Baskaran Gopalan, Praveen Kanamarlapudi, Laxmikant Patil, Deepak Mohanakumar Chandramouli, Anisha Nainani, Dheeraj Rampally, Meisam Fathi Salmi, Weijun Qian
-
Patent number: 11334594Abstract: Described herein are systems and methods of transforming data models, for example, creating a data warehouse. A directives model may be loaded based upon a parsed directives file. An entity model may be loaded, and tables, attributes, and foreign keys of a data warehouse model may be created based upon the directives model and the entity model. Mappings may be created between tables, columns, and foreign keys of the data warehouse model and entities, attributes, and relationships, respectively, of the entity model. Code to define a data warehouse may be generated based upon the tables, attributes, and foreign keys of the data warehouse model. Code to transfer data from the source data source can be generated based upon the created mappings. A lineage report can be generated that provides information identifying a corresponding source for each table and column in the data warehouse.Type: GrantFiled: August 25, 2020Date of Patent: May 17, 2022Assignee: Microsoft Technology Licensing, LLCInventor: William Edward Gibson