公开(公告)号：US5450584A

公开(公告)日：1995-09-12

申请号：US270785

申请日：1994-07-05

申请人： Kouichi Sekiguchi ,  Yojiro Morimoto ,  Miho Muranaga ,  Yoshikazu Yamashita

发明人： Kouichi Sekiguchi ,  Yojiro Morimoto ,  Miho Muranaga ,  Yoshikazu Yamashita

IPC分类号： G06F15/16 ,  G06F9/50 ,  G06F12/00 ,  G06F15/177 ,  G06F17/30 ,  G06F13/38

CPC分类号： G06F9/5088 ,  G06F17/30575 ,  G06F9/5083 ,  Y10S707/966 ,  Y10S707/99953

摘要： A distributed data-base communication network system includes a plurality of terminal stations which respectively contain data-base devices and which are associated with one another by means of data communication lines. A data-base management apparatus is provided in each of these stations and includes an internal load monitor device for monitoring the accessing load of the internal data-base device of the internal station and an external load monitor device for monitoring the accessing loads of the data-base devices of the external terminal stations. A data-base load distribution management device is connected to the monitor devices, and automatically transfers at least part of the data-base information of the internal data-base device to a selected one of the external terminal stations when the internal data-base accessing load has exceeded the maximum permissible level, thus enhancing the uniformity of distribution of the data-base load of the communication network.

摘要翻译： 分布式数据库通信网络系统包括分别包含数据基设备并且通过数据通信线路相互关联的多个终端站。 在这些站中的每一个中都提供数据库管理装置，并且包括用于监视内部站的内部数据库装置的访问负载的内部负载监视装置和用于监视数据的访问负载的外部负载监视装置 - 外部终端站的基站设备。 数据库负载分配管理装置连接到监视器装置，并且当内部数据库访问时，自动地将内部数据库装置的数据库信息的至少一部分传送到所选择的一个外部终端站 负载已超过最大允许电平，从而提高通信网络数据库负载分配的均匀性。

公开(公告)号：US5291594A

公开(公告)日：1994-03-01

申请号：US698115

申请日：1991-05-10

申请人： Koichi Sekiguchi ,  Nobuhiro Kato ,  Yojiro Morimoto ,  Miho Muranaga

发明人： Koichi Sekiguchi ,  Nobuhiro Kato ,  Yojiro Morimoto ,  Miho Muranaga

IPC分类号： G06F12/00 ,  G06F17/30 ,  G06F9/00

CPC分类号： G06F17/30575 ,  G06F17/30377 ,  Y10S707/922 ,  Y10S707/966 ,  Y10S707/99952

摘要： A distributed database system comprises a plurality of sites having a computer and a database, and interconnected by communication lines. In each computer, a transaction execution section executes data processing of transaction by accessing the database, according to a transaction generated by a transaction generation section or a transaction sent by another site. A list creation section creates a list of the sites which participate in the transaction generated by the transaction generation section, and sends the list to all other sites participating in the transaction. A commit preparation process section prepares the commit processing of the transaction when the transaction execution section has finished executing the data processing of the transaction and sends a commit preparation completion message to all participation sites. A commit process section executes commit processing of the transaction when it has received the commit preparation completion message from all participation sites within a predetermined period after sending the commit preparation completion message to them.

摘要翻译： 分布式数据库系统包括具有计算机和数据库的多个站点，并且通过通信线路互连。 在每个计算机中，事务执行部分根据由事务生成部分生成的事务或由另一个站点发送的事务来访问数据库来执行事务的数据处理。 列表创建部分创建参与事务生成部分生成的事务的站点的列表，并将列表发送到参与事务的所有其他站点。 提交准备过程部分在事务执行部分完成执行事务的数据处理时准备事务的提交处理，并向所有参与站点发送提交准备完成消息。 提交处理部分在向其发送提交准备完成消息之后，在预定时间段内从所有参与站点接收到提交准备完成消息时，执行事务的提交处理。

公开(公告)号：US5379424A

公开(公告)日：1995-01-03

申请号：US60506

申请日：1993-05-12

