Abstract: The present disclosure provides compounds and methods for inhibiting DNA-dependent protein kinase (DNA-PK). Aspects of the present disclosure also include methods of using the compounds to treat diseases, including, but not limited to, cancer. In certain embodiments, the compounds inhibit DNA-PK and thus sensitize cancers to therapies such as chemotherapy and radiotherapy. Certain compounds of the present disclosure are in the form of prodrugs that release the DNA-PK inhibitor in hypoxic tissue such as is known to occur in cancers. Aspects of the present disclosure also include methods of using the compounds for repairing a DNA break in a target genomic region or for modifying expression of one or more genes or proteins. Compounds provided are of formula.

Abstract: The present disclosure provides compounds and methods for inhibiting DNA-dependent protein kinase (DNA-PK). Aspects of the present disclosure also include methods of using the compounds to treat diseases, including, but not limited to, cancer. In certain embodiments, the compounds inhibit DNA-PK and thus sensitize cancers to therapies such as chemotherapy and radiotherapy. Certain compounds of the present disclosure are in the form of prodrugs that release the DNA-PK inhibitor in hypoxic tissue such as is known to occur in cancers. Aspects of the present disclosure also include methods of using the compounds for repairing a DNA break in a target genomic region or for modifying expression of one or more genes or proteins.

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: A roller-cone drill bit in which a large groove is machined into the backface of each cone, near the crack where the cone meets the arm assembly. By making the outer lip of this crack more exposed to the open volume of turbulent flow, turbulence near the crack is increased, deposit of sediments near the crack is reduced, and infiltration of sediments through the crack is also reduced. Drill bit lifetime has been shown to be greatly extended by this change.

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 marker pen comprises a housing (1) from one end of which protrudes a plurality of fluid retaining nibs (3) each shaped to define along an upper surface a ridge (5). The nibs are positioned side-by-side with adjoining ends of neighbouring ridgees in contact or in close proximity to define together a continuous (or substantially continuous) ridge. Means are provided to prevent or inhibit migration of dye from adjoining nibs.

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: An image display apparatus with a display device for displaying images and a viewing device for viewing an image in the left eye and a different image in the right eye. Two smaller images, a left image and a right image, are created from the same two-dimensional image. The left image includes, as it's left most part, the left most part of the two-dimensional image, the right image includes, as it's right most, the right most part of the image two-dimensional image, and both the left and right images include a common central part of the full image. When the left and right images are displayed such that the left eye sees one image and the right eye sees the other image, the viewer sees the two-dimensional image as a virtual image that can be wider than the viewable width of the display device. The width of the virtual image can be varied to accommodate the viewer.

Abstract: The compounds of the instant invention are bicyclic amino acids useful in the treatment of epilepsy, faintness attacks, hypokinesia, cranial disorders, neurodegenerative disorders, depression, anxiety, panic, pain, arthritis, neuropathological disorders, and sleep disorders. Processes for the preparation of the final products and intermediates useful in the process are included. Pharmaceutical compositions containing one or more of the compounds are also included.

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: A method of preventing execution of unnecessary joins between tables 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 compounds of the instant invention are bicyclic amino acids useful in the treatment of epilepsy, faintness attacks, hypokinesia, cranial disorders, neurodegenerative disorders, depression, anxiety, panic, pain, arthritis, neuropathological disorders, and sleep disorders. Processes for the preparation of the final products and intermediates useful in the process are included. Pharmaceutical compositions containing one or more of the compounds are also included.