Method and apparatus using dynamic SQL for item create, retrieve, update delete operations in a content management application
    4.
    发明申请
    Method and apparatus using dynamic SQL for item create, retrieve, update delete operations in a content management application 审中-公开
    使用动态SQL的项目创建,检索,更新内容管理应用程序中的删除操作的方法和设备

    公开(公告)号:US20050160101A1

    公开(公告)日:2005-07-21

    申请号:US10758090

    申请日:2004-01-16

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F16/284

    摘要: One feature of the present invention provides a content management system that can handle a wide variety requests by using different types of items with differing attributes. The content management maintains a set of tables to manage the items. A first table is used to index or catalog each of the items and its type. A second table is used to store the attributes of each type of item. The attributes specify information about the item's type and may also include a partial SQL statement. When needed, the content management system may then use these tables to determine an item's type, retrieve the attributes for that type, obtain a partial SQL statement from the attributes, and dynamically build a SQL statement to process a wide variety of requests or commands.

    摘要翻译: 本发明的一个特征提供一种内容管理系统,其可以通过使用具有不同属性的不同类型的项目来处理各种请求。 内容管理维护一组表以管理项目。 第一个表用于索引或编制每个项目及其类型。 第二个表用于存储每种类型的项目的属性。 属性指定关于项目类型的信息,并且还可以包括部分SQL语句。 当需要时,内容管理系统然后可以使用这些表来确定项目的类型,检索该类型的属性,从属性获取部分SQL语句,并动态构建SQL语句来处理各种请求或命令。

    Parameter passing of data structures where API and corresponding stored procedure are different versions/releases
    5.
    发明申请
    Parameter passing of data structures where API and corresponding stored procedure are different versions/releases 失效
    API和相应的存储过程是不同版本/版本的数据结构的参数传递

    公开(公告)号:US20050160432A1

    公开(公告)日:2005-07-21

    申请号:US10759661

    申请日:2004-01-16

    IPC分类号: G06F9/44 G06F17/30

    CPC分类号: G06F17/30415 G06F9/54

    摘要: A method, system and computer program product for passing parameters of data structures where an API and corresponding stored procedures are at different version/release levels. A received data structure is parsed for a version identifier of a caller. The parsed version identifier is compared to a stored procedure version identifier and a determination is made with regards to a data structure compatibility or a data structure incompatibility. If a data structure compatibility is determined, all received data structure elements are parsed. If, however, a data structure incompatibility is determined, only data structure elements known to both the caller and the stored procedures are parsed.

    摘要翻译: 一种用于传递数据结构参数的方法,系统和计算机程序产品,其中API和相应的存储过程处于不同的版本/版本级别。 接收到的数据结构被解析为呼叫者的版本标识符。 将解析的版本标识符与存储过程版本标识符进行比较,并且关于数据结构兼容性或数据结构不兼容性进行确定。 如果确定了数据结构兼容性,则解析所有接收的数据结构元素。 然而,如果确定数据结构不兼容性,则仅解析调用者和存储过程已知的数据结构元素。