专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明专利

JP2000250921A METHOD AND SYSTEM FOR MANAGING DATABASE 失效
公开(公告)号：JP2000250921A
公开(公告)日：2000-09-14
申请号：JP4966499
申请日：1999-02-26
申请人： HITACHI LTD
发明人： GOSHO HIROYUKI , KIMURA KOJI , KONDO YOICHI , HARA KIYONOBU , TAKAZAWA KAZUYUKI
IPC分类号： G06F12/00 , G06F17/30
摘要： PROBLEM TO BE SOLVED: To perform grouping operation which requires sorting by a grouping column value at high speed by providing a means for extracting records from a data base and grouping them by using a hash method and a means for sorting the grouped records. SOLUTION: In hash grouping 102, ungrouped records are take out the data base, one by one, a hash value is obtained from a hash function 103 by using a grouping column value as a key, and grouped records are generated in a hash grouping area 104 and related in sorting order. In grouped record extraction 106, the grouped records are taken out of the hash grouping area 104 in the sorting order, which is always held. In sort grouping 107, ungrouped records stored in a work file 105 are sorted by the grouping column value to generate grouped records.

2. 发明专利

JPS61141035A Data retrieval system 失效
标题翻译：数据检索系统
公开(公告)号：JPS61141035A
公开(公告)日：1986-06-28
申请号：JP26275684
申请日：1984-12-14
申请人： Hitachi Ltd
发明人： GOSHO HIROYUKI , TAKAYAMA HIROSHI
IPC分类号： G06F7/24
摘要： PURPOSE: To process a sort request in descending and ascending orders at a high speed by installing a pointer capable of pointing data in right and left directions between nodes of the same depth on an index of a tree structure.
CONSTITUTION: The titled system is of an index model having a tree structure, and formed with a route page 1, an index page 2, leaf pages 3W5 and data 7 and 8 of one line on a table, which include a key value. In order to attain the retrieval in descending and ascending orders by such an index, the pointer capable of pointing in both directions is given between nodes on pages having the same depth. Owing to the installation of the pointer, data can be obtained by specifying one index key value, and the result sorted in the ascending or descending order can be obtained with the use of the index having the tree structure.
COPYRIGHT: (C)1986,JPO&Japio
摘要翻译：目的：通过安装指向树结构索引上相同深度的节点之间的左右方向的数据的指针，以高速递减顺序处理排序请求。标准：标题系统是具有树结构的索引模型，并且形成有一个路由页面1，索引页2，叶子页3-5以及表上的一行的数据7和8，其中包括一个键值。为了通过这样的索引以递减顺序获得检索，能够在具有相同深度的页面上的节点之间给出能够指向两个方向的指针。由于指针的安装，可以通过指定一个索引键值来获得数据，并且可以使用具有树结构的索引获得按升序或降序排序的结果。

3. 发明专利

JP2000322294A METHOD AND DEVICE FOR DATA BASE MANAGEMENT 失效
公开(公告)号：JP2000322294A
公开(公告)日：2000-11-24
申请号：JP12691699
申请日：1999-05-07
申请人： HITACHI LTD
发明人： KODERA TAKASHI , ITO KAZUHIRO , BAN KAZUTAKE , KIRIHARA TAKASHI , GOSHO HIROYUKI , KUBO MITSUO , MIYATA SHINJI , OKUDA KIYOYUKI
IPC分类号： G06F12/00
摘要： PROBLEM TO BE SOLVED: To reduce the number of running instructions in a computer which are required for data conversion for data form adjustment between computers, to reduce the number of running instructions in the computer by performing data conversion for data form adjustment between computers and data form adjustment between data attributes by single conversion, and to reduce the number of running instructions in the computer which are required for conversion from a text of data operation statements from a client computer to a form of a computer where a data base exists. SOLUTION: When attributes of data are those indicating the data form which is handled in a client computer 102, conversion from the data form of the client computer to that of a computer 101 where a data base 109 exists is not performed. When these attributes are those indicating the data form which is handled in the computer 101, data conversion for data form adjustment between computers and that between data attributes are performed by one conversion processing. Data operation instruction statements are analyzed in the data form of the client computer 102 as they are.

4. 发明专利

JPH11232153A DATA BASE SYSTEM 失效
公开(公告)号：JPH11232153A
公开(公告)日：1999-08-27
申请号：JP3481598
申请日：1998-02-17
申请人： HITACHI LTD
发明人： SHIRAI KATSUMASA , GOSHO HIROYUKI , FURUYA SACHIKO , SHIGEMURA TORU
IPC分类号： G06F12/00 , G06F17/30
摘要： PROBLEM TO BE SOLVED: To improve the retrieval performance, to make the data possible to be guaranteed as the latest data in comparison with a conventional replication system, and to make the data resorable only by the server side at the time of the occurrence of a fault by delivering such data that a client highly probably requests as a subset data base together with a retrieval program. SOLUTION: A data base server 18 provided with a data base 22 and plural clients 11 each provided with subset data base 15 are connected through a network to constitute a system. A data use condition storage device 23 and a data extraction device 19 use a data use condition management data base 14 to deliver data, which may be highly probably used by a client, as a subset data base based on the capability of the client and the past data use condition.

