Abstract: A computing device is provided, comprising a processor configured to select at least one pair of tuples of columns including a source tuple from a first table and a target tuple from a second table. For each pair, the processor may select one or more rows from the source tuple and elements of the target tuple. For each selected row, the processor may programmatically generate a script that, when performed on the source tuple, produces a value consistent with the target tuple. The processor may apply each script to other rows of the source tuple and determine that an output is in the target tuple. For each column of the target tuple, for the script with output that meets a matching criterion, the processor may convey the output and, in response to a signal accepting the script, join the tables at least in part by performing each accepted script.

Abstract: Examples of partitioning a group of related database tables are provided herein. A database table in a group of related database tables can be designated as a lead database table. A partitioning field can also be determined by which database tables in the group are partitioned. A data load, with respect to the partitioning field, of the lead database table can be calculated. The data load can include a data distribution across different values of the partitioning field. A group partitioning scheme can be determined based on the data load of the lead database table. The database tables of the group can then be partitioned according to the group partitioning scheme.

Abstract: A Processing method for processing SQL statements of different flavors by a database management system may be provided. The method comprises receiving SQL statements of different SQL flavors, parsing each received SQL statement for identifying an SQL flavor characteristic, tracking an SQL statement identifier of a related SQL PREPARE operation for determining the SQL flavor characteristic at subsequent DMBS operations, adapting a DBMS mode of the DBMS dynamically to the identified SQL flavor characteristic, adapting another received SQL statement to a DBMS mode of the database management system, and sending each of the adapted SQL statements to the DBMS for the SQL PREPARE operation under the adapted database management system mode.

Abstract: Techniques are described herein for routing requests for database cloud services. In an embodiment, a different Uniform Resource Identifier (URI) is assigned to each respective database schema of a plurality of database schemas in one or more databases. For each respective database schema, mapping data is stored that maps at least a portion of the URI to the respective database schema. In response to receiving a first request that includes a URI and a set of one or more database commands, a target database schema in a target database is identified based on the mapping data and the URI. A connection is established for accessing the target database schema in the target database. The set of one or more database commands is sent over the connection to access the target database schema in the target database.

Abstract: Systems, methods, and computer program products to perform an operation comprising receiving, by a database management system (DBMS) from an application, a request specifying to generate a global temporary table (GTT) of a first format, identifying a first GTT, of a plurality of GTTs stored by the DBMS, that has a second format, different than the first format, modifying the first GTT such that at least a portion of the modified first GTT is of the first format, and providing the modified first GTT to the application.

Abstract: In a distributed processing system having multiple processing nodes including alive nodes and dead nodes, a method is provided for collecting an object from the alive nodes. The method includes maintaining a separate count value for each of remote nodes at which the object is remotely-referenced. The method further includes suppressing a collection of the object when the separate count value for any of the remote nodes is non-zero. The method also includes clearing the separate count value for a given one of the remote nodes when the given one of the remote nodes is dead.

Abstract: File measurements are computed and stored in persistent memory of a deduplicated storage system as files are written or on demand, where the file measurements are used to estimate storage requirements for storing a subset of files. The file measurements are accumulated into an initial measurement at a first point in time and a final measurement at a second point in time to obtain an estimate of any change in a quantity of unique segments required to store the subset of files in the deduplicated storage system between the first and second points in time. Future storage requirements can be estimated based on a computed rate of change in the amount of storage required to store the subset of files between the first and second points in time.

Abstract: Various embodiments relate generally to data science and data analysis, computer software and systems, and wired and wireless network communications to provide an interface between repositories of disparate datasets and computing machine-based entities that seek access to the datasets, and, more specifically, to a computing and data storage platform that facilitates consolidation of one or more datasets, whereby a collaborative data layer and associated logic facilitate, for example, efficient access to, and implementation of, collaborative datasets. In some examples, a method may include receiving a dataset having a data format into a dataset ingestion controller configured to form a collaborative dataset, interpreting data of the dataset against data classifications at an inference engine to derive at least an inferred attribute, associating the data with annotative data identifying the inferred attribute, and converting the dataset at a format converter to form an atomized dataset.

Abstract: A method includes retrieving event analytics data for a software application installed on a plurality of user devices. The event analytics data indicates a number of times each of the application states of the software application were accessed by the user devices. The method further includes mapping function names to the application states accessed by the user devices, each of the function names indicating a functionality associated with the software application. The method further includes determining a usage fraction value for each of the function names, the usage fraction value for each function name indicating the number of times the function name was mapped relative to the number of times each of the function names was mapped. Additionally, the method includes receiving a search query, generating search results based on at least one of the usage fraction values, and transmitting search results.

Abstract: Methods and systems for indexing document passages are presented. In some embodiments, a computing device may identify a plurality of documents that comprise a plurality of passages. A passage index comprising a plurality of entries may be generated. Each entry may comprise keywords from a passage of the plurality of passages in one of the plurality of documents. Each entry may further comprise at least one annotation associated with the passage. A search query comprising at least one search keyword may be received. The passage index for each document of the plurality of documents may be analyzed using the at least one search keyword to identify at least one passage from the plurality of documents that matches the search query. In response to the query, the at least one passage may be presented.

