Abstract: A raw dataset including measures and dimensions is processed, by a preprocessing module, using an algorithm that produces a preprocessed dataset such that at least one type of statistical analysis of the preprocessed dataset yields equal results to the same type of statistical analysis of the raw dataset. The preprocessed dataset is then analyzed by a statistical analysis module to identify subsets of the preprocessed dataset that include a non-random structure or pattern. The analysis of the preprocessed dataset includes the at least one type of statistical analysis that produces the same results for both the preprocessed and raw datasets. The identified subsets are then ranked by a statistical ranker based on the analysis of the preprocessed dataset and a subset is selected for visualization based on the rankings. A visualization module then generates a visualization of the selected identified subset that highlights a non-random structure of the selected subset.

Abstract: Embodiments of the systems and methods disclosed herein provide a prescriptive analytics platform and polarity analysis engine in which a user can identify a target objective and use the system to find out whether the user's objectives are being met, what predictive factors are positively or negatively affecting the targeted objectives, as well as what recommended changes the user can make to better meet the objectives. The systems and methods may include a polarity analysis engine configured to determine the polarity of terms in free-text input in view of the target objective and the predictive factors and use the polarity to generate the recommended changes.

Abstract: Methods, systems, and apparatus, for receiving a native application search result that identifies a native application and a first URI that causes the native application to display a native application page that includes content responsive to the query; determining, at the user device, whether the user device has a native application installed that can process the first uniform resource identifier (URI) of the native application search result; in response to determining that the user device does not have a native application installed that can process the first URI, processing, at the user device, a second URI that can be processed by the first application, where the second URI, when processed, causes the first application to display a first application page that includes content responsive to the query; wherein the content included in the first application page and the content included in the native application page are synchronized content.

Abstract: In one embodiment, a method of processing a structured query language (SQL) statement is provided, comprising: determining whether a first query and a second query are equivalent, the first and second queries being respectively the left side and the right side operands of the OUTER JOIN operation; determining whether a SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation; and responsive to determining that the first query and the second query are equivalent and that the SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation, transforming the SQL statement into an optimized query SQL statement by removing the OUTER JOIN operation.

Abstract: Techniques for search with more like this refinements are disclosed. In some embodiments, search with more like this refinements includes receiving a product and a context (e.g., the context can include related category information, user context, and/or other context related information); generating a search query based on the product and the context; and determining a plurality of products that match the search query to generate more like this search results.

Abstract: Systems, methods, and computer-readable medium, are disclosed for transforming user-defined-function invocations in a query-based environment. A user-defined-function (UDF) and a query invoking the UDF are received. The UDF is parsed into a plurality of statements. A first expression tree corresponding to the UDF and a second expression tree corresponding the query are constructed, and merged using an operator to generate a transformed expression. The transformed expression is simplified, using transformation rules, if it is determined that is can be simplified.

Abstract: A method for guided keyword-based exploration of data stored in a database includes providing, with a processing device, valid query templates for the data, wherein the provided valid query templates include static parts and dynamic parts; selecting those of the provided valid query templates that match a user-provided keyword; generating valid queries from the selected valid query templates using the data; and querying the data using a user-selected valid query selected from the generated valid queries.

Abstract: A method, system and computer-usable medium for providing composite cognitive insights comprising receiving streams of data from a plurality of data sources; processing the streams of data from the plurality of data sources, the processing the streams of data from the plurality of data sources performing data enriching and generating a sub-graph for incorporation into a cognitive graph; processing the cognitive graph, the processing the cognitive graph providing a plurality of individual cognitive insights; generating a composite cognitive insight, the composite cognitive insight being composed of the plurality of individual cognitive insights; and, providing the composite cognitive insight to a user via a set of cognitive media content.

Abstract: A supplemental data report generation device may interface with one or more databases to generate a supplemental data report document for reporting actions of an aggregate user reporting entity. The device may retrieve a set of criteria for the supplemental data report, such as a set of items to be covered by the report, an action property, and a reporting rule based on the action property. The device may review action records stored in a record data store and identify actions that have the action property. Operational attributes associated with the plurality of actions may be identified through the action records. The device may use the operational attributes associated with the action records to determine if they are subject to the reporting rule, and these actions may be included in the supplemental data report.

Abstract: A method begins by storage units of a dispersed storage network (DSN) receiving a retrieval request for a data object, where each storage unit stores a unique group of encoded data slices of the data object and a local set of encoded recovery data slices. The method continues with some storage units sending the unique group of encoded data slices to a requesting computing device and with one storage unit sending an encoded recovery data slice to the requesting computing device. The method continues with the requesting computing device identifying an errant unique group encoded data slice, correcting the errant encoded data slice based on received data slices to produce an updated unique group of encoded data slices, and dispersed storage error decoding the updated unique group of encoded data slices and the unique groups of encoded data slices from other storage units to recover the data object.

Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for enhancing search results. In one aspect, a method includes receiving a query. A plurality of search results responsive to the query are identified. The search results are analyzed to determine that at least a first search result is associated with a first answer box topic. The search results are provided along with an answer box precursor for the first answer box topic.

