A METHOD AND SYSTEM FOR A RELATIONAL DATA MODEL FOR INTEGRATED MANAGEMENT AND ANALYSIS OF GENERALIZED N-DIMENSIONAL TABULAR DATA WITH MULTILINGUAL SUPPORT

摘要

A database system includes at least one first parameter value table having a multiplicity of parameter value identifiers each corresponding to a respective data record and a multiplicity of object of analysis identifiers each corresponding to the respective data record. The database system further includes a collection table having a multiplicity of collection identifiers, and a parameter table having a multiplicity of parameter identifiers each associated with a respective one of the collection identifiers of the collection table. The database system also includes a dimension role table having a multiplicity of role identifiers each associated with a respective dimension identifier and a respective one of the parameter identifiers of the parameter table, an object of analysis table having a multiplicity of object of analysis identifiers of the at least one parameter value table, each object of analysis identifiers being associated with a respective one of the dimension identifiers of the dimension role table, and a record index part table having a multiplicity of record identifiers each associated with a respective one of the parameter identifiers of the parameter table, a respective one of the role identifiers of the dimension role table, and a respective one of the object of analysis identifiers of the object of analysis table. The database system further includes a record table having a multiplicity of parameter value identifiers of the at least one parameter value table, each parameter value identifier being associated with a respective one of the record identifiers of the record index part table.