• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.19 no.37
• /
• pp.251-261
• /
• 1996

Databases are critical to business information systems and RDBMS is most widely used for the database system. Normalization was designed to control various anomalies(insert, update, and delete anomalies). However normalized database design does not account for the tradeoffs necessary for the performance reason. In this research, we model a database design problem without storage constraint. Given a normalized database design, in this model, we do the denormalization of duplicating columns in order in reduce frequent join processes. In this paper, we consider insert, update, delete, and storage cost, and the anomalies are treated by additional disk I/O cost necessary for each insert, update transaction. We propose a branch and bound method, and show considerable cost reduction.

• Journal of architectural history
• /
• v.5 no.2 s.10
• /
• pp.83-95
• /
• 1996

Computerized visual database construction of architectural precedents has just begun in some research institutes in the world. In Korea the first visual database has shown its testl version by S architectural design firm in september 1996. In this article the author discusses the historical contexts and the recent computerization cases, the traits, the uses and the limits of architectural visual database system of precedents. The forms and contents of data fields in two cases are compared with a focus on the description of architectural traits of each data entry. Compared to the KIA format, the S database has better performance for architectural design reference because it collects more pictures and drawings and larger texts for the field of architectural chracteristics. But this latter also is constrained by its capacity of memory and so lacks the reciprocity of the DOORS in the Graduate School of Design, Harvard University. A visual database system which has more flexible allocation of memory and respondent with the users is yet to be prepared. But this system also should be maintained by some experts in architectural history, theory and criticism, because their knowledge is essential for selection of precedents and revision of the data description. A full-fledged electronic visual database in architecture will not only save much effort for the architect, but also will change the architects' design behavior. Nevertheless this does not mean the automatic promotion of architects' creativity.

• Korean Institute of Interior Design Journal
• /
• no.31
• /
• pp.71-78
• /
• 2002

Understanding the consumer changed life styles are integrated, mutual complement for user's worth and consciousness, the life of consumption, etc. Recently, Apartment Model House has built for distribute to Apartment house When they enter the units after 2 or 3 years. So, Interior designer make an inference from the changed life styles. But, We don't have enough information to trace the design trend about residential space design. Design database is correspond with interior space and structured entity relationship. There are three parts in this Database, Type, Elements and Relation information. Type are composed size, ages, style, and space, Elements are materials and space elements. Relation information are publishing, designer, exhibition, construction company, remodeling, Intoner design and User favorite styles are the development in web environment. This research supplies interior design information for Web environment and trend analysis supports collaboration with development of interior design information database.

• Korean Management Science Review
• /
• v.11 no.3
• /
• pp.87-102
• /
• 1994

Conceptual database design is an important activity because the performance of a DBMS heavily depends on the proper design of the database, and view integration is one of the most important phases of conceptual database design. During this phase, the individual views designed by separate user groups are integrated into a global view for the entire system. After the view integration, a database schema must be validated before it becomes a stable product of the design. In this paper, a methodology for view integration an validation is suggested. The individual views are modeled by entity-relationship model. The entities are integrated according to their name and domain information. After that, the relationships are merged by their constraints. We also present a methodology for checking redundant relationships which has an algorithmic description.

• The Transactions of the Korea Information Processing Society
• /
• v.3 no.4
• /
• pp.745-756
• /
• 1996

In this paper, the design and implementation of VODS is described. VODS is an object-oriented database de-sign support system. VODS supports the whole database design steps according to the EOMT(extended OMT). EOMT as an object- oriented database design methodology is deviced by extending the object model of OMT(Object Modeling Technique) for supporting information navigations to manipulate hyperemia objects. Database designers can do the whole design steps by clicking mouse buttons on the appropriate icons or commands from the initial screen mode.

• Journal of the Korean Institute of Illuminating and Electrical Installation Engineers
• /
• v.16 no.3
• /
• pp.1-6
• /
• 2002

The purpose of this study was to develop an exterior lighting design database system for building lighting design. This database system has been designed to work internet web service as a design tool for architect and architecture student who are not profession of lighting design. In this study, exterior lighting database system has been accumulated with rendering image of each building from and lighting projector placement.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1998.10a
• /
• pp.342-351
• /
• 1998

The purpose of this study is to develop a central database and a database management system to store and manage information systematically from each module of an integrated structural design system. In order to efficiently express structural design process related to the data which is very complex, we used an object-oriented modeling methodology to propose the possibility to apply a database schema for application programs in an integrated system for reinforced concrete structural design. Based on this model, we developed an interface between each module and central database. After modeled by using object modeling technique, the database was mapped by the relational database table. Then the central database and the interface were programed by using Visual C/syo ++/, a windows environmental development tool.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.2 no.2
• /
• pp.95-99
• /
• 2001

We can embody a variable size of high classic industrial material. and jewelry design within 5 hours. using a rapid prototype 3D CAD, which includes 30 kinds of database selected by jewelry designers. If the jewelry can be investigated and the customer can modify it right away ; then the qualify of the jewelry is much better. Based on our investigation. we can reduce 30$\%$ of the development cost by using a standard database. We can also create a new design with complex design element in the database. Therefore, we may reduce the production time to less than 5 hours by using a Powerful technique system rather than producing hand-made jewelry, which can take more than 27 hours.

• Journal of the Korean Society for Aeronautical & Space Sciences
• /
• v.31 no.5
• /
• pp.25-36
• /
• 2003

Aircraft design pursues integrated design efforts by considering all design elements together. In the integrated design environment, it is crucial for the design data to be consistent, free of errorm, and most recent. Database design process consists of the analysis of the data which shall be stored and managed, the construction of the E-R Diagram, and the mapping of the database table. As a DBMS (DataBase Management System), Oracle 8i is employed to design and construct the database. The database design methodology is devised to apply for the several MDO(Multidisciplinary Design Optimization) techniques like MDF(MultiDisplinary Feasible), IDF(Individual Discipline Feasible), and CO(Collaborative Optimization). The defined process is demonstrated through a couple of design examples, including a simple numerical example and a UCAV(Unmanned Combat Aerial Vehicle) design optimization.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1999.10a
• /
• pp.444-451
• /
• 1999

The purpose of this study is to Propose data models for central database in integrated system for structural design building. In order to efficiently express data related to structure, I analyzed the structure design process and classified data considering design step. 1 used an object-oriented modeling methodology for logical data model and relational modeling for physical data model. Based on this model, we will develop an integration system with several applications for structure design. Each application will communicate through the central database.