| 数据交叉表在实际生活中的应用与理论分析 |
| |
| 引用本文： | 魏连秋,张义红.数据交叉表在实际生活中的应用与理论分析[J].衡水学院学报,2006,8(1):39-41. |
| |
| 作者姓名： | 魏连秋 张义红 |
| |
| 作者单位： | 1. 衡水学院,数学与计算机科学系,河北,衡水,053000
2. 衡水学院分院,信息技术系,河北,衡水,053000 |
| |
| 摘 要： | 数据库在计算机发展的今天已经越来越广泛地被使用,而数据库中数据的多种形式变换更是经常的,其中行列数据的变换是较难的,通过对该问题进行深入分析,联想到关系表中数据的逻辑形式,利用Excel的数据透视表和VFP中的交叉表来实现行列数据交换较为合适,进而利用SQL查询语句分析了行列数据交换的实质。
|
| 关 键 词： | 交叉表 数据透视表 视图 游标 SQL |
| 文章编号： | 1673-2065(2006)01-0039-03 |
| 收稿时间： | 10 20 2005 12:00AM |
| 修稿时间： | 2005年10月20 |
The Data Overlapping Table in the Practical Application and The Theory Analysis |
| |
| WEI Lian-qiu,ZHANG Yi-hong.The Data Overlapping Table in the Practical Application and The Theory Analysis[J].Journal of Hengshui University,2006,8(1):39-41. |
| |
| Authors: | WEI Lian-qiu ZHANG Yi-hong |
| |
| Institution: | 1. Mathematics and Computer Science Department, Hengshui University,Hengshui,Hebei 053000 China;2. Information Technology Department, Branch of Hengshui University,Hensshui,Hebei 053000 China |
| |
| Abstract: | The database developed in the computer today is already used more and more widely,but in the database the data form transformation is frequent.Rank data transformation is more difficult.Through the thorough analysis to this problem,associaing the data logical form in the relation table,we realize the rank data exchange in the Excel data perspective table and the VFP overlapping table is more appropriate,then analyze the rank data exchange essence with the SQL inquiry sentence. |
| |
| Keywords: | overlapping table Data perspective table View Vernier SQL |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
