Abstract: Example embodiments of systems and methods for data transmission system between transmitting and receiving devices are provided. In an embodiment, each of the transmitting and receiving devices can contain a master key. The transmitting device can generate a diversified key using the master key, protect a counter value and encrypt data prior to transmitting to the receiving device, which can generate the diversified key based on the master key and can decrypt the data and validate the protected counter value using the diversified key.

Abstract: Provided herein are conjugated oligonucleotides that are characterized by efficient and specific tissue distribution.

Abstract: The present disclosure relates to engineered microorganisms capable of producing gadusol. The engineered microorganisms contain a nucleotide sequence encoding 2-epi-5-valione synthase (EEVS) and a nucleotide sequence encoding methyltransferase-oxidoreductase (MT-Ox). Methods of using the engineered microorganisms to produce gadusol, including the culturing of such microorganisms, are also described.

Abstract: The present disclosure relates to engineered microorganisms capable of producing gadusol. The engineered microorganisms contain a nucleotide sequence encoding 2-epi-5-valione synthase (EEVS) and a nucleotide sequence encoding methyltransferase-oxidoreductase (MT-Ox). Methods of using the engineered microorganisms to produce gadusol, including the culturing of such microorganisms, are also described.

Abstract: A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: receive user input indicating selected items to be retrieved from the database; ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, if so: create a second view that is a copy of the first view and add a copy of each reach through item to it; and create a query that refers only to the second view and the items exposed by it.

Abstract: A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is disclosed. The method includes presenting the SQL statement to the database and identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria. For each identified join, the SQL statement may be modified so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.

Abstract: The present invention relates to a query generator for generating a query for obtaining selected data from a database. The query generator includes a processor which is adapted to receive an input indicating the selected data to be obtained. The processor then analyses the input to determine whether the input requires a joining of data in different tables, and an aggregation step. If so, the processor generates a query which causes the database to aggregate the data within each of the tables as required; and, join the aggregated data, the joined aggregated data representing the selected data.

Abstract: A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is disclosed. The method includes determining in the SQL statement a unique identifier to a row of the master table. The unique identifier is then equated to an identifier to related rows of the detail table using the join condition. A revised SQL statement may then be produced that only refers to the detail table using the identifier to the rows of the detail table. Subsequently, the revised SQL statement is processed.

Abstract: A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: a) receive user input indicating selected items to be retrieved from the database; b) ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, c) if so: i) create a second view that is a copy of the first view and add a copy of each reach through item to it; and ii) create a query that refers only to the second view and the items exposed by it.

Abstract: Various methods of programming a processing system utilizing a computer having a configuration canvas, at least one processor, and a plurality of function objects is disclosed. A processing configuration is created by placing object icons associated with function objects onto the canvas. Execution paths are automatically routed between the object icons based on orientations of icons on the canvas. Data flow paths are created between object icons on the canvas separately from the routings of the execution paths. Execution paths can be re-routed to increase the versatility of the processing system. Also, visual instruments and instrument icons can be utilized to further graphically illustrate and control the processing configuration.

Abstract: A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is described. The method comprises: a) presenting the SQL statement to the database; b) identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria; and c) for each identified join, modifying the SQL statement so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.

Abstract: A method of preventing execution of unnecessary joins between tables in a database is described.

Abstract: A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is described.

Abstract: The present invention relates to a repository which stores properties of database objects. The repository includes a first store for storing a number of predetermined properties, and a second store for storing additional properties. A processor is provided for determining or modifying the properties stored in the first and second stores.

Abstract: The present invention relates to a repository which stores properties of database objects. The repository includes a first store for storing a number of predetermined properties, and a second store for storing additional properties. A processor is provided for determining or modifying the properties stored in the first and second stores.

Abstract: The present invention relates to a query generator for generating a query for obtaining selected data from a database. The query generator includes a processor which is adapted to receive an input indicating the selected data to be obtained. The processor then analyses the input to determine whether the input requires a joining of data in different tables, and an aggregation step. If so, the processor generates a query which causes the database to aggregate the data within each of the tables as required; and, join the aggregated data, the joined aggregated data representing the selected data.