申请人： Yojiro Morimoto ,  Koichi Sekiguchi ,  Miho Muranaga ,  Nobuhiro Kato

发明人： Yojiro Morimoto ,  Koichi Sekiguchi ,  Miho Muranaga ,  Nobuhiro Kato

IPC分类号： G06F12/00 ,  G06F17/30 ,  G06F15/40 ,  G06F15/16

CPC分类号： G06F17/30575 ,  G06F17/30463 ,  Y10S707/922 ,  Y10S707/966 ,  Y10S707/99932 ,  Y10S707/99939

摘要： A distributed database management system includes a plurality of computers, each including a database for storing data files to be processed. The plurality of computers are interconnected by communication lines. Each computer has stored data file names, and corresponding address area and location information for all databases, and measures data file retrieval time from the databases. A retrieval time memory section stores data file retrieval times corresponding to the address areas of data stored in the databases. A retrieval time prediction section retrieves the data file retrieval times for data files corresponding to a data file name requested by a user when the requested data file is stored in at least two databases, utilizing stored data file retrieval times and corresponding address areas and location information on where the data file is stored. A data retrieval optimization section selects the database location information and the address area associated with the requested data file name according to the retrieval result by the retrieval time prediction section, and retrieves the requested data file from the appropriate database according to the location information and address area. The system can also register input data files according to a desired retrieval time.

摘要翻译： 分布式数据库管理系统包括多个计算机，每个计算机包括用于存储要处理的数据文件的数据库。 多个计算机通过通信线路互连。 每台计算机都存储了所有数据库的数据文件名，相应的地址区和位置信息，并从数据库中测量数据文件检索时间。 检索时间存储部存储与存储在数据库中的数据的地址区域对应的数据文件检索时间。 检索时间预测部，利用存储的数据文件检索时间和相应的地址区域以及位置信息，检索在请求的数据文件存储在至少两个数据库中时由用户请求的数据文件名称对应的数据文件的数据文件检索时间 存储数据文件的位置。 数据检索优化部分根据检索时间预测部分的检索结果选择与所请求的数据文件名相关联的数据库位置信息和地址区域，并根据位置信息和地址从适当的数据库检索所请求的数据文件 区。 系统还可以根据所需的检索时间寄存输入数据文件。

公开(公告)号：US5293627A

公开(公告)日：1994-03-08

申请号：US704581

申请日：1991-05-22

申请人： Nobuhiro Kato ,  Yojiro Morimoto ,  Miho Muranaga ,  Koichi Sekiguchi

发明人： Nobuhiro Kato ,  Yojiro Morimoto ,  Miho Muranaga ,  Koichi Sekiguchi

IPC分类号： G06F12/00 ,  G06F17/30 ,  H04J3/06 ,  G06F13/00

CPC分类号： G06F17/30575 ,  G06F1/14 ,  G06F17/30353 ,  H04J3/0679

摘要： A method for adjusting current clock counts in a distributed database apparatus is accomplished. Each processor assigns a timestamp to a transaction according to its clock when the transaction is generated, and transaction are executed by accessing the database according to timestamp order. A processor in at least a first one of the computer sites accesses an abort count corresponding to a second computer site; compares an abort count corresponding to the first computer site with the abort count corresponding to the second computer site; and changes the current clock count corresponding to the first computer site to more closely match the current clock count corresponding to the second computer site, at times when the comparison between the abort counts in the first and second computer sites indicates that new transactions have been aborted more frequently in one of the two computer sites.

摘要翻译： 完成了分布式数据库装置中调整当前时钟计数的方法。 每个处理器根据事务生成时的时钟分配一个时间戳，根据时间戳顺序访问数据库来执行事务。 至少第一个计算机站点中的处理器访问对应于第二计算机站点的中止计数; 将对应于第一计算机站点的中止计数与对应于第二计算机站点的中止计数进行比较; 并且当第一和第二计算机站点中的中止计数之间的比较指示新的事务已被中止时，将与第一计算机站点相对应的当前时钟计数更改为更紧密地匹配对应于第二计算机站点的当前时钟计数 更频繁地在两个电脑网站之一。