Relational Database Fundamentals

Much of this book is a discussion of computer languages. SQL is a type of programming language. Becoming fluent in SQL helps make the most of a relational database. SMILES, SMARTS, and SMIRKS are chemical computer languages that express many fundamental aspects of chemical structure. Becoming fluent in all these languages will help you create... 

The primary purpose of the Chemical Information Database is to take advantage of both the relational power of ORACLE and the chemical structural retrieval power of MACCS. If one needs to retrieve information based upon structure, it is best done in MACCS. The link to ORACLE allows one to control the retrieval of batch information so that each batch can be considered a separate display or page of information. This is possible because each batch in ORACLE is considered a separate set of information. The biological efficacy information is stored in an ORACLE relational database. This information existed before the MACCS-ORACLE link. Because of the link, chemical information in MACCS can be directly linked relationally to biological information in ORACLE. This ability to link biological and chemical information is an important and fundamental tool for drug discovery scientists. This application supports a primary business objective by linking structure-activity data. 

The hierarical, network, relational, and object-oriented database models are the four fundamental ones. 

The authors have described some fundamental procedures to evaluate the solid-liquid phase relations of nano-sized particles in binary alloys from the calculation of the surface properties as well as the phase equilibira on the basis of thermodynamic databases, which are usually used for the calculation of phase diagrams of the bulk materials. In order to obtain quantitatively precise values of the melting points and liquidus temperatures in alloys, we should carry out further investigation as follows ... 

---