-
公开(公告)号：US09658826B2
公开(公告)日：2017-05-23
申请号：US14851538
申请日：2015-09-11
发明人： Ritsuko Boh , Noriaki Kohno
CPC分类号： G06F7/08 , G06F17/30336 , G06F17/30486 , G06F17/30946
摘要： A method and system for sorting data of an input file containing multiple records associated with multiple tables of a database. The multiple records include key values. The key values are segmented into ranges of key values for each table. Each range of key values for each table is a segment having a segment value. A block number, which contains a unique permutation of the segment values of the segments, is generated. The segment values denote the ranges of key values encompassing multiple key values in each record. A sort key value for each record is ascertained, based on the generated block number for each record, and added to each record. The multiple records are sorted according to the sort key values in the multiple records. The sorted multiple records are stored in an output file. The selected multiple key values include all key values that satisfy a condition.
-
公开(公告)号：US09213782B2
公开(公告)日：2015-12-15
申请号：US14188746
申请日：2014-02-25
发明人： Ritsuko Boh , Noriaki Kohno
CPC分类号： G06F7/08 , G06F17/30336 , G06F17/30486 , G06F17/30946
摘要： A method and system for sorting data of an input file containing multiple records associated with multiple tables of a database. The multiple records include key values. The key values are segmented into ranges of key values for each table. Each range of key values for each table is a segment having a segment value. Multiple key values are selected for the multiple records. A block number, which contains a unique permutation of the segment values of the segments, is generated. The segment values denote the ranges of key values encompassing the multiple key values in each record. A sort key value for each record is ascertained, based on the generated block number for each record, and added to each record. The multiple records are sorted according to the sort key values in the multiple records. The sorted multiple records are stored in an output file.
摘要翻译： 一种用于对包含与数据库的多个表相关联的多个记录的输入文件的数据进行排序的方法和系统。 多个记录包括键值。 键值被分割成每个表的键值的范围。 每个表的每个关键值范围都是具有段值的段。 为多个记录选择了多个键值。 生成包含段的段值的唯一置换的块号。 段值表示包含每个记录中的多个键值的键值的范围。 根据每个记录的生成块号确定每个记录的排序键值，并将其添加到每个记录。 多个记录根据多个记录中的排序键值进行排序。 排序的多个记录存储在输出文件中。
-
公开(公告)号：US20160154871A1
公开(公告)日：2016-06-02
申请号：US14938299
申请日：2015-11-11
发明人： Ritsuko Boh , Noriaki Kohno
IPC分类号： G06F17/30
CPC分类号： G06F16/273
摘要： A temporal DB that stores data having been stored in a DB of a mainframe is provided in a DB dedicated device 20. During a DB update, when an application on a mainframe issues an update SQL, a DBMS updates the DB and stores an update log, and an update-log capturing unit periodically reads out the update log. In the DB dedicated device 20, an update-log applying unit updates the temporal DB based on the update log. During DB reference, when the application on the mainframe issues an inquiry SQL with inquiry target time attached, the DBMS transfers the inquiry SQL to the inquiry processing unit. In the DB dedicated device, the inquiry processing unit inquires the temporal DB about data for the inquiry target time and returns an inquiry result to the DBMS.
摘要翻译： 存储在主机DB中的数据的时间DB被提供在DB专用设备20中。在DB更新期间，当大型机上的应用程序发出更新SQL时，DBMS更新DB并存储更新日志 并且更新日志捕获单元周期性地读出更新日志。 在DB专用设备20中，更新日志应用单元基于更新日志更新时间DB。 在DB引用期间，当主机上的应用程序发出查询SQL查询目标时间时，DBMS将查询SQL传输到查询处理单元。 在DB专用设备中，查询处理单元询问时间DB关于查询目标时间的数据，并将查询结果返回给DBMS。
-
公开(公告)号：US08898127B2
公开(公告)日：2014-11-25
申请号：US13648338
申请日：2012-10-10
发明人： Noriaki Kohno
CPC分类号： G06F17/30362 , G06F17/30171 , G06Q40/02
摘要： A lock control device receives a lock acquisition request from an application and transmits a lock acquisition request to a DBMS, receives a lock acquisition response from the DBMS, and transmits a lock acquisition response to the application, and each time, acquires statistical time information including the lock request counter, subsequent lock request counter, lock request time, lock acquisition time, initial lock acquisition time, and subsequent lock request time. The statistical processing device calculates the lock request count for each resource, subsequent lock request count for each resource, average lock wait time, and average lock acquisition delay expectation time, based on the statistical time information. Based on these values, the statistical processing device calculates an evaluation value which is the degree of expectation for the time eliminated from the lock wait time when lock acquisition is postponed, and outputs the lock order of the resources arranged in order of smallest evaluation value to a lock order table.
摘要翻译： 锁定控制装置从应用程序接收锁定获取请求，并向DBMS发送锁定获取请求，从DBMS接收锁定获取响应，并向应用发送锁定获取响应，并且每次获取统计时间信息，包括 锁定请求计数器，后续锁定请求计数器，锁定请求时间，锁定获取时间，初始锁定获取时间和随后的锁定请求时间。 统计处理装置根据统计时间信息计算每个资源的锁定请求计数，每个资源的后续锁定请求计数，平均锁定等待时间和平均锁定获取延迟期望时间。 基于这些值，统计处理装置计算作为在锁定获取被推迟时从锁定等待时间消除的时间的期望值的评价值，并将按照最小评价值排列的资源的锁定顺序输出到 锁订单表。
-
公开(公告)号：US11144574B2
公开(公告)日：2021-10-12
申请号：US14938299
申请日：2015-11-11
发明人： Ritsuko Boh , Noriaki Kohno
IPC分类号： G06F16/27
摘要： A temporal DB that stores data having been stored in a DB of a mainframe is provided in a DB dedicated device 20. During a DB update, when an application on a mainframe issues an update SQL, a DBMS updates the DB and stores an update log, and an update-log capturing unit periodically reads out the update log. In the DB dedicated device 20, an update-log applying unit updates the temporal DB based on the update log. During DB reference, when the application on the mainframe issues an inquiry SQL with inquiry target time attached, the DBMS transfers the inquiry SQL to the inquiry processing unit. In the DB dedicated device, the inquiry processing unit inquires the temporal DB about data for the inquiry target time and returns an inquiry result to the DBMS.
-
公开(公告)号：US20160004503A1
公开(公告)日：2016-01-07
申请号：US14851538
申请日：2015-09-11
发明人： Ritsuko Boh , Noriaki Kohno
CPC分类号： G06F7/08 , G06F17/30336 , G06F17/30486 , G06F17/30946
摘要： A method and system for sorting data of an input file containing multiple records associated with multiple tables of a database. The multiple records include key values. The key values are segmented into ranges of key values for each table. Each range of key values for each table is a segment having a segment value. Multiple key values are selected for the multiple records. A block number, which contains a unique permutation of the segment values of the segments, is generated. The segment values denote the ranges of key values encompassing the multiple key values in each record. A sort key value for each record is ascertained, based on the generated block number for each record, and added to each record. The multiple records are sorted according to the sort key values in the multiple records. The sorted multiple records are stored in an output file.
-
公开(公告)号：US20150378675A1
公开(公告)日：2015-12-31
申请号：US14851127
申请日：2015-09-11
发明人： Ritsuko Boh , Noriaki Kohno
CPC分类号： G06F7/08 , G06F17/30336 , G06F17/30486 , G06F17/30946
摘要： A method and system for sorting data of an input file containing multiple records associated with multiple tables of a database. The multiple records include key values. The key values are segmented into ranges of key values for each table. Each range of key values for each table is a segment having a segment value. Multiple key values are selected for the multiple records. A block number, which contains a unique permutation of the segment values of the segments, is generated. The segment values denote the ranges of key values encompassing the multiple key values in each record. A sort key value for each record is ascertained, based on the generated block number for each record, and added to each record. The multiple records are sorted according to the sort key values in the multiple records. The sorted multiple records are stored in an output file.
摘要翻译： 一种用于对包含与数据库的多个表相关联的多个记录的输入文件的数据进行排序的方法和系统。 多个记录包括键值。 键值被分割成每个表的键值的范围。 每个表的每个关键值范围都是具有段值的段。 为多个记录选择了多个键值。 生成包含段的段值的唯一置换的块号。 段值表示包含每个记录中的多个键值的键值的范围。 根据每个记录的生成块号确定每个记录的排序键值，并将其添加到每个记录。 多个记录根据多个记录中的排序键值进行排序。 排序的多个记录存储在输出文件中。
-
公开(公告)号：US09189512B2
公开(公告)日：2015-11-17
申请号：US14478108
申请日：2014-09-05
发明人： Noriaki Kohno
CPC分类号： G06F17/30362 , G06F17/30171 , G06Q40/02
摘要： A lock control device receives a lock acquisition request from an application and transmits a lock acquisition request to a DBMS, receives a lock acquisition response from the DBMS, and transmits a lock acquisition response to the application, and each time, acquires statistical time information including the lock request counter, subsequent lock request counter, lock request time, lock acquisition time, initial lock acquisition time, and subsequent lock request time. The statistical processing device calculates the lock request count for each resource, subsequent lock request count for each resource, average lock wait time, and average lock acquisition delay expectation time, based on the statistical time information. Based on these values, the statistical processing device calculates an evaluation value which is the degree of expectation for the time eliminated from the lock wait time when lock acquisition is postponed, and outputs the lock order of the resources arranged in order of smallest evaluation value to a lock order table.
摘要翻译： 锁定控制装置从应用程序接收锁定获取请求，并向DBMS发送锁定获取请求，从DBMS接收锁定获取响应，并向应用发送锁定获取响应，并且每次获取统计时间信息，包括 锁定请求计数器，后续锁定请求计数器，锁定请求时间，锁定获取时间，初始锁定获取时间和随后的锁定请求时间。 统计处理装置根据统计时间信息计算每个资源的锁定请求计数，每个资源的后续锁定请求计数，平均锁定等待时间和平均锁定获取延迟期望时间。 基于这些值，统计处理装置计算作为在锁定获取被推迟时从锁定等待时间消除的时间的期望值的评价值，并将按照最小评价值排列的资源的锁定顺序输出到 锁订单表。
-
公开(公告)号：US20140317449A1
公开(公告)日：2014-10-23
申请号：US14217829
申请日：2014-03-18
发明人： Noriaki Kohno , Hideki Nagasawa
CPC分类号： G06F11/1402 , G06F9/5027 , G06F11/1443
摘要： A system stores at least one item of connection information for each of a plurality of processing systems. The system receives a request from the requesting apparatus and, in response to receiving the request, sets a status related to one item of the connection information stored in the storage unit for connection to one of the processing systems. The system transmits the received request to the one processing system by using the one item of connection information and receives a response denoting a result of the processing from the one processing system. Responsive to receiving the response, the system releases the status related to the one item of connection information, and transmits the response to the requesting apparatus.
摘要翻译： 系统存储多个处理系统中的每一个的至少一个连接信息项。 系统从请求设备接收请求，响应于接收到请求，设置与存储在存储单元中的一个连接信息有关的状态，以连接到处理系统之一。 系统通过使用一个连接信息将接收到的请求发送给一个处理系统，并从一个处理系统接收表示处理结果的响应。 响应于接收到响应，系统释放与一条连接信息有关的状态，并将响应发送到请求设备。
-
公开(公告)号：US20140222839A1
公开(公告)日：2014-08-07
申请号：US14188746
申请日：2014-02-25
发明人： Ritsuko Boh , Noriaki Kohno
IPC分类号： G06F17/30
CPC分类号： G06F7/08 , G06F17/30336 , G06F17/30486 , G06F17/30946
摘要： A method and system for sorting data of an input file containing multiple records associated with multiple tables of a database. The multiple records include key values. The key values are segmented into ranges of key values for each table. Each range of key values for each table is a segment having a segment value. Multiple key values are selected for the multiple records. A block number, which contains a unique permutation of the segment values of the segments, is generated. The segment values denote the ranges of key values encompassing the multiple key values in each record. A sort key value for each record is ascertained, based on the generated block number for each record, and added to each record. The multiple records are sorted according to the sort key values in the multiple records. The sorted multiple records are stored in an output file.
摘要翻译： 一种用于对包含与数据库的多个表相关联的多个记录的输入文件的数据进行排序的方法和系统。 多个记录包括键值。 键值被分割成每个表的键值的范围。 每个表的每个关键值范围都是具有段值的段。 为多个记录选择了多个键值。 生成包含段的段值的唯一置换的块号。 段值表示包含每个记录中的多个键值的键值的范围。 根据每个记录的生成块号确定每个记录的排序键值，并将其添加到每个记录。 多个记录根据多个记录中的排序键值进行排序。 排序的多个记录存储在输出文件中。
-
-
-
-
-
-
-
-
-
搜索结果
14 条记录 (耗时 0.021 秒)
