Database processing method, apparatus for carrying out the same and medium storing processing program
    111.
    发明授权
    Database processing method, apparatus for carrying out the same and medium storing processing program 失效
    数据库处理方法,用于执行相同和中等存储处理程序的装置

    公开(公告)号:US06675160B2

    公开(公告)日:2004-01-06

    申请号:US10167435

    申请日:2002-06-13

    IPC分类号: G06F1730

    摘要: A database processing system for analyzing a query issued to a database to generate a corresponding execution procedure for performing database processing in accordance therewith. A plurality of columns for storing data each constituted by a set of instances and conditions concerning the instances constituting the plurality of columns are entered. A query is inputted which contains a predicate for evaluating whether a set of instances which meet the designated conditions and which can be identified with the same subscript exists among the sets of instances stored in the plurality of columns. In response to the query, a decision is made as to whether or not an index has been generated for one or plural columns specified in the query predicate. When the index is generated, the index is accessed to acquire an identifier of table data which is “true” for a predicate. Unless the index is generated, a decision is then made as to whether or not column data acquired by accessing the database meet the conditions specified in the predicate contained in the query.

    摘要翻译: 一种数据库处理系统,用于分析发给数据库的查询,以生成相应的执行过程,用于执行数据库处理。 输入用于存储数据的多个列,每个列由关于构成多个列的实例的一组实例和条件构成。 输入查询,该查询包含用于评估在多个列中存储的实例组中是否存在满足指定条件并且可以被标识具有相同下标的一组实例的谓词。 响应于该查询,作出关于是否已经在查询谓词中指定的一个或多个列生成了索引的决定。 当生成索引时,访问索引以获取对于谓词为“true”的表数据的标识符。 除非生成索引,否则就决定通过访问数据库获取的列数据是否满足查询中包含的谓词中指定的条件。

    Database management methods and equipment, and database management program storage media
    112.
    发明授权
    Database management methods and equipment, and database management program storage media 失效
    数据库管理方法和设备,以及数据库管理程序存储介质

    公开(公告)号:US06578039B1

    公开(公告)日:2003-06-10

    申请号:US09702351

    申请日:2000-10-31

    申请人: Nobuo Kawamura

    发明人: Nobuo Kawamura

    IPC分类号: G06F1730

    摘要: Multiple key ranges are correlated with multiple data storage areas provided in memory. In storing data in a database, the data is stored in the data storage area correlated with the key range containing the data. When the addition of a data storage area as mentioned above is needed, a given volume of data is moved from the multiple data storages to the newly added data storage area and the key ranges for the moved data are correlated with the data storage areas.

    摘要翻译: 多个密钥范围与存储器中提供的多个数据存储区域相关。 在将数据存储在数据库中时,将数据存储在与包含数据的键范围相关的数据存储区域中。 当需要添加如上所述的数据存储区域时,将给定量的数据从多个数据存储器移动到新添加的数据存储区域,并且移动的数据的关键字范围与数据存储区域相关联。

    Database management apparatus and query operation therefor, including processing plural database operation requests based on key range of hash code
    113.
    发明授权
    Database management apparatus and query operation therefor, including processing plural database operation requests based on key range of hash code 失效
    数据库管理装置及其查询操作,包括基于哈希码的密钥范围处理多个数据库操作请求

    公开(公告)号:US06556988B2

    公开(公告)日:2003-04-29

    申请号:US09809253

    申请日:2001-03-16

    IPC分类号: G06F1730

    摘要: A database management system for executing database operations in parallel by a plurality of nodes and a query processing method for it are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

    摘要翻译: 描述用于由多个节点并行执行数据库操作的数据库管理系统和用于其的查询处理方法。 数据库管理系统包含用于确定分发节点以检索信息的决策管理节点,以便分析从应用程序接收到的查询,生成用于处理查询的处理过程,并执行该处理和连接节点进行排序,合并 并且加入由分发节点检索的信息。 当执行查询处理时,由决策管理节点决定的分发节点检索要处理的信息,由决策管理节点决定的连接节点也从检索到的信息中获得查询结果。 查询结果从输出节点输出并传送到应用程序。

    Manufacturing method of batteries
    114.
    发明授权
    Manufacturing method of batteries 失效
    电池制造方法

    公开(公告)号:US06371996B1

    公开(公告)日:2002-04-16

    申请号:US09557774

    申请日:2000-04-25

    IPC分类号: H01M236

    摘要: This manufacturing method of batteries that comprises the steps of accommodating a battery element 4 in an envelope film body 3 of which one end side is opened to form an opening 3a for injecting an electrolytic solution; and sealing the opening 3a after the electrolytic solution 12 is injected from the opening 3a of the envelope film body 3; wherein an opening 3a side of the envelope film body 3 is made larger than a prescribed shape and dimension to use as a temporary reservoir region 3c of an injected electrolytic solution 12, after injection of a prescribed amount of the electrolytic solution 12 the region 3d of the prescribed shape and dimension being sealed and cut to form a battery. According to the method, a manufacturing method of batteries that can not only make smaller and lighter the batteries but also mass-produce batteries of high quality can be provided.

    摘要翻译: 这种电池制造方法包括以下步骤:将电池元件4容纳在其一端敞开的封套膜体3中,形成用于注入电解液的开口3a; 在从包膜膜体3的开口部3a注入电解液12之后,密封开口部3a; 其中包封膜主体3的开口3a侧被制成大于规定的形状和尺寸以用作注入的电解液12的临时储存区域3c,在注入规定量的电解液12之后,将区域3d 规定的形状和尺寸被密封和切割以形成电池。 根据该方法,可以提供一种电池的制造方法,其不仅能够使电池变得越来越轻,而且还可以批量生产高质量的电池。

    System and method for implementing parallel operations in a database
