Data tranformations for applications supporting different data formats
    11.
    发明授权
    Data tranformations for applications supporting different data formats 有权
    支持不同数据格式的应用的数据传输

    公开(公告)号:US08275779B2

    公开(公告)日:2012-09-25

    申请号:US12357814

    申请日:2009-01-22

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/3092

    摘要: Embodiments of the invention allow structured data to be transferred between a source application and a target application that process structured data in different formats. For example, structured data may have a set of associated rules which transform the structured data based on a set of variables. The source application may register variable definitions for each of the variables in a registry. The target application may read the registry and register values for each of the rule variables. Once values are registered for the variables, the source application may transfer the structured data to a transformation engine that applies the rules, using the registered values for the variables, to transform the structured data into a format compatible with the target application. In doing so, the transformation engine can generate a document in any format compatible with the target application and subsequently transfer the generated document to the target application.

    摘要翻译: 本发明的实施例允许结构化数据在源应用程序和以不同格式处理结构化数据的目标应用程序之间传送。 例如,结构化数据可以具有一组相关联的规则,其基于一组变量来变换结构化数据。 源应用程序可以为注册表中的每个变量注册变量定义。 目标应用程序可以读取每个规则变量的注册表和注册值。 一旦为变量注册了值,源应用程序可以将结构化数据传输到转换引擎,该转换引擎使用变量的注册值将规则转换为与目标应用程序兼容的格式。 在这样做时,转换引擎可以以与目标应用程序兼容的任何格式生成文档,并随后将生成的文档传送到目标应用程序。

    DATA TRANFORMATIONS FOR A SOURCE APPLICATION AND MULTIPLE TARGET APPLICATIONS SUPPORTING DIFFERENT DATA FORMATS
    12.
    发明申请
    DATA TRANFORMATIONS FOR A SOURCE APPLICATION AND MULTIPLE TARGET APPLICATIONS SUPPORTING DIFFERENT DATA FORMATS 失效
    用于源应用的数据传输和支持不同数据格式的多目标应用

    公开(公告)号:US20100185634A1

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

    申请号:US12357859

    申请日:2009-01-22

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/30569 G06F17/3092

    摘要: Embodiments of the invention allow structured data to be transferred between a source application and target applications that process structured data in different formats. For example, structured data may have associated rules which transform the structured data based on some variables. The source application may register variable definitions for each variable in a registry. Each target application may read the registry and register values for the variables. Once values are registered, the source application transfers the structured data to a transformation engine that applies the rules, using the registered values for the variables, to transform the structured data into a format compatible with the target applications. The transformation engine may also determine distinct sets of variable values and transform structured data based on each distinct set. In doing so, the number of transformed data generated is limited to the number of distinct sets, thereby avoiding generating duplicate transformed data.

    摘要翻译: 本发明的实施例允许结构化数据在源应用程序和以不同格式处理结构化数据的目标应用程序之间传送。 例如,结构化数据可以具有相关联的规则,其基于一些变量来转换结构化数据。 源应用程序可以为注册表中的每个变量注册变量定义。 每个目标应用程序可以读取注册表并注册变量的值。 一旦注册了值,源应用程序将结构化数据传输到转换引擎,该转换引擎使用注册的变量值将规则转换为与目标应用程序兼容的格式。 转换引擎还可以基于每个不同的集合来确定不同的变量值集合并且转换结构化数据。 在这样做时,生成的变换数据的数量被限制为不同集合的数量,从而避免生成重复的转换数据。

    Data model simplification through field fallout
    13.
    发明授权
    Data model simplification through field fallout 有权
    数据模型通过现场灰尘简化

    公开(公告)号:US08122052B2

    公开(公告)日:2012-02-21

    申请号:US12769527

    申请日:2010-04-28

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

    CPC分类号: G06F17/30398 G06F17/30392

    摘要: Methods, articles of manufacture and systems are provided for simplifying a query building process by limiting the number of fields presented to a user for building queries. The number of fields presented to the user may be limited by hiding one or more logical fields from the user based on usage characteristics. For example, a logical field that is rarely used or has not been used within a predetermined period of time may be hidden from the user. For some embodiments, a fallout manager may monitor the use of logical fields in building queries, update usage characteristics, and mark logical fields as hidden based on the usage characteristics. A graphical user interface may not present to a user logical fields that have been marked as hidden.

    摘要翻译: 提供了方法,制品和系统,以通过限制呈现给用户的字段数量来建立查询来简化查询构建过程。 提供给用户的字段的数量可以通过基于使用特性隐藏来自用户的一个或多个逻辑字段来限制。 例如,在预定时间段内很少使用或未被使用的逻辑字段可能被用户隐藏。 对于一些实施例,灰尘管理器可以监视构建查询中的逻辑字段的使用,更新使用特征,以及基于使用特性将逻辑字段标记为隐藏。 图形用户界面可能不会向用户呈现已被标记为隐藏的逻辑字段。

    Usage-based optimization of network traffic and data warehouse size
    14.
    发明授权
    Usage-based optimization of network traffic and data warehouse size 有权
    基于用户优化的网络流量和数据仓库大小

    公开(公告)号:US08086574B2

    公开(公告)日:2011-12-27

    申请号:US12106641

    申请日:2008-04-21

    IPC分类号: G06F17/00

    摘要: The present invention generally provides systems, methods, and articles of manufacture for maintaining a data warehouse having a plurality of fields updated with data from one or more data sources. Rather than automatically update every field of data available in the warehouse, a limited subset of fields identified through their involvement in queries issued against the warehouse are updated. By limiting the fields that are updated, the network bandwidth required to transmit the updates to the data warehouse may be reduced. Further, by removing fields from the data warehouse that are not in use, the size of the data warehouse may be reduced.

    摘要翻译: 本发明通常提供用于维护具有用来自一个或多个数据源的数据更新的多个字段的数据仓库的系统,方法和制品。 不是自动更新仓库中可用数据的每个字段,而是通过参与对仓库发出的查询来识别的有限子集的字段被更新。 通过限制更新的字段,可以减少向数据仓库发送更新所需的网络带宽。 此外,通过从未使用的数据仓库中删除字段,可以减少数据仓库的大小。

    Partial data model exposure through client side caching
    15.
    发明授权
    Partial data model exposure through client side caching 失效
    通过客户端缓存部分数据模型曝光

    公开(公告)号:US07574423B2

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

    申请号:US10392642

    申请日:2003-03-20

    IPC分类号: G06F17/30

    摘要: The present invention generally provides methods, articles of manufacture and systems for exposing, on a client device, fields of a data model representing an underlying database for use in building queries against the database. For some embodiments, the client device may be a device having limited resources, such as a handheld computing device. Therefore, rather than load and expose the entire data model on the client at once, a limited portion of the data model may be exposed on a client in a “just in time” (JIT) basis. The limited portion may be determined, for example, based on input received from a user and system parameters, such as the system memory and network bandwidth available to the client device.

    摘要翻译: 本发明通常提供了在客户端设备上暴露在数据库中的数据模型的表示用于构建针对数据库的查询的基础数据库的字段的方法,制品和系统。 对于一些实施例,客户端设备可以是具有有限资源的设备,诸如手持计算设备。 因此,不是一次在客户端上加载和公开整个数据模型,数据模型的有限部分可能会以“即时”(JIT)为基础在客户端上公开。 有限部分可以例如基于从用户接收的输入和诸如客户端设备可用的系统存储器和网络带宽的系统参数来确定。

    USAGE-BASED OPTIMIZATION OF NETWORK TRAFFIC AND DATA WAREHOUSE SIZE
    16.
    发明申请
    USAGE-BASED OPTIMIZATION OF NETWORK TRAFFIC AND DATA WAREHOUSE SIZE 有权
    基于用户的网络交通和数据仓库规模优化

    公开(公告)号:US20080228711A1

    公开(公告)日:2008-09-18

    申请号:US12106641

    申请日:2008-04-21

    IPC分类号: G06F7/00 G06F17/30

    摘要: The present invention generally provides systems, methods, and articles of manufacture for maintaining a data warehouse having a plurality of fields updated with data from one or more data sources. Rather than automatically update every field of data available in the warehouse, a limited subset of fields identified through their involvement in queries issued against the warehouse are updated. By limiting the fields that are updated, the network bandwidth required to transmit the updates to the data warehouse may be reduced. Further, by removing fields from the data warehouse that are not in use, the size of the data warehouse may be reduced.

    摘要翻译: 本发明通常提供用于维护具有用来自一个或多个数据源的数据更新的多个字段的数据仓库的系统,方法和制品。 不是自动更新仓库中可用数据的每个字段,而是通过参与对仓库发出的查询来识别的有限子集的字段被更新。 通过限制更新的字段,可以减少向数据仓库发送更新所需的网络带宽。 此外,通过从未使用的数据仓库中删除字段,可以减少数据仓库的大小。

    Data model simplification through field fallout
    17.
    发明授权
    Data model simplification through field fallout 有权
    数据模型通过现场灰尘简化

    公开(公告)号:US07734646B2

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

    申请号:US10353666

    申请日:2003-01-29

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

    CPC分类号: G06F17/30398 G06F17/30392

    摘要: The present invention generally provides methods, articles of manufacture and systems for simplifying a query building process by limiting the number of fields presented to a user for building queries. The number of fields presented to the user may be limited by hiding one or more logical fields from the user based on usage characteristics. For example, a logical field that is rarely used or has not been used within a predetermined period of time may be hidden from the user. For some embodiments, a fallout manager may monitor the use of logical fields in building queries, update usage characteristics, and mark logical fields as hidden based on the usage characteristics. A graphical user interface may not present to a user logical fields that have been marked as hidden.

    摘要翻译: 本发明通常提供方法,制品和系统,用于通过限制呈现给用户的用于构建查询的字段的数量来简化查询构建过程。 提供给用户的字段的数量可以通过基于使用特性隐藏来自用户的一个或多个逻辑字段来限制。 例如,在预定时间段内很少使用或未被使用的逻辑字段可能被用户隐藏。 对于一些实施例,灰尘管理器可以监视构建查询中的逻辑字段的使用,更新使用特征,以及基于使用特性将逻辑字段标记为隐藏。 图形用户界面可能不会向用户呈现已被标记为隐藏的逻辑字段。

    SECURE DATABASE ACCESS THROUGH PARTIAL ENCRYPTION
    19.
    发明申请
    SECURE DATABASE ACCESS THROUGH PARTIAL ENCRYPTION 有权
    安全数据库通过部分加密访问

    公开(公告)号:US20080148070A1

    公开(公告)日:2008-06-19

    申请号:US12036076

    申请日:2008-02-22

    IPC分类号: G06F11/30

    CPC分类号: H04L63/0428 G06F21/6245

    摘要: The present invention generally is directed to systems, methods, and articles of manufacture for securing sensitive information involved in database transactions. Embodiments of the present invention selectively encrypt only portions of transactions involving sensitive data, thereby reducing or eliminating the processing overhead resulting from wastefully encrypting non-sensitive data. The sensitive data may be identified by a document. The document may be accessed by a requesting entity to determine which portions of a query should be encrypted prior to sending the query to a database server over a network. The document may also be accessed by a database server to determine which portions of query results should be encrypted prior to sending the query results to the requesting entity over the network.

    摘要翻译: 本发明一般涉及用于保护涉及数据库事务的敏感信息的系统,方法和制品。 本发明的实施例仅选择性地仅加密涉及敏感数据的交易的部分,从而减少或消除由于非敏感数据的浪费加密而导致的处理开销。 敏感数据可以由文档识别。 在通过网络将查询发送到数据库服务器之前,请求实体可以访问文档以确定查询的哪些部分应被加密。 文档也可以被数据库服务器访问,以便在通过网络将查询结果发送到请求实体之前,确定查询结果的哪些部分应被加密。

    SYSTEM AND METHOD FOR CREATING AND POPULATING DYNAMIC, JUST IN TIME, DATABASE TABLES
    20.
    发明申请
    SYSTEM AND METHOD FOR CREATING AND POPULATING DYNAMIC, JUST IN TIME, DATABASE TABLES 审中-公开
    用于创建和人口动态的系统和方法,只在时间上,数据表

    公开(公告)号:US20080016047A1

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

    申请号:US11456902

    申请日:2006-07-12

    IPC分类号: G06F17/30

    CPC分类号: G06F16/2471

    摘要: A method, system and article of manufacture for executing database queries where the data being queried resides in both relational databases and other external data sources, and, more particularly, for creating a dynamic, just in time, database table using data retrieved from an external source. One embodiment provides a method of processing a database query. The method includes receiving, from a requesting entity, an abstract query of data contained in a database and an external data source, the abstract query being defined using logical fields of a data abstraction model abstractly describing the data in the database and the external data source. The method further includes generating, from the abstract query, an executable query capable of being executed by a query engine, wherein the executable query includes a reference to a temporary data structure, generating the temporary data structure using data retrieved from the external data source, and executing the executable query against the database and the temporary data structure to obtain a result set.

    摘要翻译: 一种用于执行数据库查询的方法,系统和制品,其中要查询的数据位于关系数据库和其他外部数据源中,更具体地,用于使用从外部获取的数据来创建动态的,及时的数据库表 资源。 一个实施例提供了一种处理数据库查询的方法。 该方法包括从请求实体接收包含在数据库和外部数据源中的数据的抽象查询,所述抽象查询使用抽象地描述数据库中的数据和外部数据源的数据抽象模型的逻辑字段来定义 。 该方法还包括从抽象查询生成能够由查询引擎执行的可执行查询,其中可执行查询包括对临时数据结构的引用,使用从外部数据源检索的数据生成临时数据结构, 并针对数据库和临时数据结构执行可执行查询以获得结果集。