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

1. 发明授权

US07111019B1 Data warehouse system and query processing method used in the system, and data collecting method and apparatus for the method, and charging method and apparatus in the system 有权
标题翻译：系统中使用的数据仓库系统和查询处理方法，系统的数据收集方法和装置，系统中的计费方法和装置
公开(公告)号：US07111019B1
公开(公告)日：2006-09-19
申请号：US09435034
申请日：1999-11-05
申请人： Itaru Nishizawa , Shinji Fujiwara , Kazutomo Ushijima , Shigekazu Inohara
发明人： Itaru Nishizawa , Shinji Fujiwara , Kazutomo Ushijima , Shigekazu Inohara
IPC分类号： G06F12/00 , G06F17/30 , G06F7/00
CPC分类号： G06F17/30433 , G06F17/30557 , G06F17/30575 , Y10S707/99952
摘要： In order to realize a practical data warehouse system with the use of a network in a distributed environment, for example, data collectors (101 and 102) for creating/managing each replica of server data for clients (103 and 104) as shown in FIG. 1 are connected to a network (113). A data collector holds a data request condition given from a user via a client and negotiates with a server (114, 122) which supplies data according to such resources as a storage unit, a CPU, etc. usable by the data collector, thereby the range and quality of the data for which a replica is to be created can be adjusted. For query processing, a part or the whole of a query from a client is processed with the use of a replica (123) created in the data collector. Queries which cannot be processed with any replica in the data collector are transferred to the server. Because a replica created in the data collector can be used to process a query from a client device such a way, the server load can be reduced.
摘要翻译：为了在分布式环境中实现使用网络的实用数据仓库系统，例如，用于创建/管理客户机（103和104）的每个服务器数据副本的数据收集器（101和102），如图。 1连接到网络（113）。数据收集器保存从用户经由客户端给出的数据请求条件，并与根据数据收集器可用的诸如存储单元，CPU等的资源提供数据的服务器（114,122）进行协商，由此可以调整要创建副本的数据的范围和质量。对于查询处理，使用在数据收集器中创建的副本（123）来处理来自客户端的查询的一部分或全部。无法用数据收集器中的任何副本处理的查询将传输到服务器。由于在数据收集器中创建的副本可以用于以这种方式处理来自客户端设备的查询，所以可以减少服务器负载。

2. 发明申请

US20060253435A1 Data warehouse system and query processing method used in the system, and data collecting method and apparatus for the method, and charging method and apparatus in the system 审中-公开
标题翻译：系统中使用的数据仓库系统和查询处理方法，系统的数据收集方法和装置，系统中的计费方法和装置
公开(公告)号：US20060253435A1
公开(公告)日：2006-11-09
申请号：US11485272
申请日：2006-07-13
申请人： Itaru Nishizawa , Shinji Fujiwara , Kazutomo Ushijima , Shigekazu Inohara
发明人： Itaru Nishizawa , Shinji Fujiwara , Kazutomo Ushijima , Shigekazu Inohara
IPC分类号： G06F17/30
CPC分类号： G06F16/24524 , G06F16/25 , G06F16/27 , Y10S707/99952
摘要： In order to realize a practical data warehouse system with the use of a network in a distributed environment, for example, data collectors for creating/managing each replica of server data for clients shown in FIG. 1 are connected to a network. A data collector holds a data request condition given from a user via a client and negotiates with a server which supplies data according to such resources as a storage unit, a CPU, etc., usable by the data collector, thereby the range and quality of the data for which a replica is to be created can be adjusted. For query processing, a part or the whole of a query from a client is processed with the use of a replica created in the data collector. Queries which cannot be processed with any replica in the data collector are transferred to the server. Because a replica created in the data collector can be used to process a query from a client in such a way, the server load can be reduced.
摘要翻译：为了在分布式环境中实现使用网络的实用数据仓库系统，例如，用于创建/管理图1所示的客户端的服务器数据的每个副本的数据收集器。 1连接到网络。数据收集器通过客户端保存从用户发出的数据请求条件，并与根据数据收集器可使用的存储单元，CPU等资源提供数据的服务器进行协商，从而达到数据收集器的范围和质量可以调整要创建副本的数据。对于查询处理，使用在数据收集器中创建的副本来处理来自客户机的部分或全部查询。无法用数据收集器中的任何副本处理的查询将传输到服务器。由于在数据收集器中创建的副本可以用于以这种方式处理来自客户端的查询，所以可以减少服务器负载。

