摘要
探讨在数据范式约束下进行Oracle数据库的设计,符合范式下的数据表可以大大减少数据冗余,便于插入、删除和更新,保持数据的完整性,使数据库的维护更加方便。但范式下的数据表一般不宜直接输出,本文对范式下数据表的动态交叉表生成的方法进行了研究,并给出了具体的代码。
The design of Oracle database based on the paradigm of students＇ mark table was discussed. Under this datasheet, the repeated and unnecessary data were reduced greatly. It is easy to insert, delete and update and maintain the integrity of data. The maintenance of database became more convenient, but the data are not suitable to output directly. The generation of dynamic crcestab was probed into and the concrete codes were given in this paper.
出处
《计算机与现代化》
2005年第9期57-59,共3页
Computer and Modernization
关键词
数据范式
表结构
动态
交又表
data paradigm table configuration dynamic crosstab
