Use of server processing of temporary results for stateless paging over arbitrary user queries
    3.
    发明授权
    Use of server processing of temporary results for stateless paging over arbitrary user queries 有权
    使用服务器处理临时结果进行无状态的分页查找任意用户查询

    公开(公告)号:US07849109B1

    公开(公告)日:2010-12-07

    申请号:US10909093

    申请日:2004-07-30

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30501

    摘要: A query processor's capabilities may be employed to identify a range rows resulting from a user query to be returned. A server cursor may be declared, opened, fetched from and closed in a single batched request in order to avoid keeping state on a database server between requests. A single block fetch may be used within the batch to retrieve a requisite number of rows from a specified ordinal position. Where server cursors are not available, an intermediate table may be used to hold a subset of the rows resulting from the user query, and row numbers may be added to facilitate selecting the range of rows from that intermediate table. Intelligence within a query processor may be leveraged to support identifying the range of rows to be returned without maintaining state between client requests.

    摘要翻译: 可以使用查询处理器的能力来识别由要返回的用户查询产生的范围行。 可以在单个批量请求中声明,打开,取出并关闭服务器游标,以避免在请求之间保持数据库服务器上的状态。 可以在批处理中使用单个块提取来从指定的顺序位置检索必要数量的行。 在服务器游标不可用的地方,可以使用中间表来存储由用户查询产生的行的子集,并且可以添加行号以便于从该中间表选择行的范围。 可以利用查询处理器内的智能来支持在不维护客户机请求之间的状态的情况下识别要返回的行的范围。

    Systems and methods for employing a trigger-based mechanism to detect a database table change and registering to receive notification of the change
    6.
    发明授权
    Systems and methods for employing a trigger-based mechanism to detect a database table change and registering to receive notification of the change 有权
    用于采用基于触发的机制来检测数据库表的系统和方法改变和注册以接收变更的通知

    公开(公告)号:US07836031B2

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

    申请号:US10401999

    申请日:2003-03-28

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F17/30368

    摘要: The present invention relates to systems and methods for employing a trigger based mechanism to detect changes in a database table, providing a notification when the database table changes and registering to receive the notification. The systems and methods employ a listeners table to store information associated with registered database tables. Alter a database table changes, a trigger mechanism associated with the database change facilitates a search of the listeners table for a parameter associated with the changed database table. If the changed database table is registered, the information from the listeners table is provided to a delivery service which transmits a message indicating the registered database table changed. After receiving the message, a notification runtime service can route a notification to a client(s) registered to receive the notification. The foregoing mitigates performing time intensive queries and utilizing inconsistent query results.

    摘要翻译: 本发明涉及采用基于触发的机制来检测数据库表中的变化的系统和方法,当数据库表改变并注册以接收通知时提供通知。 系统和方法使用侦听器表来存储与注册的数据库表相关联的信息。 更改数据库表更改,与数据库更改相关的触发机制更改便于对监听器表的搜索与更改的数据库表相关联的参数。 如果更改的数据库表被注册,则将来自侦听器表的信息提供给传送指示已注册数据库表改变的消息的传送服务。 收到消息后,通知运行时服务可以将通知发送给已注册接收通知的客户端。 前述情况减轻了执行时间密集型查询并利用不一致的查询结果。

    SYNCHRONIZATION OF A CONCEPTUAL MODEL VIA MODEL EXTENSIONS
    7.
    发明申请
    SYNCHRONIZATION OF A CONCEPTUAL MODEL VIA MODEL EXTENSIONS 审中-公开
    通过模型扩展的概念模型的同步

    公开(公告)号:US20100106684A1

    公开(公告)日:2010-04-29

    申请号:US12544125

    申请日:2009-08-19

    IPC分类号: G06F17/30

    CPC分类号: G06F16/275

    摘要: A method of synchronizing data between multiple endpoints each storing a copy of the data in accordance with different underlying schemas. An application model that provides a logical representation of an underlying schema is extended with a synchronization model that provides a logical representation of changes made to the data. The synchronization model comprises functions that provide synchronization information on the changes in a common format. Using such synchronization information, changes in a copy of the data stored in a first underlying schema on a first endpoints are applied to another copy of the data stored in a second underlying schema on a second endpoint in synchronization relationship with the first endpoint.

    摘要翻译: 一种在多个端点之间同步数据的方法,每个端点根据不同的底层模式存储数据的副本。 提供基础模式的逻辑表示的应用程序模型使用提供对数据所做更改的逻辑表示的同步模型进行扩展。 同步模型包括以通用格式提供关于变化的同步信息的功能。 使用这样的同步信息,存储在第一端点上的第一基础模式中的数据的副本的变化被应用于与第一端点处于同步关系的存储在第二端点上的第二基础模式中的数据的另一副本。

    System and method facilitating unified framework for structured/unstructured data
    9.
    发明授权
    System and method facilitating unified framework for structured/unstructured data 有权
    有助于结构化/非结构化数据统一框架的系统和方法

    公开(公告)号:US07895173B1

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

    申请号:US11190678

    申请日:2005-07-27

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

    CPC分类号: G06F17/30917

    摘要: A system and method facilitating a unified framework for accessing structured and unstructured data is provided. The invention includes a source document having data that is parsed into a data document component providing a hierarchical representation of data associated with the source document and a data set component providing a relational representation of at least a portion of the data associated with the source document. The invention further provides for a schema defining a structure of the relational representation to be associated with the source document and/or inferred by the data set component. Data stored in the data document component and the data set component are synchronized, thus a change made to data stored in the data set component is reflected in data stored in the data document component. Further, a change made to data stored in the data document component is reflected in data stored in the data set component if utilized according to the schema. The invention further provides for a service to access the hierarchical representation of data associated with the source document and/or a designer to access the relational representation of data associated with the source document.

    摘要翻译: 提供了一种便于统一框架访问结构化和非结构化数据的系统和方法。 本发明包括具有被解析成数据文档组件的数据的源文档,该数据文档组件提供与源文档相关联的数据的分层表示,以及提供与源文档相关联的数据的至少一部分的关系表示的数据集组件。 本发明还提供了定义与源文档相关联和/或由数据集组件推断的关系表示的结构的模式。 存储在数据文档组件和数据集组件中的数据被同步,因此对存储在数据集组件中的数据所做的改变反映在数据文档组件中存储的数据中。 此外,如果根据模式使用,对存储在数据文档组件中的数据的变化反映在存储在数据集组件中的数据中。 本发明还提供一种服务,用于访问与源文档相关联的数据的分层表示和/或设计者以访问与源文档相关联的数据的关系表示。

    System and method providing diffgram format
    10.
    发明授权
    System and method providing diffgram format 有权
    提供差异格式的系统和方法

    公开(公告)号:US07743319B2

    公开(公告)日:2010-06-22

    申请号:US11379913

    申请日:2006-04-24

    摘要: The present invention relates to a system and methodology to facilitate XML data communications and processing. A diffgram data structure is provided that includes one or more states of a plurality of data records. The state information can be determined by examining one or more data sources for differences from one or more reference data sources. If differences are detected between the data sources, the diffgram can be constructed in an XML compatible format with both previous state indications and current state indications that describes the state differences between the data sources. Error information and/or other administrative information or codes can also be provided to facilitate database management and/or processing.

    摘要翻译: 本发明涉及一种促进XML数据通信和处理的系统和方法。 提供包括多个数据记录的一个或多个状态的差分数据结构。 可以通过检查来自一个或多个参考数据源的差异的一个或多个数据源来确定状态信息。 如果在数据源之间检测到差异,则可以使用XML兼容格式构造差异图,其中先前的状态指示和描述数据源之间的状态差异的当前状态指示。 还可以提供错误信息和/或其他管理信息或代码以促进数据库管理和/或处理。