3. 发明授权

US06381601B1 Grouping and duplicate removal method in a database 失效
标题翻译：在数据库中分组和重复删除方法
公开(公告)号：US06381601B1
公开(公告)日：2002-04-30
申请号：US09469615
申请日：1999-12-22
申请人： Shinji Fujiwara , Kazutomo Ushijima , Itaru Nishizawa
发明人： Shinji Fujiwara , Kazutomo Ushijima , Itaru Nishizawa
IPC分类号： G06F1730
CPC分类号： G06F17/30489 , Y10S707/954 , Y10S707/99937
摘要： In order to realize high speed process for grouping the records having the identical values of one or more columns of the input list, the input list is canned, a hash value is generated using a hash function in which a value of the column as the non-vacant partial aggregation of the columns for the grouping is used as the argument, and it is determined whether two or more records having the hash values exist or not. The input list is scanned again and the calculating process of the aggregation columns is immediately executed for the records having the hash value for which it is determined by the first scanning that there is only one record having the identical hash value, the result of such calculating process is output and the records are defined as the input of the ordinary grouping process for the records which are determined to exist as the two or more records.
摘要翻译：为了实现用于对具有输入列表的一个或多个列的相同值的记录进行分组的高速处理，输入列表被装入，使用散列函数生成哈希值，其中列的值为非用于分组的列的消除性部分聚合用作参数，并且确定是否存在具有哈希值的两个或更多个记录。再次对输入列表进行扫描，并且立即对具有通过第一次扫描确定的散列值的记录执行聚合列的计算处理，即只有一个具有相同散列值的记录，这样计算的结果处理被输出，并且记录被定义为被确定作为两个或更多个记录存在的记录的普通分组处理的输入。

4. 发明授权

US5890150A Random sampling method for use in a database processing system and a database processing system based thereon 失效
标题翻译：用于数据库处理系统的随机抽样方法和基于其的数据库处理系统
公开(公告)号：US5890150A
公开(公告)日：1999-03-30
申请号：US12207
申请日：1998-01-23
申请人： Kazutomo Ushijima , Shinji Fujiwara , Kazuo Masai , Yori Takahashi , Itaru Nishizawa
发明人： Kazutomo Ushijima , Shinji Fujiwara , Kazuo Masai , Yori Takahashi , Itaru Nishizawa
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A query issue processing method, a query conversion processing method, and a data control processing method are provided for enhancing the efficiency of random sampling processing for use in a database processing system. In query issue processing 2, a query including random sampling processing is issued. In query conversion processing 8, application sequences of random sampling processing and another query processing are exchanged by considering a sampling unit of the random sampling processing. Further, in record control processing 4, random access to a secondary storage device is reduced, thereby enhancing random sampling processing efficiency. Unlike the conventional query conversion processing not considering the sampling unit, the issuance of the query including random sampling processing and performing query conversion by considering the sampling unit allow random sampling to be applied also to a query including aggregation processing, thereby enhancing the efficiency of queries in a wider range. Reduction in the random access to the secondary storage device further enhances that efficiency.
摘要翻译：提供了一种查询问题处理方法，查询转换处理方法和数据控制处理方法，用于提高在数据库处理系统中使用的随机抽样处理的效率。在查询问题处理2中，发出包括随机抽样处理的查询。在查询转换处理8中，通过考虑随机抽样处理的抽样单位来交换随机抽样处理和另一查询处理的应用程序。此外，在记录控制处理4中，减少对二次存储装置的随机访问，从而提高随机抽样处理效率。与不考虑采样单元的常规查询转换处理不同，通过考虑采样单元来执行随机抽样处理和执行查询转换的查询的发布允许随机抽样也适用于包括聚合处理的查询，从而提高查询的效率在更广泛的范围。减少对二次存储设备的随机访问进一步提高了该效率。

5. 发明授权

