-
1.发明授权公开(公告)号：US07203672B2
公开(公告)日：2007-04-10
申请号：US10865178
申请日：2004-06-09
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99932 , Y10S707/99938
摘要： Techniques are provided for processing, within a database server, a database statement, where at least one subtask required by the database statement is to be executed in parallel by a slave set. The database server determines whether the database statement includes an external expression, relative to the subtask, that (a) produces information that is required by slave processes in the slave set in order to perform the subtask, and (b) is not to be evaluated by each slave process in the slave set. During execution of the statement, if the database statement includes an external expression, then one or more external values are generated by causing the external expression to be evaluated, and the one or more external values are communicated to slaves of the slave set to allow the slave processes to perform respective portions of the subtask in parallel, without requiring each slave of the slave set to evaluate the external expression.
摘要翻译： 提供技术来在数据库服务器内处理数据库语句，数据库语句所要求的至少一个子任务将由从属集并行执行。 数据库服务器确定数据库语句是否包含相对于子任务的外部表达式，（a）产生从属集中的从属进程所需的信息以执行子任务，并且（b）不被评估 由从设备中的每个从属进程。 在执行语句期间，如果数据库语句包含外部表达式，则通过使外部表达式进行求值来生成一个或多个外部值，并将一个或多个外部值传送到从设备的从站，以允许 从属进程并行执行子任务的各个部分，而不需要从属集的每个从属点来评估外部表达式。
-
2.发明申请公开(公告)号：US20050131890A1
公开(公告)日：2005-06-16
申请号：US10865178
申请日：2004-06-09
CPC分类号： G06F17/30445 , Y10S707/99932 , Y10S707/99938
摘要： Techniques are provided for processing, within a database server, a database statement, where at least one subtask required by the database statement is to be executed in parallel by a slave set. The database server determines whether the database statement includes an external expression, relative to the subtask, that (a) produces information that is required by slave processes in the slave set in order to perform the subtask, and (b) is not to be evaluated by each slave process in the slave set. During execution of the statement, if the database statement includes an external expression, then one or more external values are generated by causing the external expression to be evaluated, and the one or more external values are communicated to slaves of the slave set to allow the slave processes to perform respective portions of the subtask in parallel, without requiring each slave of the slave set to evaluate the external expression.
摘要翻译： 提供技术来在数据库服务器内处理数据库语句，数据库语句所要求的至少一个子任务将由从属集并行执行。 数据库服务器确定数据库语句是否包含相对于子任务的外部表达式，（a）产生从属集中的从属进程所需的信息以执行子任务，并且（b）不被评估 由从设备中的每个从属进程。 在执行语句期间，如果数据库语句包含外部表达式，则通过使外部表达式进行求值来生成一个或多个外部值，并将一个或多个外部值传送到从设备的从站，以允许 从属进程并行执行子任务的各个部分，而不需要从属集的每个从属点来评估外部表达式。
-
3.发明授权Executing nested subqueries of parallel table functions in the parallel single cursor model 有权在并行单光标模型中执行并行表函数的嵌套子查询公开(公告)号：US07451133B2
公开(公告)日：2008-11-11
申请号：US10930433
申请日：2004-08-30
CPC分类号： G06F7/00 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： Techniques are provided for processing a database statement that includes a table function capable of parallel execution, where the input of the table function is specified in a subquery. During compilation of the database statement, a global cursor is generated for the database statement. The global cursor includes a first plan component for executing the table function and a second plan component for generating input for the table function. A “dummy” cursor is then generated. When slaves execute the table function, they call the dummy cursor for input. When a slave calls the dummy cursor for input, the dummy cursor causes a context switch back to the global cursor, so that the second plan component within the first cursor generates the input for the slave.
摘要翻译： 提供了用于处理数据库语句的技术，该数据库语句包括能够并行执行的表函数，其中在子查询中指定了表函数的输入。 在编译数据库语句时，会为数据库语句生成一个全局游标。 全局光标包括用于执行表功能的第一计划组件和用于生成表功能的输入的第二计划组件。 然后生成“虚拟”光标。 当从站执行表功能时，它们调用虚拟光标进行输入。 当从机调用虚拟光标进行输入时，虚拟光标会使上下文切换回全局光标，以便第一个光标中的第二个计划组件生成从属设备的输入。
-
4.发明申请Executing nested subqueries of parallel table functions in the parallel single cursor model 有权在并行单光标模型中执行并行表函数的嵌套子查询公开(公告)号：US20050131880A1
公开(公告)日：2005-06-16
申请号：US10930433
申请日：2004-08-30
IPC分类号： G06F7/00
CPC分类号： G06F7/00 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： Techniques are provided for processing a database statement that includes a table function capable of parallel execution, where the input of the table function is specified in a subquery. During compilation of the database statement, a global cursor is generated for the database statement. The global cursor includes a first plan component for executing the table function and a second plan component for generating input for the table function. A “dummy” cursor is then generated. When slaves execute the table function, they call the dummy cursor for input. When a slave calls the dummy cursor for input, the dummy cursor causes a context switch back to the global cursor, so that the second plan component within the first cursor generates the input for the slave.
摘要翻译： 提供了用于处理数据库语句的技术，该数据库语句包括能够并行执行的表函数，其中在子查询中指定了表函数的输入。 在编译数据库语句时，会为数据库语句生成一个全局游标。 全局光标包括用于执行表功能的第一计划组件和用于生成表功能的输入的第二计划组件。 然后生成“虚拟”光标。 当从站执行表功能时，它们调用虚拟光标进行输入。 当从机调用虚拟光标进行输入时，虚拟光标会使上下文切换回全局光标，以便第一个光标中的第二个计划组件生成从属设备的输入。
-
公开(公告)号：US08707254B2
公开(公告)日：2014-04-22
申请号：US13441225
申请日：2012-04-06
申请人： John M. Oslake , Subramanian Muralidhar , Richard Shawn Bice , Jeffrey Robert Currier , Narayan Mohanrao Nevrekar , Kenneth Van Hyning
发明人： John M. Oslake , Subramanian Muralidhar , Richard Shawn Bice , Jeffrey Robert Currier , Narayan Mohanrao Nevrekar , Kenneth Van Hyning
IPC分类号： G06F9/44
CPC分类号： G06F8/30 , G06F9/5072
摘要： Embodiments are directed to declaratively managing software applications, dynamically applying configuration changes to a specified software application based on a service level objective (SLO) and to efficiently performing an impact analysis for a specified service level agreement SLO.
摘要翻译： 实施例涉及声明性地管理软件应用，基于服务级别目标（SLO）动态地将配置改变应用于指定的软件应用，并且有效地对指定的服务级别协议SLO执行影响分析。
-
公开(公告)号：US20090313436A1
公开(公告)日：2009-12-17
申请号：US12465667
申请日：2009-05-14
申请人： Muralidhar Krishnaprasad , Anil Nori , Subramanian Muralidhar , Sudhir Mohan Jorwekar , Lakshmi Suresh Goduguluru
发明人： Muralidhar Krishnaprasad , Anil Nori , Subramanian Muralidhar , Sudhir Mohan Jorwekar , Lakshmi Suresh Goduguluru
CPC分类号： G06F12/0802 , G06F12/0813
摘要： A cache region can be created in a cache in response to receiving a cache region creation request from an application. A storage request from the application can identify the cache region and one or more objects to be stored in the cache region. Those objects can be stored in the cache region in response to receiving the storage request.
摘要翻译： 响应于从应用程序接收高速缓存区域创建请求，可以在高速缓存中创建高速缓存区域。 来自应用的存储请求可以识别高速缓存区域和要存储在高速缓存区域中的一个或多个对象。 响应于接收到存储请求，可以将这些对象存储在高速缓存区域中。
-
公开(公告)号：US20080319957A1
公开(公告)日：2008-12-25
申请号：US11764851
申请日：2007-06-19
申请人： Subramanian Muralidhar , Simon Cavanagh , Steve Starck , Sean B. House , Fabio Meireles Fernandez Valbuena , Katica Iceva , Ramesh Nagarajan
发明人： Subramanian Muralidhar , Simon Cavanagh , Steve Starck , Sean B. House , Fabio Meireles Fernandez Valbuena , Katica Iceva , Ramesh Nagarajan
IPC分类号： G06F17/30
CPC分类号： G06F16/24526
摘要： Systems and methods that provide for a canonical representation in a structured form of a query, against a data model platform. A parser component can parse the SQL query to generate the abstract class that represent the query (command tree). Moreover, a view generation component can supply a mapping between a rich structure (e.g., on the client side) and the relational side. Accordingly, a query can be represented by an abstract class in form of a tree structure with nodes, which has metadata tied therewith.
摘要翻译： 针对数据模型平台提供查询结构化形式的规范表示的系统和方法。 解析器组件可以解析SQL查询以生成表示查询（命令树）的抽象类。 此外，视图生成组件可以提供丰富结构（例如，在客户端侧）和关系侧之间的映射。 因此，查询可以由具有节点的树结构的形式的抽象类表示，其具有与之相关联的元数据。
-
公开(公告)号：US20080250073A1
公开(公告)日：2008-10-09
申请号：US11697234
申请日：2007-04-05
申请人： Anil Kumar Nori , Laxmi Narsimha Rao Oruganti , Subramanian Muralidhar , Ambrish Mishra , Lev Novik , Manikandan Thangarathnam , Sankara Subramanian , Sudarshan A. Chitre , Sitaram C.V. Raju , Vijay Tandra Sistla
发明人： Anil Kumar Nori , Laxmi Narsimha Rao Oruganti , Subramanian Muralidhar , Ambrish Mishra , Lev Novik , Manikandan Thangarathnam , Sankara Subramanian , Sudarshan A. Chitre , Sitaram C.V. Raju , Vijay Tandra Sistla
IPC分类号： G06F17/00
CPC分类号： G06F17/30368
摘要： Systems and methods that track changes in a database via a change tracking layer that enables separation of change tracking and change enumeration. Such an arrangement enables multiple change enumeration and sync technologies over a single change tracking layer, while reducing amount of tracking information that are maintained.
摘要翻译： 通过变化跟踪层跟踪数据库中的更改的系统和方法，该变化跟踪层可实现变更跟踪和更改枚举的分离。 这样的布置使得能够通过单个改变跟踪层进行多次更改枚举和同步技术，同时减少维护的跟踪信息的数量。
-
公开(公告)号：US07320061B2
公开(公告)日：2008-01-15
申请号：US10912426
申请日：2004-08-05
申请人： Qin Yu , Subramanian Muralidhar
发明人： Qin Yu , Subramanian Muralidhar
IPC分类号： G06F12/00
CPC分类号： G06F17/30318
摘要： Methods and apparatus for efficiently storing data in a variable array (VARRAY) of a database system are disclosed. A method for storing data in a VARRAY having an associated large object segment in a system having a memory and a kernel includes determining a size of data to be inserted into the VARRAY. The method also includes determining when the size of the data is less than a threshold value, and storing the data as inline raw data in a column of the VARRAY that is present in the memory when the size of the data is less than the threshold value. When the size of the data is not less than the threshold value, the data is stored in a large object that is associated with the VARRAY. Further, when a VARRAY type is evolved to have a larger maximum size, existing data is not migrated or transformed.
摘要翻译： 公开了将数据有效地存储在数据库系统的可变数组（VARRAY）中的方法和装置。 在具有存储器和内核的系统中具有相关联的大对象段的VARRAY中存储数据的方法包括确定要插入到VARRAY中的数据的大小。 该方法还包括当数据的大小小于阈值时确定数据的大小是否小于阈值，并且当数据的大小小于阈值时，将数据作为内联原始数据存储在存在于存储器中的VARRAY的列中 。 当数据的大小不小于阈值时，数据存储在与VARRAY相关联的大对象中。 此外，当VARRAY类型演变为具有较大的最大大小时，现有数据不会迁移或转换。
-
10.发明授权公开(公告)号：US06889229B1
公开(公告)日：2005-05-03
申请号：US09968617
申请日：2001-09-28
IPC分类号： G06F17/30
CPC分类号： G06F17/30581 , Y10S707/954 , Y10S707/955 , Y10S707/99943
摘要： Techniques for replicating a database object of a relational database managed by a database system from a first node on a network to a second node on the network include determining that the database object on the first node includes a user-defined object. A first routine of the database system is invoked. The first routine performs the step of copying the database object to the second node of the network. The first routine copies a name of a user-defined defined type of the user-defined object from the first node to the second node. The first routine also copies a first definition of the user-defined type from the first node to the second node. The first routine then copies a second definition of the database object from the first node to the second node. The second definition includes the name of the user-defined type. These techniques provide the benefits of peer-to-peer replication in a distributed database to users of object-relational databases that including user-defined objects.
摘要翻译： 将由数据库系统管理的关系数据库的数据库对象从网络上的第一节点复制到网络上的第二节点的技术包括确定第一节点上的数据库对象包括用户定义的对象。 调用数据库系统的第一个例程。 第一个例程执行将数据库对象复制到网络的第二个节点的步骤。 第一个例程将用户定义的用户定义的类型的名称从第一个节点复制到第二个节点。 第一例程还将用户定义类型的第一定义从第一节点复制到第二节点。 然后，第一个例程将数据库对象的第二个定义从第一个节点复制到第二个节点。 第二个定义包括用户定义类型的名称。 这些技术为包括用户定义的对象的对象关系数据库的用户提供了分布式数据库中对等复制的好处。
-
-
-
-
-
-
-
-
-
搜索结果
41 条记录 (耗时 0.033 秒)