Rational
databases are relationships between data which is represented in tables. It is
a way to structure and organize data. This theory was developed by E.F Codd in
1970 and have been used since then to manage databases. A table characterizes one entity type where
the rows represent each types and the columns represent the value for the type.
The row has its own unique key which is called a primary key. By linking the
key with other keys from other tables it is possible for the data to be related
with other types. This creates a relationship between other tables and creates
specific data. It could be a useful information in a building project where you
would like to get information about e.g. the different door which are used in different
rooms. A table would then describe the doors with an ID number, name of the door,
and material. An other table would describe the rooms in the building also with
an ID number, name of the room and size of the room. Each table could have information about all
the doors in the project where many of them has the same name and material but
the ID is the unique key. The same is for the rooms where the ID for the room is
the unique key. A new table with only the ID numbers of the doors and the rooms
can then show the connection between the doors and the rooms. It can then tell
how many of a specific door is in a specific room.
https://www.youtube.com/watch?v=NvrpuBAMddw
https://aws.amazon.com/relational-database/
https://en.wikipedia.org/wiki/Relational_database
Blas Andres
Rodriguez Vieira: Your post made it easy for my to understand what SLQ is and
why it is important. It is interesting how you in the end of your post describes
how important it is for almost all business to be able to understand the language
of the databases because almost very thing becomes digital and we therefore
store more and more data.
Tyler
Madden: Interesting how the databases can be used in the construction business to
improve effectivity and thereby save more. In the company where I work we sometime
makes databases of tables when we are doing inspections of a lot of buildings
where we have a specific ID for each building and then we can put in data for
the roof, walls, foundation etc. It is a very easy way to get collect all the information
we have for each building. And a easy way to get the information further to the
owner of the building to tell them how the conditions is of all the e.gs roofs
at all the buildings.
Weiyi Tang:
Well described how the data in the design phase. It made think of how the
simulation programs for energy and indoor climate actually works with the
different input data we use.
Julie, you’re explanation of relational database theory is much more condensed than mine, and I think you did a much better job of explaining it haha. The image that you inserted in your blog post helps to understand the theory significantly, and I appreciate it. I think the effects that this will have on the computing industry will significantly help the construction industry as computers become more powerful. 15 Years ago, we used floppy disks with about 200 megabytes of memory, and that was all that was needed. Today, we are looking at files that are 5 gigabytes. 15 Years from now, we will probably be looking at 250 gigabyte files, which is the size of a single hard drive in computers today. These developments in computing power are important and necessary to continue growing society.
ReplyDeleteI think you had a hard topic to talk about. Relational databases are complex and can have very useful applications. I think this might also be able to be applied to the phasing of a building and help with scheduling, but I may not be understanding the concept as a whole yet. But overall good breakdown of the topic.
ReplyDelete