| 范式下的Oracle数据库设计及其动态交叉表的生成 |
| |
| 引用本文： | 张新林.范式下的Oracle数据库设计及其动态交叉表的生成[J].计算机与现代化,2005(9):57-59. |
| |
| 作者姓名： | 张新林 |
| |
| 作者单位： | 罗定职业技术学院,广东,罗定,527200 |
| |
| 摘 要： | 探讨在数据范式约束下进行Orade数据库的设计，符合范式下的数据表可以大大减少数据冗余，便于插入、删除和更新，保持数据的完整性，使数据库的维护更加方便。但范式下的数据表一般不宜直接输出，本文对范式下数据表的动态交又表生成的方法进行了研究，并给出了具体的代码。
|
| 关 键 词： | 数据范式 表结构 动态 交又表 |
| 文章编号： | 1006-2475（2005）09-0057-03 |
| 收稿时间： | 2004-10-26 |
| 修稿时间： | 2004年10月26 |
Design of Oracle Database and Its Dynamic Crosstab Based on Data Paradigm |
| |
| ZHANG Xin-lin.Design of Oracle Database and Its Dynamic Crosstab Based on Data Paradigm[J].Computer and Modernization,2005(9):57-59. |
| |
| Authors: | ZHANG Xin-lin |
| |
| Abstract: | 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 crosstab was probed into and the concrete codes were given in this paper. |
| |
| Keywords: | data paradigm table configuration dynamic crosstab |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