Abstract: The present application present systems and methods for leveraging existing sources of information to supplement and enhance job opening postings and other types of business postings. A plurality of sources, including social network sites, talent profiles, and/or surveys and questionnaires are accessed in order to retrieve data relating to a business object. The retrieved data is transformed, such that it may be used to supplement job opening postings and other types of postings with job description data, work culture data, and other business-related data in order to build a social brand for the business.

Abstract: In one embodiment, a method of processing a structured query language (SQL) statement is provided, comprising: determining whether a first query and a second query are equivalent, the first and second queries being respectively the left side and the right side operands of the OUTER JOIN operation; determining whether a SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation; and responsive to determining that the first query and the second query are equivalent and that the SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation, transforming the SQL statement into an optimized query SQL statement by removing the OUTER JOIN operation.

Abstract: A tool for standardized layout transformations of BIDI data exchanged between legacy and modern systems is provided. The tool retrieves client connection information from a client request for data. The tool determines, based, at least in part, on the client connection information, a client application's operating system. The tool determines whether the data requested in the client request is BIDI data. Responsive to a determination that the data requested is BIDI data, the tool initiates a layout transformation of the data requested at a single point within the database server. The tool returns transformed BIDI data to the client application.

Abstract: Methods and apparatuses are disclosed for synchronizing data inputs generated at a plurality of frequencies by a plurality of data sources. A device receives a first set of data points from a first data source of the plurality of data sources generated at a first frequency of the plurality of frequencies, receives a second set of data points from a second data source of the plurality of data sources generated at a second frequency of the plurality of frequencies, selects a time window corresponding to a period of time during which at least a subset of the first set of data points and at least a subset of the second set of data points were generated, and generates a vector representing a first reduced form of the subset of the first set of data points and a second reduced form of the subset of the second set of data points.

Abstract: An apparatus for processing Mediation Bridge Ontology (MBO) based on ontology alignment patterns. The apparatus includes an MBO strategy design pattern component to have a plurality of strategy design pattern classes, to request, from a Pattern Relationship Model (PRM) component, a PRM for execution of the plurality of strategy design pattern classes, to receive the requested PRM from the PRM component, to execute a strategy design pattern using the received PRM, to acquire alignment information from the executed strategy design pattern, and to store the acquired alignment information, an MBO mediation pattern component to add a new class to the MBO strategy design pattern component through an interface used for communicating with other objects, and the PRM component to have a plurality of PRMs, and, in response to a request from the MBO strategy design pattern component, to provide a PRM to the MBO strategy design pattern component.

Abstract: The present disclosure describes techniques and apparatuses for a hardware-implemented Adelson-Velskii and Landis' (AVL) tree module. In some aspects, commands are received at the AVL tree module that request operations be performed for an AVL tree table stored in memory. Each command is written to one of multiple hardware threads of the AVL tree module that perform AVL tree operations by causing records of the AVL tree table to be read from memory using a single read operation and then written to the AVL tree module, modifying those records without accessing memory, and causing modified records to be written back to memory using a single write operation. Once a command is written to a hardware thread, the hardware thread can perform the corresponding AVL tree operation. After the AVL tree operation is performed, results are returned to the requesting agent to indicate whether the AVL tree operation was performed successfully.

Abstract: A system and method for database storage may be dynamically optimized for entity-attribute-value (EAV) data. In one embodiment, this dynamic EAV database may include one column for the entity identification (“ID”) and a second column for the serialized data for that ID (each attribute and the values for those attributes). The database may be dynamically updated to move or copy certain attributes to a separate column. The dynamic updating of one or more attributes may be based on certain factors (seasonal, temporal, usage, etc.), such as frequent requests for a particular attribute. This dynamic updating and indexing of particular attributes may improve certain queries and data requests.

Abstract: An in-memory database system stores the entirety of a database that is being operated on by a database system within main memory. The database includes a table that comprises a plurality of rows including a particular row. The database table comprises a first version of the particular row having a first valid time, and a second version having a second valid time. Index(es) are associated with the database table. Each index is implemented as a lock-free data structure and references the plurality of rows, including referencing the first and second versions of the particular row. A transaction acting on the first version of the particular row is executed. The first version of the particular row is visible to the transaction based on the first valid time and the second version of the particular row being not visible to the transaction based on the second valid time.

Abstract: The processing of transaction oriented data tends to be row-oriented, while the processing of analytical operations tends to be column-oriented. Various systems, sometimes referred to as operational data warehouses, may comprise mechanisms adapted for use in scenarios where both transactional data processing and analytical queries are to be performed efficiently. The operational data warehouse (ODW) may perform and update data efficiently by maintaining a table in structures comprising a column store, a delta store, a delete bitmap, and a delete buffer. In this environment, key values may be associated for each row such that the ODW may more efficiently seek rows. Further, rows may also be excluded from a column store based at least in part on a filter criterion. The filtering criterion may be used to filter out rows based on a created predicate set by a user or the system.