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

Relational Schema Representation for Table with Complex Head

为在关系型数据库中有效地表示复杂表头表格,研究单层、多层双表头表格的规范形式,提出森林表头指标矩阵的表示方法与以森林表头为代表的复杂表格到关系模式的行/列和单元映射及其压缩映射方法。分析结果表明,上述方法的语义保全性和存储效率较高,直观易用,可推广应用于更复杂的网状表头表格。

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.