It also allows you to sort based on any field and generate reports that contain only certain fields from each record. Relational databases use tables to store information. The standard fields and records are represented as columns fields and rows records in a table. With a relational database, you can quickly compare information because of the arrangement of data in columns.
The relational database model takes advantage of this uniformity to build completely new tables out of required information from existing tables. In other words, it uses the relationship of similar data to increase the speed and versatility of the database. The "relational" part of the name comes into play because of mathmatical relations. A typical relational database has anywhere from 10 to more than 1, tables. Each table contains a column or columns that other tables can key on to gather information from that table.
By storing this information in another table, the database can create a single small table with the locations that can then be used for a variety of purposes by other tables in the database.
A typical large database, like the one a big Web site, such as Amazon would have, will contain hundreds or thousands of tables like this all used together to quickly find the exact information needed at any given time.
Relational databases are created using a special computer language, structured query language SQL , that is the standard for database interoperability. SQL is the foundation for all of the popular database applications available today, from Access to Oracle.
Sign up for our Newsletter! Mobile Newsletter banner close. Mobile Newsletter chat close. Mobile Newsletter chat dots. Mobile Newsletter chat avatar. Applications access data by specifying queries, which use operations such as project to identify attributes, select to identify tuples, and join to combine relations. Codd in Relational databases provide an environment from which data can be accessed or reassembled in a variety of different ways without needing to reorganize the database tables.
Each table has a unique identifier, or primary key, which identifies the information in the table, and each row contains a unique instance of data for the categories defined by the columns.
The logical connection between different tables can then be established with the use of foreign keys - a field in a table that connects to the primary key data of another table. Relational Database Management Systems often employ SQL or structured query language for gathering data for reports and for interactive queries.
The relational model of the relational database separates logical data structures from physical storage structures, enabling database administrators to manage physical data storage without affecting access to that data as a logical structure.
The distinction also applies to database operations -- logical operations allow an application to specify the content it needs, and physical operations determine how that data should be accessed, then carries out the task. The main advantage of a relational database is its formally described, tabular structure, from which data can be easily stored, categorized, queried, and filtered without needing to reorganize database tables.
Further benefits of relational databases include:.
0コメント