Showing posts with label A. Show all posts
Showing posts with label A. Show all posts

Tuesday, February 13, 2018

Week 6: Blog Post 5 - Relational Database Theory

Relational Database Theory


Definition

A relational database (RDB) is defined as a collection of multiple data sets stored and organized as items in a set of formally described tables (rows & columns). This data can be accessed or reassembled in any customizable way at a later point in time. This neat piece of creation was invented by Edgar F. Codd at IBM 1970 [1]. RDB runs on Structured Query Language (SQL), an application that provides a user-friendly programming interface for database interaction. [2] 


Types of RDBs
In an RDB, data is stored in a tabular format with rows and columns. A row represents a data instance and a column represents a column. One or more data that is stored relates to one or more data records to form functional dependencies. There are four types of dependencies:


  • One to One: One table record relates to another record in another table.
  • One to Many: One table record relates to many records in another table.
  • Many to One: More than one table record relates to another table record.

  • Many to Many: More than one table record relates to more than one record in another table. [2]
Function

The main capabilities of an RDB is its ability to communicate and relate one data instance stored in any row, any column, any table and any data set to another data instance in a likewise manner. The basic database operations are select, project and join. "Select" retrieves data, "project" identifies data characteristics and "join" combines relations of data instances.[2]

Other advantages include scalability and data security. It is basically a useful tool similar to Microsoft Excel, except instead of having computational power, it only stores data but can be store an enormous amount of data/information. Data security capabilities provide certain users access to all datasets while giving the option of preventing some users to access only certain databases. 

[1] http://searchsqlserver.techtarget.com/definition/relational-database

[2] https://www.techopedia.com/definition/1234/relational-database-rdb


Comments:

Mark:

I read your article as a way to compare the content we found since we have the same topic. Essentially, we cover the same content such as keywords in the definition of a database, the importance of relations. Great job on including the figures as it highlights and exemplifies the difference between tables with relations and one without.

Tyler:

My blog post covered the topic of Relational Database Theory which is basically the body of data storing. But while reading I saw that SQL is the main "language" used when talking to these databases we created. And your article reinforced my initially understanding of what SQL does. The highlight of your article to me is that SQL is still used as the main language used to talk to databases which I would assume technology nowadays would have probably have replaced it. But I like your idea (more so a statement) that SQL is and should co-evolve with databases and its various types. Not just simple inventory tables but complex large scale data such as AutoCAD and Revit related data per family created.


Chris:

I agree that time is money and money is time in the world of construction. this DSM sounds like a pretty neat piece of technology that could potentially revolutionize future construction work. Hours vs Months is quite a feat to achieve but what I would be worried is the socio and economical problems that will arise when "machines start stealing human's jobs".



Monday, January 29, 2018

Future Problems with Revit/BIM

Week 4: What are the possible future problems with Revit/BIM?

Some problems that BIM could face in the future include technology becoming too advanced or too simplified. Although a certain amount of user friendly aspects need to be maintained, it would significantly decrease the usability for authorized construction aspects of the program if it were to be made too simple. Along with that, there exist other similar programs which could be described as simpler versions of Revit, such as SketchUp that may be accessed by less advanced users.

In examination of BIM/Revit becoming too advanced too quickly could cause it to be too difficult to learn and not adopted as widely. However, BIM has a sort of monopoly on the construction fields since it is one of the most compatible methods of tying projects together completely. This would deem it very difficult to update, and looking at its history would prove that quick updates or advancement of the program are not the aim of Autodesk corporations. If it were to become too complicated, then all of the older generations within correlated work fields would be unable to perform as well in their jobs. This could lead to greater expenditures in training and other related matters which over time could add up significantly.

Other costs besides those that would have to be invested into necessary training implementations would be due to the program directly. Files containing a large amount of information such as structural and architectural details tend to be quite heavy. If these programs are going to get more detailed, then the files will get even heavier and this will require higher resolution viewing methods along with higher storage systems and rule out people/companies who don’t have the most updated software available for access. 


Comments: 

