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 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: 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: 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: 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: 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: Described herein is a technology for facilitating searching and matching of data. In accordance with one implementation, first and second feature sets are extracted. The first feature set is associated with an input data string including one or more first ideographic elements, while the second feature set is associated with a candidate string including one or more second ideographic elements. A match score of the candidate string is determined based on the first and second feature sets.

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: 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: 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: 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.

Abstract: A method and system for highlighting portions of a graph based on exception highlight rules is described. Highlight rules for a graph are received from a selection of a portion of an axis of the graph. Portions of the graph satisfying the highlight rules are identified. Visualization on the graph is generated to highlight the identified portions of the graph satisfying the highlight rules.

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: A database query is modified to improve performance by identifying portions of database tables that are likely to be reused and modifying the database query accordingly. According to certain embodiments, the degree of selectivity with which a table is accessed is used to identify tables that are likely to be reused in subsequent database operations.

Abstract: A method and system for visualization interaction design for cross-platform utilisation is described. The system includes a unified user interface interaction module and a visualization module. The visualization module generates an interactive graph for data visualization. The unified user interface interaction module includes a unified user interface module configured to receive an operation on the interactive graph. The unified user interface module includes a pointer user interface module and a touchscreen user interlace module. The visualization module updates the interactive chart from the operation on the interactive graph with the corresponding user interlace module.