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

1. 发明申请

US20070143249A1 System and method for deploying an SQL procedure 有权
标题翻译：用于部署SQL过程的系统和方法
公开(公告)号：US20070143249A1
公开(公告)日：2007-06-21
申请号：US11311810
申请日：2005-12-17
申请人： Margaret Bernal , Yao-Ching Chen , Ding-Wei Chieh , Curt Cotner , Baoqiu Cui , Tammie Dang , Marion Farber , Georgia Fuller , Joe Huang , Hui-An Lee , Claire McFeely , Chunfeng Pei , James Pickel , Yumi Tsuji , Jay Yothers , Margaret Zagelow , Liyan Zhou
发明人： Margaret Bernal , Yao-Ching Chen , Ding-Wei Chieh , Curt Cotner , Baoqiu Cui , Tammie Dang , Marion Farber , Georgia Fuller , Joe Huang , Hui-An Lee , Claire McFeely , Chunfeng Pei , James Pickel , Yumi Tsuji , Jay Yothers , Margaret Zagelow , Liyan Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/30587
摘要： An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.
摘要翻译： SQL过程部署系统将包含过程逻辑组件和数据库请求组件的查询过程从源系统部署到目标系统。在生成查询过程时，系统生成查询过程源代码，符号表和封装的优化结果，以重新生成数据库请求组件的查询语句的运行时指令，并使查询语句具有部署的过程逻辑零件。在部署期间，系统维护程序逻辑组件和数据库请求组件之间的关联。系统将程序逻辑组件的内部表示复制到目标系统，而无需再生。系统重新生成数据库请求组件以在目标系统上重新创建查询过程，并在过程逻辑组件和数据库请求组件之间保持一致的接口。

2. 发明申请

US20060288052A1 Supporting multiple versions of a routine 有权
公开(公告)号：US20060288052A1
公开(公告)日：2006-12-21
申请号：US11156509
申请日：2005-06-17
申请人： Yao-Ching Chen , Curt Cotner , Baoqiu Cui , Tammie Dang , Joe Huang , Claire McFeely , Robert Miller , Manogari Simanjuntak , Yumi Tsuji , Xiaoyu Yang , Jay Yothers , Margaret Zagelow
发明人： Yao-Ching Chen , Curt Cotner , Baoqiu Cui , Tammie Dang , Joe Huang , Claire McFeely , Robert Miller , Manogari Simanjuntak , Yumi Tsuji , Xiaoyu Yang , Jay Yothers , Margaret Zagelow
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99952 , Y10S707/99953
摘要： Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.

3. 发明申请

US20050125410A1 Package resolution mechanism for database systems 有权
标题翻译：数据库系统的包解析机制
公开(公告)号：US20050125410A1
公开(公告)日：2005-06-09
申请号：US10730192
申请日：2003-12-04
申请人： Curt Cotner , Tammie Dang , Brian Howell , Fung Lee , Hui-An Lee , Charles Lin , Claire McFeely , Jennifer Ou , James Pickel , Jay Yothers
发明人： Curt Cotner , Tammie Dang , Brian Howell , Fung Lee , Hui-An Lee , Charles Lin , Claire McFeely , Jennifer Ou , James Pickel , Jay Yothers
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30595
摘要： A method and system for providing package resolution in a database system is disclosed. The method and system comprise providing a statement within a server which allows an application to identify a list of package collections. The method and system further includes executing the statement to obtain the appropriate package. A system and method in accordance with the present invention provides a new current package path value, which is set via a statement referred to as Set Current Package Path. The SET CURRENT PACKAGE PATH statement allows the application to supply a precedence list of qualified package collections during execution time, therefore the scheme for resolving packages can be changed at any point during execution. The SET CURRENT PACKAGE PATH statement improves application development by making the package resolution mechanism less error prone and less tedious for the application developer, while providing an optimal-performance solution in the client-server environment.
摘要翻译：公开了一种在数据库系统中提供打包分辨率的方法和系统。方法和系统包括在服务器内提供允许应用程序识别包集合列表的语句。该方法和系统还包括执行该语句以获得适当的包。根据本发明的系统和方法提供新的当前包路径值，其通过称为设置当前包路径的语句来设置。 SET CURRENT PACKAGE PATH语句允许应用程序在执行时间内提供合格的包集合的优先列表，因此可以在执行期间的任何时候更改解决包的方案。 SET CURRENT PACKAGE PATH语句通过使程序包解析机制对于应用程序开发人员而言更不容易出错，更乏味，同时在客户端 - 服务器环境中提供最佳性能解决方案，从而改进了应用程序开发。

