µ¥ÀÌÅÍ ¸ðÇü(Data model)
- µ¥ÀÌÅ͸¦ Á¤ÀÇÇÏ°í µ¥ÀÌÅÍµé °£ÀÇ °ü°è¸¦ ±ÔÁ¤ÇÏ¸ç µ¥ÀÌÅÍÀÇ ÀÇ¹Ì¿Í µ¥ÀÌÅÍ¿¡ °¡ÇØÁø
Á¦¾à Á¶°ÇÀ» ³ªÅ¸³»´Â °³³äÀûÀÎ µµ±¸
(1) °´Ã¼¿¡ ±Ù°ÅÇÑ ³í¸®Àû ¸ðµ¨
- µ¥ÀÌÅ͸¦ °³³äÀû ´Ü°è¿Í ºä ´Ü°è¿¡¼ ±â¼ú
- À¶Å뼺ÀÖ°Ô µ¥ÀÌÅ͸¦ ±¸Á¶È
- µ¥ÀÌÅÍ Á¦¾àÁ¶°ÇÀ» ºÐ¸íÈ÷ ÁöÁ¤
1) °³Ã¼°ü°è ¸ðµ¨(E-R : Entity-Relationship Model)
2) ÀÌÁø ¸ðµ¨(Binary Model)
3) ÀÇ¹Ì µ¥ÀÌÅÍ ¸ðµ¨(Semantic Data Model)
4) Á¤º¸³í¸® ¸ðµ¨(Information Logical Model)
(2) ·¹Äڵ忡 ±Ù°ÅÇÑ ³í¸®Àû ¸ðµ¨
- µ¥ÀÌÅ͸¦ °³³äÀû ´Ü°è¿Í ºä ´Ü°è¿¡¼ ±â¼úÇϴµ¥ ¾²ÀδÙ
- µ¥ÀÌÅͺ£À̽ºÀÇ ÀüüÀûÀÎ ³í¸®Àû ±¸Á¶¸¦ ÁöÁ¤Çϴµ¥ »ç¿ë
1) °èÃþ µ¥ÀÌÅÍ ¸ðÇü(hierarchical data model)
- Æ®¸®(tree) ÇüÅ·ΠǥÇöµÇ¸ç ·¹À̺íÀ» ±â¼úÇÒ ÇÊ¿ä°¡ ¾ø´Ù
- »çÀÌŬÀÌ ¾ø´Ù
2) ¸Á µ¥ÀÌÅÍ ¸ðÇü(network data model)
- ³×Æ®¿öÅ©, ±×·¡ÇÁ ÇüÅ·ΠǥÇö
- ½Ç ¼¼°è¿Í °¡Àå ±ÙÁ¢ÇÑ ÇüÅÂÀÇ ¸ðµ¨
- »çÀÌŬÀ» °¡Áü
3) °ü°è µ¥ÀÌÅÍ ¸ðÇü(¡¦(»ý·«)
1.1.7 µ¥ÀÌÅÍ º£À̽º ¾ð¾î
(1) µ¥ÀÌÅÍ Á¤ÀǾî(data definition language)
(2) µ¥ÀÌÅÍ Á¶ÀÛ¾î(data manipulation language)
¨ç ÀýÂ÷ DML : ÀϽÿ¡ 1°³ÀÇ ·¹Äڵ常 ó¸®, ÀÀ¿ë¿¡ »ðÀÔµÇ¾î »ç¿ë
¨è ºñÀýÂ÷ DML : ÀϽÿ¡ ´Ù¼ö ·¹ÄÚµå ó¸®, ´ëȽĻç¿ë - ÁúÀǾî
|