Mark - I very much agree with your outlook on BIM dependence factor. I never saw this as a downfall but now I can see clearly how too much trust in these types of software could likely get us into trouble. Perhaps even though hand drafting is very much a thing of the past, we should still try to incorporate it into a few college classes or internships so that our generation of engineers has a deeper understanding of methods and design. This could be helpful in aiding us in coming up with better ways to use BIM and get us accustomed to double checking everything in our computerized models instead of trusting them outright.

Cody – I like how you mentioned simple time cutting tasks that BIM can offer as advantages to its users through the use of added commands and coding. Also, I never knew that BIM incorporated energy analysis software. That is quite interesting and must be one of the smaller updates that they keep improving slowly over the years that you had mentioned. While I do agree that it is important for Autodesk to keep listening to its clients, I do believe that it is also important for them to concentrate on listening to the current client base for the best possible improvements to be made.


Lauren – Your post mostly goes to show that even though AutoCAD is a very useful tool, BIM is slightly better with its automated generation of things. For example, in different views such as an elevation, will be automatically created when a user has only created something such as a plan view. I have never heard of MicroStation, but I should look more into it. I do agree that on the surface Revit seems quite simple and easy to follow but mastering it takes a great level of dedication and time. I like how you point out that only so much can be perfected when it comes to AutoCAD and similar programs and therefore it is easier to manage unlike Revit software as one delves deeper into its intricacies.  

Saturday, January 20, 2018

Odorizzi - B2 BIM Handbook: Chapter 2 Parametric Modeling

The portion of the BIM handbook that was delegated to Group A was Chapter 2, titled “BIM Design Tools and Parametric Modeling.” I must confess that I did not find the 66-page-long chapter the most compelling of passages that I have had the pleasure of reading. I am going to attempt to pick out only the good parts to talk about, while giving a complete overview of the content in the chapter.

The focus of Chapter 2 is to bridge the gap from the 2-dimensional, autocad / hand drawing design experiences to the potential of designing with BIM using object-based parametric modeling. A major point that Chapter 2 drives home is that the “objects” being modeled are not represented with fixed geometry and properties, but are governed by parameters and rules such that the object has a behavior. These parameters and rules allow the object to update itself based on the context/connectivity of the object. For example, if the column layout of a building changes to increase the spacing between gridlines, moving the gridline will in turn cause the floor, walls, roof, etc to all move and adjust as well. Hence, BIM builds a series of parametric objects that relate each object to its surroundings, and also builds a database of properties to control the objects themselves. I typically find this idea to make the most sense when comparing to AutoCad - in AutoCad you draw lines, but in Revit (BIM), the lines that are drawn are representing an object with 3-dimensional properties.

Chapter 2 goes through the development of object-based modeling. I found the history rather boring. Major research on modeling 3D geometry started in 1960, and developed into a pairing of two 3D modeling techniques: Boundary representation (which stored modeling operations and arguments with the object) and Constructive Solid Geometry (CGS: which used algebraic formulas). Manufacturing and aerospace disciplines were the first to jump on board with these techniques. For example, Boeing spent over $1 billion when developing the parametrics for the 777 family of planes. The modeling process was estimated to save Boeing over 6000 change requests and reduce the spatial rework of the models by 90%.

The common thread with modeling in BIM is libraries of families, or more generically - libraries of objects. For example, Revit comes with families for walls, floors, beams, etc - and additional families can be downloaded from vendors online. Most importantly, specific families can be crafted by the user for specific instances in a project. These families store parameters that allow the user to gradually build a very complex model that holds very complete information. However, a common shortcoming of BIM is the size of model files (often multi-gigabyte), which can render the model impractical to use if the specs of the computer are surpassed.

The chapter proceeds to go through major BIM platforms available for use, including Revit, Bentley systems, ArchiCad, Digital Project, Vectorworks, Tekla Strutures, DProfiler, etc. Some of these platforms can be used for design only, others offer fabrication-level modeling. Typically, the common trend was that a more detailed model had a more complicated user interface and larger files sizes - such that the pros were “you can build a complete model” and the cons were “but there is a huge learning curve and it might surpass your computer’s capacity.”

