Data Warehouse, Data Mart, Online Analytical Processing (olap), Decision Support Systems Patents (Class 707/600)
  • Patent number: 11163764
    Abstract: A computer-implemented method for balancing storage utilization and query processing in a distributed database. In one embodiment, the method receives a set of queries to perform on a database; determines a uniqueness score and a usage score based on the set of queries for each column of each data table in the database; normalizes the usage score and the uniqueness score to generate a normalized usage score and a normalized uniqueness score; multiplies the normalized uniqueness score by a first weight factor to produce a weighted uniqueness score; multiplies the normalized usage score by a second weight factor to produce a weighted usage score; combines the weighted uniqueness score and the weighted usage score to generate a combined column score; selects a column having a highest combined column score; and recreates the plurality of data tables of the database on the plurality of nodes using the column as a new distribution key.
    Type: Grant
    Filed: June 1, 2018
    Date of Patent: November 2, 2021
    Assignee: International Business Machines Corporation
    Inventors: Yet-San Lam, Malcolm Singh
  • Patent number: 11157496
    Abstract: A computer-implemented method for balancing storage utilization and query processing in a distributed database. In one embodiment, the computer-implemented method receives a set of queries to perform on a database that is distributed among a plurality of nodes. The database includes a plurality of data tables that each includes a plurality of columns and a plurality of rows. The computer-implemented method determines a uniqueness score and a join score for each column of each data table in the database based on the set of queries. The computer-implemented method determines a new distribution key based on the uniqueness score and the join score for each column of each data table in the database. The computer-implemented method recreates the plurality of data tables of the database on the plurality of nodes using the new distribution key for execution of the set of queries.
    Type: Grant
    Filed: June 1, 2018
    Date of Patent: October 26, 2021
    Assignee: International Business Machines Corporation
    Inventors: Yet-San Lam, Malcolm Singh
  • Patent number: 11157466
    Abstract: In various embodiments, a computer system implements a service that stores a plurality of database templates that define data types supported for a non-relational database accessible to a plurality of applications. The service receives, from a developer of an application, a selection of one of the plurality of database templates to be used by the application. In response to the selection, the service issues a set of data definition language (DDL) instructions to provision the non-relational database with a schema that implements a particular data type defined by the selected template. Requests from the application to manipulate a value of the particular data type stored in the non-relational database system are serviced. In some embodiments, the servicing includes identifying a set of data manipulation language (DML) instructions to be executed and issuing the set of DML, instructions to the non-relational database.
    Type: Grant
    Filed: September 4, 2018
    Date of Patent: October 26, 2021
    Assignee: salesforce.com, inc.
    Inventors: Benjamin Busjaeger, Michael Sgroi, Scott D. Hansma
  • Patent number: 11119458
    Abstract: A building management system (BMS) includes building equipment, a data collector, a sample aggregator, and an application. The building equipment is operable to monitor and control a variable in the BMS and to provide raw data samples of the variable. The data collector is configured to collect the raw data samples from the building equipment and generate a raw data timeseries including a plurality of the raw data samples. The sample aggregator is configured to automatically generate a data rollup timeseries including a plurality of aggregated data samples. The aggregated data samples are generated by aggregating the raw data samples as the raw data samples are collected from the building equipment. Both timeseries are stored in a timeseries database. The application is configured to retrieve the raw data timeseries and the data rollup timeseries from the timeseries database in response to a request for timeseries data associated with the variable.
    Type: Grant
    Filed: November 18, 2019
    Date of Patent: September 14, 2021
    Assignee: Johnson Controls Tyco IP Holdings LLP
    Inventors: Gerald A. Asp, Youngchoon Park, Peter A. Craig
  • Patent number: 11106647
    Abstract: Provided are methods, systems, and computer readable media for user interaction with database methods and systems. In an aspect, a user interface can be generated to permit dynamic display generation to view data. The system can comprise a visualization component to dynamically generate one or more visual representations of the data to present in the state space.
    Type: Grant
    Filed: February 21, 2019
    Date of Patent: August 31, 2021
    Assignee: QLIKTECH INTERNATIONAL AB
    Inventor: Håkan Wolgé
  • Patent number: 11086963
    Abstract: An experimentation platform controls testing of features by an application server. Based on a user identifier, the experimentation platform determines which feature should be provided, and the application server provides the corresponding version of a user interface. If the user behavior data shows that using a tested feature results in an improvement, the tested feature will be adopted. To determine whether or not an improvement is observed, a statistically significant amount of data is gathered. The experimentation platform gathers data regarding user behavior for the feature versions and, in response, adjusts the frequency at which each version is served. Providing the proposed version to an increased percentage of users decreases the total number of page serves required to gather statistically significant data. The experimentation platform may provide an updated projected time to completion of testing based on the changed percentage of users receiving the proposed version.
    Type: Grant
    Filed: December 5, 2018
    Date of Patent: August 10, 2021
    Assignee: eBay Inc.
    Inventors: Deepak Kumar Vasthimal, Pavan Kumar Srirama, Arun Kumar Akkinapalli
  • Patent number: 11061926
    Abstract: Methods and systems for managing synchronization among databases are described. One method includes establishing a trigger within a transactional database storing a plurality of transaction records, the trigger having a trigger condition associated with storing a new transaction record in the transactional database. The method includes, in response to each occurrence of the trigger condition, storing a primary key of the new transaction record into a primary key table. The method also includes aggregating transaction record information into a transaction dataset, the transaction record information being from each of a plurality of transaction records that are associated with primary keys stored in the primary key table during a predetermined time period; and transmitting the transaction dataset to a remote analysis database as streaming data.
    Type: Grant
    Filed: October 2, 2018
    Date of Patent: July 13, 2021
    Assignee: Target Brands, Inc.
    Inventor: Deepa Sarasamma
  • Patent number: 11055974
    Abstract: Methods, systems, and apparatus, for defining and monitoring an event for a physical entity and the performance of an action in response to the occurrence of the event. A method includes receiving data indicating an event for a physical entity, the event specified in part by a physical environment feature for which the occurrence of the event is to be monitored by the data processing apparatus; receiving data indicating an action associated with the event and to be taken in response to the occurrence of the event; monitoring for the occurrence of the event for the physical entity; and in response to the occurrence of the event, causing the action associated with the event to be performed.
    Type: Grant
    Filed: December 16, 2019
    Date of Patent: July 6, 2021
    Assignee: GOOGLE LLC
    Inventors: Fergus Gerard Hurley, Robin Dua
  • Patent number: 11003693
    Abstract: An allocation of tables across a distributed database provides for taking into account existing table groups while also obtaining newly calculated table groups that are formed according to a new table group allocation. Such a new table group allocation may be desired to optimize workload balancing and/or data transfers for new workload patterns. Maintaining one or more types of existing table groups allows for the existing table groups to not be overwritten during allocation of the tables. An identification of tables is used, as well as a selected user-defined grouping option to indicate a mode for maintaining or replacing the existing table groups. An iterative process includes assigning, for each table, a group name and a group type.
    Type: Grant
    Filed: April 5, 2018
    Date of Patent: May 11, 2021
    Assignee: SAP SE
    Inventor: Antje Heinle
  • Patent number: 10992481
    Abstract: A computer-implemented method includes receiving, by an electronic device, a two-dimensional code generation request from a user operating the electronic device, the electronic device comprising secure element; obtaining, by the electronic device, two-dimensional code generation data, wherein the two-dimensional code generation data comprises account data of the user and timestamp data of the electronic device; obtaining, by the electronic device, signature data based on a predetermined signature algorithm stored in the secure element; and generating, by the electronic device, a target two-dimensional code based on the two-dimensional code generation data and the signature data.
    Type: Grant
    Filed: October 30, 2020
    Date of Patent: April 27, 2021
    Assignee: Advanced New Technologies Co., Ltd.
    Inventors: Qi Huang, Shengbo Zhao, Hui Liao, Zhiwei Wang, Yawen Wei
  • Patent number: 10977266
    Abstract: Disclosed herein are system, method, and computer program product embodiments for performing ad-hoc analytical queries of graph data. An embodiment operates by receiving a graph pattern for a subgraph of interest. The facts of interest are then selected from graph data based on the received graph pattern. Dimensions are then defined based on a dimension seed pattern and a set of level expressions, and measures are defined based on a computation function and an aggregation function. A graph cube is formed based on the selected facts and the defined dimensions and measures. Because the facts, dimensions, and measures of interest are defined at the time of an analytical query, a user does not have to define such facts, dimensions, and measures, or know which analytical queries will be of interest, at the time of data collection.
    Type: Grant
    Filed: May 15, 2015
    Date of Patent: April 13, 2021
    Assignee: SAP SE
    Inventors: Michael Rudolf, Hannes Voigt, Christof Bornhövd, Wolfgang Lehner
  • Patent number: 10965665
    Abstract: Systems and methods for network security are provided. Various embodiments of the present technology provide systems and methods for an identity security gateway agent that provides for privileged access. Embodiments include a system and method that uses a single sign-on (SSO) (or similar) mechanism to facilitate a user accessing web-based service providers, but separates the assertion and entire SSO process from the user credential.
    Type: Grant
    Filed: September 16, 2020
    Date of Patent: March 30, 2021
    Assignee: SAILPOINT TECHNOLOGIES, INC
    Inventors: Ryan Privette, Kris Keller
  • Patent number: 10956255
    Abstract: An automated agent may communicate with a user via a chat channel to proactively alert the user of an L1 IT support issue. The L1 IT support issue may be determined based on monitoring indications of human-initiated activities maintained by a system of record, and may, prior to the automated agent's alert, be unknown to the user. In some instances, a natural language understanding (NLU) module may be used to identify an entity and intent from the indications of human-initiated activities, and the L1 IT support issue may be determined based on the determined entity and intent. After alerting the user of the L1 IT support issue, the automated agent may inform, via the chat channel, the user of a remediation step available to address the L1 IT support issue. Upon obtaining the user's permission, the automated agent may perform the remediation step to address the L1 IT support issue.
    Type: Grant
    Filed: April 24, 2020
    Date of Patent: March 23, 2021
    Assignee: MOVEWORKS, INC.
    Inventors: Ahmed Al-Bahar, Sadish Ravi, Sunil Nagaraj, Dongxu Zhou, Vaibhav Nivargi, Varun Singh, Jiang Chen, Bhavin Nicholas Shah
  • Patent number: 10949410
    Abstract: Various embodiments of systems and methods to provide multi-threaded data analytics. In one aspect, a master view table is generated by retrieving data records corresponding to a plurality of entities from one or more data source tables. A plurality of aspects are determined from the generated master view table. Further, a plurality of aspect relational view tables are generated by comparing the plurality of aspects with one another based on relationship factors. At least one insight of the data records are determined by analyzing the plurality of aspect relational view tables and the master view table in multi-thread.
    Type: Grant
    Filed: December 2, 2015
    Date of Patent: March 16, 2021
    Assignee: SAP SE
    Inventor: John Alex William
  • Patent number: 10915564
    Abstract: The techniques discussed herein leverage structure within data of a corpus to parse unstructured data to obtain structured data and/or to predict latent data that is related to the unstructured and/or structured data. In some examples, parsing and/or predicting can be conducted at varying levels of granularity. In some examples, parsing and/or predicting can be iteratively conducted to improve accuracy and/or to expose more hidden data.
    Type: Grant
    Filed: April 29, 2019
    Date of Patent: February 9, 2021
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Kris K. Ganjam, Kaushik Chakrabarti
  • Patent number: 10915523
    Abstract: A Codex human knowledge encyclopedia including a webpage database residing in the Codex and stored in non-volatile digital memory, a master index and a partial master index for each element of the Codex, an optimizer receiving from a computing device interactive input, and executing software instructions to transform input based on rules of grammar and semantics into a search pattern and personalizing the search pattern by adding Global Positioning System (GPS) coordinates from the computing device. Mapping the search pattern to an element stored in the Codex and upon identifying the search pattern, obtaining the optimal dataset from the Codex bypassing all calculations since optimal dataset is readily available, picking and arranging, in an order from highest to lowest, from the optimal dataset, the top responses as output based on personalized usage pattern of behavior, and displaying the output to the user.
    Type: Grant
    Filed: December 26, 2016
    Date of Patent: February 9, 2021
    Inventor: Richard Paiz
  • Patent number: 10909116
    Abstract: A method, system and computer program product for processing queries in a hybrid database system. A database management system of the hybrid database system obtains an estimated execution time of a query by an online transaction processing engine. The database management system further obtains an estimated execution time of the query by a database accelerator. Furthermore, the database management system determines a wait time (which could be zero) for the database accelerator to process the query. The database management system then determines whether the online transaction processing engine or the database accelerator will process the query using the estimated execution time of the query by the online transaction processing engine, the estimated execution time of the query by the database accelerator and the wait time (which could be zero) for the database accelerator to process the query. In this manner, the processing of queries in hybrid database systems is optimized.
    Type: Grant
    Filed: February 20, 2018
    Date of Patent: February 2, 2021
    Assignee: International Business Machines Corporation
    Inventors: Al Chakra, Ruiping Li, Terence P. Purcell, Lily Zhou
  • Patent number: 10846273
    Abstract: In accordance with an embodiment, described herein is a system and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment. A cube schema inference component can successively perform column-wise splits to calculate information gain ratios between each pair of a plurality of columns in the tabular data. A cross correlation matrix can be constructed from the information gain ratios between each pair of columns. The system can determine relationships among the plurality of columns based on the cross correlation matrix; create a hierarchy directed graph to represent the relationships; and further transform the hierarchy directed graph into a cube schema that can be used to create a cube for loading the tabular data, or to map the tabular data into an existing cube in the multidimensional database environment.
    Type: Grant
    Filed: October 24, 2016
    Date of Patent: November 24, 2020
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Dima Alberg, Victor Belyaev, Guy Shaked, Gabby Rubin
  • Patent number: 10824814
    Abstract: A method for generating a suggested phrase having a similar meaning to a supplied phrase in an analytics system includes: receiving, on a computer system comprising a processor and memory storing instructions, the supplied phrase, the supplied phrase including one or more terms; identifying, on the computer system, a term of the phrase belonging to a semantic group; generating the suggested phrase using the supplied phrase and the semantic group; and returning the suggested phrase.
    Type: Grant
    Filed: November 13, 2017
    Date of Patent: November 3, 2020
    Inventors: Avraham Faizakof, Amir Lev-Tov, David Ollinger, Yochai Konig
  • Patent number: 10812322
    Abstract: Described in detail herein is an event streaming system. A controller disposed at a facility, can receive an event from computing systems disposed at the facility. The event is received by the controller at a time the event occurs. The controller can stream the event including the set of data. A central system can receive the at least one event streamed by the controller. The central system can include a repository cluster, a relational database, and a NoSQL database. The central system can concurrently route the set of data included in the event to the repository cluster, the relational database and the NoSQL database of the event response system to store the set of data in the repository cluster, the relational database and the NoSQL database.
    Type: Grant
    Filed: April 11, 2018
    Date of Patent: October 20, 2020
    Assignee: Walmart Apollo, LLC
    Inventors: Bryan Scott Lipkin, Biju Nair
  • Patent number: 10810178
    Abstract: Provided are methods comprising receiving a query for information from the database, determining particular data element types and data element values that are the subject of the query, instantiating a query data structure containing the data element types and the data element values that are the subject of the query, identifying records within the database that contain one or more data element types and/or data element values that are included in the query data structure, and instantiating a results data structure comprising information relating to the identified records.
    Type: Grant
    Filed: September 24, 2013
    Date of Patent: October 20, 2020
    Assignee: QIikTech International AB
    Inventors: Chris Branch, Alistair Eaves
  • Patent number: 10803079
    Abstract: A method of querying data including: providing a transaction management table; providing a system-period temporal table; assigning a unique identifier to a transaction; performing a first operation at a first timestamp; writing a first row identifier in the system-period temporal table; writing in the row corresponding to the first row identifier the unique identifier of the first operation in the row begin entry of the system-period temporal table; writing in the row corresponding to the first row identifier a dummy transaction identifier corresponding to a maximum timestamp value of the database system in the row end entry of the system-period temporal table; committing the transaction at a commit timestamp such that the commit timestamp is later than the first timestamp; inserting a row in the transaction management table and inserting values for the unique transaction identifier, the first timestamp and the commit timestamp in the transaction management table.
    Type: Grant
    Filed: July 25, 2017
    Date of Patent: October 13, 2020
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventor: Yasuhiro Onoda
  • Patent number: 10795705
    Abstract: A data parallel pipeline may specify multiple parallel data objects that contain multiple elements and multiple parallel operations that operate on the parallel data objects. Based on the data parallel pipeline, a dataflow graph of deferred parallel data objects and deferred parallel operations corresponding to the data parallel pipeline may be generated and one or more graph transformations may be applied to the dataflow graph to generate a revised dataflow graph that includes one or more of the deferred parallel data objects and deferred, combined parallel data operations. The deferred, combined parallel operations may be executed to produce materialized parallel data objects corresponding to the deferred parallel data objects.
    Type: Grant
    Filed: June 24, 2019
    Date of Patent: October 6, 2020
    Assignee: Google LLC
    Inventors: Craig D. Chambers, Ashish Raniwala, Frances J. Perry, Stephen R. Adams, Robert R. Henry, Robert Bradshaw, Nathan Weizenbaum
  • Patent number: 10748071
    Abstract: A computer-implemented method, computerized apparatus and computer program product, the method comprising: receiving a latency constraint on a Complex Event Processing (CEP) computation; monitoring progress of the CEP computation to determine a risk of violating the latency constraint; and, responsive to determining that a risk of violating the latency constraint exists, outputting at least one possible result of the CEP computation.
    Type: Grant
    Filed: January 4, 2016
    Date of Patent: August 18, 2020
    Assignee: International Business Machines Corporation
    Inventors: Fabiana Fournier, Alexander Kofman, Mordechai Nisenson, Inna Skarbovsky
  • Patent number: 10725994
    Abstract: Merging adjacent rows of a synopsis table so as to increase the effectiveness of the synopsis table regarding data skipping. Adjacent rows for merging are identified based on statistics regarding: (i) queries of the database; (ii) effectiveness of the synopsis table for data skipping; and (iii) usage of predicates in queries of the database. Once merged, the synopsis table is smaller, and more effective with respect to data skipping, while fewer computing resources (administrative, maintenance, memory, clock cycles, storage space, etc.) are needed to process the database queries.
    Type: Grant
    Filed: April 8, 2016
    Date of Patent: July 28, 2020
    Assignee: International Business Machines Corporation
    Inventors: Ian R. Finlay, Christian M. Garcia-Arellano, Adam J. Storm, Calisto P. Zuzarte
  • Patent number: 10725995
    Abstract: Merging adjacent rows of a synopsis table so as to increase the effectiveness of the synopsis table regarding data skipping. Adjacent rows for merging are identified based on statistics regarding: (i) queries of the database; (ii) effectiveness of the synopsis table for data skipping; and (iii) usage of predicates in queries of the database. Once merged, the synopsis table is smaller, and more effective with respect to data skipping, while fewer computing resources (administrative, maintenance, memory, clock cycles, storage space, etc.) are needed to process the database queries.
    Type: Grant
    Filed: March 30, 2017
    Date of Patent: July 28, 2020
    Assignee: International Business Machines Corporation
    Inventors: Ian R. Finlay, Christian M. Garcia-Arellano, Adam J. Storm, Calisto P. Zuzarte
  • Patent number: 10719618
    Abstract: A system includes a processor and a computer-readable medium configured to store instructions for execution by the processor. The instructions include receiving a first document corresponding to a first application hosted by a distributed computing provider. The instructions include parsing the first document into a first data structure according to a data structure definition. The data structure definition describes an inheritance property. The instructions include, in response to presence of a first inheritance property in the first data structure: identifying an inherited document based on the first inheritance property; obtaining the inherited document; reading the inherited document; determining inheritance permissions from the inherited document; and, in response to the inheritance permissions permitting the first document to inherit the inherited document, selectively modifying the first data structure based on the inherited document.
    Type: Grant
    Filed: March 8, 2018
    Date of Patent: July 21, 2020
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Raja Charu Vikram Kakumani, John Erik Araya, Muhammad Omer Iqbal
  • Patent number: 10719508
    Abstract: A method for providing low-latency responses to queries to a data search system comprises storing first digital data in a first digital data repository using a first column-oriented storage format; storing second digital data in a second digital data repository using a second column-oriented storage format, wherein the second column-oriented storage format is different from the first column-oriented storage format; generating a plurality of pre-computed views based on both the exposure data and the risk item data; storing the plurality of pre-computed views in the second data repository using the second column-oriented storage format; and in response to receiving a search query, determining a result set that is responsive to the query based on one or more particular pre-computed views of the plurality of pre-computed views and providing the result set to another computer or display device as output.
    Type: Grant
    Filed: April 19, 2018
    Date of Patent: July 21, 2020
    Assignee: RISK MANAGEMENT SOLUTIONS, INC.
    Inventor: Christopher George
  • Patent number: 10715394
    Abstract: At each delegate device and each non-delegate device of a logical device hierarchy, a data cube is generated. The logical device hierarchy includes more than one level, and each level includes one or more groups, and each group includes one delegate device and one or more non-delegate devices. At each delegate device, data cubes are received from the one or more non-delegate devices associated with the same group. At each delegate device, data cubes are received from delegate devices of a different group, and that delegate device is the parent of the delegate devices associated with a different group. At each delegate device, the received data cubes are aggregated into a weighted data cube. From each delegate device, the weighted data cube are outputted to the parent of the delegate device.
    Type: Grant
    Filed: October 29, 2018
    Date of Patent: July 14, 2020
    Assignee: SAP Portals Israel Ltd.
    Inventors: Michal Keidar, Eyal Barlev, Ido Goren
  • Patent number: 10713230
    Abstract: Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a custom data column within the object data structure, and this single custom data column may contain different data types for each tenant.
    Type: Grant
    Filed: July 11, 2018
    Date of Patent: July 14, 2020
    Assignee: salesforce.com, inc.
    Inventors: Craig Weissman, Simon Wong
  • Patent number: 10706233
    Abstract: Provided is a computer implemented method including receiving a digital communication; analyzing said communication using natural language processing to identify any semantic reference to one or more digital artifacts; and identifying and locating the one or more digital artifacts. In some embodiments one or more digital artifacts are not specifically identified in the digital communication. In some embodiments one or more digital artifacts are not specifically included in the digital communication. Related apparatus, systems, techniques, and articles are also described.
    Type: Grant
    Filed: March 7, 2016
    Date of Patent: July 7, 2020
    Assignee: M-Files Oy
    Inventors: Trevor Cookson, Jayson deVries, Mostafa Karamibekr, Glenn Owen, Ramanpreet Singh, Christopher Towler
  • Patent number: 10671604
    Abstract: Methods for splitting a plurality of records into subsets for parallel processing by separate threads are disclosed. In one embodiment, a plurality of records are added to a database. The adding includes tracking, for each unique value found in the plurality of records within a selected one of the sequence of fields, a statistic based on the values found in the plurality of records within a next one of the sequence of fields. Then a plurality of queries are generated, each includes a row value constructor (RVC) with a logical operation, a specific one of the unique values found within the selected one of the sequence of fields, and, for that specific value, the tracked statistic. Then a plurality of threads are caused to execute that each submit one of the queries and operate on a subset of the plurality of records responsive to execution of that query.
    Type: Grant
    Filed: January 30, 2018
    Date of Patent: June 2, 2020
    Assignee: salesforce.com, inc.
    Inventors: Danil Dvinov, Parth Vijay Vaishnav, Chenghung Ker
  • Patent number: 10649965
    Abstract: Data structures stored on a source database are migrated to a destination database in which the data are structured in a different format than that of the source database. Dictionaries are stored that are based on representations of the data structures stored on the source database that are formatted in other than the structural format used on the source database for the data structures. One of the data structures and a corresponding one of the dictionaries are transferred from the source database to a destination database. The transferred data structure is loaded onto the destination database in accordance with the transferred dictionary.
    Type: Grant
    Filed: November 14, 2016
    Date of Patent: May 12, 2020
    Assignee: International Business Machines Corporation
    Inventors: Pedro M. Barbas, Konrad Emanowicz, Gareth Jenkins, Enda McCallig, Lei Pan
  • Patent number: 10642990
    Abstract: A system and method for facilitating timely end user creation, customization, and/or configuration of analytic reports in a computing environment, such as an enterprise-computing environment. An example method includes receiving configuration information characterizing one or more User Interface (UI) features to be incorporated into an analytic report; employing the configuration information to generate one or more database queries to selectively retrieve data from the database; using the configuration information and the one or more database queries to construct an analytic template; and publishing the analytic template so that the analytic template is accessible to one or more end users of the computing environment. In a more specific embodiment, the computing environment includes an enterprise-computing environment, and the one or more users include enterprise personnel.
    Type: Grant
    Filed: July 22, 2016
    Date of Patent: May 5, 2020
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Balaji Pattabhiraman, Rahul Mahashabde, Virad Gupta, Deepankar Narayanan, Raghu Edalur, Sai Jai Ganesh Gurubaran
  • Patent number: 10609562
    Abstract: To provide overall security to a utility management system, critical command and control messages that are issued to components of the system are explicitly approved by a secure authority. The explicit approval authenticates the requested action and authorizes the performance of the specific action indicated in a message. Key components of the utility management and control system that are associated with access control are placed in a physical bunker. With this approach, it only becomes necessary to bunker those subsystems that are responsible for approving network actions. Other management modules can remain outside the bunker, thereby avoiding the need to partition them into bunkered and non-bunkered components. Access to critical components of each of the non-bunkered subsystems is controlled through the bunkered approval system.
    Type: Grant
    Filed: April 10, 2018
    Date of Patent: March 31, 2020
    Assignee: ITRON NETWORKED SOLUTIONS, INC.
    Inventors: Raj Vaswani, Wilson Chuen Yew Yeung, Cristina Seibert, Nelson Bruce Bolyard, Benjamin N. Damm, Michael C. Stjohns
  • Patent number: 10585691
    Abstract: In a distribution system including a plurality of physical machines, when an output file output by first processing performs multistage processing input to second processing, a physical machine which is a deployment destination of a first virtual machine for performing the first processing, a physical machine which is a storage destination of each data block included in the output file, and a physical machine which is a deployment destination of a second virtual machine for performing the second processing are determined based on relationship between the first and second processing.
    Type: Grant
    Filed: October 30, 2014
    Date of Patent: March 10, 2020
    Assignee: Hitachi, Ltd.
    Inventors: Yohsuke Ishii, Takuya Oda, Hiromu Hota, Nobuaki Kohinata
  • Patent number: 10585892
    Abstract: A system and method facilitating transforming or updating displayed data using data hierarchy information. An example method includes storing hierarchy information characterizing a dataset via one or more tree tables; selectively accessing a database to update data characterized by metadata of the one or more tree tables; employing one or more pivot grids to replicate one or more hierarchical properties of the one or more tree tables; and displaying information based on the one or more pivot grids. The displaying step may further include using the pivot grid(s) to generate and display analytic(s), wherein data for the pivot grid(s) and analytics(s) is obtained from flattened tree tables. Dynamically executed Structured Query Language (SQL) construct(s) may retrieve un-cached fresh multi-dimensional data used for the pivot grid(s) or analytic(s) in a manner consistent with hierarchy information retrieved (via SQL) from the tree tables as tree metadata.
    Type: Grant
    Filed: May 12, 2015
    Date of Patent: March 10, 2020
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Kalpana Madhalam, Rahul Mahashabde, Balaji Pattabhiraman, Deepankar Narayanan, Virad Gupta
  • Patent number: 10585916
    Abstract: Systems and methods for improving efficiency are described herein. The systems and methods described herein can also comprise systems and methods for reducing waste. Systems and methods described herein can comprise a date warehouse, data marts, and visualizations.
    Type: Grant
    Filed: October 7, 2016
    Date of Patent: March 10, 2020
    Assignee: Health Catalyst, Inc.
    Inventors: David A Burton, Thomas D Burton, Steven C Barlow
  • Patent number: 10581698
    Abstract: A method and system for enabling transfer of widgets across containers at runtime. According to embodiments of the present invention, a user is allowed to transfer a widget across containers at runtime, for example, moving a widget that has been deployed and operated in one widget container to another, even though the destination widget container originally does not support the widget. Specifically, the widget being transferred can keep consistency in terms of data and state before and after the transfer. Furthermore, the user can implement the cross-container transfer of widgets at runtime by, for example, convenient interaction means like a drag-and-drop operation. In this way, the user can operate and interact with Web applications in a more convenient and flexible way.
    Type: Grant
    Filed: July 12, 2018
    Date of Patent: March 3, 2020
    Assignee: International Business Machines Corporation
    Inventors: Jie Cui, Richard D. Thompson, Yuan Wang, Jing Min Xu
  • Patent number: 10528540
    Abstract: The present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for dynamic aggregate generation and updating for high performance querying of large datasets. Certain embodiments are directed to technological solutions for determining at least one aggregate of selected virtual cube attributes (e.g., measures, dimensions, etc.) describing a virtual multidimensional data model of a subject database, and generating an aggregate table and a set of aggregate metadata for the aggregate. In some embodiments, an aggregate database statement configured to operate on the subject database can be issued to generate the aggregate table and/or aggregate metadata. Further, the aggregate can be dynamically determined responsive to receiving a database statement configured to operate on the virtual multidimensional data model representing the subject database.
    Type: Grant
    Filed: November 19, 2015
    Date of Patent: January 7, 2020
    Assignee: AtScale, Inc.
    Inventors: Sarah Gerweck, David Ross
  • Patent number: 10523728
    Abstract: Example embodiments of the present invention relate to a method, a system, and a computer program product for data analytics. The method includes receiving a plurality of first data streams from respective managed elements in a network and partitioning data of the plurality of first data streams according to an attribute regarding the data into a partitioned second data stream. The partitioned second data stream then may be streamed toward a data analytics platform for consumption by the data analytics platform. In a preferred embodiment, WebSockets are used.
    Type: Grant
    Filed: June 28, 2013
    Date of Patent: December 31, 2019
    Assignee: EMC IP Holding Company LLC
    Inventors: Stephen G. Graham, Matthew L. Troutman, Robert A. Lincourt, Jr., Dominique Prunier
  • Patent number: 10515315
    Abstract: This disclosure relates to predicting and managing supply chain network risks. In one embodiment, a processor-implemented method obtains identifiers for supply chain contributors and parameters; and a query. The method performs a natural language processing algorithm on the query to extract text components, which it analyzes to identify supply chain component clusters and risk identifiers. It also includes executing a machine learning technique for learning of the risk identifiers and generating co-occurrence rules between the risk identifiers, as well as associated rule support and rule confidence parameters. It further includes sorting the co-occurrence rules to generate a prioritized rules list, and generating a risk prediction model for the supply chain using the prioritized rules list, using a classifier algorithm.
    Type: Grant
    Filed: March 31, 2016
    Date of Patent: December 24, 2019
    Assignee: Wipro Limited
    Inventor: Selvakuberan Karuppasamy
  • Patent number: 10509795
    Abstract: Systems, computer-implemented methods, and non-transitory computer readable media are provided for determining related ontological data. The disclosed systems may be configured to receive a first ontology and a second ontology, the first ontology and the second ontology comprising hierarchically organized ontological data. The disclosed systems may also be configured to receive an indication that a first ontological datum in the first ontology is equivalent to a second ontological datum in the second ontology, and a query for ontological data related to a third ontological datum subordinate to the first ontological datum. The disclosed systems may be configured to determine a first semantic distance between the third ontological datum and a fourth ontological datum in the second ontology satisfies a semantic distance criterion, and output the fourth ontological datum based on the determination that the first semantic distance satisfies the semantic distance criterion.
    Type: Grant
    Filed: August 22, 2017
    Date of Patent: December 17, 2019
    Assignee: ILLUMINA, INC.
    Inventors: Kai-How Farh, Jorg Hakenberg, Milan Karangutkar, Wenwu Cui, Hong Gao
  • Patent number: 10503621
    Abstract: To ensure that there is an elected manager among storage nodes of an erasure coding group (“ECG”), an ECG manager (“ECGM”) election process is periodically performed among available storage nodes that are configured with the software to perform the services of an ECGM. When a storage node is activated, an ECGM process of the storage node begins executing and is assigned a process identifier (“PID”). A storage node can utilize a service query framework to identify other available storage nodes and retrieve their ECGM PIDs. The storage node then selects a PID according to a criterion and elects the storage node corresponding to the selected PID to be the acting ECGM. This process is performed periodically, so even if the acting ECGM storage node fails, a new ECGM is eventually selected from the available storage nodes.
    Type: Grant
    Filed: May 8, 2017
    Date of Patent: December 10, 2019
    Assignee: NETAPP, INC.
    Inventors: Dheeraj Raghavender Sangamkar, Song Guen Yoon, Emalayan Vairavanathan, Yi Zhang
  • Patent number: 10475039
    Abstract: Methods and apparatus, including computer program products, are provided for in-memory simulations. The method may include forming a virtual cube including at least one change value representative of a change to a simulation; forming another cube including online data; and combining the virtual cube and the other cube to form a union cube representative of a result of the simulation, the virtual cube, other cube, and the union cube comprised in an in-memory storage and shared for at least a session associated with the simulation. Related systems, methods, and articles of manufacture are also disclosed.
    Type: Grant
    Filed: December 10, 2012
    Date of Patent: November 12, 2019
    Assignee: SAP SE
    Inventor: Shan Jiang
  • Patent number: 10452529
    Abstract: Systems, apparatuses, and methods for cloud memory sizing are disclosed. An initial database memory allocation is determined for the provisioning of a database server instance. Periodically, sizes of key database tables of the database server instance are measured and an upper and a lower bound ratio are determined based on the key database table sizes and a buffer pool size. The upper and lower bound ratios are used to determine a desired memory allocation from which a report is generated including an interface for generating an instance move action for re-provisioning the database server instance with the desired memory allocation.
    Type: Grant
    Filed: June 11, 2015
    Date of Patent: October 22, 2019
    Assignee: ServiceNow, Inc.
    Inventors: Joseph Michael Davis, Scott Michael Nemes, Atul Saini, Siddharth Shah
  • Patent number: 10454997
    Abstract: The present disclosure is directed at methods, systems, and techniques for sharing data in a physical security system that includes multiple server nodes. One of the server nodes (a “first node”) accesses a node identifier identifying another of the server nodes (a “second node”), following which the first node sends the data to the second node. Both the first and second nodes are part of a server cluster that includes multiple server nodes, and each of the server nodes in the server cluster has access to cluster membership information. The cluster membership information identifies all of the server nodes in the server cluster, and the node identifier is part of the cluster membership information.
    Type: Grant
    Filed: September 7, 2012
    Date of Patent: October 22, 2019
    Assignee: Avigilon Corporation
    Inventors: Andrew Martz, Ross Wightman, Greg Magolan, Shaun Marlatt
  • Patent number: 10431260
    Abstract: An information processing apparatus includes circuitry configured to acquire time data relating to a state of an object in each process of an operation performed on the object, the operation including at least one process; calculate an achievement value indicating a state of each process, based on the time data acquired; compare the achievement value calculated with a reference value; and generate a chart that visually represents a result of comparison for each process. The visual representation of the result of comparison is different according to the result of comparison.
    Type: Grant
    Filed: April 9, 2018
    Date of Patent: October 1, 2019
    Assignee: Ricoh Company, Ltd.
    Inventors: Hajime Yamana, Keiji Ohmura
  • Patent number: 10410385
    Abstract: Methods, systems and computer program products for generating hypergraph representations of dialog are provided herein. A computer-implemented method includes analyzing at least one dialog to identify one or more topics and one or more contributions by one or more persons to the one or more topics, tracking evolution of the identified topics over time in the at least one dialog, generating a hypergraph representation of the at least one dialog utilizing the identified topics, the identified contributions and the tracked evolution of the identified topics, and providing an interactive visualization tool based on the hypergraph representation of the at least one dialog.
    Type: Grant
    Filed: February 19, 2016
    Date of Patent: September 10, 2019
    Assignee: International Business Machines Corporation
    Inventors: Prithu Banerjee, Manikandan Padmanaban, Biplav Srivastava, Srikanth G. Tamilselvam
  • Patent number: 10394818
    Abstract: A system and method is described for database split generation in a massively parallel or other distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table.
    Type: Grant
    Filed: September 24, 2015
    Date of Patent: August 27, 2019
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventor: Ashok Shivarudraiah