数据整形技术在提高检索记录集效率中的应用

Application of Data Shaping Technique to Improve the Efficiency of Retrieval Record Sets

在两个数据库间作一个简单的INNERJOIN操作,虽然在SQL中这是一个简单的任务,但是使用直接的SQL语言会产生性能问题。文中简要介绍了数据整形技术,通过实例研究为什么SQLjoin命令的效率低,并且使用数据整形技术来解决这个问题,从而提高了检索记录集的效率。

INNER JOIN, a simple operation, is done between two databases. Although this is a straightforward task, direct usage of SQL can produce performance problem. Data shaping technique is briefly introduced in this paper. Why the command of join in SQL is inefficient is also studied by examples. And data shaping has the capacity to solve this problem. Accordingly, the efficiency of retrieval record sets is greatly improved.