Patents Examined by Wilson Lee
  • Patent number: 11625371
    Abstract: Systems and methods are described herein for performing automated audit balance control (ABC) procedures for data that has moved between data stores within an enterprise or other organization. The systems and methods inspect the data at a target data store and determine the quality of the movement of the data to the target data store based on the inspection. For example, the systems and methods can inspect row or record counts for the data in a data store, aggregate numeric sums within the data at the target data store, perform key data value comparisons between different locations that contained the data, perform full data comparisons between different locations that contained the data, perform checksum comparisons, apply complex business rules, and so on, when determining or verifying the completeness and accuracy of data as it arrives to a temporary or permanent location.
    Type: Grant
    Filed: September 21, 2021
    Date of Patent: April 11, 2023
    Assignee: T-Mobile USA, Inc.
    Inventors: Jeffrey Scott, Venkata Reddy Donthireddy
  • Patent number: 11620339
    Abstract: The present disclosure relates to methods, systems, and apparatuses for identifying related records in a database. The method includes receiving, via a network interface, a related records query, the related records query identifying at least one record stored in the electronic database, determining, based on transaction data, at least one related record that is related to the identified at least one record, determining, by a processor, that the at least one related record is unavailable, in response to determining that the at least one related record is unavailable, determining at least one keyword associated with the at least one related record, selecting at least one of one or more substitute records based at least in part on comparing the at least one keyword with a set of keywords associated with one or more substitute records, and providing the selected one or more substitute records as a response to the related records query.
    Type: Grant
    Filed: June 17, 2021
    Date of Patent: April 4, 2023
    Assignee: GROUPON, INC.
    Inventors: Suryanarayanan Parameswaran, Vivek Singh Solanki, Shubham Mittal
  • Patent number: 11620275
    Abstract: Embodiments of the invention are directed to synchronous multi-point update of associated text. Aspects include receiving, from a user, a request to associate a first text with one or more other instances of the first text and looking up the first text in a text association table. Based on determining that no entry in the text association table corresponds to the first text, aspects include creating an entry in the text association table corresponding to the first text. Aspects also include adding an address of the first text to the entry in the text association table. Based on detecting a change to one of the first text and one of the one or more other instances of the first text, aspects further include updating the first text and each of the one or more other instances of the first text that was not changed.
    Type: Grant
    Filed: August 26, 2021
    Date of Patent: April 4, 2023
    Assignee: International Business Machines Corporation
    Inventors: Dong Chen, Peng Hui Jiang, Jing Bai, Ting Ting Zhan, Xiaoli Duan, Jun Su
  • Patent number: 11615100
    Abstract: Provided is a mechanism capable of easily grasping or analyzing the relation between three or more variables. An information processing apparatus (100) includes a control unit (130) that accepts the designation of a variable of interest among multiple variables including three or more variables with respect to data including values of the multiple variables, and outputs first information indicating the strength of the relation between the variable of interest and the combinations of explanatory variables including two or more explanatory variables among the multiple variables.
    Type: Grant
    Filed: June 18, 2019
    Date of Patent: March 28, 2023
    Assignee: Sony Corporation
    Inventor: Takashi Isozaki
  • Patent number: 11615203
    Abstract: A record management system stores records for an organization having a plurality of members and a plurality of groups, and manages accessibility of the records for the organization according to a specified record access policy. The record management system generates an accessibility database that indicates, for each member, records that are explicitly or implicitly accessible by each member such that the records accessible for each member can be quickly determined if needed. A member has explicit access to a record if there is an explicit indication of accessibility between the member and the record. A member has implicit access to a record through membership associations to other members or groups that have access to the record. The record management system also receives search queries from members and returns records that are relevant and accessible to the members based on the accessibility database.
    Type: Grant
    Filed: April 28, 2021
    Date of Patent: March 28, 2023
    Assignee: Salesforce, Inc.
    Inventors: Scott Rickard, Anuprit Kale, Victor Spivak, Yanik Grignon, Venkatesan Chandrasekaran
  • Patent number: 11599553
    Abstract: Systems and methods for automatically profiling data a user selects to transfer to a paste area are described. Data may be automatically profiled the at the user selected target paste area to determine if sets of data are of the same data type. There may be a clarification for a target paste area or for identifying the data type. Additionally, there may be reformatting the selected data set to match the target data's format. Machine learning may trigger formatting or prompting actions according to one or more predetermined thresholds.
    Type: Grant
    Filed: October 20, 2021
    Date of Patent: March 7, 2023
    Assignee: Capital One Services, LLC
    Inventors: Jeremy Goodsitt, Austin Walters, Anh Truong, Vincent Pham, Galen Rafferty
  • Patent number: 11599543
    Abstract: Technologies are described for routing structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment. The elastic compute nodes do not store persistent database tables. For example, a SQL statement can be received for execution within the distributed database environment. A workload class can be identified that matches properties of the SQL statement. Based on the workload class, a routing location hint can be obtained that identifies a set of elastic compute nodes. The SQL statement can then be routed to one of the identified elastic compute nodes for execution. Execution of the SQL statement at the elastic compute node can involve retrieving database data from other nodes which store persistent database tables.
    Type: Grant
    Filed: May 26, 2022
    Date of Patent: March 7, 2023
    Assignee: SAP SE
    Inventors: Jaeyoung Choi, Deok Hoe Kim, Kyu Hwan Kim, Chae Kwang Lee, Jane Jung Lee, Juchang Lee
  • Patent number: 11599550
    Abstract: A method of operating a data exchange includes creating a first listing referencing data of a first database of a plurality of databases, wherein the first listing comprises access controls and a data share associated with a first user, the access controls defining portions of the first database that are accessible by a second user, receiving a request from the second user for a bidirectional share between the portions of the first database that are accessible by the second user and portions of a second database controlled by the second user, and receiving an instruction from the first user to perform a database operation referencing data of the bidirectional share between the portions of the first database that are accessible by the second user and the portions of the second database controlled by the second user.
    Type: Grant
    Filed: June 13, 2022
    Date of Patent: March 7, 2023
    Assignee: Snowflake Inc.
    Inventors: Pui Kei Johnston Chu, Benoit Dageville, Matthew J. Glickman, Christian Kleinerman, Prasanna Krishnan, Justin Langseth
  • Patent number: 11599664
    Abstract: Methods, systems, and apparatuses for providing access to records of a database stored on a database server in a cloud database platform are described herein. A data sharing platform may determine a shared view definition for access to the database. The data sharing platform may determine rules that specify criteria that limit access to the records stored by the database. The one or more first rules may be received via a user interface. The data sharing platform may perform, based on the rules, a data access certification process on the records stored by the database to generate a table of certification results. The data sharing platform may generate, based on the table of certification results, and without modifying the records stored by the database, a limited consumer view definition. Based on updates to the records, a new limited consumer view definition may be generated.
    Type: Grant
    Filed: June 14, 2022
    Date of Patent: March 7, 2023
    Assignee: Capital One Services, LLC
    Inventors: Nagender Gurram, Yudhish Batra, Syed Shamaz Salim, Praveen Kandukuri
  • Patent number: 11593401
    Abstract: In some aspects, the disclosure is directed to methods and systems for data storage and retrieval from a computer memory. A computing device may store a first hierarchical data structure having a first sequence of sub-data structures and a second hierarchical data structure having a second sequence of sub-data structures in memory. The computing device may link the first hierarchical data structure and the second hierarchical data structure together. The computing device may link the first hierarchical data structure and the second hierarchical data structure by inserting an identifier of a sub-data structure of the second sequence in the first sequence.
    Type: Grant
    Filed: March 3, 2022
    Date of Patent: February 28, 2023
    Assignee: iDesignEDU, LLC
    Inventors: Paxton Riter, Ned Stone, Whitney Kilgore, Krista Galyen, Sam Foster, Andreas Buchmann, Derek Howard
  • Patent number: 11593314
    Abstract: An example method can include storing, on a CSM, a first content item and representations of second and third content items, the second content item having content/features enabled by a cloud service and designed for access through a native online application and the third content item having content/features supported by a local application and having additional features designed for access through a cloud service and native online application; when the first content item is invoked, presenting the content/features of the first content item; in response to a request to access the representation of the second or third content item, sending, to a cloud service, a request for the additional features of the third content item or the content/features of the second content item; and based on metadata received from a cloud service, providing the additional features/content of the third content item or the content/features of the second content item.
    Type: Grant
    Filed: June 2, 2021
    Date of Patent: February 28, 2023
    Assignee: Dropbox, Inc.
    Inventors: Joshua Kaplan, Jason Terk, Stan Yeung
  • Patent number: 11587769
    Abstract: A device includes a microwave generator configured to generate a microwave having a bandwidth, an output unit, a directional coupler and a measurer. The microwave generator generates a microwave a power of which is pulse-modulated to be a High level and a Low level. A set carrier pitch is set to satisfy a preset condition. The preset condition includes a condition that a value obtained by dividing a set pulse frequency by the set carrier pitch or a value obtained by dividing the set carrier pitch by the set pulse frequency is not an integer and a condition that an ON-time of the High level is equal to or larger than 50%. The microwave generator averages a first High measurement value and a first Low measurement value in a preset moving average time longer than a sum of the ON-time of the High level at a preset sampling interval.
    Type: Grant
    Filed: July 21, 2021
    Date of Patent: February 21, 2023
    Assignees: TOKYO ELECTRON LIMITED, TOKYO KEIKI INC.
    Inventors: Yohei Ishida, Kazushi Kaneko, Hajime Tamura, Koichi Murai
  • Patent number: 11573982
    Abstract: Techniques for providing an efficient real-time hierarchy based on change events are disclosed. In some embodiments, a computer-implemented method comprises: storing a hierarchy table comprising hierarchy data that represents a snapshot state of a hierarchy tree of entities at a first point in time and having been last updated at the first point in time; receiving one or more user requests to change entity data representing entities of the hierarchy tree; storing one or more change events in a queue based on the user request(s); receiving a query request for the hierarchy tree; in response to the receiving of the query request, generating a query result based on the hierarchy table stored in the database and the change event(s) stored in the queue; and performing a function of an enterprise application platform using the query result.
    Type: Grant
    Filed: December 14, 2020
    Date of Patent: February 7, 2023
    Assignee: SAP SE
    Inventor: Wei Chen
  • Patent number: 11573958
    Abstract: The present invention relates to an in-document search method and device for a query vector, and an object of the present invention is to improve the accuracy of a response by generating sentence data corresponding to data in a table form stored in database. The in-document search method for a query vector includes a step A of receiving a user query from a user terminal, a step B of generating a user query vector for the user query, a step C of extracting candidate table data based on the user query vector in a data storage module, a step D of searching for a response corresponding to the user query vector in the candidate table data, and a step E of providing the response to the user terminal.
    Type: Grant
    Filed: December 24, 2020
    Date of Patent: February 7, 2023
    Assignee: 42 Maru Inc.
    Inventors: Dong Hwan Kim, Jin Min Park, Ju Kwan Lee, Hyuk Sung Kwon, Hyeong Jin Jang
  • Patent number: 11567900
    Abstract: The interface is to receive an indication to execute an optimize command. The processor is to receive a file name; determine whether adding a file of the file name to a current bin causes the current bin to exceed a threshold; associate the file with the current bin in response to determining that adding the file does not cause the current bin to exceed the bin threshold; in response to determining that adding the file to the current bin causes the current bin to exceed the bin threshold: associate the file with a next bin, indicate that the current bin is closed, and add the current bin to a batch of bins; determine whether a measure of the batch of bins exceeds a batch threshold; and in response to determining that the measure exceeds the batch threshold, provide the batch of bins for processing.
    Type: Grant
    Filed: July 23, 2021
    Date of Patent: January 31, 2023
    Assignee: Databricks, Inc.
    Inventors: Rahul Shivu Mahadev, Burak Yavuz, Tathagata Das
  • Patent number: 11556545
    Abstract: A method for providing optimized support for transactional processing and analytical processing with minimal memory footprint may include storing, on a data page in a disk of a database system, a portion of one or more columns of data from a database table. A metadata associated with the data page may be stored on a metadata page in the disk of the database system. The metadata may include one or more byte ranges on the data page at which the portion of the one or more columns of data is stored. The database system may execute one or more queries by accessing, based at least on the metadata associated with the data page, a portion of the data page storing the portion of the one or more columns of data required by the one or more queries. Related systems and articles of manufacture are also provided.
    Type: Grant
    Filed: January 26, 2021
    Date of Patent: January 17, 2023
    Assignee: SAP SE
    Inventor: Ivan Schreter
  • Patent number: 11556542
    Abstract: A method for presenting output returned by a command-line interface is disclosed. In one embodiment, such a method submits, by way of a command-line interface (CLI), a command to retrieve a list of resources. The method further submits, in association with the command, an indicator to compress the list. In response to receiving the command and indicator, the method retrieves the list of resources and compresses the list such that resources with identical attributes are presented as a single tuple in the list. Such a tuple may, in certain embodiments, identify the resources with identical attributes as a range of resources and/or as a comma delimited list of resources. The tuple may also, in certain embodiments, identify how many resources with identical attributes are represented by the tuple. A corresponding system and computer program product are also disclosed.
    Type: Grant
    Filed: February 7, 2015
    Date of Patent: January 17, 2023
    Assignee: International Business Machines Corporation
    Inventors: Dale H. Anderson, Jason L. Peipelman
  • Patent number: 11550665
    Abstract: The described embodiments set forth techniques for preserving clone relationships between files at a computing device. In particular, the techniques involve identifying clone relationships between files in conjunction with performing operations on the files where it can be beneficial to preserve the clone relationships. The operations can include, for example, preserving clone relationships between files that are being copied from a source storage device (that supports file cloning) to a destination storage device that supports file cloning. Additionally, the operations can include preserving clone relationships when backing up and restoring files between a source storage device (that supports file cloning) and a destination storage device that does not support file cloning. In this manner, the various benefits afforded by the clone relationships between files can be retained even as the files are propagated to destination storage devices that may or may not support file cloning.
    Type: Grant
    Filed: September 29, 2017
    Date of Patent: January 10, 2023
    Assignee: Apple Inc.
    Inventors: Pavel Cisler, Christopher A. Wolf, Loic E. Vandereyken, Eric A. Weiss
  • Patent number: 11531681
    Abstract: A method for accessing listings in a data exchange includes creating a first listing in a data exchange, the first listing referencing a first database of a plurality of databases and specifying identity-based sharing of the first database, creating a second listing in the data exchange, the second listing referencing a second database of the plurality of databases and data of the first database shared according to the identity-based sharing of the first database, and receiving an instruction from a user of the data exchange, the instruction referencing the second listing and instructing the addition of the second listing to a set of consumed data shares accessible by the user.
    Type: Grant
    Filed: March 25, 2022
    Date of Patent: December 20, 2022
    Assignee: Snowflake Inc.
    Inventors: Pui Kei Johnston Chu, Benoit Dageville, Matthew J. Glickman, Christian Kleinerman, Prasanna Krishnan, Justin Langseth
  • Patent number: 11520767
    Abstract: A determination is made that the performance of a user database query to a database does not meet a first performance threshold. In response to the user database query not meeting the first performance threshold, one or more test queries of the database are performed. A second determination is made whether a performance of the one or more test queries meets a second performance threshold. In response to the one or more test queries meeting the second performance threshold, an analysis is performed to determine whether to resize a database buffer cache of the database.
    Type: Grant
    Filed: August 25, 2020
    Date of Patent: December 6, 2022
    Assignee: ServiceNow, Inc.
    Inventor: Ankit Khetarpal