会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • System and method for providing user defined types in a database system
    • 在数据库系统中提供用户定义类型的系统和方法
    • US06976029B2
    • 2005-12-13
    • US10775282
    • 2004-02-10
    • Ramachandran VenkateshJun FangJose A. BlakeleyBeysim SezginBalaji RathakrishnanPeter A. Carlin
    • Ramachandran VenkateshJun FangJose A. BlakeleyBeysim SezginBalaji RathakrishnanPeter A. Carlin
    • G06F7/00G06F17/00G06F17/30
    • G06F7/00G06F17/30289Y10S707/99934Y10S707/99943
    • A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.
    • 数据库系统和方法允许用户以实现定义用户定义类型的结构的类的高级编程语言编写程序代码,并且可以在该类型的实例上调用方法。 该类然后向数据库系统注册,该系统针对类强制执行用户定义类型的特定合同。 合同包括以下要求。 首先,类必须为数据库存储中的用户定义类型的持久化实例指定多种不同格式之一。 第二,类必须能够返回用户定义类型的空值。 第三,类必须提供一种将用户定义类型转换为另一种类型的方法。 一旦满足这些要求,数据库系统就可以创建用户定义类型的实例。 可以在可以使用任何其他内置类型的所有上下文中使用用户定义的类型。 这包括定义表的列,将变量和参数声明为函数和存储过程,以及评估SQL查询和更新中用户定义类型的表达式。 优选地,数据库系统存储关于用户定义类型的元数据,以便随后用于创建该类型的实例。
    • 5. 发明授权
    • System and method for providing user defined types in a database system
    • 在数据库系统中提供用户定义类型的系统和方法
    • US07308460B2
    • 2007-12-11
    • US11016240
    • 2004-12-17
    • Ramachandran VenkateshJun FangJose A. BlakeleyBeysim SezginBalaji RathakrishnanPeter A. Carlin
    • Ramachandran VenkateshJun FangJose A. BlakeleyBeysim SezginBalaji RathakrishnanPeter A. Carlin
    • G06F17/30
    • G06F7/00G06F17/30289Y10S707/99934Y10S707/99943
    • A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.
    • 数据库系统和方法允许用户以实现定义用户定义类型的结构的类的高级编程语言编写程序代码,并且可以在该类型的实例上调用方法。 该类然后向数据库系统注册,该系统针对类强制执行用户定义类型的特定合同。 合同包括以下要求。 首先,类必须为数据库存储中的用户定义类型的持久化实例指定多种不同格式之一。 第二,类必须能够返回用户定义类型的空值。 第三,类必须提供一种将用户定义类型转换为另一种类型的方法。 一旦满足这些要求,数据库系统就可以创建用户定义类型的实例。 可以在可以使用任何其他内置类型的所有上下文中使用用户定义的类型。 这包括定义表的列,将变量和参数声明为函数和存储过程,以及评估SQL查询和更新中用户定义类型的表达式。 优选地,数据库系统存储关于用户定义类型的元数据,以便随后用于创建该类型的实例。
    • 6. 发明授权
    • System and method for providing user defined types in a database system
    • 在数据库系统中提供用户定义类型的系统和方法
    • US07596576B2
    • 2009-09-29
    • US11057475
    • 2005-02-14
    • Ramachandran VenkateshJun FangJose A. BlakeleyBeysim SezginBalaji RathakrishnanPeter A. Carlin
    • Ramachandran VenkateshJun FangJose A. BlakeleyBeysim SezginBalaji RathakrishnanPeter A. Carlin
    • G06F7/00G06F17/00
    • G06F7/00G06F17/30289Y10S707/99934Y10S707/99943
    • A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.
    • 数据库系统和方法允许用户以实现定义用户定义类型的结构的类的高级编程语言编写程序代码,并且可以在该类型的实例上调用方法。 该类然后向数据库系统注册,该系统针对类强制执行用户定义类型的特定合同。 合同包括以下要求。 首先,类必须为数据库存储中的用户定义类型的持久化实例指定多种不同格式之一。 第二,类必须能够返回用户定义类型的空值。 第三,类必须提供一种将用户定义类型转换为另一种类型的方法。 一旦满足这些要求,数据库系统就可以创建用户定义类型的实例。 可以在可以使用任何其他内置类型的所有上下文中使用用户定义的类型。 这包括定义表的列,将变量和参数声明为函数和存储过程,以及评估SQL查询和更新中用户定义类型的表达式。 优选地,数据库系统存储关于用户定义类型的元数据,以便随后用于创建该类型的实例。
    • 7. 发明授权
    • Asynchronous database index maintenance
    • 异步数据库索引维护
    • US08140495B2
    • 2012-03-20
    • US12435026
    • 2009-05-04
    • Peter A. CarlinPer-Ake LarsonJingren Zhou
    • Peter A. CarlinPer-Ake LarsonJingren Zhou
    • G06F17/30
    • G06F17/30312
    • This disclosure provides techniques for asynchronously maintaining database indexes or sub-indexes. For example, a database management server may receive a data manipulation statement to modify particular data stored in a database and determine whether an index associated with executing the statement is maintained asynchronously. When the index is maintained asynchronously, maintenance of the index to reflect changes made to the particular data by executing the data manipulation statement may be delayed until an index maintenance event. The index maintenance may be based on an isolation level of a transaction including a query that triggered the index maintenance.
    • 本公开提供用于异步维护数据库索引或子索引的技术。 例如,数据库管理服务器可以接收数据操作语句来修改存储在数据库中的特定数据,并且确定与执行语句相关联的索引是否被异步地维护。 当索引异步维护时,通过执行数据操作语句来反映对特定数据所做的更改的索引的维护可能会延迟到索引维护事件。 索引维护可以基于事务的隔离级别,包括触发索引维护的查询。
    • 8. 发明授权
    • Auto-parameterization of database queries
    • 自动参数化数据库查询
    • US06356887B1
    • 2002-03-12
    • US09340596
    • 1999-06-28
    • Harold R. BerensonPeter A. CarlinNigel R. EllisCesar A. Galindo-LegariaGoetz GraefeAjay KalhanCraig C. PeeperSamuel H. Smith
    • Harold R. BerensonPeter A. CarlinNigel R. EllisCesar A. Galindo-LegariaGoetz GraefeAjay KalhanCraig C. PeeperSamuel H. Smith
    • G06F1730
    • G06F17/30433Y10S707/99932Y10S707/99934
    • An auto-parameterization process transforms a database query into a parameterized basic query form by replacing any constant values in the query with parameters. The auto-parameterization process attempts to generate a safe execution plan from the basic query form if there is currently no such plan available. A safe execution plan is defined as an execution plan that is optimal over a range of values for the parameters. If a safe execution plan can be generated, it is passed for execution, along with the constant values that were present in the query. If a safe execution plan cannot be generated, the auto-parameterization process passes a specific execution plan for execution. The safe execution plan is cached either at the time it is created or at the time it is executed. The cache is searched each time a parameterized basic query plan is generated by the auto-parameterization process. The auto-parameterization process also evaluates the query before creating the corresponding parameterized basic query form to determine if it is likely that a safe execution plan can be generated for the query.
    • 自动参数化过程通过用参数替换查询中的任何常量值,将数据库查询转换为参数化的基本查询表单。 如果当前没有此类计划可用,则自动参数化过程将尝试从基本查询表单生成安全执行计划。 一个安全的执行计划被定义为在参数值范围内最佳的执行计划。 如果可以生成安全的执行计划,则将其传递给执行,以及查询中存在的常量值。 如果无法生成安全执行计划,则自动参数化过程将通过特定的执行计划执行。 安全执行计划在创建时或执行时缓存。 每次通过自动参数化过程生成参数化的基本查询计划时,将搜索缓存。 在创建相应的参数化基本查询表单之前,自动参数化过程还会对查询进行评估,以确定是否可能为查询生成安全的执行计划。
    • 9. 发明申请
    • Asynchronous Database Index Maintenance
    • 异步数据库索引维护
    • US20100281005A1
    • 2010-11-04
    • US12435026
    • 2009-05-04
    • Peter A. CarlinPer-Ake LarsonJingren Zhou
    • Peter A. CarlinPer-Ake LarsonJingren Zhou
    • G06F17/30
    • G06F17/30312
    • This disclosure provides techniques for asynchronously maintaining database indexes or sub-indexes. For example, a database management server may receive a data manipulation statement to modify particular data stored in a database and determine whether an index associated with executing the statement is maintained asynchronously. When the index is maintained asynchronously, maintenance of the index to reflect changes made to the particular data by executing the data manipulation statement may be delayed until an index maintenance event. The index maintenance may be based on an isolation level of a transaction including a query that triggered the index maintenance.
    • 本公开提供用于异步维护数据库索引或子索引的技术。 例如,数据库管理服务器可以接收数据操作语句来修改存储在数据库中的特定数据,并且确定与执行语句相关联的索引是否被异步地维护。 当索引异步维护时,通过执行数据操作语句来反映对特定数据所做的更改的索引的维护可能会延迟到索引维护事件。 索引维护可以基于事务的隔离级别,包括触发索引维护的查询。