Abstract: Aspects provide for automatic verification of JavaScript Object Notation (JSON) data by making a JSON call via an Extensible Markup Language (XML) Hypertext Transfer Protocol (HTTP) HTTP object against a data warehouse data item stored in a back end server. JSON response data returned from the back end server in response to the JSON call is converted into actual XML result data that includes a first plurality of XML statements. A Structured Query Language (SQL) query is executed against the data warehouse data item, and expected XML result data generated in response thereto that include a different (second) plurality of XML statements. The JSON response data returned from the back end server is thereby verified in response to matching the actual XML result data to the expected XML result data.

Abstract: The present disclosure describes systems and methods for managing and implementing an asset license reclamation program across a network. The status of an asset, such as computer software, is automatically determined and if the asset does not meet particular use criteria, the asset may be flagged for reclamation and/or redeployment, either within the same network segment or in a separate network segment.

Abstract: An index shared between a plurality of tables is used to access a data sharing space (DSS) storing a set of rows from a base table having a plurality of rows with stored data. First data values of the index are identified in response to a query for a table. A subset of rows is then retrieved from the DSS using the index elements corresponding to the first data values. Second data values and some of the first data values are then identified in response to a second query for a table. A second subset of rows are then retrieved from the DSS using the index elements corresponding to the second data values and some of the first data values and the query is then applied to the subset of rows.

Abstract: Database report subscription technology, in which subscriptions are delivered to multiple, different recipients on a customized basis. In response to detection of an event that triggers generation and delivery of a database report, customized versions of the report are generated for the multiple, different recipients based on a definition of the data used to generate the report included in the subscription, report parameters that define presentation aspects of the report included in the subscription, and profile data associated with at least one of the multiple, different recipients. The customized versions of the report include at least a first version of the report and a second version of the report that differs from the first version of the report and the customized versions of the report are delivered to the multiple, different recipients.

Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for evaluating substitute terms. One of the methods includes receiving a query having an original term and determining one or more substitution contexts for the original term, wherein a substitution context includes one or more context terms and an indication of a position in the query of the original term and the one or more context terms. The substitution contexts are classified into a first category or a second category based on a respective score of each substitution context. The original term is associated with one or more substitution contexts in the first category.

Abstract: A method of extracting unclassified data from a collection of data including both classified data and unclassified data, includes: providing a plain text format file including a plurality of attributes; using the attributes to identify unclassified data within a collection of data that includes a combination of unclassified and classified data; and extracting the identified unclassified data from the collection of data. An apparatus that implements the method is also provided.

Abstract: Embodiments include methods, systems and computer program products a for offloading multiple processing operations to an accelerator includes receiving, by a processing device, a database query from an application. The method also includes performing analysis on the database query and selecting an accelerator template from a plurality of accelerator templates based on the analysis of the database query. The method further includes transmitting an indication of the accelerator template to the accelerator and executing at least a portion of the database query on the accelerator.

Abstract: The disclosed computer-implemented method for storing updated storage stack summaries may include (1) analyzing a storage stack to determine a structure of the storage stack, (2) storing a summary of the structure of the storage stack to a database, (3) intercepting a command directed to the storage stack that causes a change to the structure of the storage stack, and (4) updating only that portion of the summary of the structure in the database that is affected by the change to the structure of the storage stack instead of updating the entire summary. Various other methods, systems, and computer-readable media are also disclosed.

Abstract: The invention concerns a device (D) for assigning time information to a main multimedia content related to a given object. To this end, said device comprises: a clustering module (4) configured to cluster a set of auxiliary multimedia contents with time information and related to said object, so as to deliver clusters comprising some of said auxiliary multimedia contents; a determining module (5) configured to determine a time data for each cluster; a computing module (6) configured to compute a distance between the main multimedia content and each of said clusters, an assigning module (7) configured to assign to the main multimedia content, the time data of the cluster having the smallest distance said amongst computed distances.

Abstract: A system and method for spatial data processing are described. Path bundle data packages from a viewing device are accessed and processed. The path bundle data packages identify a user interaction of the viewing device with an augmented reality content relative to and based on a physical object captured by the viewing device. The path bundle data packages are generated based on the sensor data using a data model comprising a data header and a data payload. The data header comprises a contextual header having data identifying the viewing device and a user of the viewing device. A path header having data identifies the path of the interaction with the augmented reality content. A sensor header having data identifies the plurality of sensors. The data payload comprises dynamically sized sampling data from the sensor data. The path bundle data packages are normalized and aggregated. Analytics computation is performed on the normalized and aggregated path bundle data packages.

Abstract: A system and method for querying a database is disclosed. Database tables are represented as nodes in a model. Each node is associated with at least one leaf. The nodes can be interconnected with one another. A model input is received by a server from a client device, the model input including a starting node, one or more leaves, and optionally one or more filters. A query is executed against a database based on the model input. A subsequent query can be generated by selecting a result of the first query. Also disclosed is a technique for cancelling queries.

