Embedded multi-language programming
    1.
    发明申请
    Embedded multi-language programming 审中-公开
    嵌入式多语言编程

    公开(公告)号:US20070044066A1

    公开(公告)日:2007-02-22

    申请号:US11208228

    申请日:2005-08-19

    IPC分类号: G06F9/44

    CPC分类号: G06F8/33

    摘要: Multiple programming languages can be embedded and supported within a single source. Programs nested with syntax from a plurality of languages (e.g., C#, SQL, XML . . . ), among other things, enable users to avail themselves of advantageous aspects of different languages for particular tasks. Language services that provide language specific functionality including but not limited to formatting, intelligent assist, auto completion, and coloring, can be employed and switched between to afford support for their respective languages in a mixed language source program. Similarly, mixed language programs can be compiled with language specific services or systems such as parsers, scanners and the like to process corresponding code portions.

    摘要翻译: 多种编程语言可以在单一来源内嵌入和支持。 嵌套有来自多种语言(例如,C#,SQL,XML ...)的语法的程序等等使得用户能够利用不同语言的有利方面来执行特定任务。 可以使用提供语言特定功能的语言服务,包括但不限于格式化,智能辅助,自动完成和着色,并在混合语言源程序中为其各自语言提供支持。 类似地,混合语言程序可以用语言特定的服务或诸如解析器,扫描仪等的系统来编译以处理相应的代码部分。

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

    公开(公告)号:US20050177583A1

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

    申请号:US11016240

    申请日:2004-12-17

    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.

    Systems and methods for supporting inheritance for user-defined types
    7.
    发明申请
    Systems and methods for supporting inheritance for user-defined types 有权
    用于支持用户定义类型继承的系统和方法

    公开(公告)号:US20050177581A1

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

    申请号:US10837929

    申请日:2004-05-03

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

    摘要: Various embodiments of the present invention are directed to a database with an extensible type system for at least one user-defined type that comprises information for describing its structure as well as information for describing an inheritance relationship between itself and another user-defined type (either a subtype or a supertype/base type). For certain embodiments, the user-defined type is defined in something other than Sequential Query Language (SQL) statement such as, for example, a Common Language Runtime (CLR) statement, a statement in C, C++, and C# (“C-sharp”), and/or a visual basic statement. In any event, several embodiments are further directed to a system wherein the database is aware of the inheritance relationship between two user-defined types by an explicit registration of the user-defined types with said database.

    摘要翻译: 本发明的各种实施例涉及具有用于至少一个用户定义类型的可扩展类型系统的数据库,其包括用于描述其结构的信息以及用于描述其自身与另一用户定义类型之间的继承关系的信息 子类型或超类型/基类型)。 对于某些实施例,用户定义的类型以顺序查询语言(SQL)语句(例如公共语言运行时(CLR))语句,C,C ++和C#(“C- 锐利“)和/或视觉基本声明。 在任何情况下,几个实施例进一步涉及系统,其中数据库通过用户定义的类型与所述数据库的显式注册来了解两个用户定义类型之间的继承关系。

    Incremental approach to an object-relational solution
    9.
    发明申请
    Incremental approach to an object-relational solution 有权
    对象关系解决方案的增量方法

    公开(公告)号:US20070055692A1

    公开(公告)日:2007-03-08

    申请号:US11364060

    申请日:2006-02-28

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30607

    摘要: The claimed subject matter relates to an architecture that can facilitate an incremental approach to an Object-Relational mapping solution. The architecture can provide a rich data model that is defined at the value layer. The rich data model can expose an interface that conforms with the interfaces exposed by common storage-specific data providers. The architecture can extend common storage-specific data provider to support common command representations, and provide entity services that work in terms of the rich data model as well as object services such as identity management, updating and change tracking.

    摘要翻译: 所要求保护的主题涉及可以促进对象关系映射解决方案的增量方法的体系结构。 该架构可以提供在值层定义的丰富的数据模型。 丰富的数据模型可以暴露符合常见存储特定数据提供者所暴露接口的接口。 该架构可以扩展常见的特定于存储的数据提供者,以支持通用命令表示,并提供在富数据模型以及对象服务(如身份管理,更新和更改跟踪)方面工作的实体服务。

    Query optimizer using implied predicates
    10.
    发明申请
    Query optimizer using implied predicates 审中-公开
    查询优化器使用隐含谓词

    公开(公告)号:US20050210023A1

    公开(公告)日:2005-09-22

    申请号:US10803443

    申请日:2004-03-18

    IPC分类号: G06F12/00 G06F17/30

    CPC分类号: G06F16/24537 G06F16/24542

    摘要: Improved query optimizer using implied predicates. The system facilitates allowing a query optimizing component to introduce into a query, extra predicates that facilitate the following: render the same results as the original query; are used as dictated by rules passed to the optimizing component—these rules specify whether the new predicate is an equivalence (that will substitute the old predicate) or an implication (in which the old predicate is preserved); are considered as cost-based alternatives, and discarded if not useful; are tied to index utilization; and can consider both standard and multi-valued indices.

    摘要翻译: 改进了使用隐含谓词的查询优化器。 该系统便于允许查询优化组件引入到查询中,另外的谓词便于执行以下操作:渲染与原始查询相同的结果; 根据传递给优化组件的规则使用这些规则 - 这些规则指定新谓词是否是等价性(将替代旧谓词)或暗示(其中保留旧谓词); 被认为是基于成本的替代品,如果不是有用的话; 与指数利用挂钩; 并且可以考虑标准和多值指数。