Data Extraction, Transformation, And Loading (etl) Patents (Class 707/602)
  • Patent number: 12045250
    Abstract: The present disclosure relates to computer-implemented methods, software, and systems for exchanging metadata between applications. One example method includes providing a metadata service defining a service metadata model for exposing metadata of data objects defined at one or more applications. A connection to a data source associated with a first application is established from a separate application to acquire the metadata from the data source for one or more data objects related to the first application. In response to establishing the connection, a view of content from the data source is provided that includes a list of entities from the service metadata model. A query defined based on the list of entities is received for acquiring metadata associated with the one or more identified entities. The query is evaluated at a backend of the first application and the metadata for the identified entities from the data source is provided.
    Type: Grant
    Filed: September 28, 2021
    Date of Patent: July 23, 2024
    Assignee: SAP SE
    Inventor: Daniel Buchmann
  • Patent number: 12047249
    Abstract: A computing system to generate models of managed devices and applications in an Internet of Things (IOT) system by identifying each endpoint in the managed devices and applications capable of transmitting or receiving the data and defining flows for data from the endpoints in sensors to endpoints of IOT servers via endpoints of the programmable edge device applications. The computing system can develop a data flow map to define a connectivity of the programmable edge device applications to the sensors and the servers in the IOT system for exchanging the data from the sensors to the servers in the IOT system via the programmable edge device applications. The computing system can prompt configuration of the managed devices and applications in the IOT system based on the data flow map, which implements the connectivity of the programmable edge device applications to the sensors and to servers in the IOT system.
    Type: Grant
    Filed: August 27, 2020
    Date of Patent: July 23, 2024
    Assignee: Siemens Industry Software Inc.
    Inventors: Emmanuel Petit, Abdul Basit, Ghada Bahig, Ahmed Moustafa
  • Patent number: 12038929
    Abstract: Query planning in a distributed database that includes a table partitioned into shards according to a sharding criterion and distributed to database instances includes receiving a data-query. The data-query includes a “distinct count” clause on a first column and a “group by” clause on least a second column. A query plan is formulated to include respective instructions for converting, at at least some of the database instances, distinct values of the first column grouped by values of the second column into a count of the distinct values grouped by the values of the second column to obtain respective intermediate results; instructions for receiving the respective intermediate results from at least a subset of the at least some of the database instances; and instructions for concatenating the respective intermediate results using a summing operation to obtain the first “distinct count” of the first column grouped by the second column.
    Type: Grant
    Filed: June 13, 2023
    Date of Patent: July 16, 2024
    Assignee: ThoughtSpot, Inc.
    Inventors: Ashok Anand, Ambareesh Sreekumaran Nair Jayakumari, Prateek Gaur, Donko Donjerkovic
  • Patent number: 12026150
    Abstract: Methods and systems are used for providing a generic data state transfer interface to the state of data and information for a reporting system. As an example, a generic data status request is received, by a generic data source access function of a backend source system, from a reporting system. In response to the generic data status request being received, a first set of notifications is retrieved, by the generic data source access function, from a first source database. Each notification of the first set of notifications to each corresponding target notification of a set of target notifications in a generic data status response is mapped, by the generic data source access function, using a customizable mapping function based on a specific application of a plurality of applications in each notification. The generic data status response is transmitted, by the generic data source access function, to the reporting system.
    Type: Grant
    Filed: October 5, 2021
    Date of Patent: July 2, 2024
    Assignee: SAP SE
    Inventors: Neha Garg, Hemanth Kumar M S
  • Patent number: 12020367
    Abstract: Enhanced techniques applicable to a ray tracing hardware accelerator for traversing a hierarchical acceleration structure are disclosed. The traversal efficiency of such hardware accelerators are improved, for example, by transforming a ray, in hardware, from the ray's coordinate space to two or more coordinate spaces at respective points in traversing the hierarchical acceleration structure. In one example, the hardware accelerator is configured to transform a ray, received from a processor, from the world space to at least one alternate world space and then to an object space in hardware before a corresponding ray-primitive intersection results are returned to the processor. The techniques disclosed herein facilitate the use of additional coordinate spaces to orient acceleration structures in a manner that more efficiently approximate the space occupied by the underlying primitives being ray-traced.
    Type: Grant
    Filed: February 11, 2022
    Date of Patent: June 25, 2024
    Assignee: NVIDIA CORPORATION
    Inventors: Gregory Muthler, John Burgess, James Robertson, Magnus Anderson
  • Patent number: 12019648
    Abstract: Methods, systems, devices, and computer-readable media used by a cloud data management system for collecting data from accounts hosted by a cloud-based data warehousing system on different cloud platforms or in different cloud regions of a cloud platform. Collection of data in the multi-cloud platform and/or multi-cloud region environments may be facilitated by the on-demand creation of one or more data collection accounts. Based on the collected data, one or more data warehouse resources not managed by the cloud data management system may be discovered, configured, and onboarded to the cloud data management system.
    Type: Grant
    Filed: October 12, 2022
    Date of Patent: June 25, 2024
    Assignee: Capital One Services, LLC
    Inventors: Hiren Shah, Ganesh Bharathan, Sridhar Maramreddy, Naga Venkata Sriram Vadakattu, Naveen Kumar Kilaru, David Ellis, Felix Li, Yudhish Batra, Kishore Kolanu, Syed Siraj Mehmood, Nicole Markley
  • Patent number: 12019644
    Abstract: Methods for performing a query operation on a database comprise selecting a connection to the database from a plurality of connections to the database, the connections being arranged within a data structure and each having a predetermined number of query slots; waiting for a query slot to be available on the selected connection; in response to determining that the predetermined number of query slots include at least one available query slot, accessing one of the at least one available query slots; reordering the plurality of connections within the data structure; causing the query operation to execute at least partially using the accessed query slot; and releasing the accessed query slot.
    Type: Grant
    Filed: August 24, 2023
    Date of Patent: June 25, 2024
    Assignee: Xero Limited
    Inventors: Cassandra Mcfaull, Geoff Thornburrow
  • Patent number: 11989157
    Abstract: Techniques for performing test adaption and distribution for customer storage systems in accordance with a customer knowledge base. The techniques can include sending, by each customer storage system, data to the customer knowledge base. The data includes, for each customer storage system, a version of a data storage application and associated system configuration and parameters. In response to a query from a QA testing system, the data is migrated from the customer knowledge base to a QA database. The QA testing system analyzes the data to determine the most common system configuration, parameters, and data storage application version for most of the customer storage systems. The QA testing system adapts a test plan for testing the data storage application to conform with the most common system configuration and parameters and executes an application upgrade plan on QA storage appliances pre-prepared in accordance with the most common data storage application version.
    Type: Grant
    Filed: January 10, 2022
    Date of Patent: May 21, 2024
    Assignee: Dell Products L.P.
    Inventors: Ilan Yosef, Shay Goldshmidt
  • Patent number: 11989187
    Abstract: In an example embodiment, a data model, software architecture, and process for synchronizing information about tags is provided, that permits assignment between different microservices. When a tag is added to an entity, then an assignment is made. The assignment is a record that contains a reference to a unique identifier for the tag and also describes the entity's domain and entity type. Each service uses at least one distinct domain, so tag assignments from different services should not conflict with one another.
    Type: Grant
    Filed: April 27, 2022
    Date of Patent: May 21, 2024
    Assignee: SAP SE
    Inventors: Michael Decker, Susanne Gottlieb, Mike Luang-Khot, Steffen Maier, Arthee Pranadharthi Haran, Pradeep Rathod, Philipp Thiele, Mathias Zietzschmann
  • Patent number: 11983172
    Abstract: A method includes generating a predictive model mapping batch size to estimated memory utilization based on a plurality of prior batch sizes applied for performing a corresponding plurality of prior data format conversions, and further based on a plurality of prior actual memory utilization occurring in performing the corresponding plurality of prior data format conversions. A next batch size is automatically selected for performance of a subsequent data format conversion based on the predictive model and a current memory availability. A batch of data for performance of the subsequent data format conversion is identified based on the batch of data having the next batch size. The subsequent data format conversion is performed the batch of data, and an actual amount of memory utilized in performing the subsequent data format conversion is determined. The predictive model is updated based on the next batch size and the actual amount of memory utilized.
    Type: Grant
    Filed: December 7, 2021
    Date of Patent: May 14, 2024
    Assignee: Ocient Holdings LLC
    Inventors: Natalia Marie Jenuwine, George Kondiles, Anna Veselova, Ravi V. Khadiwala
  • Patent number: 11971888
    Abstract: The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one aggregation and at least one join operation. The subject technology analyzes the query plan to identify an aggregation that is redundant. The subject technology removes the aggregation based at least in part on the analyzing. The subject technology determines at least one aggregation property corresponding to at least one query operation of the query plan. The subject technology inserts at least one adaptive aggregation operator in the query plan based at least in part on the at least one aggregation property, the at least one aggregation property comprising a set of aggregation properties. The subject technology provides a modified query plan based at least in part on the inserted at least one adaptive aggregation operator in the query plan.
    Type: Grant
    Filed: February 19, 2021
    Date of Patent: April 30, 2024
    Assignee: Snowflake Inc.
    Inventors: Bowei Chen, Thierry Cruanes, Florian Andreas Funke, Allison Waingold Lee, Jiaqi Yan
  • Patent number: 11966411
    Abstract: Techniques for change data capture (CDC) log augmentation are described. In some examples, a user configures CDC log augmentation by indicating which data should be included in a CDC log, and the database, when generating a CDC log associated with this configuration, can obtain the associated data and augment the CDC log by inserting this data into it. The augmented data can include one or more fields from a record in a separate database table, where the record can be identified based on the changed record represented by the CDC log.
    Type: Grant
    Filed: September 12, 2022
    Date of Patent: April 23, 2024
    Assignee: Amazon Technologies, Inc.
    Inventors: Punit Rajgaria, Murali Brahmadesam
  • Patent number: 11954130
    Abstract: A logical graph is generated using at least a portion of log data received from a set of agents executing on one or more nodes in one or more data centers. The logical graph is augmented using data obtained from one or more agents executing in containerized environments, including by representing communications between pods within the logical graph. The augmented logical graph is used to detect an anomaly.
    Type: Grant
    Filed: November 19, 2021
    Date of Patent: April 9, 2024
    Assignee: Lacework Inc.
    Inventors: Yijou Chen, Harish Kumar Bharat Singh, Murat Bog, Vikram Kapoor
  • Patent number: 11941017
    Abstract: Extract, Transform, Load (ETL) processing may be initiated by detected events. A trigger event may be associated with an ETL process apply one or more transformations to a source data object. The trigger event may be detected for the ETL process and evaluated with respect to one or more execution conditions for the ETL process. If the execution conditions for the ETL process are satisfied, then the ETL process may be executed. At least some of the source data object may be obtained, the one or more transformations of the ETL process may be applied, and one or more transformed data objects may be stored.
    Type: Grant
    Filed: October 21, 2022
    Date of Patent: March 26, 2024
    Assignee: Amazon Technologies, Inc.
    Inventors: George Steven McPherson, Mehul A. Shah, Prajakta Datta Damle, Gopinath Duddi, Anurag Windlass Gupta
  • Patent number: 11922140
    Abstract: In one embodiment of systems and methods described herein, a computing device is configured to generate and display a user interface including one or more selectable generic options; receive a selection of a data analysis function to perform machine learning; translate the selected function into pre-configured commands for each back-end tool that are specific to each back-end tool for performing the selected function, wherein the pre-configured commands identify and access specific schema with a compatible format for reading the specific schema from each back end tool to expose retail-specific data sets in accordance with the specific schema; execute the preconfigured commands based on the specific schema and retrieve corresponding retail-specific data from a plurality of the back-end tools based on the specific schema; and execute the selected data analysis function on the retrieved retail-specific data from the plurality of back-end tools and generate a data analysis result using Artificial Intelligence-Ena
    Type: Grant
    Filed: April 6, 2020
    Date of Patent: March 5, 2024
    Assignee: Oracle International Corporation
    Inventors: Sandhya Lonial, Sajith Vijayan
  • Patent number: 11922328
    Abstract: Systems and methods for generating a machine-learning (ML) model for extracting information from one or more electronic documents, where the ML model can be used as a data object, which can be part of a database command or as part of a document information extraction process that is continuously running (e.g., document information extraction pipeline).
    Type: Grant
    Filed: September 22, 2023
    Date of Patent: March 5, 2024
    Assignee: Snowflake Inc.
    Inventors: Michal Gdak, Ganeshan Ramachandran Iyer, Tomasz Malisz, Mikolaj Niedbala, Pawel Pollak, Saurin Shah, Jan Tomasz Topinski, Daria Wieteska
  • Patent number: 11921864
    Abstract: A computer-implemented method, computer program product and computing system for: obtaining first system-defined platform information concerning a first security-relevant subsystem within a computing platform; obtaining at least a second system-defined platform information concerning at least a second security-relevant subsystem within the computing platform; combining the first system-defined platform information and the at least a second system-defined platform information to form system-defined consolidated platform information; and generating a security profile based, at least in part, upon the system-defined consolidated platform information.
    Type: Grant
    Filed: September 23, 2022
    Date of Patent: March 5, 2024
    Assignee: RELIAQUEST HOLDINGS, LLC
    Inventors: Brian P. Murphy, Joe Partlow, Colin O'Connor, Jason Pfeiffer
  • Patent number: 11899663
    Abstract: In an example embodiment, a solution is provided that aggregates records as they are submitted to a third party (on the write path) rather than performing a real-time aggregation when a request is processed that needs the aggregation (read path). More particularly, in an example embodiment, a caching layer is introduced that avoids having to read all usage events to compute an aggregation when a request is received for aggregated data. The caching layer maintains values for various metrics that require aggregation.
    Type: Grant
    Filed: September 15, 2021
    Date of Patent: February 13, 2024
    Assignee: STRIPE, INC.
    Inventors: Alisa (Shuhui) He, Tushar Dhoot, Ji Huang
  • Patent number: 11899735
    Abstract: Systems, methods, and non-transitory computer readable media containing instructions allow altering default website display parameters to conform with a neurodevelopmental disorder, epilepsy, visual impairment, and/or cognitive disability profile. In one implementation, a non-transitory computer readable medium contains instructions that cause a processor to alternate default website display parameters to conform with a disability profile by: obtaining an indication that a user of a website has a disability; and based on the obtained indication, implementing a predefined template to alter multiple website default display parameters to conform with needs of the user with the disability; wherein implementing the predefined template impacts presentation of content on a computing device of the user with the disability without impacting presentation of content on other computing devices display to other simultaneous viewers of the website.
    Type: Grant
    Filed: July 11, 2022
    Date of Patent: February 13, 2024
    Assignee: accessiBe Ltd.
    Inventor: Shir Ekerling
  • Patent number: 11894676
    Abstract: A building energy management system includes building equipment, a data collector, an analytics service, a timeseries database, and an energy management application. The building equipment monitor and control one or more variables in the building energy management system and provide data samples of the one or more variables. The data collector collects the data samples from the building equipment and generates a data timeseries including a plurality of the data samples. The analytics service performs one or more analytics using the data timeseries and generates a results timeseries including a plurality of result samples indicating results of the analytics. The timeseries database stores the data timeseries and the results timeseries. The energy management application retrieves the data timeseries and the results timeseries from the timeseries database in response to a request for timeseries data associated with the one or more variables.
    Type: Grant
    Filed: March 7, 2022
    Date of Patent: February 6, 2024
    Assignee: JOHNSON CONTROLS TECHNOLOGY COMPANY
    Inventors: Andrew J. Boettcher, Steven R. Vitullo, Vivek Narain, Youngchoon Park, Gerald A. Asp, Peter A. Craig, Vijaya S. Chennupati
  • Patent number: 11886459
    Abstract: A data management system includes a processor. An estimated ETL level mapping processing unit is operated on the processor to estimate existence of unregistered ETL that is ETL not registered in a repository, to calculate a degree of similarity based on matching between an existing data model and retained data, and to extract a column to be a candidate based on the degree of similarity. The existence of the unregistered ETL is estimated by estimating the presence or absence of connectedness in the ETLs on the basis of correspondence between input data and output data in ETLs by using an execution ETL log relevant to an execution history of the ETL.
    Type: Grant
    Filed: March 14, 2022
    Date of Patent: January 30, 2024
    Assignee: Hitachi, Ltd.
    Inventors: Keiko Tanigawa, Toshihiko Kashiyama, Jumpei Okoshi
  • Patent number: 11886460
    Abstract: In some examples, a computing device is able to communicate with a plurality of data clusters. For example, a first data cluster may be configured with a first version of data cluster software including a first library version, and a second data cluster may be configured with a second version of data cluster software including a second library version that is different from the first. The computing device may execute a single instance of an application to send, based at least on information in the first library version, to the first data cluster, a request for first data, and may receive the first data from the first cluster. Further, the computing device may send, based at least on information in the second library version, second data that is based on the first data to the second data cluster to store the second data with the second data cluster.
    Type: Grant
    Filed: January 31, 2020
    Date of Patent: January 30, 2024
    Assignee: HITACHI VANTARA LLC
    Inventors: Angelo Manuel Rodriguez, Jacob Russell Gminder, Angel Luis Ramos Cardona
  • Patent number: 11880344
    Abstract: Methods and systems for generating multi-operator data transformation pipelines. An example method includes accessing raw data for transformation; receiving a selection of a target table or target visualization, wherein the target table or target visualization is for data other than the raw data; extracting table properties and target constraints; and based on the extracted table properties and target constraints, synthesizing one or more multi-operator data transformation pipelines for transforming the raw data to a generated table or generated visualization.
    Type: Grant
    Filed: May 14, 2021
    Date of Patent: January 23, 2024
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Yeye He, Surajit Chaudhuri, Junwen Yang
  • Patent number: 11880358
    Abstract: In one embodiment, a device receives, from a requestor, a query function that queries a dataset and an intended use schema associated with the query function. The device determines, using a policy ruleset, whether the intended use schema falls within an available schema for the dataset. The device executes the query function on the dataset to form a result data, when the intended use schema falls within the available schema for the dataset. The device provides the result data to the requestor.
    Type: Grant
    Filed: September 16, 2021
    Date of Patent: January 23, 2024
    Assignee: CISCO TECHNOLOGY, INC.
    Inventors: Trevor George Smith, Oliver James Bull, Gaétan Feige
  • Patent number: 11868431
    Abstract: According to one embodiment, an information processing apparatus includes: a processor configured to select a first case based on subject data including at least one feature, and acquire a first prediction value that is a value of an objective variable included in the first case; a first estimator configured to estimate frequency data indicating frequencies of observation values of the objective variable, based on a history of observation values of the objective variable; a second estimator configured to estimate first frequency data indicating frequencies of first prediction values, based on a history of first prediction values acquired before the first prediction value is acquired; and a corrector configured to correct the first prediction value acquired by the processor, based on the frequency data and the first frequency data.
    Type: Grant
    Filed: March 10, 2021
    Date of Patent: January 9, 2024
    Assignee: Kabushiki Kaisha Toshiba
    Inventors: Mitsuru Kakimoto, Hiromasa Shin, Yoshiaki Shiga, Fang Ni
  • Patent number: 11868332
    Abstract: A data index establishment method obtains M raw data segments and a first-layer mapping relationship through segment fitting on raw data in a raw data table, and further obtains N first key segments and a second-layer mapping relationship through segment fitting on a first key of each raw data segment. In a subsequent data query process, a multi-layer mapping relationship is input from a to-be-queried key sequentially in descending order, until a location of the to-be-queried key in the raw data table is located.
    Type: Grant
    Filed: April 21, 2021
    Date of Patent: January 9, 2024
    Assignee: HUAWEI CLOUD COMPUTING TECHNOLOGIES CO., LTD.
    Inventors: Wenli Zhou, Mingchang Wei, Jiangbo Liu
  • Patent number: 11853313
    Abstract: In accordance with an embodiment, an intelligent load plan that can automatically ensure that a system is in a runnable state and no other conflicting activity can affect the results of the data loads, such as ETLs. Such an intelligent load plan can be used in on data warehousing solutions as well as on a cloud data warehouse solution. The intelligent load plan can, in some embodiments, automatically detect situations based on which it knows it is not supposed to run the load plan.
    Type: Grant
    Filed: June 14, 2016
    Date of Patent: December 26, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventor: Gunaranjan Vasireddy
  • Patent number: 11853400
    Abstract: 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: Grant
    Filed: March 20, 2023
    Date of Patent: December 26, 2023
    Assignee: Bottomline Technologies, Inc.
    Inventors: Paul Green, Jerzy Bala
  • Patent number: 11853735
    Abstract: The systems and methods provide continuous integration and continuous deployment pipeline management using pipeline-agnostic rule sets applied to pre-deployment code samples. The system standardizes the application of a rule set to a pre-deployment code sample to use data at a given location, but the system allows for the sample itself to determine which data stream of the data streams at that data location is used. As such, the systems and methods avoid the need for the plethora of rule sets that would overwhelm a user and defeat the purpose of the CaaS product, but the system allows for processing pre-deployment code samples that are specific to the sample.
    Type: Grant
    Filed: February 10, 2023
    Date of Patent: December 26, 2023
    Assignee: Citibank, N.A.
    Inventors: Tridib Choudhury, Manish Shah, Satish Chandreskharan, Robert Kovach, Shweta Sobat, Arunkumar Saripalli
  • Patent number: 11848829
    Abstract: Computing systems, for example, multi-tenant systems create data centers in a cloud platform using a cloud platform infrastructure language that is cloud platform independent. The system receives a cloud platform independent declarative specification describing a new datacenter to be created or modifications to an existing datacenter deployed on a cloud platform. The system compiles the cloud platform independent declarative specification to generate a metadata representation of the data center. If the datacenter is existing, the system generates a metadata representation representing modifications to the datacenter to obtain a desired datacenter. The system sends the metadata representation and a set of instructions for execution on a target cloud platform. The target cloud platform executes the instructions to configure the data center. The system provides users with access to the computing resources of the data center configured by the target cloud platform.
    Type: Grant
    Filed: November 6, 2020
    Date of Patent: December 19, 2023
    Assignee: Salesforce, Inc.
    Inventors: Srinivas Dhruvakumar, Mayakrishnan Chakkarapani, Varun Gupta, Joshua Paul Meier
  • Patent number: 11847131
    Abstract: In various embodiments, a data integration system is disclosed which enables incremental loads into a data warehouse by developing a data partitioning plan and selectively disabling and enabling indexes to facilitate incremental loads into fact tables.
    Type: Grant
    Filed: May 7, 2021
    Date of Patent: December 19, 2023
    Assignee: Oracle International Corporation
    Inventors: Justin Hyde, Jeff Titmas
  • Patent number: 11847130
    Abstract: In some implementations, a monitoring device may receive configuration information associated with an extract, transform, load (ETL) pipeline that includes one or more data sources and one or more data sinks. The monitoring device may generate, based on the configuration information, lineage data related to a data flow from the one or more data sources to the one or more data sinks in the ETL pipeline. The monitoring device may generate one or more predicted quality metrics associated with the ETL pipeline using a machine learning model. The monitoring device may generate a visualization in which multiple nodes are arranged to indicate the data flow from the one or more data sources to the one or more data sinks and further in which the one or more predicted quality metrics are encoded within the visualization.
    Type: Grant
    Filed: May 21, 2021
    Date of Patent: December 19, 2023
    Assignee: Capital One Services, LLC
    Inventors: Chanakya Kaspa, Divya Mehrotra, Gregory Muzyn
  • Patent number: 11822496
    Abstract: A method for operating a communications network that includes at least two users that are communicatively connected to one another via a descriptor-based communication system such as Ethernet. For writing data from a writing user into a user to be written, receive descriptors and data are transmitted from the writing user to the user to be written, in the user to be written, the data being written according to the received receive descriptors, and/or for reading data by a reading user from a user to be read, transmit descriptors are transmitted from the reading user to the user to be read, data being read by the user to be read according to the received transmit descriptors and transmitted to the reading user. A communications network and users are also described.
    Type: Grant
    Filed: February 17, 2022
    Date of Patent: November 21, 2023
    Assignee: ROBERT BOSCH GMBH
    Inventors: Josef Newald, Lambros Dalakuras, Thomas Hogenmueller
  • Patent number: 11810547
    Abstract: In an example embodiment, machine learning is utilized to automatically present and explain analysis of multidimensional objects categorized based on context in an enterprise data warehouse. The system is capable of handling dependencies to provide clear insights demonstrated in a native language of an end user. The system is multilingual and capable of framing explanations based on natural language processing (NLP), artificial intelligence (AI), and machine learning. It converts the textual predictions into speech synthesis in the user-understandable native format and then dictates the analysis using the speech synthesis.
    Type: Grant
    Filed: April 8, 2021
    Date of Patent: November 7, 2023
    Assignee: SAP SE
    Inventor: Ramalingam Tv
  • Patent number: 11803798
    Abstract: In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for automatic generation of asserts in such environments. A data pipeline or process, such as, for example an extract, transform, load (ETL) process, can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance. Each customer (tenant) can additionally be associated with a customer tenancy and a customer schema. During the process of populating a data warehouse instance, the system can automatically generate dynamic data-driven ETL asserts, including determining a list of columns for tables in the data warehouse; determining a data type for each column; generating an assert for each determined data type; validating the generated assert; and maintaining the generated assert.
    Type: Grant
    Filed: April 17, 2020
    Date of Patent: October 31, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Krishnan Ramanathan, Gangadhar Ronanki, Aman Madaan
  • Patent number: 11797711
    Abstract: The present document relates to an electronic device, a method for providing personal information using same, and a computer-readable recording medium for recording same, wherein the electronic device may include a communication circuit, a storage, a display, and a processor. According to various embodiments, the processor may be configured to generate a smart contract comprising information on categories of personal information to be provided to an external user, information about the external user, and information about a de-identification level of the personal information to be provided; transfer the smart contract to a block chain; receive a request for provision of personal information from the block chain; process personal information of a user on the basis of the smart contract; and transfer the processed personal information to the block chain. Other various embodiments are possible.
    Type: Grant
    Filed: October 30, 2019
    Date of Patent: October 24, 2023
    Inventors: Jaeyoung Lee, Kyungmoon Kim, Yikeun Park, Kichan Sung, Dongjin Lee, Heesoo Lee
  • Patent number: 11798268
    Abstract: Provided is a method for improving reliability of artificial intelligence-based object recognition, in which: in a server interworking with an artificial intelligence module, one or more object regions included in learning data including an image of a recognition target object to be recognized through the artificial intelligence module are recognized; object region recognition data which sets the recognized object regions is extracted and is provided to user terminals in a designated order; a procedure for receiving, from the user terminals, object region selection data which selects at least one effective object region corresponding to the recognition target object among object regions included in the object region recognition data is performed; and the object region selection data of respective users received from the user terminals is mutually compared and analyzed by the same object region selection data.
    Type: Grant
    Filed: December 9, 2019
    Date of Patent: October 24, 2023
    Inventor: Cheol Ho Shin
  • Patent number: 11768833
    Abstract: Concepts for processing a SQL statement comprising a ROLAP sort operation are presented. One such concept comprises: determining whether a ROLAP partitioning column of the SQL statement does not refer to database columns from a sort operation of the SQL statement; and determining whether the ROLAP partitioning columns of the SQL statement are all referenced in the output of the SQL statement. Responsive to determining a ROLAP partitioning column of the SQL statement does not refer to database columns from a sort operation of the SQL statement, and to determining all of the ROLAP partitioning columns of the SQL statement are referenced in the output of the SQL statement, the SQL statement is modified by removing the ROLAP sort operation from the SQL statement.
    Type: Grant
    Filed: July 24, 2019
    Date of Patent: September 26, 2023
    Assignee: International Business Machines Corporation
    Inventors: Pedro Miguel Barbas, David Kelly, Jan Mahon, Donald Fraser
  • Patent number: 11770020
    Abstract: A method for monitoring or controlling equipment of a building includes receiving a first timeseries comprising first data samples of a first variable monitored or controlled by a system and a second timeseries comprising second data samples of a second variable monitored or controlled by the system. The first data samples are at least partially asynchronous with the second data samples. The method includes synchronizing the first timeseries with the second timeseries by aggregating both the first timeseries and the second timeseries using equivalent aggregation intervals. Aggregating the first timeseries generates a third timeseries comprising aggregated values of the first variable and aggregating the second timeseries generates a fourth timeseries comprising aggregated values of the second variable. The method includes performing an automated operation to monitor or control the equipment of the building using the synchronized data samples of the third timeseries and the fourth timeseries.
    Type: Grant
    Filed: July 27, 2022
    Date of Patent: September 26, 2023
    Assignee: JOHNSON CONTROLS TECHNOLOGY COMPANY
    Inventors: Gerald A. Asp, Youngchoon Park, Peter A. Craig
  • Patent number: 11762840
    Abstract: A system, method, and computer-readable medium are disclosed that generate staging data independently from the execution of control scripts, which process the staging data, improving the quality, efficiency, and speed of data processing systems. The staging data can be independently loaded, validated, and utilized across multiple control scripts, reducing redundancy in the loading of data and the overhead of executing separate data processing for each control script. The control scripts can be automatically validated, such as by verifying expected output data ranges. Additionally, the complexity of the control scripts can be reduced as the loading of data is not performed by the control scripts. The controls scripts can generate a variety of output data, such as an indication of impacted accounts, and provide notifications based on the output data. A variety of machine learning classifiers may automatically generate the staging data and validate the staging data and/or output data.
    Type: Grant
    Filed: December 17, 2021
    Date of Patent: September 19, 2023
    Assignee: Capital One Services, LLC
    Inventors: Daniel Gunn, Zhihao Gao, Pulkit Gulati, William Cartar
  • Patent number: 11748556
    Abstract: System and method of enhancing previously published PDF document files, including files signed or locked to prevent further editing, with enhancement data stored external to the PDF document files. Here an internet server (enhancement server) is configured with a database that stores a plurality of PDF document files, linked with corresponding PDF document URL, enhanced content data, and statistics. When the enhancement server receives a particular PDF document URL request, it returns annotated PDF information that combines the original PDF document and the enhanced content data. This annotated PDF information can be viewed in the GUI of a remote computerized device. The enhancement server can also receive user input from the remote device, store user uploaded data and files, update user statistics, and use this data to enhance the PDF files further. Applications include PDF linked Q&A, lectures, walkthroughs, enhanced media, and chat sessions.
    Type: Grant
    Filed: August 9, 2022
    Date of Patent: September 5, 2023
    Inventor: Ahmed Mohamed Hany AbdelAlim ElGamal
  • Patent number: 11750488
    Abstract: A computer-implemented method, a computer program product, and a computer system for minimizing latency in an infrastructure. One or more servers receive a request of deploying a new extract, load, and transform (ELT) logic. One or more servers analyze the new ELT logic to identify source and target locations, analyze logs of existing ELT logics, identify physical locations of infrastructure resources, and identify available physical spaces for moving the infrastructure resources close to each other. One or more servers determine infrastructure resources that need to be moved so that round trip network communication of the new ELT logic are optimized, based on the physical locations of the infrastructure resources, the available physical spaces, and parameters identified through analysis of existing ELT logics. One or more servers move the infrastructure resources that need to be moved.
    Type: Grant
    Filed: April 12, 2022
    Date of Patent: September 5, 2023
    Assignee: International Business Machines Corporation
    Inventors: Sudheesh S. Kairali, Sarbajit K. Rakshit
  • Patent number: 11741167
    Abstract: An illustrative computing system generates, based on a plurality of point-of-interest data records each including data representative of a distinct set of features for a distinct point-of-interest associated with a distinct geographic location, a graph data structure that includes the plurality of point-of-interest data records and a plurality of weighted feature relationships interconnecting the plurality of point-of-interest data records. The computing system generates one or more merged point-of-interest data records based on the graph data structure and provides the one or more merged point-of-interest data records to a mapping system to indicate one or more points-of-interest on a user interface map of a geographic area.
    Type: Grant
    Filed: March 23, 2022
    Date of Patent: August 29, 2023
    Assignee: Verizon Patent and Licensing Inc.
    Inventors: Wesley Boyer, Aleksei Maximillian Kac, Mark Romanak, Thomas M. Baker, Jr., Jeremy McKay, Jared David Barnes, Rossi Guiliani
  • Patent number: 11741102
    Abstract: A query processing method includes receiving a query from a requestor. The query is directed to a first data model specifying multiple base data fields. The method includes determining a set of extension bindings for the first data model based on the query. Each binding specifies an extension to the first data model from a set of model extensions and specifies one of the base data fields of the first data model as a node at which the extension is added. The method includes generating a data object from base data values and extension data values according to an extended data model. The extended data model is defined by the first data model extended by, for each binding of the set, adding data fields from the specified extension to the first data model at the specified node. The method includes returning the data object to the requestor.
    Type: Grant
    Filed: March 10, 2022
    Date of Patent: August 29, 2023
    Assignee: Express Scripts Strategic Development, Inc.
    Inventors: Dennis Fuglsang, Robert W. Scanlon
  • Patent number: 11734297
    Abstract: 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: Grant
    Filed: June 15, 2022
    Date of Patent: August 22, 2023
    Assignee: Splunk Inc.
    Inventors: Subramaniam Baskaran, Syam Bollu, Tristan Fletcher, Michael Margulis, Joel Schoenberg, Omprakaash Thoppai
  • Patent number: 11733957
    Abstract: A computer-implemented method, a computer system and a computer program product distribute content in a virtual meeting session. The method includes extracting a plurality of embedded graphics from a presentation. The embedded graphics are selected from a group consisting of web links, images and video data. The method also includes transmitting the plurality of embedded graphics to a participant computing device. Lastly, the method includes displaying a virtual meeting dashboard that includes the plurality of embedded graphics.
    Type: Grant
    Filed: September 27, 2021
    Date of Patent: August 22, 2023
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Sneha Mary Varghese, Esteban Arias-Navarro, Jones Ahoi
  • Patent number: 11729269
    Abstract: Embodiments are directed to bandwidth management in distributed file systems. A request stored in a queue may be dequeued. A work credit value may be determined based on a duration since a last job and a work rate associated with the file system such that the work credit value conforms to a maximum threshold value. A job may be initialized based on the dequeued request such that the work credit value may be reduced based on a size of the job. In response to the reduced work credit value being a negative value further actions may be performed, including: determining a time delay based on the reduced work credit value, the work rate, and the size of the job; delaying an execution of the job until the expiry of the time delay such that upon expiry of the time delay, the job is executed to satisfy the request.
    Type: Grant
    Filed: October 26, 2022
    Date of Patent: August 15, 2023
    Assignee: Qumulo, Inc.
    Inventors: Landon John Meernik, Porter Michael Smith, Kevin David Jamieson, Daniel Shvarts
  • Patent number: 11714954
    Abstract: A webpage containing information to be extracted may undergo changes to a layout of elements that present the information. These changes could result in an inability to retrieve the information later. A first graph is determined that represents elements of a first version of a webpage at a first time. An element in the first graph for which information is being acquired is specified. A relevant portion of the first graph is designated that includes the element and immediate neighbors in the first graph. Later, a second version of the webpage is retrieved, and a second graph of that second version is determined. The relevant portion of the first graph is compared to the second graph. If a match is found, the information of interest is extracted from the specified element of the second graph. This allows extraction of information to proceed even if the layout of elements changes.
    Type: Grant
    Filed: December 11, 2020
    Date of Patent: August 1, 2023
    Assignee: AMAZON TECHNOLOGIES, INC.
    Inventors: Vijay Daniel Manason, Sathya Prakash Podila Venkata Subramanya, Ansar Pasha, Meghana Agrawal, Mandar Subhashrao Joshi, Shrikant G Nayak, Sandeep Bhaskar, Antonisamy Arokiasamy, Navin Anand
  • Patent number: 11714824
    Abstract: A system and method for enabling ETL (Extract-Transform-Load) as a service for data processing are disclosed. A user interface (UI) platform includes an input interface layer and an output interface layer. A receiver receives user input, via the input interface layer, of configuration details data corresponding to a desired data to be fetched from one or more data sources. A processor fetches the desired data from said one or more data sources based on the configuration details data to be utilized for the desired data processing scheme; automatically implements a transformation algorithm on the desired data corresponding to the configuration details data and the desired data processing scheme to output a transformed data in a predefined format; and transmits, via the output interface layer, the transformed data to downstream applications or systems in an end-to-end pipeline.
    Type: Grant
    Filed: August 5, 2021
    Date of Patent: August 1, 2023
    Assignee: JPMORGAN CHASE BANK, N.A.
    Inventors: Prashanth Madhav Padbidri, Sidhartha Sinha
  • Patent number: 11693876
    Abstract: The present disclosure involves systems, software, and computer implemented methods for efficient shared bulk loading into optimized storage. One example method includes identifying a data set on a client to load to a server. Load steps that can be performed either on the client or the server are identified. Values for load factors are determined. Load rules are determined that are based on load factors and are for determining processing locations for the load steps. A processing location of either the client or the server is determined for each load step, based on the load rules. Load steps that have a processing location of the client are executed on the data set, on the client. The data set is transferred from the client to the server, over a network. Load steps that have a processing location of the server are executed on the data set, at the server.
    Type: Grant
    Filed: January 10, 2020
    Date of Patent: July 4, 2023
    Assignee: SAP SE
    Inventors: Stefan Noll, Jens Teubner, Norman May, Alexander Boehm