摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
The present invention provides methods and compositions to reduce growth of microbial colonies, including infections, and includes therapeutic compositions, methods for treatment of infections, and methods for identifying additional such compositions.
摘要:
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.
摘要:
The present invention provides methods and compositions to reduce growth of microbial colonies, including infections, and includes therapeutic compositions, methods for treatment of infections, and methods for identifying additional such compositions.
摘要:
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.
摘要:
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.