Abstract: Techniques and solutions are described for determining a set of elements of a second set that may correspond to a given element of a first set of elements. The elements can be, in specific examples, components of a database system, such as tables (or entities), attributes, or records. Significance metric values are calculated for elements in the first and second sets. The significance metric values can be a number of records in an entity or a number of read or write access operations for an entity or for a record of an entity. A significance metric value for the given element can be used at least in part to select elements of the second set as potential match candidates, based at least in part on significance metric values for elements of the second set. Selecting elements can include selecting elements based on a window of elements of the second set or a range of significance metric values.

Abstract: A system for simulating a dataset based on sample statistics, and generating pipeline instructions for a database using the simulated dataset, is disclosed. The system may be a cloud-based platform. The system can provide improved performance and security while designing and deploying Extract-Transform-Load (ETL) database pipelines to manage on-premises data. The system receives, from a remote client, sample statistics characterizing a distribution of data corresponding to a column of a database table. The system can generate, based on the received sample statistics, a simulated dataset representing the column of the database table. The simulated dataset may be generated using pseudo-random data values from a distribution with statistics matching the sample statistics. The system can build a simulated database relation based at least in part on the simulated dataset. The system can generate and deploy pipeline instructions using the simulated database relation.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receiving a request for a map visualization that includes geo-enriched data comprising a set of shapes. In response to the request, the program further generates a query for the geo-enriched data. The program also sends the query to a geo-enriching data system. The program further receives the geo-enriched data from the geo-enriching data system. The program also generates the map visualization that includes the set of shapes.

Abstract: Disclosed is a system for facilitating provisioning of social networking data to a mobile device. Further, the system may include a communication device configured for receiving at least one location information corresponding to a tour, receiving at least one selection corresponding to a plurality of filtering icons corresponding to a filtered social networking data, and transmitting a travel plan to the mobile device. Further, the system may include a processing device configured for filtering social networking data based on the at least one location information to generate the filtered social networking data, and generating the travel plan based on the at least one selection.

Abstract: The disclosure describes a method for database migration including: identifying, during an uptime of a source database system, one or more increments between a back-up copy of the source database system and the source database system, the source database system comprising: one or more datafiles encoding data objects, and tablespace data encoding table/index data, restoring, in parallel and during the uptime of the source database system, the one or more datafiles from the back-up copy to a target database system that uses a different endian format; in response to determining that a downtime for the source database system has arrived, sequentially performing, during a downtime of the source database system: setting the tablespace data to read only; recovering datafiles on the target database system in accordance with the one or more increments; and setting the tablespace data to read and write; and activating the target database system to go live.

Abstract: Solutions for managing archived storage include receiving, at a first node, a snapshot comprising object data (e.g., a virtual machine disk snapshot) from a second node (e.g., a software defined data center), and storing the snapshot in a tiered structure that includes a data tier and a metadata tier. Snapshots may be used for fail-over operations and/or backups, to support disaster recovery. The data tier comprises a log-structured file system (LFS), and the metadata tier comprises a content addressable storage (CAS) identifying addresses within the LFS. The metadata tier also comprises a logical layer indicating content in the CAS. Segment cleaning of the data tier is performed using a segment usage table (SUT). Some examples include performing a fail-over operation from the second node to a third node using at least the stored snapshot for workload recovery. In some examples, the CAS comprises a log-structured merge-tree (LSM-tree).

Abstract: Disclosed are embodiments for replacing database table join keys with index keys. In one embodiment, a method is disclosed comprising: receiving, by a processor, annotation data, the annotation data comprising a set of rows; retrieving, by the processor, a root dataset, the root dataset stored in one or more files; generating, by the processor, a row identifier for each row in the set of rows, the row identifier storing a plurality of fields enabling alignment of a respective row in the annotation data to a corresponding row in the root dataset; generating, by the processor, an annotation dataset, the annotation dataset comprising the set of rows and corresponding row identifiers; and writing, by the processor, the annotation dataset to at least one file, the at least one file separate from the one or more files.

Abstract: A distributed, deduplicated storage system according to certain embodiments is arranged in a parallel configuration including multiple deduplication nodes. Deduplicated data is distributed across the deduplication nodes. The deduplication nodes can be networked together and communicate with one another according using a light-weight, customized communication scheme (e.g., a scheme based on FTP or HTTP). In some cases, deduplication management information including deduplication signatures and/or other metadata is stored separately from the deduplicated data in deduplication management nodes, improving performance and scalability.

Abstract: Examples of the present disclosure describe systems and methods of providing a people relevance platform. In aspects, an event may be generated by an application/service on a client device. The event may be transmitted to a people relevance platform. The people relevance platform may use the event to query one or more data sources for user contacts associated with the user. The people relevance platform may generate/modify a graph or model using the user contact data, and may provide the user contact data to the client device. The client device may update a local cache and provide the user contact data to the originating application. The client device may monitor the user selection of a contact, and transmit the selection information to the people relevance platform. The people relevance platform may modify the graph and/or model based on the selection information.

