Development of Distributed Database System for Educational Information

本课题的主要目的是形成标准的教育信息数据格式，并开发支持数据库建设和利用的程序。经过两年的开发，研究成果如下：教育信息在质量和数量上都是多种多样的，因此以相同的数据结构处理教育信息数据库是非常重要的。标准数据格式（SDF）由三个元素组成：标签代码、数据长度和数据本身。这种结构非常简单，适用于几乎所有的教育信息。SDF有两种类型，适用于磁带文件和磁盘文件，也可以处理EBCDIC和ASCII（日本汉字中的JEF和JIS）。支持数据库建设和利用的程序开发我们已经开发了近百个支持数据库建设的程序，这些程序都是在SDF中结构化的。以及它的利用率。这些程序具有主机厂商开发的数据库系统通常不支持的功能。程序分为几个部分：1)数据有效性检查，2)转换，3)数据编辑，4)记录编辑，5)统计报告，6)打印输出，7)KWIC列表，8)其他。由于几乎所有的程序都是用FORTRAN编写的，因此它的可移植性非常好。

Our research project mainly aims to form the standard data format for educational information and to develop programs which support construction of database and its utilization. The research results of two Years development are as follows.1. The standard data format(SDF) Educational information is full of variety both in its quality and quantity, so it is very important that database for educational information is processed in the same data structure. The standard data format (SDF) consists of three elements which are the tag code, the data length and data itself. This structure is very simple and applicable to almost all educational information. There are two types of SDF which are applicable for magnetic tape file and disk file, and also SDF can handle both EBCDIC and ASCII (JEF and JIS in Kanji).2. The development of programs which support construction of database and its utilization We have developed about one hundred programs to support construction of databases which are structurized in SDF. and its utilization. These programs have functions which are usually not supported in database system developed by main frame maker. Programs are grouped in several as 1)validity checking of data, 2)conversion, 3)editing of data, 4)editing of record, 5)statistical report, 6)printout, 7)KWIC list, and 8)others. As almost all programs are written in FORTRAN, its portability is very good.