5. 发明专利

JPH0660040A MULTISERVER PROGRAM CONTROL SYSTEM 失效
公开(公告)号：JPH0660040A
公开(公告)日：1994-03-04
申请号：JP20905292
申请日：1992-08-05
申请人： HITACHI LTD
发明人： GOSHO HIROYUKI
IPC分类号： G06F13/00 , G06F15/16 , G06F15/177
摘要： PURPOSE:To select a server program by making no inter-program communication with a manager program by a client program. CONSTITUTION:When a user application program 11 sends a request to process a transaction with a certain transaction number, the client program 21 which receives it retrieves a server program control table 61 provided in the common area to the manager program on the basis of the transaction number as a key. When the transaction number is already registered in the server program control table 61, the client program 21 assigns a server program 41 which is already assigned in the transaction and performs the transaction processing.

6. 发明专利

JPH05165701A DISTRIBUTED DATA BASE MANAGEMENT SYSTEM 失效
公开(公告)号：JPH05165701A
公开(公告)日：1993-07-02
申请号：JP33471591
申请日：1991-12-18
申请人： HITACHI LTD
发明人： GOSHO HIROYUKI
IPC分类号： G06F12/00 , G06F15/16
摘要： PURPOSE:To improve the development efficiency of a job program by compiling the job program operating data bases whose data contents differ and definition is the same in respective nodes by means of one node and managing with the copies of the object of the job program and a DML object to other nodes. CONSTITUTION:A table definition part 34 analyzes data by the input of a table definition sentence 37 and a table name is obtained in RDBMS 16, and a network 11 transmits it to RDBMS 17. A table number management part 35 retrieves a table number management list 32 with the table name, and gives the same table number when the same table name is registered. The table definition part 34 generates a table 28 in a data base file 25 based on the table number transmitted by the network. At the time of the compiling of the job program 36 retrieving the table 27 of the same table name in RDBMS 15, an SQL object 31 which an SQL compiling part 33 generates can be shared by the nodes 12, 13 and 14.

7. 发明专利

JPH03276258A EXCLUSIVE CONTROL METHOD FOR DATA RETRIEVING SYSTEM 失效
公开(公告)号：JPH03276258A
公开(公告)日：1991-12-06
申请号：JP7330690
申请日：1990-03-26
申请人： HITACHI LTD
发明人： KODERA TAKASHI , YAMAHIRA KOSAKU , GOSHO HIROYUKI , ABE ATSUSHI
IPC分类号： G06F17/30
摘要： PURPOSE:To minimize the exclusive range of a data store part by applying the assembly processing to the data store position information obtained while an exclusive operation is applied to an index part and applying an exclusive state to the data store part only at a part corresponding to the data store position obtained through the assembly processing. CONSTITUTION:An exclusive state is applied to an index part 12 so as to obtain the data store position information on each assembly of data with which the data are retrieved and assemblied. Then an exclusive state is left only in an idex page corresponding to the data page including the assembly of data and other index pages are released. Then an assembly processing part 14 applies the assembly processing to an assembly of data pages, and an exclusive state is applied to the corresponding data page of a data store part 11 corresponding to an obtained part. At the same time, the exclusive state of the index page of the part 12 is released and a data operating part 13 operates the data on the part kept in the exclusive state at the part 11. When this data operation is over, the exclusive state of the corresponding page of the part 11 is released. Thus the exclusive range of the part 11 is minimized.

8. 发明专利

JPH0293766A TABLE COUPLING SYSTEM FOR RELATIONAL DATA BASE 失效
公开(公告)号：JPH0293766A
公开(公告)日：1990-04-04
申请号：JP24409488
申请日：1988-09-30
申请人： HITACHI LTD
发明人： GOSHO HIROYUKI
IPC分类号： G06F12/00 , G06F17/30
摘要： PURPOSE:To shorten processing time and to simplify processing by using a coupling index and taking-out the records of plural tables directly when a user designates a coupling condition, the plural tables are coupled and data are retrieved. CONSTITUTION:A coupling index 3 is prepared to have information 4-1, 4-2,... which are composed of the identifier of the record in the table having a correspondent key in the values of coupling fields EMP.DNO.5-3 and DEPT.DNO.6-1 of an EMP table 1 and a DEPT table 2, namely, the key and coupling field. Namely, when the user designates the coupling condition concerning the values of the respective coupling field DNO.5-3 and DNO.6-1, the tables 1 and 2 are coupled and an inquiry to retrieve the data is requested, without executing the taking-out or sort of the unnecessary record, coupling processing is executed only by referring the coupling keys 4-1, 4-2,... of the index 3 which is already prepared.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式