Performance modeling of distributed database

1984 IEEE First International Conference on Data Engineering Pub Date : 1984-04-24 DOI:10.1109/ICDE.1984.7271320

M. Tsuchiya, M. P. Mariani

{"title":"Performance modeling of distributed database","authors":"M. Tsuchiya, M. P. Mariani","doi":"10.1109/ICDE.1984.7271320","DOIUrl":null,"url":null,"abstract":"This paper describes a simple yet effective distributed database model that simulates database utilization in the distributed data processing environment. The model is table driven such that database access requirements, file location, and other information necessary for defining the database environment are set up internally in several tables. Each database transaction is defined and represented by a transaction flow diagram (TFD) and a sequence of TFDs representing a operational scenario is input to the model. The model \"executes\" input TFDs by looking up tables that specify their data file access requirements. While executing TFDs, the history of database usage is logged and various statistics are gathered. The performance data are used to measure database access overhead, characterize database workload, and fine-tune performance by reallocating files. The model has been implemented in Fortran on the VAX 11/780 and has been used for both measuring the given database performance and analyzing sensitivity to design changes. It has proven to be an effective tool for analyzing design effectiveness of distributed databases.","PeriodicalId":365511,"journal":{"name":"1984 IEEE First International Conference on Data Engineering","volume":"1 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1984-04-24","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"1984 IEEE First International Conference on Data Engineering","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICDE.1984.7271320","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 1

Abstract

This paper describes a simple yet effective distributed database model that simulates database utilization in the distributed data processing environment. The model is table driven such that database access requirements, file location, and other information necessary for defining the database environment are set up internally in several tables. Each database transaction is defined and represented by a transaction flow diagram (TFD) and a sequence of TFDs representing a operational scenario is input to the model. The model "executes" input TFDs by looking up tables that specify their data file access requirements. While executing TFDs, the history of database usage is logged and various statistics are gathered. The performance data are used to measure database access overhead, characterize database workload, and fine-tune performance by reallocating files. The model has been implemented in Fortran on the VAX 11/780 and has been used for both measuring the given database performance and analyzing sensitivity to design changes. It has proven to be an effective tool for analyzing design effectiveness of distributed databases.

查看原文本刊更多论文

分布式数据库的性能建模

本文描述了一个简单而有效的分布式数据库模型，模拟了分布式数据处理环境下的数据库使用情况。该模型是表驱动的，因此数据库访问需求、文件位置和定义数据库环境所需的其他信息在几个表中进行内部设置。每个数据库事务由事务流程图(TFD)定义和表示，表示操作场景的TFD序列被输入到模型中。该模型通过查找指定其数据文件访问需求的表来“执行”输入tfd。在执行tfd时，将记录数据库使用的历史，并收集各种统计信息。性能数据用于度量数据库访问开销，描述数据库工作负载，并通过重新分配文件对性能进行微调。该模型已在VAX 11/780上用Fortran语言实现，并已用于测量给定的数据库性能和分析对设计变化的敏感性。它已被证明是分析分布式数据库设计有效性的有效工具。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

1984 IEEE First International Conference on Data Engineering

自引率

0.00%

发文量