Tuesday, February 10, 2015

B5 - Group A--Kaili Yue--Relational Database Theory

Database is basically a collection of information organized. A relational database is digital database whose organization is based on the relational model of data. From 1970 relational database organizes data into one or more tables of rows and columns. The rows of the table are stand for instance. The columns of the table are stand for the attribute values describing each instance.

Each database is a collection of related tables. The traditional database is organized by fields, records, and files. Each field is a single piece of information; a record is one complete set of fields. A file is a collection of records.
The theory of relational database is built upon the mathematical theory of sets. In mathematics, a set is one of the most general ways of considering more than one object at once. A substantial amount of theory has been built up to describe this.
Database is one of the most important elements of internet. All the information which we search online is from database. The database makes our life easily. Before 1970, the database is just like a messy storeroom. In this storeroom has everything, but the problem is so hard to find the one without knowing it. In 1970, Edgar F. Codd published a paper showed how information stored in large database could be accessed without knowing how the information was structured or where it resided in the database. That means users don`t have to know the information specialized. A few key words will find the information that you want. In 1983, IBM produced the DB2 family of relational database. DB2 database handle so many transactions everyday until today. Arvind Krishna, general manager of IBM information management, DB2 continues to be a leader in innovative relational database software.
Now, relational database theory is used in our daily life. The key words are more flexible and easier. Shopping online, Google, Email and making travel reservations are all about relational database theory.



Comments:
To  J Schwakoff: lots of examples about database. After I read your article I have a general idea about the database. Very helpful!

To   Mikeala Price:  You did very complete research about SQL. Structured Query Language is a basic computer language to create database.

To   Santiago Uribe: I like your way to make a couple of assumptions before to read and do the research. Gave me lots of new ideas. Good Job!



References:
Webopedia. N.p., n.d. Web. 10 Feb. 2015. 
<http://www.webopedia.com/TERM/D/database.html>.

wikibooks. N.p., n.d. Web. 10 Feb. 2015. <http://en.wikibooks.org/wiki/Relational_Database_Design/Basic_Concepts>.

Icons of Progress. N.p., n.d. Web. 10 Feb. 2015. <http://www-03.ibm.com/ibm/history/ibm100/us/en/icons/reldb/>.

1 comment:

  1. I enjoyed you providing examples how how databases are used in our daily lives! Google does an excellent job of creating databases based on "search" keywords and have built their empire on this system. It is certainly a feat deserving ofwhen you can search any word and in Google and it has results in a fraction of a second. If you search the keyword "SQL" in Google you get: "About 292,000,000 results (0.35 seconds)". It would be interesting to see how big their server-rooms are.

    ReplyDelete