复杂表头表格的关系模式表示  

Relational Schema Representation for Table with Complex Head

作　　者：杨海涛[1] 

机构地区：[1]广东省建设信息中心总工程师室

出　　处：《计算机工程》2011年第4期49-51,54,共4页Computer Engineering

基　　金：广东省建设厅电子政务基金资助项目(粤建办发[2008]4号)

摘　　要：为在关系型数据库中有效地表示复杂表头表格,研究单层、多层双表头表格的规范形式,提出森林表头指标矩阵的表示方法与以森林表头为代表的复杂表格到关系模式的行/列和单元映射及其压缩映射方法。分析结果表明,上述方法的语义保全性和存储效率较高,直观易用,可推广应用于更复杂的网状表头表格。Aiming at how to express efficiently charts with complex heads in relational databases, this paper studies several norm forms of charts with double heads in single-or multi-tiers, puts forward first the index matrix expression method for chart heads in index-forest form, the row/column and element mapping methods as well as their compressing methods for representing complex charts, especially those with index-forest heads, onto relational schemes. Analysis results show that this method has storage semantic conservation and efficiency. It is intuitive and facile, and can be extended for more complex charts with heads in network form.

关 键 词：复杂表头表格 关系模式 表达能力 多维数据模型 

分 类 号：TP311.12[自动化与计算机技术—计算机软件与理论]