发明名称 SYSTEM TO GENERATE A STRUCTURED QUERY LANGUAGE QUERY BY USING A DIMENSIONAL HIERARCHY
摘要 A tree-structured database is collapsed into a two-column table. The two-column table includes a characteristic key value for a given leaf node in the first column and the system identification (SID) relating to the characteristic key value in the second column and also identifying the node that leads to the characteristic key value. Data is presented by coupling the characteristic key value with a transaction table. A query that is formulated in an infocube may be translated to a relational data base query, collapsed, and reformulated into an infocube result set, or vice versa.
申请公布号 US2009070359(A1) 申请公布日期 2009.03.12
申请号 US20070851417 申请日期 2007.09.07
申请人 NOLAN ELLEN 发明人 NOLAN ELLEN
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项
地址