Abstract: A system receives an object selection, and outputs the object. The system receives a first service selection, outputs the first service's object, receives a second service selection, and outputs the second service's object. The system receives selections of the object's first field and the first service object's field, and stores first metadata that maps between the object's first field and the first service object's field. The system receives selections of the object's second field and the second service object's field, and stores second metadata that maps between the object's second field and the second service object's field. The system updates an object instance by using the first metadata to send first request data to the first service and receive first response data from the first service, and by using the second metadata to send second request data to the second service and receive second response data from the second service.

Abstract: The system tokenizes values stored by records' fields, creates trie from tokenized values, each branch labeled with tokenized value, each node storing count indicating number of records associated with tokenized value sequence beginning from trie root. The system tokenizes value stored by record field, identifies nodes, beginning from trie root, corresponding to token value sequence associated with tokenized value, until node is identified that stores count that is less than node threshold. The system identifies branch sequence comprising each identified node as record's key, and associates key with node storing count less than node threshold, and record with key. The system tokenizes prospective value stored by prospective record's field, identifies nodes, beginning from trie root, corresponding to another token value sequence associated with tokenized prospective value, until another node is identified that stores another count that is less than node threshold.

Abstract: Systems and methods are provided for generating database access objects. Metadata associated with a database table is retrieved. The metadata includes a table name, column names, foreign key information, and/or primary key information. Objects are generated. Each object is associated with a corresponding row in the database table and includes fields associated with a corresponding column in the database table. A database access object is generated based on the metadata. The database access object includes relational database code to access data associated with the objects. The database access object is modified. Data associated with an object is accessed based on the modified database access object.

Abstract: In various embodiments, a system of synchronizing data is described. The system may store data associated with a plurality of data vendors. The system may synchronize the stored data with data from a first data vendor. The received data may be parsed by identifying data values indicated by associated metadata, and modifying the data values based on a universal data format. The system may also receive synchronization requests from a user of the service. The synchronization requests may indicate requested data and a list of processing operations. The requested data may correspond to data received from multiple data vendors. The system may perform the list of processing operations and return the data. Accordingly, the system may manage data received from multiple data vendors even if the data vendors have different synchronization conditions and provide the data in different formats. The data may be analyzed and output together to a user.

Abstract: Methods and systems are provided for regulating access to a database by a server. One exemplary method involves the server receiving one or more requests for an activity with respect to the database and determining an attempted usage for the activity over a monitoring period by a source of the requests. When the attempted usage exceeds an allowed usage of the activity for the monitoring period, the server creates an entry in a cache that includes an identifier associated with the source of the one or more requests. Thereafter, the requested activity with respect to the database on behalf of the source may be prevented based on the entry in the cache.

Abstract: The system tokenizes values stored by records' fields, creates trie from tokenized values, each branch labeled with tokenized value, each node storing count indicating number of records associated with tokenized value sequence beginning from trie root. The system tokenizes value stored by record field, identifies nodes, beginning from trie root, corresponding to token value sequence associated with tokenized value, until node is identified that stores count that is less than node threshold. The system identifies branch sequence comprising each identified node as record's key, and associates key with node storing count less than node threshold, and record with key. The system tokenizes prospective value stored by prospective record's field, identifies nodes, beginning from trie root, corresponding to another token value sequence associated with tokenized prospective value, until another node is identified that stores another count that is less than node threshold.

Abstract: Systems and methods are provided for semi-synchronously exporting data. A web server creates an export record in response to receiving a data request from a client computer. The web server sends a token to the client computer, wherein receipt of the token enables the client computer to be used for other purposes while waiting for receipt of requested data. At least one of multiple batch processing servers processes the data request in response to accessing the export record. At least one of the multiple batch processing servers updates the export record to reflect the processing of the data request. The web server exports the processed data request to the client computer in response to identifying an update of the export record.

Abstract: A system receives an object selection, and outputs the object. The system receives a first service selection, outputs the first service's object, receives a second service selection, and outputs the second service's object. The system receives selections of the object's first field and the first service object's field, and stores first metadata that maps between the object's first field and the first service object's field. The system receives selections of the object's second field and the second service object's field, and stores second metadata that maps between the object's second field and the second service object's field. The system updates an object instance by using the first metadata to send first request data to the first service and receive first response data from the first service, and by using the second metadata to send second request data to the second service and receive second response data from the second service.

Abstract: Systems and methods are provided for matching snippets of search results to clusters of objects. A system adds a data snippet of a search result to a cluster of objects. The system calculates a confidence score for the add based on the recency, a job title, an email address, and/or a phone number associated with the data snippet. The system stores the add in the customer accessible database if the confidence score is sufficiently high for the add to be stored in the customer accessible database. The system generates a notice for review if the confidence score is not sufficiently high for the add to be stored in the customer accessible database.

