Abstract: In optimizing net change data replication across a plurality of transactions in a replication environment, a source replication engine at a source database system: obtains a window in a source database log for the net change data replication; for a given row identifier found in the source database log, identifies an initial operation and a latest operation across the plurality of transactions within the window; compares the initial operation and the latest operation for the given row identifier to determine a net change to a row associated with the given row identifier; and stores the net change as a final operation on the given row identifier in an optimization repository for replication to a target database. The operations stored in the optimization repository are then sent to a target database system for replication to the target database.

Abstract: Methods, systems, and apparatus, including computer programs encoded on computer-storage media, for inferring joins for data sets. In some implementations, a first data table and a second data table are identified. A first subset of records are selected from the first data table and a second subset of records are selected from the second data table. For fields of the first subset and the second subset, sets of feature values are generated indicating characteristics of the data in the fields. Based on the sets of feature values, one or more similarity score are determined, with each similarity score indicating a similarity of a column in the first data table with respect to a column in the second data table. Based on the one or more similarity scores, data indicating a recommendation to join one or more columns of the first data table with one or more columns of the second data table is provided for output by a computing device.

Abstract: A method of determining and optimizing the location of a new insurance agency is disclosed to increase market penetration of underrepresented markets. The method comprises the use of a scoring algorithm to rank various geographic regions or related zip codes. The scoring algorithm may be implemented by a location modeling system based on variables selected by a user. In addition, the various ranked geographic regions or related zip codes may be analyzed for proximity to natural or man made perils.

Abstract: The Messaging Search and Management Apparatuses, Methods and Systems (“MSM”) transforms message, ranking request inputs via MSM components into work graphs, ML structure input data, ML structure, ranking response outputs. A work graph generation request that includes group level access control data may be obtained. A set of metadata access control carrying messages, a set of users, a set of channels, and a set of topics with access control data corresponding to the group level access control data may be determined. A user priority score for each of the other users, a channel priority score for each of the channels, and a topic priority score for each of the topics, from the perspective of each user, may be calculated. A work graph data structure may be generated that includes, for each user, data regarding the calculated user priority scores, channel priority scores, and topic priority scores.

Abstract: A system for real-time search, including: a set of partitions, each including a set of segments, each segment corresponding to a time slice of messages posted to the messaging platform, and a real-time search engine configured to receive a search term in parallel with other partitions in set the set of partitions, and search at least one of the set of segments in reverse chronological order of the corresponding time slice to identify document identifiers of messages containing the search term; and a search fanout module configured to: receive a search query including the search term; send the search term to each of the set of partitions for parallel searching; and return, in response to the search query, at least one of the identified document identifiers of messages containing the search term.

Abstract: Technologies are described providing adaptive query routing in a replicated database environment. The technologies can be used with a variety of replication protocols. Prepared statements, such as for queries, from a database client can be routed to a source node, or a source node and available replica nodes, when a replica node becomes unavailable. When a replica node becomes available again, a prepared statement can be updated to indicate that the updated prepared statement can be executed at nodes including the replica node that is available again. Prepared statement routing can also be used when a portion of replicated data becomes unavailable at a replica node, but a portion of replicated data remains available.

Abstract: A method of joining a first dataset configured to store a set of data entries each identified by a respective key of a first type and a second dataset configured to store a second set of data entries identified by a respective key of a second type, the method comprising: selecting an intermediate mapping entity from a set of possible intermediate mapping entities, each mapping entity storing association between keys of the first type and keys of the second type; providing the selected intermediate mapping entity for use in joining the first data set with the second data set; wherein the step of selecting the intermediate mapping entity is based on the intersection weight between the first and second data sets via each of the intermediate mapping entities, wherein the intersection weight is the proportion of overlapping data entries between the first and second datasets.

Abstract: Methods, systems, and program products for streamlined auditing that receive an input audit request via the data interface; source entity type data (ETD) from one or more databases; prepare the ETD for input into an entity clustering module; match the ETD via the entity clustering module to locate linkages within the ETD and build relationships amongst one or more entities identified within the ETD; analyze the ETD relationships via an entity intelligence module to identify and segment targeted entities, from the one or more entities, that are applicable to the audit request; build inclusion lists of those targeted entities that are determined to fulfill the audit request; finalize the inclusion lists of targeted entities that fulfill the audit request to generate streamlined audit results; and output the streamlined audit results to an end user.

Abstract: Analytics system onboarding of web content is described. In one example, an analytics onboarding system is configured to process web content to generate recommendations, automatically and without user intervention. The recommendations are configured to assist in mapping of web content variables in web content to data elements supported by an analytics system to generate metrics that describe occurrence of events as part of user interaction with web content.

Abstract: The subject technology receives a query plan corresponding to a query. The subject technology executes the query based at least in part on the query plan, the executing including: filtering a first set of files that are to be modified by a merge statement, performing a split operation to send information related to a second set of files to a scan set builder operation in a first portion of the query plan and scan back operation in a second portion of the query plan, performing the scan set builder operation to remove the second set of files from the first set of files, performing a table scan operation based on a third set of files, and performing a first union all operation to combine the first set of data with a second set of data as a first set of combined data.

