Patent application number | Description | Published |
20090094215 | Extended Handling Of Ambiguous Joins - A system, method and article for handling ambiguous joins among a plurality of tables based on a query are disclosed. Metadata associated with the plurality tables is generated. The metadata comprises ambiguous join dimensions and special measures, where the ambiguous join dimensions provide a list of all dimensions used in conditions of the query that are ambiguous, and the special measures provide a list of measures that are affected by the ambiguous join dimensions. Data is aggregated in the plurality of tables according to an aggregation level expressed in the query and based on the metadata. | 04-09-2009 |
20090094486 | Method For Test Case Generation - A system and method for providing randomly-generated test cases for a set of interfaces of a piece of software are disclosed. A test case generator is initialized with parameter arrays S | 04-09-2009 |
20100005114 | Efficient Delta Handling In Star and Snowflake Schemes - In one aspect there is provided a method for handling deltas being posted to a repository, database, or other Business Information Warehouse (BW). The method includes receiving, at a delta handler, absolute data without an indication of a change between the received absolute data and data posted to a repository including a fact table. Identifiers are created for the received absolute data. The absolute data including the created identifier is written into a temporary table. One or more deltas are determined by performing a join of the temporary table and the fact table of the repository. The deltas correspond to the indication of the change between the received absolute data and the data posted to the repository. The delta handler provides the one or more deltas to be posted to the fact table of the repository. Related systems, apparatus, methods, and/or articles are also described. | 01-07-2010 |
20100250543 | EFFICIENT HANDLING OF MULTIPART QUERIES AGAINST RELATIONAL DATA - A query having multiple parts may be processed to form an intermediate results set. This intermediate results set may be partitioned into a plurality of groups. Thereafter, the groups may be sorted into a plurality of containers so that each container contains data sufficient to calculate one requested result in the multipart query. Related techniques, apparatuses, systems, and computer program products are also described. | 09-30-2010 |
20120130942 | OLAP Execution Model Using Relational Operations - In one embodiment the present invention includes an OLAP execution model using relational operations. In one embodiment, the present invention includes, a method comprising receiving a first query in an online analytic processor (OLAP) executing on one or more computers, the OLAP generating and comprising a model specifying a graph defining a plurality of nodes and a plurality of tiers, each node corresponding to a different operation on data. A second query is generated by the OLAP. The second query includes a plurality of layered subqueries each corresponding to one of the nodes in the graph for specifying the different operations on data. The second query is received in a relational engine coupled to the datastore. The relational engine executes the second query, and in accordance therewith, retrieves data. | 05-24-2012 |
20140108331 | OLAP Execution Model Using Relational Operations - In one embodiment the present invention includes an OLAP execution model using relational operations. In one embodiment, the present invention includes, a method comprising receiving a first query in an online analytic processor (OLAP) executing on one or more computers, the OLAP generating and comprising a model specifying a graph defining a plurality of nodes and a plurality of tiers, each node corresponding to a different operation on data. A second query is generated by the OLAP. The second query includes a plurality of layered subqueries each corresponding to one of the nodes in the graph for specifying the different operations on data. The second query is received in a relational engine coupled to the datastore. The relational engine executes the second query, and in accordance therewith, retrieves data. | 04-17-2014 |
20140149462 | PROCESSING OF COLUMNAR DATA - A system includes reception of a calculation, identification of operands of the calculation, and a source column of a table including values associated with the operands and used in the calculation, creation, for each operand, creation of a column including the value associated with that operand in a row of the column associated with that operand, column-wise aggregation of the values of the created columns into a single row, execution of the calculation using the values of the single row and create a result column including a result of the calculation, and addition of the result column as a row of the table. | 05-29-2014 |
20140289183 | KEY FIGURE DATA FILTERS IN OLAP WITH HEIRARCHIES - A system and method of key figure data filters are presented. The key figure data filters are implemented in an analytical engine of a business warehouse system. The key figure data filters employ conditions, which can be expressed as a kind of selection that describe a set. A key figure data algorithm can be implemented by the analytical engine using the conditions, yet still respect hierarchies in the business warehouse database. | 09-25-2014 |
20140372368 | Removing Group-By Characteristics in Formula Exception Aggregation - In one embodiment, a method receives a query for analyzing data in a database. The query includes a first level calculation that is performed before a second level calculation. The method determines an operator in the query configured to explicitly remove group by information for a reference characteristic in the first level calculation where the group by information is specified for the reference characteristic in the second level calculation. The first level calculation is performed by removing the group by information for the reference characteristic for the first level calculation to determine a first level calculation result and the second level calculation is performed using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result. | 12-18-2014 |
20140379742 | HOMOGENEITY EVALUATION OF DATASETS - A system includes reception of an instruction to evaluate homogeneity of a first set of values of a plurality of stored sets of values, determination of a first minimum of the first set of values, determination of a first maximum of the first set of values, determination of whether the first minimum and the first maximum are equal, and if it is determined that the first minimum and the first maximum are equal, return of a value equal to the first minimum and the first maximum in response to the instruction. | 12-25-2014 |
20140379754 | Operators for Constants in Aggregated Formulas - In one embodiment, a method receives a query for analyzing data in a database. The method then determines a constant in the query and determines an operator applied to the constant in the query. The operator explicitly controls a behavior of the constant. The constant is represented as a scalar representation in the query instead of as a vectorial representation where the constant would have been used as the vectorial representation without the use of the operator due to a rule governing use of constants. Then, the method performs a calculation for the query to determine a query result using the constant as the scalar representation. | 12-25-2014 |