How is a relational database system different from other databases?

Answer

To put it simpley there are two types of data systems. One is relational and the other is flatfile. The flatfile is pretty simple: ALL queries and data processing is done within one file. Its one record or thousands of records that your data (in one file) that your arguments will be assigned to and your results will (if successful) will appear.

The relational data system is not limited to one file or even thousands of files (program permitting) that can be searched threw. Example: lets say you are looking for a persons name. On one file you have a dataset of Short order cooks that work for diners. Lets say his name is Bob Snow. Another file has a dataset of diners and restaurants that are for sale. If you search for the keyword "Bob Snow" you should have two "Hits" that contain "Bob Snow" which would show you that Bob is a cook and also has a place for sale. They could be one and the same place to eat or they could be different.maybe he works on one but owns another...you must investigate to see if there is a connection if any. Now we only searched thru two datasets...we can have it search for a lot more..takes time but it can. Its all a matter of how many you wanna seach and whats available for the data search engine is to seek for.

The bottom line is that a relational database is a heck of lot more intense and that it will pull up all kinds of data if your argument to find that data is input correctly.

Improve Answer Discuss the question "How is a relational database system different from other databases?" Watch Question

First answer by ID3394826924. Last edit by ID1199805963. Question popularity: 51 [recommend question]


Research your answer:

Answers.com > Wiki Answers > Categories > Technology > Computers > How is a relational database system different from other databases?

Our contributors said this page should be displayed for the questions below. (Where do these come from)
If any of these are not a genuine rephrasing of the question, please help out and edit these alternates.
What are relational databases?  Disadvantage relational database?  Advantages of relational databases?  What are non relational data bases?  What is meant by relational database?  Advantages of using relational databases?  Advantages of relational database system?  Object orientedobject relational databases?  Disadvantages of relational database system?  What are the features of a relational database?  Why have relational databases dominated in GIS?  Types of relational database management system?  What are the disadvantages of realtional databases?  Diffrance between relational and non relational system?  What is difference of database and relational database?  What is the difference between databases and relational?  What way is the relational model of database systems restrictive?  Object-oriented databases and relational databases what is the difference?  Difference between relational and object oriented database management system?  What are the differences between a Relational Database Management System and a Database Management System?