A closing line in the chapter stated that the full potential of BIM will not be realized for at least another decade. Seeing that the handbook was written in 2004, we have passed a decade since the text’s writing. I know from experience that structural engineers are generally in favor of using Revit, or reserved about the process. I believe that it will be our generation of engineers that fully embrace the potential of Revit and BIM as we enter the industry, but I do not expect applications such as AutoCad to fall completely to the wayside. I have used Revit at Keast & Hood for the production of construction drawings very rapidly after carefully modeling the building first; or for exact coordination between MEP and structural Revit models; or for unusual designs to come into fruition after crafting a new family. I have also experienced the shortcomings of Revit with very slow user interfaces with big files, and I personally find detailing much easier in AutoCad than I do in Revit. However, to the point of the chapter, BIM undeniably has more power in its modeling capability and is a remarkable tool for storing and organizing vast quantities of information pertaining to each building object.

Source: C.M. Eastman.  “Chapter 2: BIM Tools and Parametric Modeling.”  BIM Handbook: A Guide to Building Information Modeling for Owners, Managers, Designers, Engineers, and Contractors.  2nd Edition., Hoboken, NJ: Wiley, 2012.  pp. 31-97

Comments:
To Dee Dee Strohl
I’ve had experience in Revit similarly to what Cody described above in his comment - on the structural side, relying on RAM for sizing, etc. Were you working simultaneously with architects out-of-house in the central model? That sounds remarkable! In the structural consulting firms I have worked at, we would always get an updated Revit model from the architect that we would link into our structural model, then we would have the worksharing you described with multiple engineers in-house working on the model simultaneously. We were never working on the same central model as the other disciplines, though. That sounds very efficient! Similarly for the contractors, I have never had exposure to allowing the contractor see the model while it is in progress. To me - that sounds like a negative aspect to collaboration, because I have experienced major changes happen to the model close to the deadline for CD’s. It would be counterproductive for a contractor to progress based on a model that is incomplete or susceptible to major changes.

To Jordan Shuster
One of the little stories that was included in Chapter 2 was about Boeing - and it rings true when you are discussing efficiency on a project through BIM. The handbook discussed how Boeing invested over $1 billion in BIM investments, modeling, etc for its 777 aircraft families, and it ultimately yielded 6000+ less change requests and a 90% decrease in spatial reworking when design was finished. I think your points about BIM bridging language barriers are very interesting. I find it on the same train of thought as the common expression, “math is the universal language,” but with pretty 3D pictures. However, one could argue that this benefit of bridging the language barrier is not new - it is essentially the same as scanning hand sketches and emailing them out. BIM is simply more refined and tech-forward, but they both rely on conveying ideas through graphics.

To Sherry Liu

I have only ever been on the design-bid-build process for projects over co-op. I think it is very interesting to think about the advantages a BIM platform serves for a design-build firm. I generally am reserved about involving the contractor in pre-construction phases of the model. I worked for a structural design firm for both of  my co-ops, and there was one instance where a contractor requested to see the 95% CD progress set of our drawings - from which he took the liberty to have his steel subcontractor develop the shops for all the column base plates. However - between 95% CDs and 100% CDs, the architect made some alterations that significantly changed the loading through the structure and changed all of the base plate sizes. My point is that the exchange of information with ALL affiliated parties throughout the entire design process can have its drawbacks as well. In my little story, the contractor wasted time and money to develop a wave of base plate shop drawings from incomplete drawings. Regardless, I believe the industry is learning and gaining efficiency with the use of BIM, and as our generation of engineers enters the work force, I think it will only continue to become more prevalent.

Tuesday, January 16, 2018

Intelligent Buildings Definition

Intelligent Buildings Definition

Professor Mitchell's: 

"Intelligence" requires the use of adaptive computer technology.
¨Intelligence" may exist in any system or phase of the building process.
We may thus talk of
Intelligent Building Industry
Intelligent Building Design
Intelligent Building Construction (including renovation)
Intelligent Building Operation
We may also subdivide by systems – structure, HVAC etc.


Mine:

An "Intelligent Building" is one that maintains efficiency and connection as well as the flexibility to improve on the original design within an evolving community. 

This does not only have to do with the immediate technology that is expected to be used by individuals within the finished structure every day but starts at the very beginning phases of design and construction as well.