Fusion general ledger
A database system combines a general ledger and a multi-dimensional database. The general ledger and multi-dimensional database are mapped such that relationships between the general ledger and multi-dimensional database are characterized with metadata dimensions. Using the mapping, data can be received into the general ledger and stored in both the general ledger and multi-dimensional database substantially simultaneously. Further, a synchronization of the data copies changes to the data automatically from the general ledger to the multi-dimensional database. Thus, there is no manual copying of data between the general ledger and the database. Further, the latency between the general ledger and database is minimal ensuring accurate analysis even contemporaneous with the input of the data.
1. A method executed in a computer system including a processor and memory for storing data, the method including:
receiving data for a cell in a general ledger;
determining an identifier for the cell;
determining a cube in a multidimensional database associated with the cell,
wherein the determining of the cube in the multidimensional database associated with the cell comprises:
receiving metadata with the data for the cell,
reading a definitional file,
comparing a cell identifier in the metadata with two or more cell identifiers in the definitional file, and
when the cell identifier in the metadata compares to the cell identifier in the definitional file, reading two or more dimensional characteristics from the definitional file that define the location of the cube in the multidimensional database; and
writing the data to the general ledger and the multidimensional database simultaneously.
2. The method as defined in claim 1 , wherein determining the identifier for the cell comprises:
receiving metadata with the data for the cell; and
reading a cell identifier in the metadata.
3. The method as defined in claim 1 , wherein determining the cube in the multidimensional database associated with the cell comprises:
receiving metadata with the data for the cell; and
reading two or more dimensional characteristics in the metadata defining the location of the cube in the multidimensional database.
4. The method as defined in claim 1 , further comprising:
receiving an identification of a portion of the general ledger;
determining an identifier for the portion of the general ledger;
determining a ledger identifier for the general ledger;
receiving a dimensional characteristic for the multidimensional database, the dimensional characteristic defining a portion of the multidimensional database associated with the portion of the general ledger;
writing a definitional file including the identifier for the portion of the general ledger, the ledger identifier, and the dimensional characteristic; and
publishing the definitional file.
5. A non-transitory computer-readable storage medium having sets of instructions storage thereon which, when executed by a computer, cause the computer to:
receive data for a cell in a general ledger;
determine an identifier for the cell;
determine a cube in a multidimensional database associated with the cell, wherein the determining of the cube in the multidimensional database associated with the cell comprises:
receiving metadata with the data for the cell,
reading a definitional file,
comparing a cell identifier in the metadata with two or more cell identifiers in the definitional file, and
when the cell identifier in the metadata compares to the cell identifier in the definitional file, reading two or more dimensional characteristics from the definitional file that define the location of the cube in the multidimensional database; and
write the data to the general ledger and the multidimensional database simultaneously.
6. A system comprising:
a non-transitory computer-readable storage medium;
a processor in communication with the non-transitory storage medium having sets of instructions storage thereon which, when executed by the processor, cause the processor to:
receive data for a cell in a general ledger;
determine an identifier for the cell;
determine a cube in a multidimensional database associated with the cell, wherein the determining of the cube in the multidimensional database associated with the cell comprises:
receiving metadata with the data for the cell,
reading a definitional file,
comparing a cell identifier in the metadata with two or more cell identifiers in the definitional file, and
when the cell identifier in the metadata compares to the cell identifier in the definitional file, reading two or more dimensional characteristics from the definitional file that define the location of the cube in the multidimensional database; and
write the data to the general ledger and the multidimensional database simultaneously.