HOME / ¹®¼°øÀ¯ / ¸®Æ÷Æ®/³í¹® / ±â¼ú°øÇÐ
0
0°ÇÀÇ Èı⺸±âÀι®Á¤º¸ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ±â¼úÇÑ ¸®Æ÷Æ® Âü°íÀÚ·áÀÔ´Ï´Ù.
Àι®Á¤º¸ µ¥ÀÌÅͺ£À̽º [¿ä¾à]
1.µ¥ÀÌÅͺ£À̽º
1.µ¥ÀÌÅͺ£À̽º
Àι®Á¤º¸ µ¥ÀÌÅͺ£À̽º [¿ä¾à]
µ¥ÀÌÅͺ£À̽º(database)¶õ?
´Ù¼öÀÇ ÀÀ¿ë ½Ã½ºÅÛµéÀÌ»ç¿ëÇϱâ À§ÇØ Ã¼°èÀûÀ¸·Î Æí ¼º, ÀúÀåµÈ µ¥ÀÌÅÍÀÇ ÁýÇÕ
an organized collection of information records that
can be accessed electronically.
a collection of data organized so that various programs can access and update the information.
1.µ¥ÀÌÅͺ£À̽º
Àι®Á¤º¸ µ¥ÀÌÅͺ£À̽º [¿ä¾à] µ¥ÀÌÅͺ£À̽º ±¸ÃàÀÇ ¸ñÀû µ¥ÀÌÅÍ °ü¸®ÀÇ Æí¸®¼º µ¥ÀÌÅÍ ¹«°á¼º À¯Áö µ¥ÀÌÅÍÀÇ ¹°¸®Àû & ³í¸®Àû µ¶¸³¼º À¯Áö µ¥ÀÌÅÍ Áߺ¹ÀÇ ÃÖ¼ÒÈ µ¥ÀÌÅÍÀÇ °øÀ¯ ´Ù¾çÇÑ Á¢±Ù ¹æ¹ý Á¦°ø µ¥ÀÌÅÍ º¸¾È
1.µ¥ÀÌÅͺ£À̽º
Àι®Á¤º¸ µ¥ÀÌÅͺ£À̽º [¿ä¾à] ½ºÅ°¸¶(schema) ½ºÅ°¸¶: µ¥ÀÌÅͺ£À̽ºÀÇ ³í¸®Àû Á¤ÀÇ
1.µ¥ÀÌÅͺ£À̽º
¸±·¹À̼Ç(relation)
Çà(row)°ú ¿(column)·Î ÀÌ·ç¾îÁø 2Â÷¿ø Å×À̺í(table) Æ©ÇõéÀÇ ÁýÇÕ
¹øÈ£ À̸§ »ý³â ¸ô³â º»°ü 102 ¿ø±Õ 1540 1597 ¿øÁÖ¿ø¾¾ 103 À̼ø½Å 1545 1598 ´ö¼öÀ̾¾ 104 Çã±Õ 1569 1618 ¾çõÇã¾¾ 105 ÀÓ¼ºÁÖ 1711 1788 dzõÀÓ¾¾ ¾ÖÆ®¸®ºäÆ®(attribute) ¸±·¹À̼ÇÀÇ ¿(column) ¿£Æ¼Æ¼(entity)°¡ º¸À¯Çϴ Ư¼º Ç¥Çö field Æ©ÇÃ(tuple) ¸±·¹À̼ÇÀÇ Çà(row) record, entity Àι®Á¤º¸ µ¥ÀÌÅͺ£À̽º [¿ä¾à] µ¥ÀÌÅͺ£À̽º °ü¸® ½Ã½ºÅÛ(dbms) dbms: database management system
ÀÌ¿ëÀÚ(ÀÀ¿ë ÇÁ·Î±×·¥)°ú µ¥ÀÌÅÍÀÇ ÁßÀçÀڷμ ¸ðµç ÀÀ¿ë ÇÁ·Î±×·¥µéÀÌ µ¥ÀÌÅͺ£À̽º¿¡ Á¢±ÙÇÏ¿© °øµ¿À¸·Î È°¿ëÇÒ ¼ö ÀÖ°Ô²û °ü¸®ÇØ ÁÖ´Â ¼ÒÇÁÆ®¿þ¾î
µ¥ÀÌÅͺ£À̽ºÀÇ Æí¸®ÇÏ°í È¿À²ÀûÀÎ °Ë»ö, ÀúÀåÀ» À§ÇÑ È¯
°æ Á¦°ø
1.µ¥ÀÌÅͺ£À̽º
Àι®Á¤º¸ µ¥ÀÌÅͺ£À̽º [¿ä¾à]
2.sql
2.sql
Àι®Á¤º¸ µ¥ÀÌÅͺ£À̽º [¿ä¾à] sql(structured query language)
µ¥ÀÌÅͺ£À̽ºÀÇ °Ë»ö°ú Á¶ÀÛÀ» ½±°í ºü¸£°Ô Çϱâ À§ÇØ °³¹ßµÈ µ¥ÀÌÅͺ£À̽º ¾ð¾î
1970³â´ë ÃÊ¹Ý ibm»çÀÇ °ü°èÇü µ¥ÀÌÅͺ£À̽º ÁúÀǾî·Î °³¹ß
1973 sqare: structured queries as relational expressions
1974 sequel: structured english as query language
1976 sql: structured query language (ÀÌÇÏ »ý·«)
¹ÞÀº º°Á¡
0/5
0°³ÀÇ º°Á¡
¹®¼°øÀ¯ ÀڷḦ µî·ÏÇØ ÁÖ¼¼¿ä.
¹®¼°øÀ¯ Æ÷ÀÎÆ®¿Í Çö±ÝÀ» µå¸³´Ï´Ù.
Æ÷ÀÎÆ® : ÀÚ·á 1°Ç´ç ÃÖ´ë 5,000P Áö±Þ
Çö±Ý : ÀÚ·á 1°Ç´ç ÃÖ´ë 2,000¿ø Áö±Þ