4. 发明申请

US20050144276A1 Method, system and mechanism to multiplex multiple application server requests over a single database connection 有权
标题翻译：通过单个数据库连接复用多个应用程序服务器请求的方法，系统和机制
公开(公告)号：US20050144276A1
公开(公告)日：2005-06-30
申请号：US10729636
申请日：2003-12-04
申请人： Paul Bird , William Bireley , Curt Cotner , Tammie Dang , Margaret Dong , Georgia Fuller , Michelle Lam , James Pickel , Frankie Sun
发明人： Paul Bird , William Bireley , Curt Cotner , Tammie Dang , Margaret Dong , Georgia Fuller , Michelle Lam , James Pickel , Frankie Sun
IPC分类号： G06F15/16 , G06F15/173 , G06F17/30
CPC分类号： G06F17/3056 , G06F17/30348 , G06F17/30445 , Y10S707/99953
摘要： In a method and system for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.
摘要翻译：在用于通过单个数据库连接避免应用程序服务器请求的部分冲突的方法和系统中，数据库服务器为应用程序内为相同处理级别打开的同一个游标的每个实例分配查询标识符，允许同一光标的多个实例并行处理，无分段碰撞。应用程序服务器为通过单个数据库连接发送的每个语句分配命令源标识符，以唯一标识语句的应用程序源。这适用于同一应用程序中由不同应用程序源发送的相同语句的倍数，对于包含多个应用程序源的单个语句，以及来自通过单个数据库连接复用的不同应用程序的多个语句。这些语句可以彼此分开处理，也可以彼此并行处理，而不会出现部分冲突。

5. 发明申请

US20050177590A1 Low-overhead built-in timestamp column for relational database systems 有权
标题翻译：关系数据库系统的低开销内置时间戳列
公开(公告)号：US20050177590A1
公开(公告)日：2005-08-11
申请号：US10777604
申请日：2004-02-11
申请人： Yao-Ching Chen , Curt Cotner
发明人： Yao-Ching Chen , Curt Cotner
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99933 , Y10S707/99943
摘要： An improved automatically updated timestamp for database systems is disclosed. The automatically updated timestamp can be provided in a hidden timestamp column for a table, where the value of the timestamp column can be retrieved with a query that calls the column by name. Optionally, the timestamp column can be provided for each table in the database system to ensure its availability to applications. For cases where a timestamp for each row in a table is not desired, an automatically updated timestamp can be provided for a data page. This timestamp can be retrieved from an update timestamp recorded on disk and in the buffer pool or from a log relative byte address. Although this is a page-level timestamp, its use may be desirable for infrequently updated tables or where space on the disk and buffer pool is at a premium.
摘要翻译：公开了一种用于数据库系统的改进的自动更新时间戳。可以在表的隐藏时间戳列中提供自动更新的时间戳，其中可以使用按名称调用列的查询来检索时间戳列的值。可选地，可以为数据库系统中的每个表提供时间戳列，以确保其对应用程序的可用性。对于不需要表中每行的时间戳的情况，可以为数据页提供自动更新的时间戳。可以从记录在磁盘和缓冲池中的更新时间戳记或从日志相对字节地址检索此时间戳。虽然这是一个页面级的时间戳，但是对于不经常更新的表或者磁盘和缓冲池上的空间是非常重要的，它的使用可能是可取的。