US06832216B2 Method and system for mining association rules with negative items 有权
标题翻译：挖掘关联规则与负面项目的方法和系统
公开(公告)号：US06832216B2
公开(公告)日：2004-12-14
申请号：US10024210
申请日：2001-12-21
申请人： Takahiko Shintani , Itaru Nishizawa , Kazutomo Ushijima
发明人： Takahiko Shintani , Itaru Nishizawa , Kazutomo Ushijima
IPC分类号： G06F1730
CPC分类号： G06F17/30539 , Y10S707/99932 , Y10S707/99936
摘要： By introducing the concept of negation into an association rule, the number of combinations of items, serving as candidates of the association rule containing negative items, becomes enormous for mining. The invention sorts out frequent itemsets to be included in an association rule in advance by ensuing its upper bound of confidence satisfying conditions of a confidence and a confidence increment input by an user. Also, by checking a logic product for each bit of a bit string reflecting the presence of each item in the itemset, the combinations of items as candidates are pruned. The pruning of unnecessary combinations is effectively carried out. The number of combinations of the items for compiling association rules is reduced.
摘要翻译：通过将否定概念引入关联规则，作为包含负面项目的关联规则的候选者的项目组合数量对挖掘而言变得非常巨大。本发明通过随后其满足用户输入的置信度和置信度增长条件的置信度来预先排除要包括在关联规则中的频繁项集。此外，通过检查反映项目集中每个项目的存在的比特串的每个比特的逻辑积，修剪作为候选的项目的组合。修改不必要的组合是有效的。用于编译关联规则的项目的组合数量减少。

6. 发明申请

US20050091210A1 Method for integrating and accessing of heterogeneous data sources 审中-公开
标题翻译：异构数据源的集成和访问方法
公开(公告)号：US20050091210A1
公开(公告)日：2005-04-28
申请号：US11010266
申请日：2004-12-14
申请人： Shigekazu Inohara , Itaru Nishizawa , Akira Shimizu
发明人： Shigekazu Inohara , Itaru Nishizawa , Akira Shimizu
IPC分类号： G06F15/16 , G06F12/00 , G06F17/30 , G06F7/00
CPC分类号： G06F16/256
摘要： A method for integrating data, stored not only in a relational database management system but also in data sources such as legacy application programs or tertiary storage where inquiry cannot be executed efficiently, and for performing inquiry quickly. A distributed index for use by a data source is generated in a database hub in advance, and a distribution index application unit converts and disassembles an inquiry using the distributed index.
摘要翻译：一种用于集成数据的方法，不仅存储在关系数据库管理系统中，而且存储在诸如传统应用程序或三级存储之类的数据源中，其中查询不能被有效地执行，并且用于快速执行查询。预先在数据库集线器中生成由数据源使用的分布式索引，分发索引应用单元使用分布式索引转换和分解查询。

7. 发明授权

US06694306B1 System and method for query processing using virtual table interface 失效
标题翻译：使用虚拟表格界面进行查询处理的系统和方法
公开(公告)号：US06694306B1
公开(公告)日：2004-02-17
申请号：US09665069
申请日：2000-09-19
申请人： Itaru Nishizawa , Shigekazu Inohara , Nobutoshi Sagawa , Akira Shimizu
发明人： Itaru Nishizawa , Shigekazu Inohara , Nobutoshi Sagawa , Akira Shimizu
IPC分类号： G06F1730
CPC分类号： G06F17/30457 , G06F17/30545 , Y10S707/99933 , Y10S707/99943
摘要： A query processing system in which a virtual table to enable multiple mapping to a plurality of databases is provided in a data processing system to receive a query from an application program and partial replicas as copies of part of the data in the virtual table is prepared in storage so that the whole or part of a query can be processed using the partial replicas. For query units which cannot be processed using the partial replica, means to select an appropriate distributed join method and optimization to push down query processing to real databases as far as possible are used. The system allows transparent access to multiple different real databases according to access conditions without changing the column to be accessed in the virtual table or switching the virtual table, thereby eliminating the need to create a new application for each newly developed service.
摘要翻译：一种查询处理系统，其中在数据处理系统中提供用于启用对多个数据库的多个映射的虚拟表，以从应用程序和部分副本接收查询，作为虚拟表中的部分数据的副本存储，以便可以使用部分副本处理整个或部分查询。对于不能使用部分副本处理的查询单元，意味着选择适当的分布式连接方法，并尽可能使用优化来将查询处理推送到真实数据库。该系统允许根据访问条件透明地访问多个不同的真实数据库，而不需要更改要在虚拟表中访问的列或切换虚拟表，从而无需为每个新开发的服务创建新的应用程序。