Abstract: A server set for a data set may designate a subset of “master” servers that update the data set in order to reduce data version conflicts involving mutually exclusive updates of the data set. Multi-master configurations may fulfill the performance constraints, and the subset of masters may detect and resolve data version conflicts. However, if multiple masters perform conflict resolution for a particular data version conflict, the resolution may produce inefficiency and redundancy (if the masters reach the same outcome) or additional data version conflicts (if the masters reach different outcomes). Instead, among the masters, a merge master may be identified that applies conflict resolution techniques to data version conflicts and forwards the conflict resolution outcome to the other masters for application to the data set to resolve the data version conflict. The other masters may temporarily store updates in a tentative update set until data version conflicts are resolved.

Abstract: A computer-implemented method includes receiving a search query from a user through a user interface of a user computing device, identifying a search term within the search query, the search term including at least a portion of the search query, generating, based at least in part on the search term, one or more alternative search terms that are each different from the search term, and sending, over the communication network, the one or more alternative search terms to the user computing device.

Abstract: Methods, apparatus, systems and articles of manufacture are disclosed for a broadcast profiling system. An example method includes comparing a preference included in a user profile with a portion of a content station profile to determine whether the preference satisfies a threshold difference from the portion of the content station profile, the content station profile including (1) a first characteristic of first broadcast data associated with a first time context and a first count associated with first identifying information and (2) a second characteristic of second broadcast data associated with a second time context and a second count associated with second identifying information; in response to the threshold difference being satisfied, generating a station recommendation for a user associated with the user profile; and transmitting an instruction associated with the user, the instruction including the station recommendation, the instruction configured to cause a radio pre-set to be adjusted.

Abstract: Computer implemented systems and methods are disclosed for automatically clustering and canonically identifying related data in various data structures. Data structures may include a plurality of records, wherein each record is associated with a respective entity. In accordance with some embodiments, the systems and methods further comprise identifying clusters of records associated with a respective entity by grouping the records into pairs, analyzing the respective pairs to determine a probability that both members of the pair relate to a common entity, and identifying a cluster of overlapping pairs to generate a collection of records relating to a common entity. Clusters may further be analyzed to determine canonical names or other properties for the respective entities by analyzing record fields and identifying similarities.

Abstract: Disclosed is a folder management apparatus including a memory and a processor electrically connected to the memory. The processor is configured to detect access of a user terminal and to display at least one folder permitted to be accessed by the user terminal along with a folder badge corresponding to the folder, wherein, when update histories including modification and new generation with respect to the folder permitted to be accessed by the user terminal are generated, the folder badge indicates the number of update histories which have not been yet read by the user terminal among the update histories.

Abstract: Mining data transformation flows in spreadsheets includes identifying operations defined in a spreadsheet, identifying source data, in the spreadsheet, on which the operations operate, automatically creating an extract, transform, load (ETL) data transformation flow, and executing the created ETL data transformation flow. Creating the ETL data transformation flow includes selecting, in the ETL system, source data endpoint(s) for data extraction, selecting target data endpoint(s) for data loading, mapping at least one of the identified operations to ETL operation(s) for data transformation, and building the ETL data transformation flow, which defines extraction from the selected source data endpoint(s), transformation based on the ETL operation(s), and loading to the selected target data endpoint(s).

Abstract: A system for searching and discovering information where a first server is provided with a digital catalogue of products and is connected to a communication network. The first server communicates with a front-end client associated to an user and connected to said communication network, and with a back-end server connected to said communication network. The back-end server has in turn an indexing section for processing the data of said digital catalogue in order to extract and save relevant data of said digital catalogue in an index, and a runtime section adapted to interpret the user query on the front-end client, compare the search information and/or the user behavior with said index and send to said front-end client suggestions to the user on how to refine said query.

Abstract: Methods and systems enable a database reorganization to occur without a database outage. In one aspect, the method includes creating a shadow copy of a database, the shadow having at least one partition associated with a plurality of first data sets and the database having at least a first partition associated with a plurality of second data sets and a second partition associated with a plurality of third data sets. The method also includes reorganizing the at least one partition of the shadow, taking the first partition offline, replacing the plurality of second data sets with the plurality of first data sets in a schema, and restarting the first partition.

Abstract: A system for processing information requests associated with mobile devices comprises an evaluation module configured to determine at least one performance measure for each of a plurality of information documents using at least data in one or both of a requests database and events database. The at least one performance measure includes at least one of an impression-based performance measure, a click/call-based performance measure, and an off-line site-visit-based performance measure. The system further comprises an information server configured to select a first information document for transmitting to a first mobile device to fulfill a first request.

Abstract: Managing looped, iterative and recursive operations through applying a parameterized instance of an assertion-model apportionment-sub-model pair to a reference data model to produce a parameterized outcome model. Based on a degree of convergence of the parameterized outcome model toward a target parameterized instance of the assertion-model apportionment-sub-model pair, assembling and parameterizing a next assertion-model and a next apportionment-sub-model pair. Repeating these steps until an instance of a parameterized outcome model meets a preconfigured degree of convergence toward a corresponding target parameterized instance of the assertion-model apportionment-sub-model pair.

Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.