Abstract: Formulas in dashboards can be executed at a client executing web technologies such as HTML5 and JavaScript. The formulas specified by a spreadsheet file are transformed into a pre-defined notation format and then recursively evaluated. Related apparatus, systems, techniques and articles are also described.

Abstract: The disclosure generally describes computer-implemented methods, software, and systems for presenting error information. An indication is received of a selected error for a product installation. Installations are identified having a matching stream, build number and error. Other builds in a same stream having the same error are identified. Information is provided for displaying a graph having a horizontal line graph including first nodes representing builds in the same stream having the same error. Other occurrences of the error in builds of other streams are identified. Information for updating the graph is provided with parallel lines for each of the other streams, each parallel line including second nodes representing builds. An oldest one of the first nodes and second nodes is identified. Information is provided for presenting a list of potential changes occurring before the date associated with the oldest node and that are candidates for causing the error.

Abstract: Techniques for obtaining data from unstructured data for a structured data collection include receiving unstructured data that includes text; identifying an attribute associated with a structured data collection; obtaining at least one of historical data associated with the attribute or additional data associated with a user of the computing system; identifying one or more terms from the unstructured data as being associated with the attribute based on at least one of the historical data or the additional data; and storing the identified one or more terms in a data record of the unstructured data collection.

Abstract: Described herein is a technology for a dashboard used for visualizing data. In some implementations, a dashboard with one or more dashboard item is provided. Performance of the dashboard is evaluated to determine a load time of the dashboard. Possible suggestions for improving performance of the dashboard are provided if performance issues are determined from evaluating performance of the dashboard.

Abstract: Methods, systems, and computer-readable storage media for determining data structure and field types of a data source that is to be processed by an application. Actions include receiving the data source, providing base data associated with the data source, determining a number of fields of the data source and, for each field, a field type based on the data source and the base data, generating data structure data, the data structure data comprising the number of fields and field types, and providing the data structure data to the application.

Abstract: Techniques for processing semi-structured data include receiving semi-structured data, a value of the semi-structured data being associated with a key; identifying a structured data collection, the structured data collection being associated with a category and having a plurality of attributes; obtaining at least one of historical data associated with the plurality of attributes or additional data associated with a user of the computing system; mapping the key to an attribute of the plurality of attributes based on at least one of the historical data or the additional data; and storing the value in a cell of a data record of the structured data collection, the cell being associated with the attribute that was mapped to the key.

Abstract: Described herein is a descriptive framework to facilitate data visualization. In accordance with one aspect of the framework, one or more module manifests are provided, wherein a module manifest describes a module that represents a particular component of a visualization. A chart manifest may be used to coordinate the one or more module manifests. A visualization may be rendered based on the chart manifest.

Abstract: Systems and methods for resuming data transformations, such as broken or otherwise unsuccessful data transformations, are described. In some example embodiments, the systems and methods receive a message that indicates a broken data transformation of a data table between a source database and a destination database, identify a maximum and/or largest and greatest value for a date attribute contained within an index column for all rows of the data table that were successfully loaded to the destination database during the data transformation, and select a group of rows of data of the data table stored in the source database by querying the source database to identify rows that include a value for the date attribute that is greater than the identified value.

Abstract: A computer-implemented method of profiling a data set in a parallel processing environment includes vertically partitioning an initial data set. One or more attribute subsets are then profiled. A list of subjects is generated each corresponding to a specific attribute value identified in the profiling. Values of multiple attributes are extracted for each identified subject, and the sample results are assembled and merged.

Abstract: Systems and methods are disclosed for analyzing application code changes. The method may include adding instrumentation code to a selected one or more of a plurality of software objects associated with an application, when a corresponding object class for the selected software objects matches at least one preferred object class. In response to at least one application-related event, detecting using the instrumentation code, one or more state changes of the selected software objects or one or more communications between at least two of the selected software objects. At least one baseline assertion may be generated using the instrumentation code based on the one or more state changes or communications. A notification may be generated upon detecting at least one subsequent assertion that does not match the at least one baseline assertion. A list with the at least one preferred object class may be accessed in a configuration file.

Abstract: In an example embodiment, a method of performing data profiling in an in-memory database is provided. A command requesting a data attribute calculation on data in the in-memory database may be received. A precreated procedure stored in the in-memory database may then be used to perform the data attribute calculation on the data in the in-memory database The precreated procedure may be described in a computer language utilized by the in-memory database. Finally, a result of the performing of the data attribute calculation may be returned to the client computer.

