-
公开(公告)号：US07464071B2
公开(公告)日：2008-12-09
申请号：US11117586
申请日：2005-04-28
IPC分类号： G06F7/00
CPC分类号： G06F17/30463 , G06F17/30474 , Y10S707/99932 , Y10S707/99933
摘要： A suggested query execution plan is used as a constraint on a guided optimization process such that all execution plans that do not conform to the suggested execution plan are eliminated as possible alternatives. If the guided optimization process successfully generates a resulting execution plan, then the result will conform to the suggested execution plan. If the guided optimization process fails to generate a resulting execution plan, then it may be determined that the suggested execution plan is invalid.
摘要翻译： 建议的查询执行计划被用作引导优化过程的约束，使得不符合建议的执行计划的所有执行计划作为可能的替代方案被消除。 如果引导优化过程成功生成结果执行计划，则结果将符合建议的执行计划。 如果引导优化过程无法生成结果执行计划，则可以确定建议的执行计划无效。
-
公开(公告)号：US20060248046A1
公开(公告)日：2006-11-02
申请号：US11117586
申请日：2005-04-28
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30474 , Y10S707/99932 , Y10S707/99933
摘要： A suggested query execution plan is used as a constraint on a guided optimization process such that all execution plans that do not conform to the suggested execution plan are eliminated as possible alternatives. If the guided optimization process successfully generates a resulting execution plan, then the result will conform to the suggested execution plan. If the guided optimization process fails to generate a resulting execution plan, then it may be determined that the suggested execution plan is invalid.
摘要翻译： 建议的查询执行计划被用作引导优化过程的约束，使得不符合建议的执行计划的所有执行计划作为可能的替代方案被消除。 如果引导优化过程成功生成结果执行计划，则结果将符合建议的执行计划。 如果引导优化过程无法生成结果执行计划，则可以确定建议的执行计划无效。
-
公开(公告)号：US20060224563A1
公开(公告)日：2006-10-05
申请号：US11098949
申请日：2005-04-05
申请人： Eric Hanson , Cesar Galindo-Legaria , Lubor Kollar , Ganapathy Krishnamoorthy , Sameer Verkhedkar , Evgueni Zabokritski , Erik Ismert
发明人： Eric Hanson , Cesar Galindo-Legaria , Lubor Kollar , Ganapathy Krishnamoorthy , Sameer Verkhedkar , Evgueni Zabokritski , Erik Ismert
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , Y10S707/99932 , Y10S707/99934
摘要： A system and method for creation, modification and/or use of plan guide(s) is provided. Plan guide(s) can be employed to optimize the performance of query(ies) when it is not possible and/or desirable to change the text of the query directly. Plan guides can be useful, for example, when a small subset of queries in a database application deployed from a third-party vendor is not performing as expected. Plan guides influence optimization of queries by attaching query hints to them. In accordance with an aspect of the subject invention, a query plan execution system is provided. The system includes an execution component, a query optimizer, and, a plan cache. Plan guides and other associated metadata are stored in a plan guide metadata store.
-
公开(公告)号：US20050187944A1
公开(公告)日：2005-08-25
申请号：US10776370
申请日：2004-02-10
申请人： Alazel Acheson , Shrinivas Ashwin , Jose Blakeley , Peter Carlin , Erik Ismert , Christian Kleinerman , Ganapathy Krishnamoorthy , Girikumar Nair
发明人： Alazel Acheson , Shrinivas Ashwin , Jose Blakeley , Peter Carlin , Erik Ismert , Christian Kleinerman , Ganapathy Krishnamoorthy , Girikumar Nair
IPC分类号： G06F7/00
CPC分类号： G06F17/30595 , G06F17/3041
摘要： Various embodiments of the present invention enable functions, procedures, and triggers to be written in any of the .NET languages and executed by the RDBMS. User code can access data from the local or other SQL servers using the SQL Programming Model and both the SqlServer or SqlClient implementations respectively. Moreover, to improve upon the previous extensibility mechanism, a set of APIs (commonly known as “the in-process provider” or “inproc provider”) is utilized to provide efficient and easy to use data access while running inproc, a data access API that is an implementation of the ADO.net programming model.
摘要翻译： 本发明的各种实施例使功能，过程和触发器能够以任何.NET语言编写并由RDBMS执行。 用户代码可以分别使用SQL编程模型和SqlServer或SqlClient实现访问来自本地或其他SQL服务器的数据。 此外，为了改进以前的可扩展性机制，使用一组API（通常称为“进程内提供程序”或“inproc提供程序”）来在运行inproc时提供高效且易于使用的数据访问，数据访问API 这是ADO.net编程模型的实现。
-
公开(公告)号：US20050182800A1
公开(公告)日：2005-08-18
申请号：US10773724
申请日：2004-02-06
IPC分类号： G06F17/30
CPC分类号： G06F17/3056 , Y10S707/99934 , Y10S707/99952 , Y10S707/99954
摘要： Systems and methodologies are provided as part of a computing environment that implements an enhanced tabular data stream (TDS) protocol. Such enhanced TDS protocol can mitigate synchronization inconsistencies between client and servers, improve robustness of the data transfer, facilitate password specification as part of login procedures, and reduce administration overhead. Various headers are provided as part of the data stream protocol, and a versioning scheme is established that facilitates proper communication between servers and clients having different release dates and versions of the TDS protocol.
摘要翻译： 提供系统和方法作为实现增强的表格数据流（TDS）协议的计算环境的一部分。 这种增强的TDS协议可以减轻客户端和服务器之间的同步不一致性，提高数据传输的鲁棒性，便于作为登录过程一部分的密码规范，并减少管理开销。 提供了各种头部作为数据流协议的一部分，并且建立了一种版本控制方案，其促进具有不同发布日期和版本的TDS协议的服务器和客户端之间的正确通信。
-
6.发明授权System and method for delayed fetching of designated members of a user defined type 失效延迟提取用户定义类型的指定成员的系统和方法公开(公告)号：US07548901B2
公开(公告)日：2009-06-16
申请号：US10879326
申请日：2004-06-29
申请人： Shrinivas Ashwin , Christian Kleinerman , Eugene Zabokritski , Ganapathy Krishnamoorthy , Giri Nair
发明人： Shrinivas Ashwin , Christian Kleinerman , Eugene Zabokritski , Ganapathy Krishnamoorthy , Giri Nair
IPC分类号： G06F17/30
CPC分类号： G06F17/30471 , G06F17/30492 , Y10S707/99932 , Y10S707/99934
摘要： A number of members of a user defined type may be designated as delayable members. During an initial fetch of the type, the type may be returned from the database without the delayable members, thereby preserving valuable bandwidth and reducing the amount of time required to perform the initial fetch. Upon request, selected delayable members may be re-fetched from the database at a later time without returning the other members provided during the initial fetch.
摘要翻译： 用户定义类型的多个成员可以被指定为可延迟的成员。 在类型的初始提取期间，可以从数据库返回类型，而不需要可延迟的成员，从而保留有价值的带宽并减少执行初始提取所需的时间量。 根据请求，可以在稍后时间从数据库重新获取所选择的可延迟成员，而不返回在初始提取期间提供的其他成员。
-
7.发明授权公开(公告)号：US07333992B2
公开(公告)日：2008-02-19
申请号：US10445095
申请日：2003-05-22
IPC分类号： G06F7/30
CPC分类号： G06F17/30368 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945
摘要： A base table is scanned with a delete marker and an insert marker. The delete marker identifies a last change committed to the base table as part of a transaction prior to execution of a statement, and the insert marker identifies a last change committed to base table as part of the transaction during execution of the statement. The results of the delete marker scan are filtered with deletions stored in a delta table, and a delete table is populated with the filtered rows. The results of the insert scan are filtered with insertions stored in the delta table, and an insert table is populated with the filtered rows.
摘要翻译： 使用删除标记和插入标记扫描基表。 删除标记在执行语句之前标识作为事务的一部分提交给基表的最后一个更改，并且在执行语句期间，插入标记将提交给基表的最后一个更改标识为事务的一部分。 使用存储在增量表中的删除过滤删除标记扫描的结果，并使用已过滤的行填充删除表。 使用存储在增量表中的插入过滤插入扫描的结果，并使用已过滤的行填充插入表。
-
8.发明申请System and method for delayed fetching of designated members of a user defined type 失效延迟提取用户定义类型的指定成员的系统和方法公开(公告)号：US20050289160A1
公开(公告)日：2005-12-29
申请号：US10879326
申请日：2004-06-29
申请人： Shrinivas Ashwin , Christian Kleinerman , Eugene Zabokritski , Ganapathy Krishnamoorthy , Giri Nair
发明人： Shrinivas Ashwin , Christian Kleinerman , Eugene Zabokritski , Ganapathy Krishnamoorthy , Giri Nair
CPC分类号： G06F17/30471 , G06F17/30492 , Y10S707/99932 , Y10S707/99934
摘要： A number of members of a user defined type may be designated as delayable members. During an initial fetch of the type, the type may be returned from the database without the delayable members, thereby preserving valuable bandwidth and reducing the amount of time required to perform the initial fetch. Upon request, selected delayable members may be re-fetched from the database at a later time without returning the other members provided during the initial fetch.
摘要翻译： 用户定义类型的多个成员可以被指定为可延迟的成员。 在类型的初始提取期间，可以从数据库返回类型，而不需要可延迟的成员，从而保留有价值的带宽并减少执行初始提取所需的时间量。 根据请求，可以在稍后时间从数据库重新获取所选择的可延迟成员，而不返回在初始提取期间提供的其他成员。
-
-
-
-
-
-
-
搜索结果
8 条记录 (耗时 0.024 秒)
