본문 바로가기

F2:사례 Example

데이터 모델링(Data Modelling)

반응형

주제(Subject)
--------------------------------------------------------
한글(약어) : 데이터 모델링()
영어(약어) : Data Modelling()

관련개념(Related Concepts)
--------------------------------------------------------
데이터베이스(database)
모델링(modelling)

개요(Summary)
--------------------------------------------------------
Data modeling, in other words it is said as "DB modeling" or "Modeling", deals technique to establish architecture of the database that contains business data.

Although there are various and many ways to draw business demands on the canvas (database), a modeler should find the best effective way, which is considered in the architectural, business centric, performance related, maintainable, and modifiable views. Therefore, this modeling activity requires highly developed skills. Modelers should deeply understand the main features of the conceptual, logical, and physical models. These three models have a close relation.

Nowadays many tools assist these modeling activities. Each tool has its own unique strength and weakness. Modelers and designers should pick the most suitable tool for their purpose.


 

본문(Body)
--------------------------------------------------------
1. Data modeling
If you want to find simple and widely accepted concepts of modeling, see Wikipedia article: Data Modeling (http://en.wikipedia.org/wiki/Data_modeling). This text introduces the origin of data modeling and shows many reputational frameworks to understand modeling easily.
The most common classification model (framework) of modeling is composed of three layers - conceptual, logical and physical. Above article says that this method is based on ANSI 1975. 

2. Conceptual modeling
This layer mainly deals entities and their relationships. The notations to make a data model are various. Barker's Notation is the most popular. This (UML as a Data Modeling Notation, Part 1[Ref.3]) shows simple model and explains important concept of the notation. Most UML modeling tools support these types of data modeling diagrams.

3. Logical modeling
In this layer, modelers mainly find out appropriate attributes and keys for their models.

4. Physical modeling
In this layer, modeler should find out the optimized tablespace options and storage increment parameters.

5. Tools for modeling
The most popular tool is ER-Win of CA (Computer Associates) and Power Designer of Sybase. These tools are usually called as ER (entity and relationship) diagramming tools. You can find out many useful commercial and non-commercial (free) tools from this Wikipedia article’s link (http://en.wikipedia.org/wiki/Entity-relationship_model).




모임,단체(Commutities)
--------------------------------------------------------


블로그,개인 홈페이지 등(Humanities)
--------------------------------------------------------


참고문서(References)
--------------------------------------------------------
* 한국어(Korean)
저자. 역자. "제목". 출판사. 출판년도. (ISBN:)

* 영어(English)
저자. 제목, 판, 출판사. 출판년도. (ISBN:)
1. Wikipedia : Data Modeling
   http://en.wikipedia.org/wiki/Data_modeling

2. infogoal.com : Data Modeling Resource Center
   http://infogoal.com/dmc/dmcdmd.htm

3. UML as a Data Modeling Notation, Part 1
   Two Modeling Worlds
   by Michael J. Lynott, David C. Hay
   Published: September 3, 2008
   http://www.tdan.com/view-special-features/8457

반응형