6. 发明申请

US20050125445A1 High performance support for XA protocols in a clustered shared database 有权
标题翻译：在群集共享数据库中对XA协议的高性能支持
公开(公告)号：US20050125445A1
公开(公告)日：2005-06-09
申请号：US10726700
申请日：2003-12-04
申请人： Curt Cotner , Brian Howell , Jeffrey Josten , James Pickel
发明人： Curt Cotner , Brian Howell , Jeffrey Josten , James Pickel
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30371 , Y10S707/99953
摘要： A shared memory device called the Coupling Facility (CF) is used to record the indoubt transaction entries for each member of the database cluster, avoiding the CPU cost and elapsed time impact of persisting this information to disk (either via a log write or a relational table I/O). The CF provides full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, the CF will contain the full list of indoubt transactions for the entire database cluster. CF duplexing is used to guarantee the integrity of the CF structure used for the indoubt list. In the event of complete loss of both CF structures (which will not happen except in major disaster situations), data sharing group restart processing can reconstruct the CF structures from the individual member logs.
摘要翻译：称为耦合设施（CF）的共享内存设备用于记录数据库集群中每个成员的不确定事务条目，从而避免将此信息持续存储在磁盘上的CPU成本和耗时时间（通过日志写入或关系表I / O）。 CF为数据库集群中的所有成员提供完全读/写访问和数据一致性并发访问。在任何给定的时间点，CF将包含整个数据库集群的不确定事务的完整列表。 CF双工用于确保用于不确定列表的CF结构的完整性。在CF结构完全丢失的情况下（除主要灾害情况外不会发生），数据共享组重新启动处理可以从各个成员日志中重构CF结构。

7. 发明申请

US20060143436A1 Method and system for providing and utilizing a network trusted context 失效
标题翻译：提供和利用网络可信环境的方法和系统
公开(公告)号：US20060143436A1
公开(公告)日：2006-06-29
申请号：US11023921
申请日：2004-12-27
申请人： Paul Bird , Gayathiri Chandran , Curt Cotner , Adrian Lobo , James Pickel , Walid Rjaibi
发明人： Paul Bird , Gayathiri Chandran , Curt Cotner , Adrian Lobo , James Pickel , Walid Rjaibi
IPC分类号： H04L9/00
CPC分类号： H04L63/08 , H04L63/102
摘要： A method and system for establishing a connection between a data server and a middleware server is disclosed. The method and system include defining a plurality of trust attributes corresponding to a trusted context between the middleware server and the data server and validating the plurality of trust attributes against a plurality of attributes corresponding to the middleware server. The plurality of attributes provided in a connection request. The method and system also include establishing the trusted context based on the validating the plurality of trust attributes.
摘要翻译：公开了一种用于在数据服务器和中间件服务器之间建立连接的方法和系统。所述方法和系统包括定义与中间件服务器和数据服务器之间的可信上下文相对应的多个信任属性，并针对对应于中间件服务器的多个属性来验证多个信任属性。在连接请求中提供的多个属性。所述方法和系统还包括基于验证所述多个信任属性建立所述受信任上下文。

8. 发明申请

