工程数据库多参数存储技术的研究

Research on Multi-parameter Storage Technology Based on Engineering Database

大量的工程应用都涉及到数据库的设计方法,同一类型的工程对象(也称为实体)往往具有不同的属性。文章提出了多参数存储技术,即在关系型数据库中合理地存储不同工程对象的多种属性参数,并实现参数的便捷化管理、极小化数据库存储空间等。文章从关系型数据库优化应用的角度提出了一种多参数存储技术解决方案,以数控刀具参数管理为例,研制了一套基于多参数存储技术的关系型数据库检索算法,分析了基于多参数存储技术方案的性能并进行了测试。

The application of massive projects all involves the design method of database, the congeneric project objects （ called entity） often to have the different attributes. The multi - parameter storage technology is put forward. The many kinds of attribute parameters of the different project objects are reasonably memorized in the relational database, and the convenient management of the parameters is realized. Besides, the database storage space also can be minimized. One kind of multi - parameter storage technology is proposed from the point of view of optimization application of the relational database. The parameter management of the NC cutting tools is taken as an example. A searching algorithm of relational database based on the multi - parameter storage technology is developed. Finally, the capability of the algorithm is analyzed and tested.