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: Methods, systems, and computer program products for visually representing and displaying data are described. The visual representation may be a data animation. A data query may be submitted, a time measurement for processing the query may be obtained, and a sample size of the query may be adjusted based on the time measurement and a frame refresh rate of a data animation. A data animation may be generated based on one or more results of the query.

Abstract: Methods, systems, and computer-readable storage media for receiving data, displaying the data visualization based on the data, the data visualization being displayed within a GUI and being provided as a histogram including a first plurality of bins, the first plurality of bins being defined based on default binning parameters, receiving user input, the user input being input to the data visualization using the GUI and indicating a first operation, providing user-defined binning based on the user input, and displaying a modified data visualization based on the data and the first operation, the modified data visualization being displayed within the GUI and being provided as a histogram including a second plurality of bins, the second plurality of bins being defined based on the user-defined binning parameters and being different from the first plurality of bins.

Abstract: Systems and methods to provide automatic tree restriction are provided. In example embodiments, sizing parameters for a display location are determined. Data to be graphically displayed within the sizing parameters is accessed. A determination is then performed to determine if restriction of nodes associated with the data is needed based on the sizing parameters. If needed, restriction is performed based on the determination. The restriction is performed based on predetermined criteria established prior to the determining of the sizing parameters and the accessing of the data. A graphical display of the data within the sizing parameters may then be rendered.

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: A computer readable storage medium includes executable instructions to retrieve a dataset from a data source, where the dataset includes a first set of categories. A data structure that represents the dataset is built. A first set of merit values for the first set of categories is calculated. The first set of categories is ordered based on a criterion. The first set of categories is returned.

Abstract: An apportioned queue data structure allows a server to specify allocation of resources to return requests according to a prescribed usage request. The data structure comprises an input queue comprising of a set of subqueues (also known as windows). Windows contain requests that will be processed over a fixed window of time. Received items are removed from the input queue and packed into the subqueues according to the service level agreement. These windows (and the elements present within) are then processed in the order of the windows queue (and the order in the window) are arranged. The time for each task is not known until after the request is processed and may be estimated. In a steady state of high load, a queue is created that returns requests tending toward requested percentages of the service level agreement.

Abstract: A method for determining access to a data table store includes determining static properties of data sources during query design, loading the static properties into an unavailability table, at query execution evaluating dynamic properties of the data sources and updating the unavailability table, evaluating a preference expression by a table dispatcher component using session context information from the availability table, determining if a preferred table is available at query execution, and if available indicating to access the preferred table, else applying unavailability rules to obtain repair actions. The preference expression including a user-defined preference between an original table and its replica and user-defined repair actions, where a selection is made at query execution between an original data table and a replicated data table based on the unavailability rules. A non-transitory computer readable medium and a system for implementing the method are also disclosed.

Abstract: Methods, systems, and apparatuses for processing function calls using a hooking routines to perform pre-execution tasks are disclosed. A server computer receives a function call including a hooking routine and a request to run a particular function from a client computer. Based on a function group identifier and the credentials of the user or client computer, the server computer can perform various pre-execution tasks. The tasks can be common to all functions in the function group or be customized Both pre-execution tasks can be stored remotely from the client computer, so that updates to the pre-execution task can be made without the need to update computer readable code stored on the client computer. If the pre-execution tasks, such as an authorization, passes, then the server computer can execute the requested function, the server computer can reject or abort the requested function.

Abstract: Described are methods and systems related to analyzing data within a data report. The data report, including a result set and metadata associated with the result set is retrieved. The result set is analyzed to identify one or more fields. Dimensions and measures within the result set are inferred. Based upon the inferred dimensions and measures, a user interface element is rendered on a user interface. The user interface element is utilized to define a query. Based upon the query defined in the user interface element, a measure included in the query is aggregated along a dimension included in the query, to create a collection of aggregations. A visual representation of the collection of the aggregations is rendered on the user interface.

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: A method and system are presented of automatically suggesting rules for data stored in a table, with the table comprising a plurality of columns. The table is profiled to identify a content type for each of one or more of the plurality of columns. A rule knowledge base is accessed to locate rules specified for identified content types. Then, one or more of the located rules specified for identified content types are presented as suggestions. Acceptance of one or more of the suggested rules is received from a user, and the received validations are stored in the rule knowledge base. The accepted rules are applied to data for quality detection and monitoring. Embodiments are also described where columns are suggested based on a given rule.

