हिंदी में देखें |

Technology

Relational Databases



RelationalDatabases


Contents :-

What is a Relational Database?


Databases have been a staple of business computing from the very beginning of the digital era. In fact, the relational database was born in 1970 when E.F. Codd, a researcher at IBM, wrote a paper outlining the process. Since then, relational databases have grown in popularity to become the standard.

Originally, databases were flat. This means that the information was stored in one long text file, called a tab delimited file. Each entry in the tab delimited file is separated by a special character, such as a vertical bar (|). Each entry contains multiple pieces of information (fields) about a particular object or person grouped together as a record. The text file makes it difficult to search for specific information or to create reports that include only certain fields from each record. Here's an example of the file created by a flat database:

Lname, FName, Age, Salary|Tiwari , Ravish, 32, Rs. 10000|Singh, Aman, 28, Rs. 12000|Vatsa, Vishwa, 41, Rs. 10000|Taylor, Tom, 22, Rs. 10000

You can see that you have to search sequentially through the entire file to gather related information, such as age or salary. A relational database allows you to easily find specific information. 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. Look at this example:

RelationalDatabases2

In the relational database example, you can quickly compare salaries and ages 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,000 tables. Each table contains a column or columns that other tables can key on to gather information from that table. Look at the table below that matches the number in the City column of the above table with the name of a city.

RelationalDatabases3

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.



.....Previous     Same     Next.....

Tags- Relational Databases | What is difference between relational and nonrelational database? | What does it mean for a database to be relational? | What are the different types of relational databases? | What is a relational database in Microsoft Access? | Is Mongodb a relational database? | What is relational and nonrelational database? | Is Hadoop relational? | Is Dynamodb relational? | Is Excel a relational database? | What is the difference between database and relational database? | Is sqlite a relational database? | Why are relational databases important? | What is a relational database used for? | What is relational model database? | How do you create a relational database? | What is Nosql DB? | What are the types of databases? | What is a primary key in a database? | What is relational database in SQL? | Is Oracle a relational database? | Is mysql a relational database? | What is a non relational database example? | Who would use a database? | What is a networked database? | What is cardinality in database? | What is database entity? | What is meant by relational database management system? | What is a DBMS? | What is primary key and foreign key? | What is tuple in database? | What is relational database management system with example? | What is tuple in SQL? | What is a relation in database? | What do you mean by relational database? | Is access a relational database? | What is operational data in DBMS? | What is difference between relational and nonrelational database? | Is Mongodb a relational database? | Are all databases relational?



UpImage
Home|Indian Doctors|Indian Hospitals|Utility|Career|Electronics|Family|General|Health|PC Tips|Technology|About Us|About Admin|Feedback|Apply For Job Computer Courses|Login| Created by - Er. Sanjay Singh