Query facility

XQuery (XML Query) Flexible query facilities used to extract data from real and virtual documents by way of XML notation in a file system or on the World Wide Web. XQuery consequently provides interaction and data exchange between the web world and the database world and ultimately enables collections of XML files to be accessed like databases. The XML Query project of the W3C Consortium includes not only the standard for querying XML documents but also the next-generation standards for doing XML selection (XPath2), for XML serialization, for full-text search, for a possible functional XML data model, and for a standard set of functions and operators for manipulating web data. 

The compound registry and search system provides the graphical usei Interface, Interactive command language, search functions, and database management support which allow compound-associated Information to be added to the database and existing data to be modified or queried. The registry facility Is available on a restricted basis to those users with authority to update the compound database. On the other hand, the query facility is available to all users and allows search, display, and hard copy output of the various types of Information stored In the database. 

The portion of the search that Involves exact structures and exact structural fragments is executed in two phases. First an 8-byte hash value is calculated from the canonlcallzed (10) connection table for each exact fragment and structure. The query facility of the RDBMS is then used to search the database for all compounds that contain structures or fragments with the calculated hash values. Next, the connection tables for qualifying compounds are retrieved and the relevant attributes for the atom and bond descriptors are compared to determine if the structures do, in fact, match the target structure. 

In addition to addressing the practicalities of database maintenance, we also aim to enhance the range of the facilities available, to make the information within CHIRBASE more readily accessible to users. CHIRBASE contains two form-based applications for query building designed to help novice or expert users to formulate queries the query menu and the automatic search tool. 

To address these issues regarding adequate structural searching in CHIRBASE, some facilities have been recently added to the user interface. The result is the automatic generation and search of strategic 2D query structures defined with the help of the following commands (Fig. 4-5) ... 

Current chemical information systems offer three principal types of search facility. Structure search involves the search of a file of compounds for the presence or absence of a specified query compound, for example, to retrieve physicochemical data associated with a particular substance. Substructure search involves the search of a file of compounds for all molecules containing some specified query substructure of interest. Finally, similarity search involves the search of a file of compounds for those molecules that are most similar to an input query molecule, using some quantitative definition of structural similarity. 

Most clinical data management systems used for clinical trials today store their data in relational database software such as Oracle or Microsoft SQL Server. A relational database is composed of a set of rectangular data matrices called tables that relate or associate with one another by certain key fields. The language most often used to work with relational databases is structured query language (SQL). The SAS/ACCESS SQL Pass-Through Facility and the SAS/ACCESS LIBNAME engine are the two methods that SAS provides for extracting data from relational databases. 

I never heard what use was made of this information, but we subsequently had a couple of additional visits from the same group. Johnny Johnston also queried me further, although I cannot now remember the details. I do remember that when the men showed up in the hallway of our facility one day, I treated their visit rather offhandedly. I called out to Fred Sidell, Hey Fred, the CIA is here again The agents winced and gestured to me vigorously to hush up. ... 

Trial bums at both commercial incinerators and the Army s chemical agent disposal facilities are tailored to meet proposed operational requirements at their specific sites, under the applicable regulations governing that site. In response to a committee query, a DuPont and Company environmental manager replied as follows ... 

Ensure search and sort query reporting facilities are available or developed. 

Justifications for the expert system s recommendations need to be clear and specific. Explanation facilities - such as the why and how queries often found in expert systems - often consist of replaying the logic used by the system to arrive at a conclusion. While this is sufficient for some applications, others require more in-depth justification including causal relationships and assumptions made. Design of the explanation facility must be tied to design of the user interface of the system. 

Since large quantities of data are generated quickly, data must be efficiently interpreted and reported in a facile manner that will support rapid decisions [64], Data is formatted, reformatted, sorted, and filtered with a laboratory information management system (LIMS) or a process that involves the assembly and export of a text-based file (i.e., Microsoft Excel). The database is queried to provide the exact data that is needed for a specific report format. 

Prior to entry into the area, intelligence assets shall provide the NATO operational and local commanders with suspected areas that contain TICs. The intelligence community shall endeavor to obtain all pertinent information involving production and storage facilities of TICs. At a minimum the type of TICs and quantities at each location shall be provided to the Commander. Additionally, there is a need for Commanders to be informed on the specific risk (fire, explosion, toxicity, corrosive effects, and persistency of gas) as well as the efficiency of collective and individual protection systems. Intelligence assets should query the appropriate scientific, civilian industrial and chemical warfare treaty experts in order to gather all applicable information. When possible, local industrial site survey forms shall be obtained for all identified sites. 

This system incorporates an interactive menu-driven graphics interface for query construction in QUEST (Figure 3.3). The underlying Version 4 database also contains, for the first time, complete sets of at, -coordinates which permit the display of 2D chemical diagrams for each hit as it is located by QUEST. The PLUTO package is now being blended into QUEST so that, in later releases of Version 4, it will also be possible to examine interactively a 3 D plot of each hit in addition to the 2D representation of the chemical structure. Other facilities of Version 4 (subfiles, interface to GSTAT, etc.) are as for Version 3. 

Complete operational details of all CSD System programs are given in the relevant documentation [15]. In this section we give a brief overview of the search and retrieval facilities for the ID and 2D information items described in Section3.3.3. These details apply to all Versions of the CSD software but, where examples are necessary, we use the alphanumeric query coding of Version 3 in the text below. 

The PIR site also offers facilities for sequence similarity search (BLAST or FASTA), alignment (ClustalW), and analysis (ProClass, ProtFam, RESID, SSEARCH) of proteins. To perform the similarity search, select BLAST or FASTA to open the search form. Paste the query sequence and click the Submit button. The search returns a list of hits with option(s) for modifying the entries (modify query by choosing refine, add to or remove from the list) followed by pair-wise alignment of query sequence versus retrieved sequences (Figure 16.1). The Modify option(s) enable the user to design the list of desired entries. 

---