relational database
<database> (RDBMS - relational database management system) A database based on the relational model developed by E.F. Codd. A relational database allows the definition of data structures, storage and retrieval operations and integrity constraints. In such a database the data and relations between them are organised in tables. A table is a collection of rows or records and each row in a table contains the same fields. Certain fields may be designated as keys, which means that searches for specific values of that field will use indexing to speed them up. Where fields in two different tables take values from the same set, a join operation can be performed to select related records in the two tables by matching values in those fields. Often, but not always, the fields will have the same name in both tables. For example, an "orders" table might contain (customer_id, product_code) pairs and a "products" table might contain (product_code, price) pairs so to calculate a given customer's bill you would sum the prices of all products ordered by that customer by joining on the product-code fields of the two tables. This can be extended to joining multiple tables on multiple fields. Because these relationships are only specified at retreival time, relational databases are classed as dynamic database management system. The first commercial RDBMS was the Multics Relational Data Store, first sold in 1978. INGRES, Oracle, Sybase, Inc., Microsoft Access, and Microsoft SQL Server are well-known database products and companies. Others include PostgreSQL, SQL/DS, and RDB. ["Managing Data Bases, Four Critical Factors" Michael M. Gorman, QED Information Sciences, Inc.]. ["An Introduction To Database Systems" (6th ed) C. J. Date, Addison Wesley (an excellent source of detailed info)]. ["An End-User's Guide to Data Base" James Martin, Prentice Hall (excellent place to begin learning about DBMS)]. (2002-06-10) | ||||
Search Dictionary:
Relational database definition was found in categories: Language, Idioms & Slang(2) Computer & Internet(1) Encyclopedia(1)
Relational database Definition from Language, Idioms & Slang Dictionaries & Glossaries
| WordNet 2.0 |
relational database
Noun
1. a database in which relations between information items are explicitly specified as accessible attributes; "in a relational database the data are organized as a number of differently sized tables"
(hypernym) electronic database, on-line database, computer database, electronic information service
(hyponym) Medical Literature Analysis and Retrieval System, MEDLARS
Noun
1. a database in which relations between information items are explicitly specified as accessible attributes; "in a relational database the data are organized as a number of differently sized tables"
(hypernym) electronic database, on-line database, computer database, electronic information service
(hyponym) Medical Literature Analysis and Retrieval System, MEDLARS
| hEnglish - advanced version |
relational database
relational database
n : a database in which relations between information items are explicitly specified as accessible attributes; "in a relational database the data are organized as a number of differently sized tables"
relational database
n : a database in which relations between information items are explicitly specified as accessible attributes; "in a relational database the data are organized as a number of differently sized tables"
Relational database Definition from Computer & Internet Dictionaries & Glossaries
| DW and OLAP terms |
relational database
A collection of information organized in tables. Each table models a class of objects of interest to the organization (for example, Customers , Parts , Suppliers ). Each column in a table models an attribute of the object (for example, LastName , Price , Color ). Each row in a table represents one entity in the class of objects modeled by the table (for example, the customer name John Smith or the part number 1346). Queries can use data from one table to find related data in other tables.
A collection of information organized in tables. Each table models a class of objects of interest to the organization (for example, Customers , Parts , Suppliers ). Each column in a table models an attribute of the object (for example, LastName , Price , Color ). Each row in a table represents one entity in the class of objects modeled by the table (for example, the customer name John Smith or the part number 1346). Queries can use data from one table to find related data in other tables.
Relational database Definition from Encyclopedia Dictionaries & Glossaries
| Wikipedia English - The Free Encyclopedia |
Relational database
A relational database is a database that conforms to the relational model, and refers to a database's data and schema (the database's structure of how that data is arranged). Common usage of the term "Relational database management system" technically refers to the software used to create a relational database, but sometimes mistakenly refers to a relational database.
| See more at Wikipedia.org... |