-
公开(公告)号：US20050154714A1
公开(公告)日：2005-07-14
申请号：US10767501
申请日：2004-01-29
申请人： Qin Yu , Adiel Yoaz , Subramanian Muralidhar , Visar Nimani , Susan Kotsovolos
发明人： Qin Yu , Adiel Yoaz , Subramanian Muralidhar , Visar Nimani , Susan Kotsovolos
IPC分类号： G06F17/30
CPC分类号： G06F17/30979 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943
摘要： A request to execute a query is received in a database system. In response, the database system determines that a collection of data elements to be returned by the query corresponds to a first data structure not defined within a type dictionary of the database system. The database system obtains attribute values that describe respective data fields within the first data structure, and records, within the type dictionary, a first data type definition that specifies the data fields described by the attribute values.
摘要翻译： 在数据库系统中接收到执行查询的请求。 作为响应，数据库系统确定要由查询返回的数据元素的集合对应于在数据库系统的类型字典内未定义的第一数据结构。 数据库系统获得描述第一数据结构内的相应数据字段的属性值，并在类型字典内记录指定由属性值描述的数据字段的第一数据类型定义。
-
公开(公告)号：US07512599B2
公开(公告)日：2009-03-31
申请号：US10767501
申请日：2004-01-29
CPC分类号： G06F17/30979 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943
摘要： A request to execute a query is received in a database system. In response, the database system determines that a collection of data elements to be returned by the query corresponds to a first data structure not defined within a type dictionary of the database system. The database system obtains attribute values that describe respective data fields within the first data structure, and records, within the type dictionary, a first data type definition that specifies the data fields described by the attribute values.
摘要翻译： 在数据库系统中接收到执行查询的请求。 作为响应，数据库系统确定要由查询返回的数据元素的集合对应于在数据库系统的类型字典内未定义的第一数据结构。 数据库系统获得描述第一数据结构内的相应数据字段的属性值，并在类型字典内记录指定由属性值描述的数据字段的第一数据类型定义。
-
公开(公告)号：US07853619B2
公开(公告)日：2010-12-14
申请号：US10949895
申请日：2004-09-23
CPC分类号： G06F17/30318 , G06F17/30607
摘要： Methods and apparatus for enabling a plurality of table columns arranged to be associated with large objects (LOBs) to share a single LOB data segment within a database are disclosed. According to one aspect of the present invention, a method for allocating space associated with at least a first column arranged to accommodate LOB data and a second column arranged to accommodate LOB data includes allocating a first LOB data segment. The method also includes associating both the first column and the second column with the first LOB data segment.
摘要翻译： 公开了一种用于启用被布置为与大对象（LOB）相关联的多个表列以在数据库内共享单个LOB数据段的方法和装置。 根据本发明的一个方面，一种用于分配空间的方法，所述方法用于分配与至少布置成容纳LOB数据的第一列相关联的空间，以及用于容纳LOB数据的第二列，包括分配第一LOB数据段。 该方法还包括将第一列和第二列与第一LOB数据段相关联。
-
公开(公告)号：US20060075006A1
公开(公告)日：2006-04-06
申请号：US10949895
申请日：2004-09-23
IPC分类号： G06F17/30
CPC分类号： G06F17/30318 , G06F17/30607
摘要： Methods and apparatus for enabling a plurality of table columns arranged to be associated with large objects (LOBs) to share a single LOB data segment within a database are disclosed. According to one aspect of the present invention, a method for allocating space associated with at least a first column arranged to accommodate LOB data and a second column arranged to accommodate LOB data includes allocating a first LOB data segment. The method also includes associating both the first column and the second column with the first LOB data segment.
摘要翻译： 公开了一种用于启用被布置为与大对象（LOB）相关联的多个表列以共享数据库内的单个LOB数据段的方法和装置。 根据本发明的一个方面，一种用于分配空间的方法，所述方法用于分配与至少布置成容纳LOB数据的第一列相关联的空间，以及用于容纳LOB数据的第二列，包括分配第一LOB数据段。 该方法还包括将第一列和第二列与第一LOB数据段相关联。
-
5.发明授权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.
摘要翻译： 提供了用于处理数据库语句的技术，该数据库语句包括能够并行执行的表函数，其中在子查询中指定了表函数的输入。 在编译数据库语句时，会为数据库语句生成一个全局游标。 全局光标包括用于执行表功能的第一计划组件和用于生成表功能的输入的第二计划组件。 然后生成“虚拟”光标。 当从站执行表功能时，它们调用虚拟光标进行输入。 当从机调用虚拟光标进行输入时，虚拟光标会使上下文切换回全局光标，以便第一个光标中的第二个计划组件生成从属设备的输入。
-
6.发明申请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.
摘要翻译： 提供了用于处理数据库语句的技术，该数据库语句包括能够并行执行的表函数，其中在子查询中指定了表函数的输入。 在编译数据库语句时，会为数据库语句生成一个全局游标。 全局光标包括用于执行表功能的第一计划组件和用于生成表功能的输入的第二计划组件。 然后生成“虚拟”光标。 当从站执行表功能时，它们调用虚拟光标进行输入。 当从机调用虚拟光标进行输入时，虚拟光标会使上下文切换回全局光标，以便第一个光标中的第二个计划组件生成从属设备的输入。
-
公开(公告)号：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类型演变为具有较大的最大大小时，现有数据不会迁移或转换。
-
公开(公告)号：US20060047670A1
公开(公告)日：2006-03-02
申请号：US10912426
申请日：2004-08-05
申请人： Qin Yu , Subramanian Muralidhar
发明人： Qin Yu , Subramanian Muralidhar
IPC分类号： G06F7/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类型演变为具有较大的最大大小时，现有数据不会迁移或转换。
-
公开(公告)号：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.
摘要翻译： 响应于从应用程序接收高速缓存区域创建请求，可以在高速缓存中创建高速缓存区域。 来自应用的存储请求可以识别高速缓存区域和要存储在高速缓存区域中的一个或多个对象。 响应于接收到存储请求，可以将这些对象存储在高速缓存区域中。
-
-
-
-
-
-
-
-
-
搜索结果
41 条记录 (耗时 0.029 秒)