Abstract: A method of indicating the popularity of the subject of a search query comprising receiving a search query from a user, the search query being received by a search server; determining whether the search query is likely to be related to a particular thing; obtaining popularity information for the particular thing; and, transmitting an indicator of the popularity information to a user computer for display. Some embodiments may also include targeted information about the search query subject, including a map showing the search query subject's location, the location of similar things in the same region as the search query subject, one or more advertisements, and the like. The targeted information and/or the popularity information indicator may be displayed with, or separate from search results associated with the search query.

Abstract: A method of producing search results is disclosed. The method comprises, at a computerized search engine system distinct from a client system: receiving a search request associated with a user from the client system, the search request having one or more search terms; obtaining a user profile corresponding to the user, where the user profile is generated based in part on the user's prior computing activities, comprising one or more of browsing, searching, and messaging; obtaining search results for the search request; generating a personalized snippet for at least one of the search results in accordance with the obtained user profile, the snippet comprising a text portion of the search result chosen based on at least one or more search terms and one or more terms of the obtained user profile; and transmitting the search results and personalized snippet to the client system for display.

Abstract: A cleaning application that can clean, for one or more user profiles, at least one of one or more files of a computer or a registry of the computer is provided. The cleaning application can include a cleaning module. The cleaning module can select a plurality of user profiles of the computer. The cleaning module can further select at least one of a file location or a user profile hive for each user profile of the plurality of user profiles. The cleaning module can further clean at least one of one or more files stored within the file location or a registry stored within the user profile hive for each user profile of the plurality of user profiles.

Abstract: A system for providing an auto-complete query to a user terminal includes a query indexing unit configured to index search queries. Each of the search queries is associated with location information. The indexing includes incorporating the location information into an associated one of the search queries. At least one of the search queries being a previously provided auto-complete query. The system includes a keyword generating unit configured to generate a keyword by incorporating location information associated with the user terminal into a query inputted by the user terminal. The system includes a query providing unit configured to determine that at least one of the indexed search queries corresponds to the generated keyword, and provide, to the user terminal, the determined at least one of the indexed search queries as the auto-complete query.

Abstract: A method filters data in data visualizations. The method retrieves a set of tuples from a database according to user selection. Each tuple includes a same set of fields. The method identifies a relation between tuples. The relation is a non-empty set of ordered pairs of tuples from the set of tuples. The method receives selection of one or more filter conditions for the tuples, where at least one of the filter conditions uses the relation. The method receives selection of an aggregation level, which includes one or more fields from the set of tuples. The method then displays a data visualization based on aggregating the set of tuples at the selected aggregation level to form a set of aggregated tuples, and displays each aggregated tuple as a visible mark. Each tuple that satisfies all of the filter conditions is included in an aggregated tuple; all other tuples are excluded.

Abstract: Techniques for performing database operations using vectorized instructions are provided. In one technique, a hash table build phase involves executing vectorized instructions to determine whether a bucket in a hash table includes a free slot for inserting a key. A number of data elements from the bucket are loaded in a register. A vectorized instruction is executed against the register may be used to determine a position, within the register, that contains the “smallest” data element. If the data element at that position is zero (or negative), then it is determined that the corresponding position in the bucket is an available slot for inserting a key and corresponding data value.

Abstract: A method constructs data visualizations. The method receives a visual specification, which includes properties and corresponding user-selected property values. The visual specification defines a data visualization layout. One property value identifies source databases for the data visualization. The method constructs node queries from the visual specification corresponding to one or more data fields in the source databases. The method also constructs link queries from the visual specification corresponding to a relationship between rows of the source databases. The method retrieves node tuples from the database that satisfy at least one of the node queries and retrieves link tuples from the database that satisfy at least one of the link queries. The method displays visual marks corresponding to the retrieved node tuples and displays edge marks in the corresponding to the retrieved link tuples. Each edge mark visually connects a pair of visual marks corresponding to the node tuples.

Abstract: An index shared between a plurality of tables is used to access a data sharing space (DSS) storing a set of rows from a base table having a plurality of rows with stored data. First data values of the index are identified in response to a query for a table. A subset of rows is then retrieved from the DSS using the index elements corresponding to the first data values. Second data values and some of the first data values are then identified in response to a second query for a table. A second subset of rows are then retrieved from the DSS using the index elements corresponding to the second data values and some of the first data values and the query is then applied to the subset of rows.

Abstract: System, method, and computer program product to order query results, by processing a received query at least in part using a composite key index, wherein the composite key index comprises at least two key columns, wherein the at least two key columns comprise at least one pre-ordering column and an ordering column, wherein the query specifies ordering criteria to order a result set based on values of the ordering column, wherein the processing comprises receiving, from the composite key index, an ordering column value for each unique pre-ordering column value in the composite key index, identifying a first ordering column value as being ordered first according to the ordering criteria, and returning the first ordering column value as being responsive to the query.