-
公开(公告)号：US12007985B2
公开(公告)日：2024-06-11
申请号：US18144057
申请日：2023-05-05
申请人： Couchbase, Inc.
IPC分类号： G06F16/23 , G06F16/245 , G06F16/27
CPC分类号： G06F16/2379 , G06F16/245 , G06F16/27 , G06F16/273 , G06F16/275 , G06F16/278
摘要： A distributed database system receives and executes a transaction including a first modification statement describing a first modification operation on a subset of records, a second modification statement describing a second modification operation on the subset of records, and a commit statement. Responsive to executing the first and second modification statements, the system receives a copy of the subset of records from data servers; performs the first modification operation to generate a first modified subset of records; and performs the second modification operation on the first modified subset of records. Responsive to executing the commit statement, the system stores the second modified subset of records in a commit table and causes the subset of records to be updated at the data servers.
-
公开(公告)号：US20210357373A1
公开(公告)日：2021-11-18
申请号：US15930351
申请日：2020-05-12
申请人： Couchbase, Inc.
IPC分类号： G06F16/215 , G06F16/22 , G06F16/2453
摘要： A database system performs queries on fields storing arrays of a database (i.e., array fields) using de-duplication indexes. The system generates de-duplication indexes for array fields. The de-duplication indexes include unique entries for corresponding distinct values stored by the array fields. The system uses the de-duplication indexes to perform efficient queries specifying corresponding array fields. The system may further generate de-duplication indexes corresponding one or more fields storing various types of values. In various embodiments, the system selects an optimal index from various indexes usable to execute a query, such as a de-duplication index and a conventional index.
-
公开(公告)号：US20230315727A1
公开(公告)日：2023-10-05
申请号：US18206217
申请日：2023-06-06
申请人： Couchbase, Inc.
IPC分类号： G06F16/2453 , G06F16/93 , G06F16/2457 , G06F16/2458
CPC分类号： G06F16/2453 , G06F16/93 , G06F16/24578 , G06F16/2462
摘要： A document-oriented database system generates an optimal query execution plan for database queries on an untyped field included in a collection of documents. Each untyped field is configured to store one or more scalar data values. The system generates histograms for scalar data values stored in untyped fields. Responsive to receiving a query statement for fetching or updating data value stored in one of the untyped fields, the system assigns a cost to each operator associated with the query statement based on the histogram, compares the costs assigned to the operators, and generates a query execution plan based on the comparison, and query the database using the query execution plan.
-
公开(公告)号：US20220067029A1
公开(公告)日：2022-03-03
申请号：US17007561
申请日：2020-08-31
申请人： Couchbase, Inc.
IPC分类号： G06F16/23 , G06F16/27 , G06F16/245
摘要： A distributed database system executes transactions on a distributed database. A received transaction includes statements describing modifications of records stored in the distributed database. The distributed database system executes the transaction at a query server by obtaining copies of records corresponding to the statements of the transaction and performing the modifications specified by the statements of the transaction on the record copies. The distributed database system stores the modified record copies at the query server during execution of the transaction. After the transaction has successfully been executed at the query server, the distributed database system attempts to perform a commit process to update the records stored in the distributed database based on the modified record copies.
-
公开(公告)号：US20240346057A1
公开(公告)日：2024-10-17
申请号：US18634472
申请日：2024-04-12
申请人： Couchbase, Inc.
CPC分类号： G06F16/334 , G06F16/313
摘要： A system manages time series data stored in association with documents. The system stores a time series in multiple documents. The time series data includes a series of data points indexed in time order, and each document stores a subset of the series of data points. Each document stores metadata about a time range of the subset of series of data points. The system indexes the documents based on their time ranges. The system may be used for storing and querying spatiotemporal data. Accordingly, each document further stores spatial data and metadata representing a spatial range of geohashes. Responsive to receiving a query for one or more data points, the system selects one or more documents from the multiple documents that contain data points in the particular spatial and time range based on the indexes. The system performs the query on the data points.
-
公开(公告)号：US11200230B2
公开(公告)日：2021-12-14
申请号：US16785499
申请日：2020-02-07
申请人： Couchbase, Inc.
IPC分类号： G06F16/2453 , G06F16/93 , G06F16/2457 , G06F16/2458
摘要： A document-oriented database system generates an optimal query execution plan for database queries on an untyped data field included in a collection of documents. The system generates histograms for multiple types of data stored by the untyped data field and uses the histograms to assign costs to operators usable to execute the database query. The system generates the optimal query execution plan by selecting operators based on the assigned costs. In various embodiments, the untyped data field stores scalars, arrays, and objects.
-
公开(公告)号：US12079181B2
公开(公告)日：2024-09-03
申请号：US17888341
申请日：2022-08-15
申请人： Couchbase, Inc.
IPC分类号： G06F16/00 , G06F16/215 , G06F16/22 , G06F16/2453
CPC分类号： G06F16/215 , G06F16/2264 , G06F16/2453
摘要： A database system performs queries on fields storing arrays of a database (i.e., array fields) using de-duplication indexes. The system generates de-duplication indexes for array fields. The de-duplication indexes include unique entries for corresponding distinct values stored by the array fields. The system uses the de-duplication indexes to perform efficient queries specifying corresponding array fields. The system may further generate de-duplication indexes corresponding one or more fields storing various types of values. In various embodiments, the system selects an optimal index from various indexes usable to execute a query, such as a de-duplication index and a conventional index.
-
公开(公告)号：US11681687B2
公开(公告)日：2023-06-20
申请号：US17007561
申请日：2020-08-31
申请人： Couchbase, Inc.
IPC分类号： G06F16/23 , G06F16/27 , G06F16/245
CPC分类号： G06F16/2379 , G06F16/245 , G06F16/27 , G06F16/273 , G06F16/275 , G06F16/278
摘要： A distributed database system executes transactions on a distributed database. A received transaction includes statements describing modifications of records stored in the distributed database. The distributed database system executes the transaction at a query server by obtaining copies of records corresponding to the statements of the transaction and performing the modifications specified by the statements of the transaction on the record copies. The distributed database system stores the modified record copies at the query server during execution of the transaction. After the transaction has successfully been executed at the query server, the distributed database system attempts to perform a commit process to update the records stored in the distributed database based on the modified record copies.
-
公开(公告)号：US20210042301A1
公开(公告)日：2021-02-11
申请号：US16788923
申请日：2020-02-12
申请人： Couchbase, Inc.
IPC分类号： G06F16/2453 , G06F16/93
摘要： A document-oriented database system generates an optimal query execution plan for database queries on an untyped data field included in a collection of documents. The system generates histograms for multiple types of data stored by the untyped data field and uses the histograms to assign costs to operators usable to execute the database query. The system generates the optimal query execution plan by selecting operators based on the assigned costs. In various embodiments, the untyped data field stores scalars, arrays, and objects.
-
公开(公告)号：US20230315718A1
公开(公告)日：2023-10-05
申请号：US18144057
申请日：2023-05-05
申请人： Couchbase, Inc.
IPC分类号： G06F16/23 , G06F16/27 , G06F16/245
CPC分类号： G06F16/2379 , G06F16/245 , G06F16/27 , G06F16/273 , G06F16/275 , G06F16/278
摘要： A distributed database system receives and executes a transaction including a first modification statement describing a first modification operation on a subset of records, a second modification statement describing a second modification operation on the subset of records, and a commit statement. Responsive to executing the first and second modification statements, the system receives a copy of the subset of records from data servers; performs the first modification operation to generate a first modified subset of records; and performs the second modification operation on the first modified subset of records. Responsive to executing the commit statement, the system stores the second modified subset of records in a commit table and causes the subset of records to be updated at the data servers.
-
-
-
-
-
-
-
-
-
搜索结果
16 条记录 (耗时 0.015 秒)
