Using a Database

Excel provides a number of menu commands and functions that permit you to use a list as a database. You can use menu commands to find records in the database that match criteria that you define, or you can use worksheet fimctions to extract numerical information from a database. 

To use Excel s database commands and functions, your list must meet the following requirements. 

---

A second scheme uses a database of known chemical reactions. This more often results in synthesis routes that will work. However, this occurs at the expense of not being able to suggest any new chemistry. This method can also give many possible synthesis routes, not all of which will give acceptable yield or be easily carried out. The quality of results will depend on the database of known reactions and the means for determining which possible routes are best. These are often retro synthetic algorithms, which start with the desired product and let the researcher choose from a list of possible precursors. 

If you operate a computerized documentation system, your problems can be eased by the versatility of the computer. Using a database you can provide users with all kinds of information regarding the nature of the change, but be careful. The more you provide the greater the chance of error and the harder and more costly it is to maintain. 

An alternate method that lends itself to analysis using a database is to add varying amounts of standard to a fixed volume of unknown in separate volumetric flasks. The flasks are all filled to the mark, mixed well and measured. As an example let us take a solution containing an unknown amount of Cu2+ 25.0 ml of the unknown is pipetted into each of five 50 ml volumetric flasks. Added into these flasks are 0.0 ml, 3.0 ml 5.0 ml, 7.0 ml and 10.0 ml of a 0.600 ppm solution of Cu2+. Each flask is then filled to the mark with 1.0 M ammonia solution to develop the color. The measured absorbances were 0.326, 0.418, 0.475, 0.545 and 0.635, respectively. The concentrations of each of the standards in the... 

The AChE inhibitory properties of the coumarins scopoletin (75) and scopolin (76) were discovered by an interesting in silico approach. A model 3-dimensional pharmacophore was constructed, using a database of known inhibitors and their interaction with the AChE from Torpedo californica. The model was then used to predict likely inhibitors from a large database of those whose molecular coordinates were known. (75) and (76) were predicted and then isolated from Scopolia carniolica and tested in the Ellman assay. Results showed that (75) was much more active than the glucoside (76) but it was 2.5 orders of magnitude weaker than galantamine. Scopoletin also showed activity in vivo when given to rats. 

Llinas, A., Glen, R.C., Goodman, J.M. Solubility challenge can you predict solubilities of 32 molecules using a database of 100 reliable measurements J. Chem. Inf. Model. 2008,48,1289-303. 

When the main variables have been determined, one has to use a database as large as possible to obtain a correlation. 

Use a database of retention indices (e.g., the Flavomet see Internet Resource) to tentatively identify each peak. 

Advances in NMR instrumentation and methodology have now made it possible to determine site-specific proton chemical shift assignments for a large number of proteins and nucleic acids (1,2). It has been known for some time that in proteins the "structural" chemical shifts (the differences between the resonance positions in a protein and in a "random coil" polypeptide (3-5),) carry useful structural information. We have previously used a database of protein structures to compare shifts calculated from simple empirical models to those observed in solution (6). Here we demonstrate that a similar analysis appears promising for nucleic acids as well. Our conclusions are similar to those recently reported by Wijmenga et al (7),... 

The remainder of this paper will discuss the Varian/Digital VAX LIMS and the way laboratory requirements are fulfilled using a database management system. 

Rather than manual model building, it is possible to use a database approach to build a starting structure from homologous structural fragments taken from the crystallographic protein data bank.37 The main use of this technique is that it can be used during the earliest investigations of a molecule when adequate NMR may not yet be available. 

We have used a database not only to populate PLC and SCADA values, but also to generate forms used in the testing. These forms, referenced by each protocol, can help to minimize documentation, but, more importantly show at a glance the continuity of completed tests. 

When discussing validating databases, it is important to distinguish between a database and a Database Management System (DBMS). The DBMS is the layered software that provides the tools to build and use a database. For example, Oracle and Microsoft Access are two examples of a DBMS often used in pharmaceutical companies. 

Duffythe group contribution approach of Klopman and the neural network model of Huuskonen. " The PCCHEM program used at the US Environmental Protection Agency (EPA) incorporates three different equations. All of them are similar to GSE but have different coefficients to predict aqueous solubility depending on the range of log P values. " Meylan and Howard used a database of 817 (RMSE = 0.62) compounds to derive a heuristic equation ... 

Chr h-t. i Ti = ralioa " i nH a spreadsheet - use a database only after careful consideration. Can the task be dori- bi ttc v.it iiii n siirf-rffifahut t A. dalcjbcisu piogran i a (. ch tiiiIl tu set up and usualty needs to be updated-rogulaily. 

You can use a database to catalogue, search, sort and relate collections of information. The benefits of a computerized database over a manual card-file... 

---