公开(公告)号：US08863091B2

公开(公告)日：2014-10-14

申请号：US12189080

申请日：2008-08-08

申请人： Benoit Dageville ,  Amirali S. Valiani ,  Hailing Yu ,  Gary Ngai

发明人： Benoit Dageville ,  Amirali S. Valiani ,  Hailing Yu ,  Gary Ngai

IPC分类号： G06F9/44 ,  G06F11/36

CPC分类号： G06F11/3636

摘要： A computer is programmed with multiple software programs to record structures including (a) unstructured information to denote a transition between portions of code, and (b) metadata related to one or more attributes of the information. In addition, the computer writes two additional types of structures: section type, and dump type. The section type structure has metadata to indicate a beginning and an end, to bracket a group of structures located therebetween. The dump type has a dump header and a dump body. The dump header includes a symbol to indicate it's of dump type. The dump body is a set of values of an object used by the software program(s) during execution by the computer. A group of structures, within a section type, may include structures of each of the trace record type, dump type and section type.

摘要翻译： 计算机被编程有多个软件程序以记录结构，包括（a）非结构化信息以表示代码部分之间的转换，以及（b）与信息的一个或多个属性有关的元数据。 此外，计算机还会写入两种附加类型的结构：段类型和转储类型。 部分类型结构具有表示开头和结尾的元数据，以支架位于其间的一组结构。 转储类型具有转储头和转储主体。 转储头包含一个表示它是转储类型的符号。 转储主体是由计算机执行期间由软件程序使用的对象的一组值。 一个区段类型中的一组结构可以包括每个跟踪记录类型，转储类型和段类型的结构。

公开(公告)号：US20090106741A1

公开(公告)日：2009-04-23

申请号：US12189080

申请日：2008-08-08

申请人： Benoit Dageville ,  Amirali S. Valiani ,  Hailing Yu ,  Gary Ngai

发明人： Benoit Dageville ,  Amirali S. Valiani ,  Hailing Yu ,  Gary Ngai

IPC分类号： G06F9/44

CPC分类号： G06F11/3636

摘要： A computer is programmed with multiple software programs to record structures including (a) unstructured information to denote a transition between portions of code, and (b) metadata related to one or more attributes of the information. In addition, the computer writes two additional types of structures: section type, and dump type. The section type structure has metadata to indicate a beginning and an end, to bracket a group of structures located therebetween. The dump type has a dump header and a dump body. The dump header includes a symbol to indicate it's of dump type. The dump body is a set of values of an object used by the software program(s) during execution by the computer. A group of structures, within a section type, may include structures of each of the trace record type, dump type and section type.

摘要翻译： 计算机被编程有多个软件程序以记录结构，包括（a）非结构化信息以表示代码部分之间的转换，以及（b）与信息的一个或多个属性有关的元数据。 此外，计算机还会写入两种附加类型的结构：段类型和转储类型。 部分类型结构具有表示开头和结尾的元数据，以支架位于其间的一组结构。 转储类型具有转储头和转储主体。 转储头包含一个表示它是转储类型的符号。 转储主体是由计算机执行期间由软件程序使用的对象的一组值。 一个区段类型中的一组结构可以包括每个跟踪记录类型，转储类型和段类型的结构。

公开(公告)号：US07644106B2

公开(公告)日：2010-01-05

申请号：US11830538

申请日：2007-07-30

申请人： Shrikanth Shankar ,  Ramesh Kumar ,  Amirali S. Valiani ,  Vasudha Krishnaswamy ,  Ananth Raghavan ,  Juan R. Loaiza

发明人： Shrikanth Shankar ,  Ramesh Kumar ,  Amirali S. Valiani ,  Vasudha Krishnaswamy ,  Ananth Raghavan ,  Juan R. Loaiza

IPC分类号： G06F17/30

CPC分类号： G06F17/30362 ,  Y10S707/99952

摘要： Techniques for avoiding lock contention when processing data definition language (DDL) statements are provided. Some DDL statements modify metadata of a table and then require access to the table. After such a DDL statement modifies the metadata of a table and the updated metadata is made available (i.e., published) to other database statements, execution of the DDL statement is suspended. Data manipulation language (DML) statements acquire locks on the table. In one approach, the locks, of any DML statement, that are granted after the DDL statement is issued are timestamped. The DDL statement uses the timestamps to determine when to access the table. The timestamps are used to determine when the last DML statement (that was pending at the time the modified metadata was published) commits and releases its lock on the table.

摘要翻译： 提供处理数据定义语言（DDL）语句时避免锁争用的技术。 一些DDL语句修改表的元数据，然后需要访问该表。 在这样一个DDL语句修改表的元数据之后，更新后的元数据可用（即发布）到其他数据库语句，DDL语句的执行被暂停。 数据操作语言（DML）语句获取表上的锁。 在一种方法中，在发出DDL语句之后授予的任何DML语句的锁定是时间戳的。 DDL语句使用时间戳来确定何时访问表。 时间戳用于确定最后一个DML语句（修改后的元数据发布时待处理的）是否提交并释放其在表上的锁定。

公开(公告)号：US20090037417A1

公开(公告)日：2009-02-05

申请号：US11830538

申请日：2007-07-30

申请人： Shrikanth Shankar ,  Ramesh Kumar ,  Amirali S. Valiani ,  Vasudha Krishnaswamy ,  Ananth Raghavan ,  Juan R. Loaiza

发明人： Shrikanth Shankar ,  Ramesh Kumar ,  Amirali S. Valiani ,  Vasudha Krishnaswamy ,  Ananth Raghavan ,  Juan R. Loaiza

IPC分类号： G06F17/30

CPC分类号： G06F17/30362 ,  Y10S707/99952

摘要： Techniques for avoiding lock contention when processing data definition language (DDL) statements are provided. Some DDL statements modify metadata of a table and then require access to the table. After such a DDL statement modifies the metadata of a table and the updated metadata is made available (i.e., published) to other database statements, execution of the DDL statement is suspended. Data manipulation language (DML) statements acquire locks on the table. In one approach, the locks, of any DML statement, that are granted after the DDL statement is issued are timestamped. The DDL statement uses the timestamps to determine when to access the table. The timestamps are used to determine when the last DML statement (that was pending at the time the modified metadata was published) commits and releases its lock on the table.

摘要翻译： 提供处理数据定义语言（DDL）语句时避免锁争用的技术。 一些DDL语句修改表的元数据，然后需要访问该表。 在这样一个DDL语句修改表的元数据之后，更新后的元数据可用（即发布）到其他数据库语句，DDL语句的执行被暂停。 数据操作语言（DML）语句获取表上的锁。 在一种方法中，在发出DDL语句之后授予的任何DML语句的锁定是时间戳的。 DDL语句使用时间戳来确定何时访问表。 时间戳用于确定最后一个DML语句（修改后的元数据发布时待处理的）是否提交并释放其在表上的锁定。