management system
    115.
    发明授权
    System and method for implementing parallel operations in a database management system 有权
    在数据库管理系统中实现并行操作的系统和方法

    公开(公告)号:US6026394A

    公开(公告)日:2000-02-15

    申请号:US148648

    申请日:1998-09-04

    摘要: A database management system for executing database operations in parallel by a plurality of nodes and a query processing method are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process, and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

    摘要翻译: 描述用于由多个节点并行执行数据库操作的数据库管理系统和查询处理方法。 数据库管理系统包含用于确定用于检索信息的分发节点的决策管理节点,以分析从应用程序接收到的查询,生成用于处理查询的处理过程,并执行该处理,以及用于排序的连接节点, 合并和加入由分发节点检索的信息。 当执行查询处理时,由决策管理节点决定的分发节点检索要处理的信息,由决策管理节点决定的连接节点也从检索到的信息中获得查询结果。 查询结果从输出节点输出并传送到应用程序。

    Method of exclusive control of areas in page for tuple-oriented file
system
    116.
    发明授权
    Method of exclusive control of areas in page for tuple-oriented file system 失效
    面向元组文件系统的页面专用控制方法

    公开(公告)号:US5761658A

    公开(公告)日:1998-06-02

    申请号:US511088

    申请日:1995-08-03

    IPC分类号: G06F12/00 G06F17/30

    摘要: An area in a page for a tuple-oriented file system is exclusively controlled such that a tuple is added to, deleted from or updated in a page including a tuple area in use, a vacant area having a deleted tuple and an unoccupied area. In the case where a transaction is active for increasing the total size of the vacant area in a given page, the particular vacant area is locked to prevent another active parallel transaction from using the same vacant area. During the time when the transaction for increasing the total size of the vacant area remains active, other transactions can add a tuple to the unoccupied area or update a tuple in use in the same page to the extent that the particular page is not compacted. The transaction for increasing the total size of the vacant area can perform a special compaction for collecting a plurality of discrete vacant areas into a continuous vacant area without increasing the unoccupied area in the page. The roll back operation can thus be executed securely.

    摘要翻译: 用于面向元组的文件系统的页面中的区域被专门地控制,使得在包括使用的元组区域,具有删除的元组和未占用区域的空白区域的页面中添加元素,从其中删除或更新。 在交易活动用于增加给定页面中的空白区域的总大小的情况下,特定的空闲区域被锁定以防止另一个主动并行交易使用相同的空白区域。 在用于增加空闲区域的总大小的事务保持活动的时间期间,其他事务可以向未占用区域添加元组,或者在特定页面未被压缩的情况下更新在同一页面中使用的元组。 用于增加空白区域的总大小的交易可以执行特殊的压缩,以将多个离散的空闲区域收集到连续空闲区域中,而不增加页面中的未占用区域。 因此可以安全地执行回滚操作。

    Method apparatus for determining prefetch operating for a data base
    117.
    发明授权
    Method apparatus for determining prefetch operating for a data base 失效
    用于确定数据库的预取操作的方法装置

    公开(公告)号:US5317727A

    公开(公告)日:1994-05-31

    申请号:US353698

    申请日:1989-05-17

    CPC分类号: G06F17/3048 Y10S707/99932

    摘要: In a data base processing method including a central processing unit for analyzing a plurality of queries made from a plurality of users so as to determine an internal processing procedure with respect to a data base, and for performing the internal processing procedure; a secondary storage for storing data capable of being shared by each user; and, an input/output controlling processing unit including at least one cache storage, for controlling a transfer of a plurality of records which are required for input/output processing operations between the central processing unit and secondary storage. The data base processing method is featured in that a decision is made whether or not a prefetching operation is carried out at a start of an input/output processing operation by judging the internal processing procedure which has been formed by the query; a retrieval range into which a record to be fetched has been stored is formed when the prefetching operation is performed; and, a prefetching record number is determined as an input/output processing demand unit, taking account of an access characteristic of the internal processing procedure and also a system characteristic containing a size of the cache storage, a performance, of the central processing unit, and a traffic of the input/output processing unit.

    摘要翻译: 一种数据库处理方法,包括:中央处理单元,用于分析从多个用户进行的多个查询,以便确定相对于数据库的内部处理过程,并用于执行内部处理过程; 用于存储能够被每个用户共享的数据的辅助存储器; 以及输入/输出控制处理单元,其包括至少一个高速缓存存储器,用于控制中央处理单元和辅助存储器之间的输入/输出处理操作所需的多个记录的传送。 数据库处理方法的特征在于,通过判断由查询形成的内部处理过程,判定在输入/输出处理操作开始时是否执行预取操作; 当执行预取操作时,形成已经存储了要获取的记录的检索范围; 并且,考虑到内部处理过程的访问特性以及包含高速缓冲存储器的大小,中央处理单元的性能的系统特性,将预取记录号确定为输入/输出处理需求单元, 以及输入/输出处理单元的流量。

    ANALYSIS SYSTEM, COMPUTER SYSTEM, AND ANALYSIS METHOD
    118.
    发明申请
    ANALYSIS SYSTEM, COMPUTER SYSTEM, AND ANALYSIS METHOD 有权
    分析系统,计算机系统和分析方法

    公开(公告)号:US20150149439A1

    公开(公告)日:2015-05-28

    申请号:US14404525

    申请日:2012-05-31

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30445 G06F17/30557

    摘要: This analysis system analyzes the behavior of a DBMS in a computer system having a computer which executes tasks in parallel and reads data from a database (DB) when executing a query. This analysis system acquires the number of selected rows corresponding to a key value of an index key used in the query, and calculates a model-based predicted degree of processing parallelism of the processing corresponding to the query. The system acquires, from the storage device, event information on an input-output event with respect to the storage medium when the processing corresponding to the query is executed actually, calculates a measured degree of processing parallelism when the processing corresponding to the query is executed actually, based on the event information, and displays information based on the model-based predicted degree of processing parallelism and the measured degree of processing parallelism.

    摘要翻译: 该分析系统分析具有并行执行任务的计算机的计算机系统中的DBMS的行为,并且在执行查询时从数据库(DB)读取数据。 该分析系统获取与查询中使用的索引关键字键对应的所选行数,并计算与查询对应的处理的基于模型的预测处理并行度。 当实际执行与查询对应的处理时,系统从存储装置获取关于存储介质的输入 - 输出事件的事件信息,当执行与查询相对应的处理时,计算测量的处理并行度 实际上,基于事件信息,并且基于基于模型的预测处理并行度和所测量的处理并行度来显示信息。

    DATABASE PROCESSING METHOD, DATABASE PROCESSING SYSTEM AND DATABASE SERVER
    120.
    发明申请
    DATABASE PROCESSING METHOD, DATABASE PROCESSING SYSTEM AND DATABASE SERVER 有权
    数据库处理方法,数据库处理系统和数据库服务器

    公开(公告)号:US20130144867A1

    公开(公告)日:2013-06-06

    申请号:US13814976

    申请日:2011-01-31

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30463 G06F17/30486

    摘要: It is provided a database processing method including: a first step of receiving a query request instructing to output the requested data as query results in a designated order; a second step of generating a query execution plan including an order of accessing tables for storing the data based on the received query request; a third step of acquiring the data requested based on the query request from the database based on the generated query execution plan; a fourth step of generating intermediate results including the acquired data; a fifth step of sorting the generated intermediate results in the designated order; a sixth step of judging, for each of the intermediate results, whether an order of the sorted intermediate results has been determined; and a seventh step of outputting the intermediate results whose order has been determined as the query results in order from a head thereof.

    摘要翻译: 提供了一种数据库处理方法,包括:第一步骤,以指定的顺序接收指示以请求数据作为查询结果输出的查询请求; 生成查询执行计划的第二步骤,所述查询执行计划包括基于接收的查询请求访问用于存储数据的表的顺序; 基于所生成的查询执行计划,从数据库获取基于查询请求所请求的数据的第三步骤; 产生包括所获取的数据的中间结果的第四步骤; 以指定的顺序排列所生成的中间结果的第五步骤; 对于每个中间结果,判断排序的中间结果的顺序是否已被确定的第六步骤; 以及从其头部按顺序输出其顺序已被确定为查询结果的中间结果的第七步骤。