Abstract: Systems for managing large database systems. Storage devices hold a set of one or more subject database tables that hold subject data accessed by one or more users. A data definition statement to perform a table alteration operation (e.g., a table partition operation) over a particular table in the subject database is received, parsed, and the table alteration operation over the particular table is initiated. During the processing of the data definition statement to complete the table alteration operation, a data manipulation statement to perform a table access operation over the same table is received and parsed. The data manipulation statement is not blocked, even while the table alteration operations are ongoing. Rather, during the time that the table alteration operations are ongoing, the data manipulation statement is processed using hidden tables. After the table alteration operations have completed, incoming data manipulation statements are performed over the altered database tables.

Abstract: A method includes encoding a data object using an encoding matrix having a unity matrix portion to produce a plurality of sets of encoded data slices that includes data encoded slices and redundancy encoded slices. The method further includes dividing a task into a set of partial tasks. The method further includes determining processing speeds of a set of distributed storage and task (DST) execution units allocated for storing the plurality of sets of encoded data slices. The method further includes mapping storage and partial task assignments regarding the data encoded slices of the plurality of sets of encoded data slices to the set of DST execution units based on the processing speeds. The method further includes outputting the data encoded slices of the plurality of sets of encoded data slices and the set of partial tasks to the set of DST execution units in accordance with the storage-task mapping.

Abstract: Methods, systems, and computer program products for generating probabilistic annotations for entities and relations using reasoning and corpus-level evidence are provided herein. A method includes determining candidate entities and candidate relationships between entities from text contained within textual documents associated with a given domain; generating questions to support or refute legitimacy of a given one of the candidate entities and/or a given one of the candidate relationships; automatically determining an answer to each of the questions based on analysis of one or more additional items of knowledge pertaining to the given domain; computing a confidence score for each answer; and assigning a confidence value in support of the legitimacy of the given one of the candidate entities and/or the given one of the candidate relationships, wherein said confidence value is based on an aggregation of the confidence scores for the answers to the one or more questions.

Abstract: A method includes a primary storage unit receiving a first write request including a first key and a first value; persisting the first value in a first non-volatile memory in association with the first key; broadcasting the first write request and a first set of globally-durable keys to secondary storage units; receiving, from the secondary storage units, an acknowledgement of the first write request and a first set of locally-durable keys, each of the first sets of locally-durable keys including the first key; the primary storage unit receiving a second write request including a second key and a second value; persisting the second value in the first non-volatile memory in association with the second key; and broadcasting the second write request and a second set of globally-durable keys to the secondary storage units, the second set of locally-durable keys including the first key. A system is also disclosed.

Abstract: An apparatus has a processor and a memory connected to the processor. The memory stores instructions executed by the processor to receive a relational query at a semi-structured document database. An access permissions index is looked-up for available documents for a user submitting the relational query. The relational query is resolved against relational schema within a relational schema index for the available documents to produce secure relational query results. The secure relational query results are supplied.

Abstract: Methods for ranking search results are disclosed. The methods include obtaining an unranked set of functionally similar search that all correspond to an action. The methods further include retrieving a ranking vector corresponding to the action. The ranking vector identifies a plurality of software applications that perform a function corresponding to the action and a ranking range for each of the plurality of software applications. The methods further include iteratively ranking the functionally similar search results of the unranked set to obtain a ranked set of functionally similar search results. The ranking is based on the retrieved ranking vector and a random number generator that generates random numbers between the minimum value and the maximum value of the ranking vector.

Abstract: A method of clustering changes to configuration items in an information technology (IT) system, including collecting changed configuration items executed on computer stations connected in a network implementing the information technology system, storing the collected configuration items in a database, analyzing contextual information related to the configuration items to identify clusters having similar characteristics, clustering the configuration items based on the identified clusters having similar characteristics, and assigning a descriptor to each cluster to identify it as an IT action.

Abstract: A data streaming environment provides a summary of streaming data from a sensor that is an Internet of things device. An input interface receives the streaming data. A processor is communicatively coupled to the input interface for processing the streaming data. The processed streaming data includes, but is not limited to, a plurality of records and variables that describe a characteristic of a physical object. A computer-readable medium has instructions stored thereon that, when executed by the processor, cause the processor to execute a correlation update application with the received streaming data to provide a correlation between two variables of the streaming data. The non-transitory computer-readable medium further stores sum and bin data for the correlation update application to compute the correlation. The output interface provides the processed streaming data to be visually presented in one or more data graphs on a display device.

Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for generating and providing converted content.

Abstract: This disclosure relates to systems and methods for expanding a social network. A method includes generating respective social graphs for two or more entities, calculating one or more social metrics for each of the two or more entities using the respective social graphs, retrieving one or more performance metrics for each of the two or more entities, correlating the social metrics and the performance metrics to generate one or more associations between the social metrics and the performance metrics, and transmitting a recommendation for a requesting entity.