Data model and schema evolution
    41.
    发明申请
    Data model and schema evolution 有权
    数据模型和模式演进

    公开(公告)号:US20060259458A1

    公开(公告)日:2006-11-16

    申请号:US11128893

    申请日:2005-05-13

    IPC分类号: G06F17/30

    摘要: Systems and methodologies that facilitate evolving a data model via a combination of an explicit logical model definition, logical model changes, functional units, an explicit/implicit physical model and physical model changes, to derive a data model transformation. Such an arrangement can provide for a rich set of transformations, which can be automatically applied to a data model instantiation. The subject invention enables leveraging a common set of code, by defining the set of transformations across an arbitrary data model.

    摘要翻译: 通过显式逻辑模型定义,逻辑模型变化,功能单元,显式/隐式物理模型和物理模型变化的组合来促进数据模型演进的系统和方法,以导出数据模型转换。 这种安排可以提供丰富的转换,可以自动应用于数据模型实例化。 本发明可以通过在任意数据模型中定义转换集合来利用一组共同的代码。

    System and method for providing user defined types in a database system
    42.
    发明授权
    System and method for providing user defined types in a database system 失效
    在数据库系统中提供用户定义类型的系统和方法

    公开(公告)号:US06976029B2

    公开(公告)日:2005-12-13

    申请号:US10775282

    申请日:2004-02-10

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    摘要: 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查询和更新中用户定义类型的表达式。 优选地,数据库系统存储关于用户定义类型的元数据,以便随后用于创建该类型的实例。

    System and method for providing user defined types in a database system

    公开(公告)号:US20050177585A1

    公开(公告)日:2005-08-11

    申请号:US11057475

    申请日:2005-02-14

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    摘要: 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.

    Data model and schema evolution
    44.
    发明授权
    Data model and schema evolution 有权
    数据模型和模式演进

    公开(公告)号:US07634515B2

    公开(公告)日:2009-12-15

    申请号:US11128893

    申请日:2005-05-13

    IPC分类号: G06F12/00 G06F17/30

    摘要: Systems and methodologies that facilitate evolving a data model via a combination of an explicit logical model definition, logical model changes, functional units, an explicit/implicit physical model and physical model changes, to derive a data model transformation are presented. Such an arrangement can provide for a rich set of transformations, which can be automatically applied to a data model instantiation. The subject invention facilitates leveraging a common set of code in data model instantiation evolution, by defining the set of transformations across an arbitrary data model.

    摘要翻译: 提出了通过显式逻辑模型定义,逻辑模型变化,功能单元,显式/隐式物理模型和物理模型变化的组合来促进数据模型演进以导出数据模型变换的系统和方法。 这种安排可以提供丰富的转换,可以自动应用于数据模型实例化。 本发明通过在任意数据模型中定义转换集合来促进在数据模型实例化演进中利用一组共同的代码。

    System and method for providing user defined types in a database system
    45.
    发明授权
    System and method for providing user defined types in a database system 有权
    在数据库系统中提供用户定义类型的系统和方法

    公开(公告)号:US07596576B2

    公开(公告)日:2009-09-29

    申请号:US11057475

    申请日:2005-02-14

    IPC分类号: G06F7/00 G06F17/00

    摘要: 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查询和更新中用户定义类型的表达式。 优选地,数据库系统存储关于用户定义类型的元数据,以便随后用于创建该类型的实例。

    System and method for supporting non-native data types in a database API
    46.
    发明授权
    System and method for supporting non-native data types in a database API 有权
    支持数据库API中的非本机数据类型的系统和方法

    公开(公告)号:US07325007B2

    公开(公告)日:2008-01-29

    申请号:US11074951

    申请日:2005-03-07

    IPC分类号: G06F17/30

    摘要: A database API is presented that can expose data of non-native data-types, i.e., types that are unknown at API design-time. A broad type-system is used that is understood by both a server and a client. The API can dynamically discover, at run-time, data types that were defined using this broad type-system. The API can retrieve metadata that references a non-native data type in a client type library. A retrieved instance of the non-native data type, in serialized form, may be deserialized using the metadata.

    摘要翻译: 提供了可以公开非本地数据类型的数据的数据库API,即在API设计时未知的类型。 使用由服务器和客户端理解的广泛类型系统。 API可以在运行时动态地发现使用此广泛类型系统定义的数据类型。 API可以检索引用客户端类型库中的非本地数据类型的元数据。 可以使用元数据反序列化序列化形式的非本机数据类型的检索实例。

    System and method for supporting non-native data types in a database API
    48.
    发明申请
    System and method for supporting non-native data types in a database API 有权
    支持数据库API中的非本机数据类型的系统和方法

    公开(公告)号:US20060200486A1

    公开(公告)日:2006-09-07

    申请号:US11074951

    申请日:2005-03-07

    IPC分类号: G06F7/00

    摘要: A database API is presented that can expose data of non-native data-types, i.e., types that are unknown at API design-time. A broad type-system is used that is understood by both a server and a client. The API can dynamically discover, at run-time, data types that were defined using this broad type-system. The API can retrieve metadata that references a non-native data type in a client type library. A retrieved instance of the non-native data type, in serialized form, may be deserialized using the metadata.

    摘要翻译: 提供了可以公开非本地数据类型的数据的数据库API,即在API设计时未知的类型。 使用由服务器和客户端理解的广泛类型系统。 API可以在运行时动态地发现使用此广泛类型系统定义的数据类型。 API可以检索引用客户端类型库中的非本地数据类型的元数据。 可以使用元数据反序列化序列化形式的非本机数据类型的检索实例。