Abstract: Techniques for disambiguating data using contextual and historical information include determining that data is potentially associated with two or more classifications of a plurality of classifications; obtaining contextual information associated with the data; obtaining historical information associated with a user of the computing system; and determining that the data is more likely associated with one classification of the two or more classifications than other classifications of the two or more classifications based on the contextual information and the historical information.

Abstract: Embodiments include systems and methods for automated versioning of software on a client machine, allowing installation and updates over multiple platforms with modules written in different computer languages. In an embodiment, the client sends a list of installed modules to the server. This may be done by causing a client processor to perform method calls determining version information of the installed product. The server then checks the list and sends updates (if any) that are then automatically installed on the client. Some embodiments can perform software installation over-the-network, and prerequisite software may also be automatically installed on the client machine. The system may work on multiple platforms (e.g. Windows™, UNIX) and support multiple computer languages (e.g. C++, Java®, Python®, .NET, etc.).

Abstract: Systems and methods for converting structured data into database entries include receiving data values and metadata elements that form a data structure for the data values. The data values are converted into entries in database tables that are related according to the data structure formed by the metadata elements. The database table entries may be used to generate a webpage configured to report a metric of the data values.

Abstract: Techniques for data classification include matching one or more attributes of a commodity with one or more terms of a plurality of terms in a word matrix; generating, based on the matching, a vector for the commodity; and identifying, based on the vector, one or more classification regions that each define a classification of the commodity.

Abstract: Embodiments provide a data caching mechanism based on a user's request (query) to a remote database, and the corresponding response (query result) received therefrom. As part of a database query, the user can define cache parameter(s). When a viable communications link becomes available to access the remote database, volumes of relevant data are returned as a query result and cached locally according to those predefined cache parameter(s). Embodiments are particularly suited to allow a mobile device to interact with data of a remote database in an efficient and reliable manner. The mobile device's small form factor, may preclude local storage of large volumes of remotely stored data. However, this can be compensated for by selectively storing data in the cache memory according to user-specified parameters, allowing the mobile device to continue to have access to relevant information in the event that communication with the remote database is degraded or lost.

Abstract: In an example embodiment, a method of automatically generating data validation rules from data stored in a column of a table is provided. Outliers for the data are determined by analyzing a profiling statistic for the data, the profiling statistic having a type. Then it is determined if a predefined limit is exceeded, based on a quantity of the outliers determined for the data through the analysis of the profiling statistic. A data validation rule is then automatically generated based on non-outliers detected in the data through the analysis of the profiling statistic, the generated data validation rule also being based on the type of the profiling statistic. The data validation rule can then be applied to data subsequently entered for the column, causing at least a portion of the data subsequently entered for the column to be rejected.

Abstract: Example systems and methods of generating and distributing user-specified application information are presented. In one example, an informational code to be generated during execution of a software application is accessed. A character string specified by a first user of the software application that is descriptive of the informational code is received. The informational code and the character string are stored in a data storage device, which stores a plurality of information codes in association with corresponding character strings for the software application. The informational code is received in response to the first information code being generated during execution of the software for a second user. The character string is retrieved from the data storage device after the execution of the application based on the informational code, and transmitted for display to the second user.

Abstract: A method and system of transforming a query at a web server are provided. An abstract syntax tree representing the query can be traversed from the top down, for each node in the abstract syntax tree: labeling the node as being in a conjunct position when the node's parent is a WHERE node; labeling the node as being not in a conjunct position when the node's parent is an OR node; and labeling the node identically to the node's parent node when the node's parent is an AND node. Then any IN node in the abstract syntax tree can be transformed to an INNER JOIN node when the IN node is labeled as being in a conjunct position. The abstract syntax tree can be converted into a Structured Query Language (SQL) query, which can then be passed to a database for processing.

Abstract: Techniques for managing content on a computing device include identifying a data object including business data values defined in a structured format, the structured format including the business data values defined by two or more first dimensions and one or more second dimensions; determining a particular first dimension of the two or more first dimensions and a particular second dimension of the one or more second dimensions; generating a display grid that is displayable on a computing device, the display grid including a portion of the business data values corresponding to the particular first dimension and the particular second dimension; and preparing the display grid for display on the computing device.