Abstract: A member naming system is provided for naming members of a dimension in a data analyzing system having a receiver for receiving a pattern. One example of the dimension is a time dimension containing time periods. The pattern has a sequence of pattern components for defining a name. A time period is defined by a start time, an end time, a relationship and a level in a single time hierarchy. The time period naming system further has an interpreter for interpreting the sequence of pattern components, and a generator for generating the time period name based on the interpretation of the sequence of pattern components within a context of the relationship of the time period in the time hierarchy.

Abstract: Updating values in a multidimensional database is provided. Responsive to receiving a value for updating a first cell, a set of first component cells, a set of subsequent component cells, a set of first target cells, a set of subsequent target cells; and a set of unmarked component cells are determined. The first cell, the set of first target cells, and the set of subsequent target cells are marked as changed cells. The set of first component cells and the set of subsequent component cells are marked as allocated cells. The set of unmarked component cells are marked as required cells. Calculations are performed for the first cell, the set of first component cells, the set of subsequent component cells, the first target cells, and the set of subsequent target cells; and only cells marked as changed cells are updated based on the calculations.

Abstract: A method and a system for updating values in a multidimensional database. The method includes the steps of receiving a value for updating a cell in the multidimensional database; and determining a component cell of the cell. The component cell affects the cell through a formula. The cell receiving the input and the component cell are then marked. The method further determines a target cell, affected by the cell or the component cell through an additional formula. The target cell is also marked. The method may further include the steps of identifying an additional formula for the component cell or the target cell; determining an unmarked component cell through the additional formula; and marking the unmarked component cell. The method may further place values of the marked cells in a multidimensional space without triggering allocations, calculates a new state.

Abstract: A member naming system is provided for naming members of a dimension in a data analyzing system having a receiver for receiving a pattern. One example of the dimension is a time dimension containing time periods. The pattern has a sequence of pattern components for defining a name. A time period is defined by a start time, an end time, a relationship and a level in a single time hierarchy. The time period naming system further has an interpreter for interpreting the sequence of pattern components, and a generator for generating the time period name based on the interpretation of the sequence of pattern components within a context of the relationship of the time period in the time hierarchy.

Abstract: A fast and efficient system and method for retrieving data from a database system by a process external to the database system is provided, in which the database system accepts and processes data requests in a second query language in response to data queries issued in a first query language by the external process. The system comprises an interface module operatively coupled to the external process and the database system. Upon receiving a data query in the first query language from the external process, the interface module generates an equivalent data request in the second query language and sends the data request to the database system for processing and data retrieval. The interface module then transfers the retrieved data from the database system to the module and returns the 4data to the external process. The interface module operates as a plurality of independent co-operating processes handling at least in part concurrently various steps of the data query processing.

Abstract: A fast and efficient system and method for retrieving data from a database system by a process external to the database system is provided, in which the database system accepts and processes data requests in a second query language in response to data queries issued in a first query language by the external process. The system comprises an interface module operatively coupled to the external process and the database system. Upon receiving a data query in the first query language from the external process, the interface module generates an equivalent data request in the second query language and sends the data request to the database system for processing and data retrieval. The interface module then transfers the retrieved data from the database system to the module and returns the 4data to the external process. The interface module operates as a plurality of independent co-operating processes handling at least in part concurrently various steps of the data query processing.