Abstract: An apparatus for dynamically generating query explain data includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include a query explain program operating on a workstation. The query explain program communicates over a network with a server hosting a database system and is configured to temporarily store the query explain data received across the network from the database system in a data cache. The query explain program may be configured to automatically clear a selected portion of the data cache when the data cache reaches a user-selectable size. The user is thus allowed to determine when to clear the data cache and how much of the data cache to clear.

Abstract: The present invention involves a molded seamless vehicle interior panel having a seamless airbag door for concealing an airbag. The panel includes a retainer portion and a door portion circumscribed by the retainer portion. The retainer portion is disposed adjacent the airbag of the vehicle and has an opening to define a void over the airbag. The retainer portion has an appearance finish of an aesthetic look. The door portion disposed within the void integrally circumscribed by the retainer portion to define the seamless airbag door through which the airbag may deploy. The door portion has an appearance finish compatible to the appearance of the retainer portion such that no seam is visible. The door portion is molded together with the retainer portion and formed of a material different than the material of the retainer portion.

Abstract: A method for converting compactin to pravastatin is described. Compactin is provided and contacted with an agent derived from Actinomadura under conditions in which the agent converts compactin to pravastatin. Also described are an Actinomadura strain, an Actinomadura cell free extract, an Actinomadura hydroxylase, and a method for lowering cholesterol levels in mammals.

Abstract: The present invention automatically formats input data compatible for use with a workstation application into formatted input data compatible with a host application. The input data is in one example updated to include customized settings, such as setup options. After the update, a format module, incorporated within the application, confirms completion of the update and automatically creates a formatted input data file which is compatible with the host application. A user interface is provided to allow selection of file identification and delivery options for the formatted input data. The formatted input data may be stored in a single location, such as on a host, where it can be used with both a workstation and the host. Formatting of the input data may be automatic and transparent to the user. User implementation of file identification and delivery options allows for convenient manipulation of the formatted input data.

Abstract: An apparatus for filtering a set of query statements according to query explain data associated therewith includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include a filter generation module configured to receive user-specified filtering criteria directed to a subset of the query explain data for at least one query statement and generate in response at least one user-defined filter. The modules also include a statement filtering module configured to apply the user-defined filter to the set of query statements to selectively exclude query statements not satisfying the filtering criteria of the at least one filter.

Abstract: Methods are disclosed for the simple, rapid, and selective colorimetric detection of carbohydrates, including fructose, glucose, sialic acid, and oligosaccharides. There is no need for any prior hydrolysis or other chemical modification or of the analytes. Resorcinarenes, xanthene dyes, and related compounds, formally produced by the reaction of 2 equivalents of resorcinol and a suitable electrophilic condensation partner, are used as chromophores or fluorophores for the detection of sugars and other carbohydrates.

Abstract: A system and method for specifying custom qualifiers for explain tables allows a user to designate selected explain tables for which the user wishes to view statements. A query explain program is provided and configured with an explain table qualifier designation module for receiving a user designation of a query explain table to reference. The user selects a function of the query explain program to perform and then designates the qualifier of the query explain table to be referenced. The function is then performed in conjunction with the contents of the selected query explain table.

Abstract: Methods are disclosed for the simple, rapid, and selective colorimetric detection of carbohydrates, including fructose, glucose, sialic acid, and oligosaccharides. There is no need for any prior hydrolysis or other chemical modification or of the analytes. Resorcinarenes, xanthene dyes, and related compounds, formally produced by the reaction of 2 equivalents of resorcinol and a suitable electrophilic condensation partner, are used as chromophores or fluorophores for the detection of sugars and other carbohydrates.

Abstract: The present invention involves a molded seamless vehicle interior panel having a seamless airbag door for concealing an airbag. The panel includes a retainer portion and a door portion circumscribed by the retainer portion. The retainer portion is disposed adjacent the airbag of the vehicle and has an opening to define a void over the airbag. The retainer portion has an appearance finish of an aesthetic look. The door portion disposed within the void integrally circumscribed by the retainer portion to define the seamless airbag door through which the airbag may deploy. The door portion has an appearance finish compatible to the appearance of the retainer portion such that no seam is visible. The door portion is molded together with the retainer portion and formed of a material different than the material of the retainer portion.

Abstract: A compact, lightweight free-space optical communication system is mounted to a window, such as to a surface of the window. Mounting can be accomplished using glue, vacuum devices, or other fastener devices or fixtures. The optical communication system has features that compensate for window dynamics and other window characteristics, including fast steering solutions for pointing and tracking, and terminal size and weight factors.

