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

1. 发明申请

WO2018212856A1 METHOD FOR OPTIMIZATION OF IMPERATIVE CODE EXECUTING INSIDE A RELATIONAL DATABASE ENGINE 审中-公开
公开(公告)号：WO2018212856A1
公开(公告)日：2018-11-22
申请号：PCT/US2018/027206
申请日：2018-04-12
申请人： MICROSOFT TECHNOLOGY LICENSING, LLC
发明人： RAMACHANDRA, Karthik Saligrama , PARK, Kwanghyun , HALVERSON, Alan Dale , CUNNINGHAM, Conor John , GALINDO-LEGARIA, Cesar Alejandro , EMANI, Kameswara Venkatesh
IPC分类号： G06F17/30
摘要： Processing a database query. A method includes receiving a database query from a user. The database query includes one or more imperative functions. The one or more imperative functions are converted to one or more declarative query representations. The one or more declarative query representations include standardized relational operators included in a relational query language. Further, the one or more declarative query representations are optimizable by a query optimizer of the database. The database query is optimized at the query optimizer to create a query plan by evaluating any declarative query representation originally in the database query received from the user and the one or more declarative query representations.

2. 发明申请

WO2022212030A1 DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS 审中-公开
公开(公告)号：WO2022212030A1
公开(公告)日：2022-10-06
申请号：PCT/US2022/020289
申请日：2022-03-15
申请人： MICROSOFT TECHNOLOGY LICENSING, LLC
发明人： SINGH, Sarvesh , HALVERSON, Alan Dale , LINGAM, Sandeep , RANGARAJAN, Srikumar
IPC分类号： G06F16/2455 , G06F16/2458 , G06F16/901 , G06F16/24568 , G06F16/2471 , G06F16/27 , G06F16/9024 , G06F9/466
摘要： Methods for data visibility in nested transactions in distributed systems are performed by systems and devices. Distributed executions of queries are performed in processing systems according to isolation level protocols with unique nested transaction identifiers for data management and versioning across one or more data sets, one or more compute pools, etc., within a logical server via a single transaction manager that oversees the isolation semantics and data versioning. A distributed query processor of the systems and devices performs nested transaction versioning for distributed tasks by generating nested transaction identifiers, encoded in data rows, which are used to enforce correct data visibility. Data visibility is restricted to previously committed data from distributed transactions and tasks, and is blocked for distributed transactions and tasks that run concurrently. Local commits for completed transactions and tasks are used to minimize transaction manager interactions, and instant rollbacks are enabled for aborted transactions and tasks.

3. 发明授权

EP2973027B1 EXECUTING STORED PROCEDURES AT PARALLEL DATABASES 有权
标题翻译：与并行数据库执行中的存储过程
公开(公告)号：EP2973027B1
公开(公告)日：2017-04-19
申请号：EP14717544.2
申请日：2014-03-10
申请人： Microsoft Technology Licensing, LLC
发明人： TELETIA, Nikhil , HALVERSON, Alan Dale , YEGOROV, Artem D.
IPC分类号： G06F17/30
CPC分类号： G06F17/30477 , G06F17/30415 , G06F17/30442 , G06F17/30445 , G06F17/30545 , G06F17/30864
摘要： The present invention extends to methods, systems, and computer program products for executed stored procedures at parallel databases. Stored procedures are transformed so that execution of the stored procedure is split between a standalone database server and a parallel database coordinator. Execution of the stored procedure is initiated at the standalone database server. At execution time, control-flow statements, variable assignment, expression evaluation, etc., are handled by the standalone database server. SQL statements are passed from the standalone database server to the database for the execution. Results from executed SQL statements can be returned to the standalone database server or to a client. The parallel database coordinator can be added as a linked server to the standalone database server. In some embodiments, a session token is used to share session state between different parties.

4. 发明公开

EP4315100A1 DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS 审中-实审
公开(公告)号：EP4315100A1
公开(公告)日：2024-02-07
申请号：EP22717691.4
申请日：2022-03-15
申请人： Microsoft Technology Licensing, LLC
发明人： SINGH, Sarvesh , HALVERSON, Alan Dale , LINGAM, Sandeep , RANGARAJAN, Srikumar
IPC分类号： G06F16/2455 , G06F16/2458 , G06F16/901

6. 发明公开

EP2973027A1 EXECUTING STORED PROCEDURES AT PARALLEL DATABASES 有权
标题翻译： AUSFÜHRUNGGESPEICHERTER PROZEDUREN MIT并列DATENBANKEN
公开(公告)号：EP2973027A1
公开(公告)日：2016-01-20
申请号：EP14717544.2
申请日：2014-03-10
申请人： Microsoft Technology Licensing, LLC
发明人： TELETIA, Nikhil , HALVERSON, Alan Dale , YEGOROV, Artem D.
IPC分类号： G06F17/30
CPC分类号： G06F17/30477 , G06F17/30415 , G06F17/30442 , G06F17/30445 , G06F17/30545 , G06F17/30864
摘要： The present invention extends to methods, systems, and computer program products for executed stored procedures at parallel databases. Stored procedures are transformed so that execution of the stored procedure is split between a standalone database server and a parallel database coordinator. Execution of the stored procedure is initiated at the standalone database server. At execution time, control-flow statements, variable assignment, expression evaluation, etc., are handled by the standalone database server. SQL statements are passed from the standalone database server to the database for the execution. Results from executed SQL statements can be returned to the standalone database server or to a client. The parallel database coordinator can be added as a linked server to the standalone database server. In some embodiments, a session token is used to share session state between different parties.
摘要翻译：本发明扩展到用于并行数据库中执行的存储过程的方法，系统和计算机程序产品。转换存储过程，以便在独立数据库服务器和并行数据库协调器之间分割存储过程的执行。在独立数据库服务器上启动存储过程的执行。在执行时，控制流程语句，变量赋值，表达式求值等由独立数据库服务器处理。 SQL语句从独立数据库服务器传递到数据库以进行执行。执行的SQL语句的结果可以返回到独立数据库服务器或客户端。并行数据库协调器可以作为链接服务器添加到独立数据库服务器。在一些实施例中，使用会话令牌来共享不同方之间的会话状态。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式