The assigned article from AccessScience provides more than just a basic overview of Database Management Systems (DBMS) and their use. The article defines much of the terminology associated with DBMS and the components of a computerized database, which is essentially, an accessible collection of related information/data. Special features of databases are also highlighted, such as the fact that information is stored that is relevant to a particular database user or users; every database is designed and built for a specific user or users and serves a specific purpose. The article describes the framework of how data is stored in a computer by providing a flowchart that details the relationships between different aspects of the data and computer system. It is also pointed out that the relational DBMS is currently the most popular use of DBMS. The relational database concept is detailed fairly well in this article, and does great justice to the rational it is founded upon, while also describing its logical structure. It is interesting to note that the relational model of DBMS is essentially based on proven mathematical theories. The following two articles focus on the applications of DBMS, and more specifically, the use of the relational model in building design and engineering.
As stated in the AccessScience article, this second article also points out that the relational database model is based on set theory and predicate logic of mathematics. The article also notes that the term relational does not refer to the relationship between tables in a database, but rather, the relations between sets of information. The various types of relationships (i.e. one-to-one, one-to-many, and many-to-many) are described in detail in this article. The integrity rules of working with databases, and relational models, in particular, are stressed in this article; these rules essentially aid in avoiding referencing missing data in a database. A simple database design is key to maximizing the usefulness of its overall framework. The level of detail provided in this article gives great insight for users to follow in creating a relational database. The intent of this article is to provide good information about relational database design and its application in Microsoft Access. The article does well to do that, by including relevant information, examples, and steps to help in successfully designing databases.
This article relates the use of relational databases to BIM interoperability. The article introduces the concept of BIM based design and collaboration between building designers and how it can be enhanced by the use of relational database management systems. The terminology in this article is straightforward and simple to follow; the article does not delve into details as the previous two articles; rather, it links together the practical uses of BIM and relational databases. When detailing their advantages, the author provides an overview which states how tables within a database can be linked to one another (and more than one table); the entire concept allows for data to be managed, accessible, and reorganized. Overall, this article provides a good general overview of the use and advantages of relational databases and hints at their use in a BIM workplace.
I think that the articles you read were really fine tuned to the topic. The one article I read discussed relational databases used generally in many professions such as inventory and accounting and the issues that everyone faces, but not specifically addresses BIM or BIM interoperability. Also, the second article you talk about, I took a brief look at, and it looks like another source that may be helpful for the database assignment using Microsoft Access.
ReplyDeleteIt's interesting to see how relational databases can contribute to BIM interoperability. The logic behind such a database must be well thought out or major errors could be brought into a project. Still, I see relational databases as solid way to solve BIM interoperability problems.
ReplyDeleteAs BIM expands in the AEC industry, I agree that relational databases will help increase interoperability. It is the most efficient way to manage the large quantities of data generated by BIM. I think it will be especially useful for facilities management to operate the building based on both old and new data.
ReplyDeleteSara, the articles you found are very informative and helpful. These articles is just another testament in a wide use of DBMS, whih is not always evident. During my search, I came across many articles, similar to those Michael read, where DBMS is used in gaming. DBMS has been used extensively in marketing, sales, banking, and most of other bussiness applications. Similar to Chris' comment, as BIM becomes dominant tool in AEC industry, DBMS will be just another every day tool we will use in our careers.
ReplyDelete