-
公开(公告)号: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.
摘要翻译: 在数据库系统中接收到执行查询的请求。 作为响应,数据库系统确定要由查询返回的数据元素的集合对应于在数据库系统的类型字典内未定义的第一数据结构。 数据库系统获得描述第一数据结构内的相应数据字段的属性值,并在类型字典内记录指定由属性值描述的数据字段的第一数据类型定义。
-
公开(公告)号: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.
摘要翻译: 在数据库系统中接收到执行查询的请求。 作为响应,数据库系统确定要由查询返回的数据元素的集合对应于在数据库系统的类型字典内未定义的第一数据结构。 数据库系统获得描述第一数据结构内的相应数据字段的属性值,并在类型字典内记录指定由属性值描述的数据字段的第一数据类型定义。
-
公开(公告)号:US07689542B2
公开(公告)日:2010-03-30
申请号:US10767512
申请日:2004-01-29
申请人: Adiel M. Yoaz , Qin Yu , Ravi Murthy , Susan Kotsovolos
发明人: Adiel M. Yoaz , Qin Yu , Ravi Murthy , Susan Kotsovolos
IPC分类号: G06F17/30
CPC分类号: G06F7/00 , G06F17/30 , Y10S707/99933
摘要: Dynamic return type generation in a database system. A request is received to execute a first function. A second function is executed if the first function is defined to return data in a first type of data structure. When executed, the second function returns formatting information that indicates an arrangement of fields of data within the first type of data structure. The first function is executed to obtain a collection of data formatted according to the first type of data structure, and the collection of data is organized according to the formatting information returned by the second function.
摘要翻译: 数据库系统中的动态返回类型生成。 接收到执行第一功能的请求。 如果第一个函数定义为返回第一类数据结构中的数据,则执行第二个函数。 当执行时,第二功能返回指示第一类型的数据结构内的数据的排列的格式化信息。 执行第一功能以获得根据第一类型的数据结构格式化的数据的集合,并且根据由第二功能返回的格式化信息来组织数据的收集。
-
公开(公告)号: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数据段相关联。
-
公开(公告)号:US20060031204A1
公开(公告)日:2006-02-09
申请号:US10948536
申请日:2004-09-22
申请人: Zhen Liu , Muralidhar Krishnaprasad , Anand Manikutty , James Warner , Qin Yu , Hui Zhang , Karuna Muthiah , Ying Lu , Vikas Arora , Susan Kotsovolos
发明人: Zhen Liu , Muralidhar Krishnaprasad , Anand Manikutty , James Warner , Qin Yu , Hui Zhang , Karuna Muthiah , Ying Lu , Vikas Arora , Susan Kotsovolos
IPC分类号: G06F17/30
CPC分类号: G06F17/30545 , G06F17/30935 , Y10S707/99933
摘要: Techniques are provided for processing a query, including receiving the query, where the query specifies certain operations to be performed, including (a) a first set of one or more operations that are to be performed on a markup language data source and (b) a second set of one or more operations that are to be performed on a second data source. Then it is determined that a first server that manages the markup language data source is capable of performing the first set of operations. A request is sent to the first server to perform the first set of operations. A response is received, where the response contains results of performing the first set of operations on the markup language data source. Finally, results are generated for the query based at least in part on the results of performing the first set of operations.
摘要翻译: 提供了用于处理查询的技术,包括接收查询,其中查询指定要执行的某些操作,包括(a)要在标记语言数据源上执行的一个或多个操作的第一组,以及(b) 要在第二数据源上执行的一个或多个操作的第二组。 然后,确定管理标记语言数据源的第一服务器能够执行第一组操作。 发送请求到第一台服务器执行第一组操作。 收到响应,其中响应包含对标记语言数据源执行第一组操作的结果。 最后,至少部分地基于执行第一组操作的结果为查询生成结果。
-
公开(公告)号:US20050154715A1
公开(公告)日:2005-07-14
申请号:US10767512
申请日:2004-01-29
申请人: Adiel Yoaz , Qin Yu , Ravi Murthy , Susan Kotsovolos
发明人: Adiel Yoaz , Qin Yu , Ravi Murthy , Susan Kotsovolos
CPC分类号: G06F7/00 , G06F17/30 , Y10S707/99933
摘要: Dynamic return type generation in a database system. A request is received to execute a first function. A second function is executed if the first function is defined to return data in a first type of data structure. When executed, the second function returns formatting information that indicates an arrangement of fields of data within the first type of data structure. The first function is executed to obtain a collection of data formatted according to the first type of data structure, and the collection of data is organized according to the formatting information returned by the second function.
摘要翻译: 数据库系统中的动态返回类型生成。 接收到执行第一功能的请求。 如果第一个函数定义为返回第一类数据结构中的数据,则执行第二个函数。 当执行时,第二功能返回指示第一类型的数据结构内的数据的排列的格式化信息。 执行第一功能以获得根据第一类型的数据结构格式化的数据的集合,并且根据由第二功能返回的格式化信息来组织数据的收集。
-
公开(公告)号: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类型演变为具有较大的最大大小时,现有数据不会迁移或转换。
-
公开(公告)号:US20170103829A1
公开(公告)日:2017-04-13
申请号:US14881186
申请日:2015-10-13
申请人: Qin Yu
发明人: Qin Yu
CPC分类号: F21S4/10 , F21W2121/00
摘要: The present invention provides a light string with reinforced wires. The light string includes a plurality of reinforced wires and a plurality of lamps electrically connected in series via the plurality of reinforced wires. Each reinforced wire includes a plurality of conducting wires, an outer insulating sheath covering the plurality of conducting wires and one or more reinforcing strands configured between an inner side surface and an outer side surface of the outer insulating sheath and extending along a direction parallel to a central longitudinal axis of the reinforced wire. The bending resistant performance of the electric wire between each two adjacent lamps is improved greatly, the fatigue strength of the electric wire is much better than that of an ordinary electric wire, and the tensile strength of the electric wire is improved.
-
-
-
-
-
-
-
-
-