8. 发明授权

US06757670B1 Method and system for query processing 失效
标题翻译：查询处理方法和系统
公开(公告)号：US06757670B1
公开(公告)日：2004-06-29
申请号：US09659616
申请日：2000-09-11
申请人： Shigekazu Inohara , Itaru Nishizawa , Nobutoshi Sagawa , Akira Shimizu
发明人： Shigekazu Inohara , Itaru Nishizawa , Nobutoshi Sagawa , Akira Shimizu
IPC分类号： G06F1730
CPC分类号： G06F17/30463 , G06F17/30306 , G06F17/30483 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： Method and apparatus for query processing including an optimization controller, responding to a query from an application related to an database, and controlling optimization processing of the query. A query classification definition and a query operation direction associated with the query classification definition are defined on a storing means. The query classification definition classifies the queries according to classifications and attributes including environment for use, time for use, database to be accessed, and the amount of data that is processed. The query operation direction defines strength of the direction including “Force”, “Recommended”, “Neutral”, and “Deny”, which is used to select operation at the time of query execution from several alternatives. During optimization processing of the received query, the system controls the optimization processing according to the query control information that has been set, enabling control of DBMS operation in a batch for two or more queries without modifying the applications.
摘要翻译：用于查询处理的方法和装置，包括优化控制器，响应来自与数据库相关的应用的查询，以及控制查询的优化处理。在存储装置上定义与查询分类定义相关联的查询分类定义和查询操作方向。查询分类定义根据分类和属性对查询进行分类，包括使用环境，使用时间，要访问的数据库以及处理的数据量。查询操作方向定义包括“强制”，“推荐”，“中立”和“拒绝”的方向的强度，用于从多个选项执行查询执行时选择操作。在接收到的查询的优化处理期间，系统根据已经设置的查询控制信息控制优化处理，使得能够在批处理中对两个或更多个查询进行DBMS操作的控制，而无需修改应用程序。

9. 发明申请

US20070294338A1 Database access method and system capable of concealing the contents of query 审中-公开
标题翻译：数据库访问方法和能够隐藏查询内容的系统
公开(公告)号：US20070294338A1
公开(公告)日：2007-12-20
申请号：US11790523
申请日：2007-04-26
申请人： Itaru Nishizawa , Kazutomo Ushijima , Takahiko Shintani
发明人： Itaru Nishizawa , Kazutomo Ushijima , Takahiko Shintani
IPC分类号： G06F15/16
CPC分类号： H04L63/0428
摘要： A data relay server connected between a client computer and a database server produces a query message obtained by encrypting a retrieval condition designated by the client computer, and transmits the query message to the database server. The database server encrypts a specific data item which is designated by the retrieval condition and read out from the database, retrieves service information matched with the retrieval condition by encrypted data matching, and replies the service information as a retrieval result to the data relay server.
摘要翻译：连接在客户端计算机和数据库服务器之间的数据中继服务器产生通过加密由客户端计算机指定的检索条件获得的查询消息，并将查询消息发送到数据库服务器。数据库服务器加密由检索条件指定并从数据库读出的特定数据项，通过加密数据匹配检索与检索条件匹配的服务信息，并将服务信息作为检索结果作为检索结果回复给数据中继服务器。

10. 发明授权

US07228416B2 Database access method and system capable of concealing the contents of query 有权
公开(公告)号：US07228416B2
公开(公告)日：2007-06-05
申请号：US09941850
申请日：2001-08-30
申请人： Itaru Nishizawa , Kazutomo Ushijima , Takahiko Shintani
发明人： Itaru Nishizawa , Kazutomo Ushijima , Takahiko Shintani
IPC分类号： G06F17/00
CPC分类号： H04L63/0428
摘要： A data relay server connected between a client computer and a database server produces a query message obtained by encrypting a retrieval condition designated by the client computer, and transmits the query message to the database server. The database server encrypts a specific data item which is designated by the retrieval condition and read out from the database, retrieves service information matched with the retrieval condition by encrypted data matching, and replies the service information as a retrieval result to the data relay server.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式