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

1. 发明公开

EP1271358A3 Copying a portion of a database structure associated with a query 审中-公开
标题翻译：复制相关联的一部分与一个查询数据库结构
公开(公告)号：EP1271358A3
公开(公告)日：2007-01-31
申请号：EP02254365.6
申请日：2002-06-21
申请人： NCR INTERNATIONAL INC.
发明人： Klindt, Jerry L. , Sinclair, Paul L.
IPC分类号： G06F17/30
CPC分类号： G06F17/30513 , G06F17/30306 , Y10S707/955 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943 , Y10S707/99944
摘要： A method and computer system for copying a portion of a database structure associated with a query are disclosed. The database includes one or more database objects. The method includes recursively retrieving object definitions for one or more database objects associated with a query to produce an ordered set of object definitions. It also includes building a copy of the database structure using the ordered set of object definitions.

2. 发明公开

EP1164510A2 Virtual join index for relational databases 审中-公开
标题翻译： VirtuellerZusammenführungsindexfürrelationale Datenbanken
公开(公告)号：EP1164510A2
公开(公告)日：2001-12-19
申请号：EP01304928.3
申请日：2001-06-06
申请人： NCR INTERNATIONAL INC.
发明人： Ghazal, Ahmad Said , Hoang, Chi Kim , Sinclair, Paul L.
IPC分类号： G06F17/30
CPC分类号： G06F17/30498 , G06F17/30501 , Y10S707/954 , Y10S707/99932
摘要： The retrieval of data from a database in a computerized database management system is optimized through the use of a virtual join index and associated covering non-unique secondary indexes. The virtual join index is created by combining one or more commonly-used columns of one or more tables. The covering non-unique secondary indexes are generating by combining one or more commonly-used columns of the virtual join index. Data is not stored in the virtual join index after the covering non-unique secondary indexes are generated. Thereafter, some queries or portions thereof may be resolved solely by accessing one or more of the covering non-unique secondary indexes.
摘要翻译：通过使用虚拟连接索引和相关覆盖非唯一次要索引来优化从计算机化数据库管理系统中的数据库检索数据。通过组合一个或多个常用的一个或多个表的列来创建虚拟连接索引。覆盖的非唯一次要索引是通过组合一个或多个常用的虚拟连接索引列生成的。生成覆盖的非唯一次要索引后，数据不会存储在虚拟连接索引中。此后，可以仅通过访问覆盖非唯一次要索引中的一个或多个来解决某些查询或其部分。

3. 发明公开

EP1164510A3 Virtual join index for relational databases 审中-公开
标题翻译：关系数据库虚拟合并指数
公开(公告)号：EP1164510A3
公开(公告)日：2005-11-30
申请号：EP01304928.3
申请日：2001-06-06
申请人： NCR INTERNATIONAL INC.
发明人： Ghazal, Ahmad Said , Hoang, Chi Kim , Sinclair, Paul L.
IPC分类号： G06F17/30
CPC分类号： G06F17/30498 , G06F17/30501 , Y10S707/954 , Y10S707/99932
摘要： The retrieval of data from a database in a computerized database management system is optimized through the use of a virtual join index and associated covering non-unique secondary indexes. The virtual join index is created by combining one or more commonly-used columns of one or more tables. The covering non-unique secondary indexes are generating by combining one or more commonly-used columns of the virtual join index. Data is not stored in the virtual join index after the covering non-unique secondary indexes are generated. Thereafter, some queries or portions thereof may be resolved solely by accessing one or more of the covering non-unique secondary indexes.

4. 发明公开

EP1271358A2 Copying a portion of a database structure associated with a query 审中-公开
标题翻译： Kopieren eines Teils einer mit einer Abfrage assoziierten Datenbankstruktur
公开(公告)号：EP1271358A2
公开(公告)日：2003-01-02
申请号：EP02254365.6
申请日：2002-06-21
申请人： NCR INTERNATIONAL INC.
发明人： Klindt, Jerry L. , Sinclair, Paul L.
IPC分类号： G06F17/30
CPC分类号： G06F17/30513 , G06F17/30306 , Y10S707/955 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943 , Y10S707/99944
摘要： A method and computer system for copying a portion of a database structure associated with a query are disclosed. The database includes one or more database objects. The method includes recursively retrieving object definitions for one or more database objects associated with a query to produce an ordered set of object definitions. It also includes building a copy of the database structure using the ordered set of object definitions.
摘要翻译：公开了一种用于复制与查询相关联的数据库结构的一部分的方法和计算机系统。数据库包括一个或多个数据库对象。该方法包括递归地检索与查询相关联的一个或多个数据库对象的对象定义，以产生一组有序的对象定义。它还包括使用有序对象定义集构建数据库结构的副本。

5. 发明公开

EP1302873A2 Partitioned database system 审中-公开
标题翻译： Partitioniertes Datenbanksystem
公开(公告)号：EP1302873A2
公开(公告)日：2003-04-16
申请号：EP02256960.2
申请日：2002-10-08
申请人： NCR INTERNATIONAL INC.
发明人： Sinclair, Paul L. , Cohen, Steven B. , Pederson, Donald R.
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99942 , Y10S707/99945
摘要： Implementations of a partitioned database system and a method of using a database system are disclosed. One system implementation includes storage facilities. Each storage facility includes data from database table rows. The database table rows in each storage facility that correspond to a specific database table are logically ordered according to a row identifier (row ID). The row ID includes a first value that is based on one or more columns of the table. The row ID also includes a second value that is based on one or more columns of the table, which may be different from or the same as those on which the first value is based. The first value of the row ID is predominate in determining the order of the rows in the storage facilities. The second value determines the order of those rows with identical first values.
摘要翻译：公开了分区数据库系统的实现和使用数据库系统的方法。一个系统实现包括存储设施。每个存储设备都包括来自数据库表行的数据。对应于特定数据库表的每个存储设施中的数据库表行根据行标识符（行ID）进行逻辑排序。行ID包括基于该表的一列或多列的第一值。行ID还包括基于表的一个或多个列的第二值，其可以与第一值所基于的那些不同或相同。在确定存储设施中的行的顺序时，行ID的第一个值占主要地位。第二个值确定具有相同第一个值的那些行的顺序。

6. 发明公开

EP1302873A3 Partitioned database system 审中-公开
标题翻译：分区数据库系统
公开(公告)号：EP1302873A3
公开(公告)日：2004-10-27
申请号：EP02256960.2
申请日：2002-10-08
申请人： NCR INTERNATIONAL INC.
发明人： Sinclair, Paul L. , Cohen, Steven B. , Pederson, Donald R.
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99942 , Y10S707/99945
摘要： Implementations of a partitioned database system and a method of using a database system are disclosed. One system implementation includes storage facilities. Each storage facility includes data from database table rows. The database table rows in each storage facility that correspond to a specific database table are logically ordered according to a row identifier (row ID). The row ID includes a first value that is based on one or more columns of the table. The row ID also includes a second value that is based on one or more columns of the table, which may be different from or the same as those on which the first value is based. The first value of the row ID is predominate in determining the order of the rows in the storage facilities. The second value determines the order of those rows with identical first values.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式