METHOD, COMPUTER PROGRAM PRODUCT, AND SYSTEM OF OPTIMIZED DATA TRANSLATION FROM RELATIONAL DATA STORAGE TO HIERARCHICAL STRUCTURE
    21.
    发明申请
    METHOD, COMPUTER PROGRAM PRODUCT, AND SYSTEM OF OPTIMIZED DATA TRANSLATION FROM RELATIONAL DATA STORAGE TO HIERARCHICAL STRUCTURE 有权
    方法,计算机程序产品和从关系数据存储到分层结构的优化数据转换系统

    公开(公告)号:US20070118553A1

    公开(公告)日:2007-05-24

    申请号:US11623840

    申请日:2007-01-17

    IPC分类号: G06F7/00

    摘要: A tagging tree that defines a hierarchical output data structure and relational database query operations that retrieve the data to be included in each hierarchical section is accepted and processed. A query optimizer analyzes the tagging tree to determine database query operations that can be combined into a single query command. An outer-union query command is generated to allow efficient combination of multiple query commands, some of which are predicates to others. The tagging tree is modified to replace the database queries that were combined into the outer-union query to extract data from the results set produced by the outer-union query as opposed to submitting queries to the database manager. The optimized queries can be reused an arbitrary number of times to leverage the optimizing resources that were used in their creation.

    摘要翻译: 定义分层输出数据结构的标记树和检索要包含在每个分层部分中的数据的关系数据库查询操作被接受和处理。 查询优化器分析标记树以确定可以组合成单个查询命令的数据库查询操作。 生成一个外联合查询命令,以允许多个查询命令的有效组合,其中一些查询命令是其他命令的谓词。 标记树被修改为将组合到外联合查询中的数据库查询替换为从外联合查询生成的结果集中提取数据,而不是向数据库管理器提交查询。 优化的查询可以重复使用任意次数,以利用其创建中使用的优化资源。

    Lysin-deficient bacteriophages having reduced immunogenicity

    公开(公告)号:US07087226B2

    公开(公告)日:2006-08-08

    申请号:US11053982

    申请日:2005-02-08

    IPC分类号: A01N63/00

    摘要: The present invention features therapeutic bacteriophage deficient in the lysin protein (“Lys minus” phage). Lys minus bacteriophage are incapable of facilitating efficient lysis of the bacterial host since the enzymatic activity of the lysin of the phage is needed for breaking down the peptidoglycan layer of the bacterial cell wall. Lys minus bacteriophage retain activity in invasion of its appropriate bacterial host, destruction of the bacterial genome, and replication, which are sufficient to inhibit bacterial growth and replication. Therefore, the therapeutic Lys minus phage stops the spread of infection by the bacterial pathogen without lysis of the bacterium. This approach is attractive as it also prevents the release of the phage progeny, thus reducing or eliminating the potential for generation of immune responses against the phage. The incapacitated bacterial pathogen is then removed by the normal defense systems such as phagocytes and macrophages.

    Query-driven partial materialization of relational-to-hierarchical mappings
    23.
    发明申请
    Query-driven partial materialization of relational-to-hierarchical mappings 有权
    查询驱动的关系到层次映射的部分实现

    公开(公告)号:US20050198055A1

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

    申请号:US10795534

    申请日:2004-03-08

    IPC分类号: G06F17/00

    摘要: Techniques are provided for automatically rewriting a relational-to-hierarchical mapping into one or more modified mappings. In this way, clients that prefer or require different portions of the mapping-defined data are supported. For example, in one aspect of the invention, a technique for modifying a relational-to-hierarchical mapping in accordance with at least one user query includes the following steps/operations. At least one query associated with a query language that supports a hierarchical data structure is obtained. Further, at least one relational-to-hierarchical mapping for use in translating data associated with a relational data structure into data associated with the hierarchical data structure is obtained. Then, the at least one relational-to-hierarchical mapping is modified based on the at least one query such that data specifically relevant to the at least one query may be generated in accordance with the modified relational-to-hierarchical mapping.

    摘要翻译: 提供了用于将关系到分层映射自动重写成一个或多个修改的映射的技术。 以这种方式,支持偏好或需要映射定义数据的不同部分的客户端。 例如,在本发明的一个方面,根据至少一个用户查询修改关系到分层映射的技术包括以下步骤/操作。 获得与支持分层数据结构的查询语言相关联的至少一个查询。 此外,获得用于将与关系数据结构相关联的数据转换成与分层数据结构相关联的数据的至少一个关系到分层映射。 然后,基于至少一个查询来修改至少一个关系到分层映射,使得可以根据修改的关系到分层映射生成与至少一个查询特别相关的数据。

    Star and snowflake schemas in extract, transform, load processes
    24.
    发明授权
    Star and snowflake schemas in extract, transform, load processes 有权
    星和雪花图案在提取,转换,加载过程中

    公开(公告)号:US09323815B2

    公开(公告)日:2016-04-26

    申请号:US13618282

    申请日:2012-09-14

    IPC分类号: G06F17/30

    摘要: A computer-implemented method, computer program product and a system for supporting star and snowflake data schemas for use with an Extract, Transform, Load (ETL) process, comprising selecting a data source comprising dimensional data, where the dimensional data comprises at least one source table comprising at least one source column, importing a data model for the dimensional data into a data integration system, analyzing the imported data model to select a star or snowflake target data schema comprising target dimensions and target facts, generating a meta-model representation by mapping at least one source table or source column to each target fact and target dimension, automatically converting the meta-model representation into one or more ETL jobs, and executing the ETL jobs to extract the dimensional data from the data source and loading the dimensional data into the selected target data schema in a target data system.

    摘要翻译: 一种计算机实现的方法,计算机程序产品和用于支持用于与提取,变换,加载(ETL)过程一起使用的星形和雪花数据模式的系统,包括选择包括尺寸数据的数据源,其中所述维数据包括至少一个 源表包括至少一个源列,将维数据的数据模型导入数据集成系统,分析导入的数据模型以选择包括目标维度和目标事实的星形或雪花目标数据模式,生成元模型表示 通过将至少一个源表或源列映射到每个目标事实和目标维度,将元模型表示自动转换为一个或多个ETL作业,以及执行ETL作业以从数据源提取尺寸数据并加载维度 数据到目标数据系统中的所选目标数据模式。

    Slowly changing dimension attributes in extract, transform, load processes

    公开(公告)号:US09311368B2

    公开(公告)日:2016-04-12

    申请号:US13618158

    申请日:2012-09-14

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30563

    摘要: A computer-implemented method, computer program product and a system for identifying and handling slowly changing dimension (SCD) attributes for use with an Extract, Transform, Load (ETL) process, comprising importing a data model for dimensional data into a data integration system, where the dimensional data comprises a plurality of attributes, identifying via a data discovery analyzer one or more attributes in the data model as SCD attributes, importing the identified SCD attributes into the data integration system, selecting a data source comprising dimensional data, automatically generating an ETL job for the dimensional data utilizing the imported SCD attributes, and executing the automatically generated ETL to extract the dimensional data from the data source and loading the dimensional data into the imported SCD attributes in a target data system.

    NOVEL FUSION TAG OFFERING SOLUBILITY TO INSOLUBLE RECOMBINANT PROTEIN
    27.
    发明申请
    NOVEL FUSION TAG OFFERING SOLUBILITY TO INSOLUBLE RECOMBINANT PROTEIN 审中-公开
    新颖的融合标签提供不溶性重组蛋白的溶解性

    公开(公告)号:US20120107876A1

    公开(公告)日:2012-05-03

    申请号:US13318276

    申请日:2010-04-29

    IPC分类号: C12P21/02 C12N15/70 C07K14/00

    摘要: The invention relates to a fusion tag comprising Serine-aspartic acid repeats of the well conserved region of the Staphylococcus aureus Sdr C gene superfamily. A START codon and an enterokinase cleavage site has been incorporated into this repeat region to make a novel fusion tag that is responsible for expressing soluble proteins in bacterial system.

    摘要翻译: 本发明涉及包含金黄色葡萄球菌Sdr C基因超家族的保守区域的丝氨酸 - 天冬氨酸重复序列的融合标签。 已经将START密码子和肠激酶切割位点并入该重复区域,以制备新的融合标签,其负责在细菌系统中表达可溶性蛋白质。

    Query-driven partial materialization of relational-to-hierarchical mappings
    29.
    发明授权
    Query-driven partial materialization of relational-to-hierarchical mappings 有权
    查询驱动的关系到层次映射的部分实现

    公开(公告)号:US07469249B2

    公开(公告)日:2008-12-23

    申请号:US10795534

    申请日:2004-03-08

    IPC分类号: G06F17/00

    摘要: Techniques are provided for automatically rewriting a relational-to-hierarchical mapping into one or more modified mappings. In this way, clients that prefer or require different portions of the mapping-defined data are supported. For example, in one aspect of the invention, a technique for modifying a relational-to-hierarchical mapping in accordance with at least one user query includes the following steps/operations. At least one query associated with a query language that supports a hierarchical data structure is obtained. Further, at least one relational-to-hierarchical mapping for use in translating data associated with a relational data structure into data associated with the hierarchical data structure is obtained. Then, the at least one relational-to-hierarchical mapping is modified based on the at least one query such that data specifically relevant to the at least one query may be generated in accordance with the modified relational-to-hierarchical mapping.

    摘要翻译: 提供了用于将关系到分层映射自动重写成一个或多个修改的映射的技术。 以这种方式,支持偏好或需要映射定义数据的不同部分的客户端。 例如,在本发明的一个方面,根据至少一个用户查询修改关系到分层映射的技术包括以下步骤/操作。 获得与支持分层数据结构的查询语言相关联的至少一个查询。 此外,获得用于将与关系数据结构相关联的数据转换成与分层数据结构相关联的数据的至少一个关系到分层映射。 然后,基于至少一个查询来修改至少一个关系到分层映射,使得可以根据修改的关系到分层映射生成与至少一个查询特别相关的数据。

    Relational database management encryption system
    30.
    发明授权
    Relational database management encryption system 有权
    关系数据库管理加密系统

    公开(公告)号:US07269729B2

    公开(公告)日:2007-09-11

    申请号:US10036196

    申请日:2001-12-28

    IPC分类号: H04L9/00 G06F11/30 G06F7/04

    摘要: Disclosed is a method of internally encrypting data in a relational database, comprising the steps of providing a security dictionary comprising one or more security catalogs, receiving data from a user associating said data with a database column and at least one authorized user, generating a working encryption key, internally encrypting said working encryption key using a public key from an authorized user, storing said encrypted working key in a security catalog, and using said working key to internally encrypt said data.

    摘要翻译: 公开了一种在关系数据库中内部加密数据的方法,包括以下步骤:提供包括一个或多个安全目录的安全词典,从用户接收数据,将所述数据与数据库列和至少一个授权用户相关联,生成工作 加密密钥,使用来自授权用户的公钥对所述工作加密密钥进行内部加密,将所述加密的工作密钥存储在安全目录中,并使用所述工作密钥对所述数据进行内部加密。