US20070239719A1 HIGH PERFORMANCE SUPPORT FOR XA PROTOCOLS IN A CLUSTERED SHARED DATABASE 有权
标题翻译：在一个集群共享数据库中的XA协议的高性能支持
公开(公告)号：US20070239719A1
公开(公告)日：2007-10-11
申请号：US11764962
申请日：2007-06-19
申请人： Curt Cotner , Brian Howell , Jeffrey Josten , James Pickel
发明人： Curt Cotner , Brian Howell , Jeffrey Josten , James Pickel
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , Y10S707/99953
摘要： A shared memory device called the Coupling Facility (CF) is used to record the indoubt transaction entries for each member of the database cluster, avoiding the CPU cost and elapsed time impact of persisting this information to disk (either via a log write or a relational table I/O). The CF provides full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, the CF will contain the full list of indoubt transactions for the entire database cluster. CF duplexing is used to guarantee the integrity of the CF structure used for the indoubt list. In the event of complete loss of both CF structures (which will not happen except in major disaster situations), data sharing group restart processing can reconstruct the CF structures from the individual member logs.
摘要翻译：称为耦合设施（CF）的共享内存设备用于记录数据库集群中每个成员的不确定事务条目，从而避免将此信息持续存储在磁盘上的CPU成本和耗时时间（通过日志写入或关系表I / O）。 CF为数据库集群中的所有成员提供完全读/写访问和数据一致性并发访问。在任何给定的时间点，CF将包含整个数据库集群的不确定事务的完整列表。 CF双工用于确保用于不确定列表的CF结构的完整性。在CF结构完全丢失的情况下（除主要灾害情况外不会发生），数据共享组重新启动处理可以从各个成员日志中重构CF结构。

9. 发明申请

US20050144299A1 System and method for supporting XA 2-phase commit protocols with a loosely coupled clustered database server 审中-公开
标题翻译：用松散耦合的集群数据库服务器支持XA两阶段提交协议的系统和方法
公开(公告)号：US20050144299A1
公开(公告)日：2005-06-30
申请号：US10726702
申请日：2003-12-04
申请人： Delmar Blevins , Curt Cotner , Stephen Kinder , James Pickel , Matthew Sykes , Hong Tie
发明人： Delmar Blevins , Curt Cotner , Stephen Kinder , James Pickel , Matthew Sykes , Hong Tie
IPC分类号： G06F15/16 , G06F17/30
CPC分类号： G06F16/2455 , G06F16/284
摘要： Indoubt transaction entries are recorded for each member of a database cluster, thereby avoiding the CPU cost and elapsed-time impact of persisting this information to a disk (either via a log write or a relational table I/O). This implementation allows for full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, a full list of indoubt transactions is maintained for the entire database cluster in a relational table (e.g., an SQL table).
摘要翻译：为数据库集群的每个成员记录不确定的事务条目，从而避免将该信息持久存储在磁盘上（通过日志写入或关系表I / O）的CPU成本和经过时间的影响。此实现允许完全读/写访问和数据一致性，以便数据库集群中的所有成员进行并发访问。在任何给定的时间点，关系表（例如，SQL表）中的整个数据库集群都会维护完整的不确定事务清单。

10. 发明申请

US20070244898A1 ROW-LEVEL SECURITY IN A RELATIONAL DATABASE MANAGEMENT SYSTEM 失效
标题翻译：关系数据库管理系统中的ROW级安全性
公开(公告)号：US20070244898A1
公开(公告)日：2007-10-18
申请号：US11746896
申请日：2007-05-10
申请人： Curt Cotner , Roger Miller
发明人： Curt Cotner , Roger Miller
IPC分类号： G06F17/30
CPC分类号： G06F21/6227 , G06F17/30289 , G06F17/30595 , G06F2221/2113 , G06F2221/2145 , Y10S707/954 , Y10S707/956 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99939
摘要： An access control system and access control methods provide multilevel and mandatory access control for a database management system. The access control techniques provide access control at the row level in a relational database table. The database table contains a security label column within which is recorded a security label that is defined within a hierarchical security scheme. A user's security label is encoded with security information concerning the user. When a user requests access to a row, a security mechanism compares the user's security information with the security information in the row. If the user's security dominates the row's security, the user is given access to the row.
摘要翻译：访问控制系统和访问控制方法为数据库管理系统提供多级和强制访问控制。访问控制技术在关系数据库表中的行级别提供访问控制。数据库表包含一个安全标签列，其中记录了在分层安全机制中定义的安全标签。用户的安全标签被编码与关于用户的安全信息。当用户请求访问行时，安全机制将用户的安全信息与行中的安全信息进行比较。如果用户的安全性主导了该行的安全性，则该用户可以访问该行。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式