Sybase中多个代码表相关联查询技术的探讨

Discuss the Query about more Related Code-table in Sybase

数据库的操作中经常涉及到一个基本表和多个代码表相关联的查询,该问题影响到数据处理的完整性以及对查询的快速响应和查询结果的保存,文章对其成因进行了分析,充分利用表和视图之间的转化关系,给出了解决该问题的一个新的基本思路,本文结合Sybase11.0及PB7.0编程技术,在元宝山露天矿管理信息系统中的职工档案管理对这一方法进行了验证。

The question of query about related one base _table and more code _ table is often faced in the Sybase, it affects the integrality of database and immediately response、saving result of query, in this paper, the author analyses the cause of this question , making use of conversion between table and view, putts forward one new way ,with sybase11.0 and Powerbuilder7.0, the method is validated in worker document management of YBS-MIS.