Abstract: Transforming columns from source files to target files is described. A system associates a source column in a source file with an entity of multiple entities associated with target columns comprising a target file, based on a first set of features that describes contents of cells of a first source column that is adjacent to the source column, a second set of features that describes contents of cells of a second source column that is adjacent to the source column, and a third set of features that describes contents of cells of the source column. The system creates a mapping of the source column to a target column associated with the entity, and transforms the mapped source column to the target column in accord with the mapping.

Abstract: Systems and methods are provided for cleaning data in a customer relationship management system. A system receives a plurality of records from an on-demand system. The system identifies a record from the plurality of records that matches a stored record for a customer relationship management system. The system determines whether to update the stored record using the identified record. The system updates the stored record using the identified record in response to a determination to update the stored record using the identified record.

Abstract: Systems and methods are provided for creating indices and loading key-value pairs for NoSQL databases. Attributes are created that correspond to records in a NoSQL database based on corresponding record fields. An index is created based on the attributes. A memory is loaded with attributes that correspond to a subset of the index as keys in a key-value pair and identifiers that correspond to records that correspond to the attributes as values in the key-value pair. The attributes that correspond to the subset of the index are sorted in the memory. Any duplicate attributes are identified from the sorted attributes in the memory. Any identifiers that correspond to any duplicate attributes also identify records in the NoSQL database to be evaluated as potential duplicate records.

Abstract: To facilitate data transfer between two databases, a transfer machine accesses both databases and finds matching records. The transfer machine determines and stores a match status of a record in one database. The match status indicates whether the record corresponds to at least one of the records in the other database, and if so, which record or records in the other database correspond to the record. If the match status indicates that the record matches a record in the other database, the transfer machine determines which record is current and updates the other record. If the match status indicates that a record has no match in the other database, the transfer machine adds a copy of the record to the other database.

Abstract: Methods and systems are provided for regulating access to a database by a server. One exemplary method involves the server receiving one or more requests for an activity with respect to the database and determining an attempted usage for the activity over a monitoring period by a source of the requests. When the attempted usage exceeds an allowed usage of the activity for the monitoring period, the server creates an entry in a cache that includes an identifier associated with the source of the one or more requests. Thereafter, the requested activity with respect to the database on behalf of the source may be prevented based on the entry in the cache.

Abstract: Methods and systems are provided for regulating access to a database by a server. One exemplary method involves the server receiving one or more requests for an activity with respect to the database and determining an attempted usage for the activity over a monitoring period by a source of the requests. When the attempted usage exceeds an allowed usage of the activity for the monitoring period, the server provides a human verification test to the source and thereafter initiates the activity with respect to the database in response to receiving a satisfactory human verification response to the human verification test from the source.

Abstract: Systems and methods are provided for matching snippets of search results to clusters of objects. A system searches information based on objects in a cluster of objects. The system extracts a data snippet from the search results. The system determines whether the data snippet includes data that matches at least one of the objects in the cluster of objects. The system adds the data snippet to the cluster of objects if the data snippet includes data that matches at least one of the objects in the cluster of objects.

Abstract: Systems and methods are provided for matching snippets of search results to clusters of objects. A system adds a data snippet of a search result to a cluster of objects. The system calculates a confidence score for the add based on the recency, a job title, an email address, and/or a phone number associated with the data snippet. The system stores the add in the customer accessible database if the confidence score is sufficiently high for the add to be stored in the customer accessible database. The system generates a notice for review if the confidence score is not sufficiently high for the add to be stored in the customer accessible database.

Abstract: Systems and methods for performing latency-free database searches using two-level indexed data structures having decreasing integer sets as identifiers to represent actual data. The indexed data structures are stored in distributed memory. Data operations such as intersection and union are performed using the indexed data structures. A binary interval reduction technique is used to quickly move through the data sets looking for common elements for the intersection set, or unique elements to add to the union set.

Abstract: Systems and methods for performing latency-free contact searches using two-level indexed data structures having decreasing integer sets as identifiers to represent actual contact data. The indexed data structures are stored in distributed memory. Data operations such as intersection and union are performed using the indexed data structures. A binary interval reduction technique is used to quickly move through the data sets looking for common elements for the intersection set, or unique elements to add to the union set.

Abstract: Systems and methods are provided for cleaning data in a customer relationship management system. A system receives a plurality of records from an on-demand system. The system identifies a record from the plurality of records that matches a stored record for a customer relationship management system. The system determines whether to update the stored record using the identified record. The system updates the stored record using the identified record in response to a determination to update the stored record using the identified record.