Abstract: Disclosed is a system for translating data, extracted from disparate data sources, into a homogeneous dataset to provide meaningful information. The database schema definition module defines a database schema in order to extract meaningful information pertaining to a specific use-case. The data source determination module determines one or more disparate data sources pertinent to extract the meaningful information. The data extraction module extracts heterogeneous dataset from the one or more disparate data sources. The data extraction module further passes the heterogeneous dataset to a Data-Translate Markup Language (DTML) executer to translate the heterogeneous dataset into a homogeneous dataset. The data translation module translates the heterogeneous dataset into the homogeneous dataset by using at least one data adapter.

Abstract: Some aspects of this disclosure involve generation of crowd-based results based on measurements of affective response of users. In some embodiments described herein, sensors are used to take measurements of affective response of at least ten users who were at a certain location. The measurements may include various values indicative of physiological signals and/or behavioral cues of the at least ten users. Some examples of locations in this disclosure include vacation destinations, businesses, establishments that provide entertainment, certain geographical regions, and virtual environments. User interfaces are configured to receive data describing a location score computed based on the measurements of the at least ten users, which represents the affective response of the at least ten users to being at the certain location. The user interfaces may be used to report the location score (e.g., to a user who may be interested in visiting the certain location).

Abstract: Systems and methods are provided for searching a schema to identify and visualize corresponding data. The system may be configured to receive a search query and search the schema for columns that correspond to one another. Individual ones of the corresponding columns may have different labels or different data types. Results for the search query may be determined. The results may include a first set of columns that satisfy the search query including a first column and a second column that correspond to each other but have one or more different labels or different data types. The system may be configured to generate a graphical representation of a data distribution for the first column responsive to receiving a selection of the first column.

Abstract: The present invention generally relates to a method for summarizing content related to a keyword, the content being retrieved from online websites, the method comprising the steps of: searching (1100) the keyword with at least one search engine, thereby obtaining ranked result webpages, deriving (1200, 2200) sentences from a predetermined number of highest ranking webpages, among the ranked result webpages, combining (1300) the sentences, thereby obtaining a combined content, ranking (1400, 3400) the combined content, thereby obtaining a ranked content, outputting (1500) a predetermined number of highest ranking sentences from the ranked content as summary of the keyword.

Abstract: Electronic multi-user forms are provided. The use of these forms may include displaying the forms to more than one user, receiving population data from one or more user, and selectively displaying the population data to each user. The population data may be displayed to the various users based on the security authorization of the user seeing the form. Upon completion of the form by the users, the form may be further completed and submitted for processing or approval.

Abstract: Systems and methods are provided for performing context-based keyword searching using a search bar. Based on search terms received via the search bar, the system may be configured to provide suggested search parameters to associate with that search term. The suggested search parameters may each include a type of data and/or a filter to associate with the search term (e.g., name, phone number, date of birth, etc.). The one or more suggested search parameters may be identified based on the search term itself, a list of possible types of data or filters, a preliminary search of one or more datasets, a record of one or more previous searches performed, requirements associated with one or more searchable datasets, the format of user input received via the search bar, and/or one or more other factors.

Abstract: System and methods are disclosed for redacting analyzing unstructured data in a request for data associated with a data subject to determine whether the unstructured data is relevant to the request. The relevancy of pieces of the unstructured data may be determined by determining a categorization for each such piece of unstructured data and comparing them to known personal data associated with the data subject having the same categorization. Pieces of the unstructured data that do not match known personal data having the same categorization are redacted from the request before the request is processed.

Abstract: Techniques for enabling deduplication-aware load balancing in a distributed storage system are provided. In one set of embodiments, a node of the distributed storage system can receive an I/O (Input/Output) request pertaining to a data block of a storage object stored on a local storage component of the node. The node can further determine whether the I/O request requires insertion of a new entry into a deduplication hash table associated with the local storage component or deletion of an existing entry from the deduplication hash table. If the I/O request requires insertion of a new hash table entry, the node can add an identifier of the data block into a probabilistic data structure associated with the local storage component, where the probabilistic data structure is configured to maintain information regarding distinct data blocks that are likely present in the local storage component.

Abstract: A unified access layer (UAL) and scalable query engine receive queries from various interfaces and executes the queries with respect to non-heterogeneous data management and analytic computing platforms that are sources of record for data they store. Query performance is monitored and used to generate a query performance model. The query performance model may be used to generate alternatives for queries of users or groups of users or to generate policies for achieving a target performance. Performance may be improved by monitoring queries and retrieving catalog data for databases referenced and generating a recommendation model according to them. Duplicative or overlapping sources may be identified based on the monitoring and transformations to improve accuracy and security may be suggested. A recommendation model may be generated based on analysis of queries received through the UAL. Transformations may be performed according to the recommendation model in order to improve performance.

Abstract: A method, apparatus and server for recommending an application are provided. The method may include determining at least one target friend among a plurality of friends of a target user, obtaining social interaction characteristics between the target user and the at least one target friend, based on a pre-trained friend impact prediction model of a target application and the social interaction characteristics between the target user and the at least one target friend, determining a first impact of the at least one target friend on registration of the target user in the target application, determining a recommendation score corresponding to the target user and the target application according to the first impact of the at least one target friend on registration of the target user in the target application, and performing application recommendation according to the recommendation score.