Relational database management system

Much of this book discusses ways in which the RDBMS can be used and even extended to handle chemical structures correctly, quickly, and conveniently. Extensions of the capabilities of PostgreSQL are simply called extensions. Oracle uses the term data cartridge. There are chemical extensions or cartridges available for PostgreSQL, Oracle, and MySQL. [Pg.31]

Oracle is a commercial RDBMS. It strongly conforms to the ANSI SQL-92/99 standards. It is the most widely used RDBMS. The Oracle company sells and supports the Oracle RDBMS. There are many other companies that also offer support for Oracle RDBMS. There are several commercial chemical cartridges available for use with Oracle.5 [Pg.31]

MySQL is an open-source RDBMS. It conforms in part to the SQL 92/99 standards. The MySQL company sells and support the MySQL RDBMS. There are other companies that support MySQL and offer products that use MySQL as the underlying database. Tharun Kumar Allu describes a small molecule chemical database cartridge extension for MySQL.6 [Pg.32]

A disadvantage of the relational database management system (RDBMS) might be the overload of hardware and operating systems, which make the system slower. [Pg.236]

MACCS-II enables direct interface with other database management systems, such as the Relational Database Management System (RDBMS) and Oracle, so that databases which contain text and numeric data for which special interfaces are normally needed can be constmcted. Eor example, an Oracle MACCS-II linked system is currendy being used by the National Institute on Dmg Abuse (113) to develop a database that will allow scientists to determine the molecular stmctures of cocaine and other controlled substances as well as designer dmgs. [Pg.130]

MACCS-II enables direct interface with other database management systems, such as Ihe Relational Database Management System RDBMS) and Oracle, so that databases that contain text and numeric data, for which special interfaces arc normally needed, can be constructed. [Pg.832]

RDBMS (relational database management system) read/write permission real time (noun) real-time (unit modifier) reboot... [Pg.167]

Laboratory Information Management Systems (LIMS) are widely used in the laboratories of pharmaceuticals and related industries. LIMS is typically based on client server technology supported by a Relational Database Management System (RDBMS) as a storage repository (see Figure 21.1). They can be used to manage and process large amounts of electroiuc analysis data locally within a laboratory or company-wide between sites. [Pg.512]

Oracle and Access are two examples of relational database management systems. SAP , which has thonsands of tables, is an example of a large application that makes use of relational database technology. There are two other types of databases — hierarchical and network — but these are less common and generally limited to the mainframe world and will not be discussed here. This chapter will focus primarily on relational databases. [Pg.752]

There are many books that describe relational database management systems (RDBMS) and the structured query language (SQL) used to manipulate the data. Understanding SQL is important, and this book contains an introduction to SQL. However, the focus is on the concepts of relational data. One goal is to show how a proper integration of a new molecular structure data type yields a powerful, extended relational database for use in chemistry. For those of you new to relational databases, it is expected that the SQL introduction will suffice for your understanding of the concepts in this book. For those of you already familiar with SQL, it is hoped that you will see how the extensions described here provide a powerful, integrated way to handle molecular structures within the database. In either case, there are plenty of practical SQL examples contained in this book. [Pg.1]

The nature of the data in each column must be specified by providing a data type. The data type must be one of a fixed set of types available in the relational database management system (RDBMS) being used. A discussion of several common RDBMS follows in Chapter 4. Some of the frequently used data types are... [Pg.6]

PostgreSQL is generally referred to as an Object Relational Database Management System (ORDBMS). The use of the word object implies objects in the sense of an object-oriented computer language. While not intended to be fully object-oriented in the same sense as a computer language, an ORDBMS shares the essential aspects of objects. These include composite data types, methods (functions), and inheritance. [Pg.121]

If SMILES is used to store molecular structures in a relational database management system(RDBMS), it may be necessary to extract the symbol and bond information for some client programs that expect a connection table. The smiles to symbol and smiles to bonds function shown in the next sections allow the symbol and bond information in a SMILES to be extracted as an array. Some client programs may prefer to process this information in rows, as if they were records in a file. The following plpgsql functions can be used to present the array elements as rows. Two functions are shown ctable (connection table) and symbol coords. The symbol coords function requires an array of coordinates in addition to the symbols. [Pg.173]

Introduces the concepts of relational database management systems and the structured query language... [Pg.231]

Since vendors began releasing RDBMS (relational database management system) products in the 1970s, the processing model in which various business data are divided into distributed databases and are accessed via network has been widely adopted. Client/server systems are composed of the various functional elements associated with data processing. [Pg.715]

Relational database management systems are becoming increasingly popular for managing research information as well as business data. However, existing relational... [Pg.33]

INGRES - Relational database management system, hardware supported DEC VAX, IBM mainframe, etc., available from Relational Technology, Inc., 1080 Marina Village Parkway, Alameda, CA 94510, U.S.A. [Pg.40]

Introducing fill boxes in the standard report made through RDS2 (Report Definition System). These fill boxes are 1 1 related with RDBMS (relational database management system) column names and will be filled at display time by interactive commands. [Pg.45]

Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...