B5-Uses of databases in design offices

In my opinion, the most obvious character that the database is playing in office buildings is to control the energy system. The book, Energy Buildings is saying: “The resulting database and model are expected to provide the simple, direct decision-making process for helping estimate the energy-saving potential of some energy conservation measures to retrofit existing office buildings quickly.” For example, the picture below is showing a schematic outline of the research for developing an energy prediction model, which can quickly estimate the annual electricity use of office buildings. 

                                                

By the database, the energy treatment methods can be listed out. So how? The database can organize various results by a list of input variables. For example, for previously analyzing the natural light going through a glass curtain wall, the input can be the properties of the curtain wall, the building location characters and the time of the day, so the output can be the amount of energy going into the building, the serving area of the natural light and the efficiency of the wall. The engineers do not need to build the actual sample wall first and then go collecting the data for estimations. The database can serve for the building load and the HVAC system. By putting the data into the database, such as the building envelope, the building thermal mass, the system operations, the refrigeration and heat rejections and so on for the energy control, the tables can be created for each of them, and the tables can interact with each other.

For example, after input a thermal mass table, and a heat rejections table, we can do this in the database (Linux) to get what the thermal load should be in the office building A during the winter:

SQL> SELECT minimum thermal mass required in the office, the maximum heat rejections
1    FROM thermal mass, heat rejection
2    WHERE season= ‘winter’
3    AND building_name= ‘office A’;

Then the possible range for the thermal load will pump up as a result table. By the database, the using time of the energy systems can also be controlled. We can select the office closing time and the office opening time from the time table, and then the unoccupied period for every day through the week, the month, or the year will be listed out, so the heating or cooling systems can automatically switch on an off according to that unaccompanied period. From my Blog 1 (link), you can learn why the time control for the energy system is essential.

After the prediction designs based on the databases, the time and the money which will be used on estimating the energy system in the office building could be reduced, because the data will be organized and shared, so for the operation of the building or the other similar building, the same database can be referenced again for higher efficiency.

Works Cited:

Mao, Jiachen and Pan, Yiqun and Fu, Yangyang. Towards fast energy performance evaluation: A 

pilot study for office buildings; Energy Buildings. Volume 121, 2016, Pages 104-113, ISSN 0378-7788, https://doi.org/10.1016/j.enbuild.2016.03.077

Comments:
Yicheng Li
Yes, as you said, the SQL can help us to organize the large databases and it became the foundation of many nowadays' computer software. For SQL, the data input methods are various and simple enough to be understood, so it has already envolve in our daily life.

Tyler Madden
I totally agree with you that the smarter "relational" databases can improve the efficiency of production because the data tables are separated but they can interact with each other, and the users can use various data sets at the same time and come out with another table for showing the results. Besides Microsoft's SQL server, for the Mac system, the terminal is the SQL server.

Alec Silverstone
Agree. The data appear during the building design, and construction processes are very complex, and if there is not a database to organize those data, the mistakes and misunderstanding between the engineers and the constructors will occur frequently, and to find the reason of the error will be a suffer work. Therefore, the database is essential for construction.