Abstract: Example systems and methods of providing a connection with a backend processing system are presented. In one example, a request for a connection between the backend processing system and a user of an application is received. One of a plurality of connections with the backend processing system is selected. Each of the plurality of connections is bound with a corresponding generic user session in the backend processing system. In response to the request, the selected connection is unbound from a generic user session and bound with a user session corresponding to the user of the application. Access to the selected connection is provided to the user of the application.

Abstract: Systems and methods for information exchange using generic data streams, wherein a data stream is sent from one computer system to another, and the receiving computer system is not aware of the structure of the information in the data stream. A header of the data stream includes a description of a data object. A body of the data stream includes information for instances of a data object stored on a computer system. The object is compliant with the description provided in the header of the data stream. The information in the body of the stream is extracted based on the description provided in the header of the data stream. A user interface (UI) is dynamically created based on the description of data object to display portions of the received information, and further to allow a user to change the information.

Abstract: Methods, systems, and computer program products for visually representing and displaying data are described. One or more cells may be selected from a plurality of displayed cells in a crosstab, wherein the subset of cells has a context defined at least by one or more rows and one or more columns. An effect may be selected to apply on the subset of cells, wherein the effect includes an embedded query including parameters drawn from context of the subset of cells. A selected effect on a subset of the plurality of displayed cells may be applied. Effects may include lens effects, brush effects, and box-in/box-out effects.

Abstract: Various embodiments of systems and methods for generating multidimensional tags to analyze tagged contents are described herein. One or more predetermined tag dimensions and one or more predetermined measures associated with web content are recorded when at least one tag core is defined. The predetermined tag dimensions provide quantitative metrics describing how the tagged content has evolved. For example, time at which tagged content is consumed, user groups consuming the tagged content, and the like. The predetermined measures provide quantitative metrics describing how the tagged content is consumed such as through browsing, downloading, and the like. The tag core, the recorded predetermined tag dimensions and the recorded predetermined measures are assembled to generate a multidimensional tag.

Abstract: Described are methods and systems related to data report and analysis. A first business intelligence (BI) block is imported to a host analytics user interface (UI). The first BI block includes synchronizable dimensions to synchronize values of the first BI block with other BI blocks, and propagatable dimensions to propagate values of the first BI block to other BI blocks. A host data context of the host analytics UI is updated by propagating the propagatable dimensions of the first BI block. A second BI block is imported to the host analytics UI. The second BI block includes at least one synchronizable dimension in common with at least one propagatable dimension of the first BI block. The synchronizable dimensions of the second BI block are synchronized to the updated host data context. The first BI block and the synchronized second BI block are rendered on the host analytics UI.

Abstract: A computer-implemented system member selector module is described. The member selector module comprises presentation module, a request detector, and a tree view updater. The presentation module presents a tree view representing hierarchically organized data comprising a plurality of member nodes. The request detector detects a request to apply a selection function to one or more member nodes. The tree view updater updates the tree view in response to the request and produces an updated tree view that identifies the one or more member nodes as parameters of the selection function.

Abstract: Disclosed are methods and systems for cell content alignment. The methods and systems involve retrieving one or more table parameters, the one or more table parameters including size of currently invisible cells in a display window, size of merged cells, the display window size and text size in the merged cells, calculating a position of a text in a visible portion of merged cells based on the table parameters and displaying the text in the merged cells based on the calculated position of the text.

Abstract: Various embodiments of systems and methods for providing a semantic guidance in a report are described herein. A mismatch is identified between a report object positioned at a location on the report and the area with which the location is associated. The mismatch is identified based on the metadata of the report object and the attribute of the area with which the location is associated. In one embodiment, the identified mismatch is displayed to a user in a tooltip. In one embodiment, if an attribute of an area of the report is changed, the mismatch is identified between the report object present in the area and the changed attribute.