一种类图转化为关系数据库的自适应算法研究

摘要

An adaptive algorithm for translating class diagram into relational database is proposed. The class diagram is generated with Rational Rose, and represented by Java language. The Java source code text as an algorithm is executed. The keywords of "class", "attribute" and "relation" are compared by means of specific algorithm to discriminate their classes, natures and relations. After the setting description for the names of database tables, and the type and size of attribute fields is completed, the algorithm is executed in MYSQL database and SQL commands are generated to establish the relative database and tables. It shows that this algorithm can reduce error probability and time of translation.%提出了一种将类图转化为关系数据库RDBS的算法,首先使用Rational Rose工具创建类图,并使用Java语言对其进行描述；其次,将源代码文本作为算法执行,通过特定算法比较“class”,“attribute”和“relation”等关键字,区分出类、属性和关系；在完成数据库表的名称、属性字段的类型及大小等设置描述后,在MYSQL数据库中执行该算法,生成SQL命令创建数据库和表.这种算法能减少类图与关系数据库之间转化的出错概率和时间.