Development of Distributed Database System for Educational Information

教育信息分布式数据库系统的开发

• 批准号: 63410017
• 负责人: OIKAWA Akifumi
• 金额: $ 7.42万
• 依托单位: National Institute for Educational Research
• 依托单位国家: 日本
• 项目类别: Grant-in-Aid for General Scientific Research (A)
• 财政年份: 1988
• 资助国家: 日本
• 起止时间: 1988 至 1989
• 项目状态: 已结题
• 来源: https://kaken.nii.ac.jp/grant/KAKENHI-PROJECT-63410017/
• 关键词: Educational Information; Distributed Database; Utility Software for Database; データベース; 分散型

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.

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