Abstract: Various embodiments may operate to access individual lines of information included in a file stored in an electronic storage medium, to detect the existence of data clusters in the file based on neighboring cell content in a horizontal direction (corresponding to the individual lines), and in a vertical direction (orthogonal to the horizontal direction), to identify at least some of the data clusters as being associated with predefined table types (comprising vertical tables, horizontal tables, or cross tables), to merge some of the data clusters into section tables having common properties, and to transform the tables resulting from the merging activity, as well as remaining un-merged data clusters, into a single flat table. The stored file may comprise a spreadsheet file.

Abstract: Apparatus, systems, and methods may operate to receive an original query plan, to transform the original query plan into an equivalent executable compact query plan, and to store the compact query plan on a machine readable device. Further activities may include computing maximal source sub-queries associated with the compact query plan, and computing semi-join reductions of the maximal source sub-queries to provide an executable derivative query plan, which may also be stored on a machine readable device. Additional apparatus, systems, and methods are disclosed.

Abstract: A computer readable storage medium includes executable instructions to analyze a query associated with a report to identify query clauses. The query is applied against a data source that does not have a specified time dimension. An optimized audit log is formed from an existing audit log to store data changes of interest at the data source and temporal values associated with the data changes, where each data change corresponds to a query clause. A state table is constructed to specify the state of each query clause. Records in the optimized audit log are processed by temporal value to produce updated state tables. Transition tables are derived from the updated state tables to associate temporal values with data changes at the data source that impact a result produced by the query. Trend data is then supplied from the transition tables.

Abstract: Described herein is a technology for facilitating searching and matching of data. In some implementations, an input data string, including one or more ideographic elements, is received and converted to a Latin-based input data string. One or more input keys may be generated based on the Latin-based input data string. A reference database may be searched for one or more candidate records indexed by at least one of the one or more input keys. If the one or more candidate records are found, a match score is determined for the one or more candidate records.

Abstract: A system includes reception of a query filtered on an object of a hierarchical list of values and comprising a first filter value, generation of an SQL script based on the first filter value and at least one ancestor value of the first filter value in the hierarchical list of values, and retrieval of a data set associated with the query based on the SQL script. In some aspects, reception of the query includes reception of a command to refresh a document including the query and a prompt on a filter value, presentation of the prompt and the hierarchical list of values, and reception of the first filter value.

Abstract: A computer-readable medium to direct a computer to function in a specified manner includes executable instructions to: generate a set of qualitative assessments; convert the set of qualitative assessments into a set of quantitative assessments; produce a quantitative forecast from the set of quantitative assessments; and translate the quantitative forecast to a qualitative forecast.

Abstract: A computer-implemented system may include determination of a similarity of a semantic projection of a set of interests of a first user to a semantic projection of a first resource, wherein the semantic projection of the set of interests of the first user and the semantic projection of the first resource conforms to a common semantic projection model. Also included may be determination of a semantic interest of the first user for the first resource in a first context based on the similarity of the semantic projection of the set of the interests of the first user to the semantic projection of the first resource, and determination of an interest measure associated with the first user, the first resource and the first context based on a rating prediction for the first user to the first resource in the first context and on the determined semantic interest of the first user for the first resource in the first context.

Abstract: The invention includes a computer readable medium with executable instructions to receive a query based on nested semantic abstractions for corresponding data sources. Data source specific queries are constructed based on the query by executing the query against the nested semantic abstractions. Each data source specific query is associated with an underlying data source described by a nested semantic abstraction. The data source specific queries are executed to produce results and the results are returned.

Abstract: Various embodiments of systems and methods for dynamic visualization of search results on a GUI are described herein. A search query received by a user is divided into a plurality of search parts. One or more search results for each of the plurality of search parts are retrieved. Further, a search result array is generated from the retrieved search results. Furthermore, Venn diagram graphical representation of the search results in the search result array is determined and the same is displayed on the GUI. The Venn diagram graphical representation defines display of search results in the Venn diagram and the relevancy ranking of the search results. In addition, the user can specify a weighting for each of the plurality of search parts, which dynamically determines display opacity of at least one of the associated search results and search part circles of the Venn diagram on the GUI.

