Patents Examined by Dangelino N Gortayo
-
Patent number: 11520788Abstract: A method of improving compute performance of a distributed database system includes querying a control node of the distributed database system to ascertain a plurality of attributes characterizing an initial state of a table object in the distributed database system. Queries executed in the distributed database system are recorded. Based on these queries and at least some of the plurality of attributes, an candidate state of the table object with lower compute load than the initial state is generated. An executable transformation mapping the initial state of the table object to the candidate state is then assembled and applied to the table object.Type: GrantFiled: March 5, 2021Date of Patent: December 6, 2022Assignee: Insight Direct USA, Inc.Inventor: Edward Carl Tasker
-
Patent number: 11514039Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.Type: GrantFiled: December 23, 2020Date of Patent: November 29, 2022Assignee: SAP SEInventor: Toni Fabijancic
-
Patent number: 11514040Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.Type: GrantFiled: December 23, 2020Date of Patent: November 29, 2022Assignee: SAP SEInventor: Toni Fabijancic
-
Patent number: 11500839Abstract: Aspects are described to generate indexing on columns including links to other columns in a different table. One aspect describes a computer-implemented method comprising identifying, for a workbook comprising a plurality of cells and tables stored in a spreadsheet structure, a query comprising a formula, parsing the formula to identify, as one operand, a heterogeneous column of links in a first table of the plurality of tables to a column in a second table of the plurality of tables and at least one operator, automatically generating a virtual column for the heterogeneous column, the virtual column being inaccessible to a user, storing the generated virtual column, evaluating the function of the virtual column for each row of the first table, generating an inaccessible virtual index for the virtual column, storing the virtual index, and evaluating the formula based on the virtual index to generate a result.Type: GrantFiled: September 30, 2020Date of Patent: November 15, 2022Assignee: Amazon Technologies, Inc.Inventors: Venkata Rao Pedapati, Adrian Kwok, Anupam Srivastava, Wilfred Xavier Zhi Zhiang Wee, Helbert Fonseca Maich
-
Patent number: 11500886Abstract: An approach to finding data locations may be provided. A first synopses, which corresponds to first tabular data may be provided. An auxiliary data storage system may be scanned to identify second tabular data stored in the auxiliary data storage system. A second synopses may be obtained, in which the synopses correspond to the second columns of second tabular data. The synopsis may be computed for each second column of the second columns, according to a numeric representation of contents of cells of said each second column. The computed synopsis may include a vector of m descriptors. The two sets of one or more descriptors may be compared. A subset of the descriptors of the second synopses may be compared with corresponding descriptors of the first synopses, to identify potential matches between the second tabular data and the corpus of first tabular data.Type: GrantFiled: December 11, 2020Date of Patent: November 15, 2022Assignee: International Business Machines CorporationInventors: John G. Rooney, Luis Garcés Erice
-
Patent number: 11487772Abstract: The present disclosure provides a multi-party data joint query method, a device, a server and a storage medium. The multi-party data joint query method executed by a manager includes: analyzing a multi-party joint query sentence to obtain a logical execution plan; processing the logical execution plan according to providers of respective nodes in the logical execution plan to obtain a physical execution plan of each provider; and generating a query instruction of each provider according to the physical execution plan of each provider, and sending the query instruction to respective provider. The query instruction is configured to instruct the providers to perform a query cooperatively.Type: GrantFiled: December 26, 2019Date of Patent: November 1, 2022Assignee: BAIDU ONLINE NETWORK TECHNOLOGY (BEIJING) CO., LTD.Inventors: Zhi Feng, Yu Zhang, Sen Zhang
-
Patent number: 11481386Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium for managing a relationship between content and an environment for provisioning the content. In one aspect, a method includes receiving a request for a content item; and in response to receiving the request: selecting a creative from a plurality of creatives, the creative including a reference to a profile associated with one or more elements; retrieving content data from one or more content feeds bound to the elements; and delivering the creative and the content data to a user device.Type: GrantFiled: December 2, 2020Date of Patent: October 25, 2022Assignee: Google LLCInventors: Stephen Tsun, Vikas Jha, Shamim Samadi, Vishal Goenka, David Monsees
-
Patent number: 11481398Abstract: A system for spilling comprises an interface and a processor. The interface is configured to receive an indication to perform a GROUP BY operation, wherein the indication comprises an input table and a grouping column. The processor is configured to: for each input table entry of the input table, determine a key, wherein the key is based at least in part on the input table entry and the grouping column; add the key to a grouping hash table, wherein adding the key to the grouping hash table comprises last-in, first-out (LIFO) spilling when necessary; create an output table based at least in part on the grouping hash table; and provide the output table.Type: GrantFiled: December 9, 2020Date of Patent: October 25, 2022Assignee: Databricks Inc.Inventors: Alexander Behm, Ankur Dave, Ryan Deng, Shoumik Palkar
-
Patent number: 11481391Abstract: A distributed database system maintains data for a logical table by storing, on a plurality of storage nodes, a collection of key-item pairs. The distributed database system receives a query of the logical table, and identifies one or more portions of a key specified by the query. Based on the one or more portions of the key, the distributed database causes at least one of a get, range query, or scan operation to be performed by one or more of the storage nodes. Results for the query are generated based on one or more items obtained by performance of the operation.Type: GrantFiled: November 25, 2019Date of Patent: October 25, 2022Assignee: Amazon Technologies, Inc.Inventors: Almero Gouws, Derek William Richard Chen-Becker, Akshat Vig, Haifeng He
-
Patent number: 11475056Abstract: The present invention is in the technical field of geolocation. More particularly, the present invention is in the technical field of making content in the form of electronic data available for retrieval when a device has satisfied the Retrieval Range and other Rules which govern the ability to retrieve the content. Retrieval of Content by user devices may be based on Rules communicated by an App, Admin or third party interface and shall be contained and processed by an application interface engine.Type: GrantFiled: July 16, 2019Date of Patent: October 18, 2022Assignee: Tip Vyspots LLC VyInventor: Roopit Patel
-
Patent number: 11475050Abstract: The present disclosure involves systems, software, and computer implemented methods for providing default values for fields of data objects in an offline mode. One example method includes receiving, at a client device, a default group mapping that includes a default group identifier and a default value to be used as an initial value for a field. A field mapping can be received that includes a default group identifier and a field identifier. A request can be received while the client device is offline to create an instance of an object. A determination can be made that the field mapping includes a field identifier for a field of the object. A default value can be retrieved, from a local repository on the client device. A field value of the field in a created instance of the data object can be set to be the default value.Type: GrantFiled: December 14, 2020Date of Patent: October 18, 2022Assignee: SAP SEInventors: Thomas Biesemann, Alexander Fuerbach
-
Patent number: 11468011Abstract: A method for managing log files for recording operations on data stored in a database is provided, wherein a set of log files having an allocated first portion of storage is updated, the allocated first portion of storage is monitored, and a second portion of storage is allocated in dependence on a determination that an available portion of storage is below a predetermined size. A method for generating a snapshot is provided, wherein data entries are included in the snapshot in dependence on a determined relative order of log records in a set of log files. A method of replicating a binary large object is provided, wherein the binary large object is sent to a second database in response to identifying a log record comprising data indicating the binary large object.Type: GrantFiled: April 11, 2019Date of Patent: October 11, 2022Assignee: SingleStore, Inc.Inventors: Adrian Birka, Rodrigo Toste Gomes
-
Patent number: 11461292Abstract: A computer-implemented method for quick data exploration of data to be uploaded may be provided. The method comprises uploading, from a local system, a first data set of a first size and determining that the first data set is not corrupted. The method also comprises in parallel to the uploading performing selecting from the first data set a predefined number of records and building a second data set, determining statistical data and metadata about the first data set, and visualizing the second data set, the statistical data and the metadata.Type: GrantFiled: July 1, 2020Date of Patent: October 4, 2022Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Tomasz Kania, Tymoteusz Gedliczka, Szymon Brandys, Krzysztof Pitula, Maciej Madej, Piotr Grzywna
-
Patent number: 11455310Abstract: Cross-tabulation operation is performed within a columnar database management system. The columnar database management system receives a request to perform a cross-tabulation operation on a set of database tables. The columnar database management system determines values of cross-tabulation operation for each row of the result. The columnar database management system determines a domain for each value of the row dimension corresponding to a row combination. The columnar database management system determines an intersection set of the domains corresponding to values of the row dimensions for the row combination. The columnar database management system determines a value for the result column for the row combination as an aggregate value based on the records of the intersection set.Type: GrantFiled: February 26, 2021Date of Patent: September 27, 2022Assignee: OPEN TEXT HOLDINGS, INC.Inventors: Carles Bayés Martín, Jesús Malo Poyatos, Marc Rodríguez Sierra, Alejandro Sualdea Pérez
-
Patent number: 11449568Abstract: A system and method for outputting weather data associated with a user-specified location based on a user-specified weather inquiry, including weather data output based on user-specified weather conditions, locations output based on a user-specified weather inquiry, notifications output regarding weather-related warnings, and notifications output based on weather-related notification thresholds.Type: GrantFiled: December 9, 2020Date of Patent: September 20, 2022Assignee: AccuWeather, Inc.Inventors: R. Lee Rainey, Bill Vincent, Casey McGeever, Michelle L. Massung, Gregg Pavlik
-
Patent number: 11449481Abstract: Data storage and query method and device are disclosed, which facilitate a quick acquisition of query results through index queries at subsequent stages by establishing indexes for columns of a table. Furthermore, by scanning data in the table to obtain statistical information of data in the columns, this facilitates using the statistical information of the data in the columns to perform cost estimation in subsequent queries, in an attempt to obtain a data query mode that has the least cost and the best performance, thus improving query efficiency.Type: GrantFiled: June 5, 2020Date of Patent: September 20, 2022Assignee: Alibaba Group Holding LimitedInventors: Jiye Tu, Chuangxian Wei, Chaoqun Zhan
-
Patent number: 11449520Abstract: Provided herein are systems and methods for query result data processing, including parallel fetching and processing of query result data. A system includes at least one hardware processor coupled to memory and configured to obtain query result information associated with query result data. Multiple result batches are generated based on the query result information. Each result batch of the multiple result batches includes location information and schema information associated with a portion of the query result data. A data processing request corresponding to the result batch is detected. The portion of the query result data associated with the result batch is retrieved in response to the data processing request. The retrieving uses the location information within the result batch. The portion of the query result data is parsed using the schema information, to generate parsed result data.Type: GrantFiled: October 14, 2021Date of Patent: September 20, 2022Assignee: Snowflake Inc.Inventors: Harsha S. Kapre, Mark T. Keller, Srinath Shankar, Kushan A. Zaveri
-
Patent number: 11449507Abstract: In response to a query to a database, the identity of a slave machine which stores the requested data is resolved, and the query is parsed to identify one or more shards at the slave machine. Each shard corresponds to a partition of the requested data stored at the slave, and rows inside of the shard are respectively assigned a fixed-size local ID. Tasks corresponding to each shard are placed into a thread pool, and the threads are processed using the respective local IDs to obtain the requested data.Type: GrantFiled: September 6, 2018Date of Patent: September 20, 2022Inventors: Dillon Uzar, Tim Williams, Alex Sabella
-
Patent number: 11451595Abstract: A system comprising a first computing device operated by a first driver, a second computing device operated by a second driver, and a server is disclosed. The server may determine one or more characteristics of the first driver based on at least one of listening preferences or telematics data of the first driver. Based on the one or more characteristics of the first driver, the server may assign the first driver to a conference. The server may receive a request from the second computing device for the second driver to participate in conferencing. The server may determine that the second driver has at least one characteristic that matches one of the one or more characteristics of the first driver and may assign the second driver to the conference with the first driver. The server may bridge the first driver and the second driver in the conference.Type: GrantFiled: July 20, 2020Date of Patent: September 20, 2022Assignee: Allstate Insurance CompanyInventors: Lindsey Jo Thome, Tara Cavallaro Kozlowski
-
Patent number: 11442913Abstract: A method and device for creating a localization map, including a step of receiving environmental data values, a step of dividing the environmental data values into at least two separate data records, a step of creating a plurality of partial maps, a step of creating the localization map and a step of making the localization map available.Type: GrantFiled: August 3, 2020Date of Patent: September 13, 2022Assignee: Robert Bosch GmbHInventors: Carsten Hasberg, Jan Rohde