Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Change data capture using nested buckets

a data capture and nested technology, applied in computing, electric digital data processing, instruments, etc., can solve the problem of computationally expensive generation and maintenance of some data

Active Publication Date: 2018-08-02
SALESFORCE COM INC
View PDF8 Cites 33 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

The patent text describes a method for improving the performance of change data capture (CDC) processing in a database system. CDC is a process for detecting changes in data fields and updating multiple copies of an object with the changes. The technical effect of the patent text is to reduce the bandwidth required for a computing system to manage the database by optimizing CDC processing. The method involves detecting changes in data fields and identifying subsets of fields that have changed, and updating only the relevant data fields to provide coherent data to active users. This reduces the amount of bandwidth required for a computing system to manage the database. The patent text also describes a multi-tenant database system and various communication methods for user systems to interact with the database.

Problems solved by technology

Generating and maintaining some data may be computationally expensive.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Change data capture using nested buckets
  • Change data capture using nested buckets
  • Change data capture using nested buckets

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0010]During operation, an object of a database may have more than one copy in various memory locations. For example, if two users are accessing a particular object, two copies of the object may be generated, one for each user to utilize. Any changes made by either used may be captured upon a user submitting the data or when the user logs off. In some embodiments, changes may be captured periodically while the two users are still operating on the object. Various processes for change data capture (CDC) may be utilized in different database systems. As used herein, CDC refers to processes for detecting a change in one or more data fields in a database object and determining which data fields have changed. Detected changes in a data field may require updating across multiple existing copies of the database object to provide coherent data to active users. As a number of objects in a database increases, with each object including multiple data fields, the CDC process may become cumbersom...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Systems and techniques are disclosed relating to management of a database. A method may include maintaining, by a computer system, a multi-tenant database operable to store a plurality of objects. Each object may be capable of including up to a maximum potential number of definable fields. Each field may have an associated index number that has been assigned sequentially. The method may include receiving user-defined data values for a subset of the maximum potential number of fields of a particular object, and storing, for the particular object, a boundary value indicating a range of index values that have been defined for the particular object. The method may further include, in response to determining that the particular object has been accessed, selectively processing a number of fields of the particular object. The number of fields may be determined based on the stored boundary value for the particular object.

Description

BACKGROUNDTechnical Field[0001]Embodiments described herein are related to the field of database computing systems, and more particularly to the implementation of change data capture processing.Description of the Related Art[0002]Cloud application development platforms, such as the Force.com multitenant architecture, may allow individual enterprises and software as a service (SaaS) vendors to develop robust, reliable, and Internet-scale applications. Web applications may generate various types of data, e.g., by accessing objects within a database and processing information accessed from the objects. In some databases, various objects may include varying amounts of data. Generating and maintaining some data may be computationally expensive. Data included in a particular object may be processed in response to certain accesses of the object by one or more users of the database.BRIEF DESCRIPTION OF THE DRAWINGS[0003]FIG. 1 illustrates a block diagram of an embodiment of a multi-tenant d...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(United States)
IPC IPC(8): G06F17/30
CPCG06F17/30377G06F17/30321G06F16/2228G06F16/2379G06F16/2291G06F16/23G06F16/2358
Inventor MILRUD, BORIS
Owner SALESFORCE COM INC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com