Abstract: A pie chart comprising a pie having at least two slices and a selector head is displayed in a graphical user interface. The selector head is rotatable around a circular selection assist track having a center point corresponding to a center point of the pie. In addition, the graphical user interface can display information associated with/complementary to a first selected slice. Thereafter, user-generated input is received changing a position of the selector head from the first slice to a second slice. This movement of the selector head causes information associated with the second slice to be displayed in the graphical user interface. In some implementations, a highlight display unit and/or a legend can also be provided. Related apparatus, systems, methods, and articles are also described.

Abstract: Apparatus, systems, and methods may operate to receive, sequentially, individual lines of information included in a file stored in an electronic storage medium; to locate one or more tables in a spreadsheet when at least two of the lines in a sequence are consecutive lines that begin with a non-empty cell and have a matching length; to determine a vertical orientation or a horizontal orientation of the tables based on an arrangement of the information within the lines and across the lines; and to create metadata from the information, based on the arrangement. The metadata may comprise object label names, object qualifications, and/or object data types. Additional apparatus, systems, and methods are disclosed.

Abstract: A computer readable storage medium comprises executable instructions to provide a workspace for a user to define an expression with expression components from a graphical palette associated with the workspace. Placeholders are indicated in the workspace for the expression components to be added by the user. The placeholders are associated with a data type. The data type is enforced for each placeholder. A structured visual representation of the expression is provided on the workspace.

Abstract: A system and method to map a set of words to a set of ontology terms, the method including determining a starting point for ontologies including terms matching a set of words, determining a term set corresponding to the set of words in an ontology context of each of the starting points, ranking the term sets determined for all of the starting points, and providing an output of the term sets in a ranked order.

Abstract: Described herein are methods and systems for pattern recognition in web search engine result pages. The input data is a result page from a web search engine as well as an integer number for the results on the page. The output is a regular expression that matches all the results on the page, capturing each result and its individual fields.

Abstract: Described herein is a technology for facilitating searching and matching of data. In some implementations, an input data string, including one or more ideographic elements, is received and converted to a Latin-based input data string. One or more input keys may be generated based on the Latin-based input data string. A reference database may be searched for one or more candidate records indexed by at least one of the one or more input keys. If the one or more candidate records are found, a match score is determined for the one or more candidate records.

Abstract: A system and method for dynamic generation of contextual charts for reports based on personalized visualization preferences are described. In one embodiment, a system of an embodiment creates a chart for a report based on an analysis of past user preferences. In one embodiment, a system of the embodiment saves user behavior and preferences over time.

Abstract: Various embodiments of phonetic keys for the Japanese language are described herein. A Kana rule set is applied to Kana characters provided by a user. The Kana characters are defined in an alphabetic language based on the sound of the Kana characters. A full phonetic key is then generated based on the defined Kana characters. A replaced-vowel phonetic key is generated by replacing a vowel in the full phonetic key and a no-vowel phonetic key is generated by removing the vowel in the full phonetic key. Kana records in a database are then processed to determine a relevant Kana record that has a phonetic key identical to at least one of the full phonetic key, the replaced-vowel phonetic key, and the no-vowel phonetic key. The relevant Kana records are then presented to the user.

Abstract: A system to process unstructured data is provided. An example system to process unstructured data comprises a receiver to access a source of unstructured data, an entity type module to determine an entity type, a rules generator to automatically generate a linguistic rule based on the determined entity type, and an entity extractor to obtain an entity from the source of unstructured data, using the linguistic rule. The entity comprises an alpha-numeric string.

Abstract: A computer readable storage medium includes executable instructions to convert an entity to a standard form including normalized attributes, a tag reference and a feature. The entity is expanded with corresponding variants. The standard form and corresponding variants are combined to form an annotated entity in a first processing step. The entity is assigned to a group in a second processing step that accesses the annotated entity. The entity is processed in a single pass comprising the first processing step and the second processing step.

Abstract: Disclosed is a user interface on a display for editing data transformations comprising an ETL process. A first display area presents a data representation of a data transformation. A second display area presents a view of input data, and a third display are presents a view of output data. User input to modify the data transformation is received. In response to receiving the user input, the third display area is updated with output data generated by applying the modified data transformation to the input data.