Abstract: A method and apparatus for transferring convenience feature data (e.g., speed dial numbers, etc.) from one telephone to another local telephone within the same home or small office. In particular, the telephone includes a memory located within a corded or cordless telephone configured for storing data, and a transfer module configured to transfer requested data between the memory and a target device in response to a transfer request. The corded telephone utilizes a DTMF generator/receiver, a demodulation/modulation module, or a Bluetooth module to establish a communication path between the corded telephone and the target device. The cordless telephone utilizes a DTMF generator/receiver, a demodulation/modulation module, a radio frequency (RF) transceiver, or a Bluetooth module to establish a communication path between the cordless telephone and the target device.

Abstract: A method for selectively preparing customized reports of query explain data comprises selectively retrieving from the database subsets of the query explain data for the at least one query statement; formatting the subsets for display to a user; displaying within a report customization window one or more controls for selectively designating subsets of the query explain data for the at least one query statement to be included in the report; and in response to selection of the one or more controls, generating a report that includes the designated subsets of the query explain data for the at least one query statement.

Abstract: A system and method for specifying custom qualifiers for explain tables allows a user to designate selected explain tables for which the user wishes to view statements. A query explain program is provided and configured with an explain table qualifier designation module for receiving a user designation of a query explain table to reference. The user selects a function of the query explain program to perform and then designates the qualifier of the query explain table to be referenced. The function is then performed in conjunction with the contents of the selected query explain table.

Abstract: An adjunct Type II caller ID/call waiting (CIDCW) receiver unit is provided which has a greatly improved ability to detect tones and other call related information on a telephone line from a central office while the customer premises equipment is in an off-hook condition. The inventive adjunct CIDCW receiver unit is placed in series between the telephone line from the central office and the customer premises equipment, rather than in parallel with the customer premises equipment as in conventional adjunct CIDCW receiver units. A second telephone line interface (TLI) is included in the adjunct CIDCW receiver unit for connection to the customer premises unit to simulate the impedance of the telephone line. The adjunct CIDCW receiver unit has the ability to disconnect, mute or suppress the microphone signal from the customer premises equipment from being included in the signal received by the call related information receiver portion of the adjunct CIDCW receiver unit.

Abstract: A communications handling center in which agents are assigned to handling queues for handling incoming communications, and handling attributes are assigned to the agents, is disclosed. The center forwards incoming communications, such as telephone calls, by determining handling requirements, including an appropriate handling queue and required agent attributes. An available agent within a queue is first located, and then an assessment is made whether that agent possesses required attributes in order to handle the communication. If so, the call is forwarded to the located agent. Preferably, the assigned agent attributes are relevant to all queues to which the agent may be assigned, allowing for the easy administration of the communications handling center, by reducing the number of queues that must be maintained.

Abstract: A method for converting compactin to pravastatin is described. Compactin is provided and contacted with an agent derived from Actinomadura under conditions in which the agent converts compactin to pravastatin. Also described are an Actinomadura strain, an Actinomadura cell free extract, an Actinomadura hydroxylase, and a method for lowering cholesterol levels in mammals.

Abstract: A method for converting compactin to pravastatin is described. Compactin is provided and contacted with an agent derived from Actinomadura under conditions in which the agent converts compactin to pravastatin. Also described are an Actinomadura strain, an Actinomadura cell free extract, an Actinomadura hydroxylase, and a method for lowering cholesterol levels in mammals.

Abstract: A method for selectively preparing customized reports of query explain data comprises selectively retrieving from the database subsets of the query explain data for the at least one query statement; formatting the subsets for display to a user; displaying within a report customization window one or more controls for selectively designating subsets of the query explain data for the at least one query statement to be included in the report; and in response to selection of the one or more controls, generating a report that includes the designated subsets of the query explain data for the at least one query statement.

Abstract: According to one aspect of the invention, two lines are utilized to selectively forward calls based on caller ID data. Thus, according to one embodiment of the invention, a method of connecting a calling party to a called party includes the steps of a customer premise equipment (CPE) receiving an incoming call from the calling party on a first line, the CPE evaluating caller ID data associated with the incoming call, and the CPE placing an outgoing call to the called party on a second line based on the caller ID data. In another embodiment, a CPE includes a first line, a second line, and a calling unit adapted to place an outgoing call on the second line based on caller ID data associated with an incoming call received on the first line.

Abstract: Type 2 caller ID/call waiting (CIDCW) customer premises equipment (CPE) is provided which has a greatly improved method of detecting tones indicating the availability of call information regarding an incoming call while the customer premises equipment is in an off-hook condition. A hybrid echo canceler (HEC) algorithm is added to the customer premises equipment (CPE) to suppress the signal from the microphone of the customer premises equipment from being included in the signal analyzed for the presence of tones. Thus, the microphone of the customer premises equipment need not be muted upon detection of the alerting CAS tone sequence in a Caller ID service. The HEC algorithm runs substantially continuously in a preferred embodiment, and may be combined with a conventionally operating HEC which cancels reflections due to the hybrid or telephone line interface.