PostgreSQL
ÃÑ ÆäÀÌÁö ¼ö : 3224

Àüü ÇÔ¼ö/¿ë¾î»çÀü
Facebook Joinc ±×·ì   Joinc QA »çÀÌÆ®



joinc´Â Firefox¿Í chrome¿¡¼­ Å×½ºÆ® Çß½À´Ï´Ù. IE¿¡¼­´Â Å×À̺íÀÌ ±úÁö°Å³ª À̹ÌÁö°¡ º¸ÀÌÁö ¾ÊÀ» ¼ö ÀÖ½À´Ï´Ù. ƯÈ÷ ±¸±Û DocsÀ̹ÌÁöÀÇ °æ¿ì ¿¢¹Úó¸®µÉ ¼ö ÀÖ½À´Ï´Ù.

PostgreSQL

PostgreSQLÀº BSD ¶óÀ̼¾½º¸¦ µû¸£´Â Object-Relational database management system (ORDBMS)ÀÌ´Ù. ͏®Æ÷´Ï¾Æ ¹öŬ¸®´ëÇÐÀÇ ÄÄÇ»ÅÍ °úÇкο¡¼­ °³¹ßÇÑ POSTGRES 4.2¿¡ ±â¹ÝÀ» µÎ°í ÀÖ´Ù. POSTGRES´Â ¸¹Àº Áøº¸µÈ ±â´ÉµéÀ» °¡Áö°í ÀÖ¾ú´Âµ¥, ¸î¸î ±â¼úµéÀº ÈÄ¿¡ ´Ù¸¥ »ó¿ë µ¥ÀÌÅͺ£À̽º¿¡¼­ »ç¿ëµÇ±âµµ ÇÑ´Ù.

PostgreSQLÀº ´ÙÀ½°ú °°Àº SQL92¿Í SQL99¸¦ Áö¿øÇϸç, ´ÙÀ½°ú °°Àº (Çö´ëÀÇ ´ëºÎºÐÀÇ RDBMS(12)°¡ Á¦°øÇÏ´Â)±â´ÉµéÀ» Á¦°øÇÑ´Ù.
  1. º¹ÀâÇÑ Äõ¸®
  2. ¿Ü·¡ Ű
  3. Æ®¸®°Å
  4. ºä
  5. Æ®·£Àè¼Ç
  6. multiversion concurrency control

À§ÀÇ ±âº»ÀûÀÎ ±â´É¿Ü¿¡µµ ¾Æ·¡¿Í °°Àº È®ÀåµÈ ±â´Éµéµµ Á¦°øÇÑ´Ù.
  1. ´Ù¾çÇÑ µ¥ÀÌÅÍ Å¸ÀÔ
  2. ÇÔ¼ö(functions)
  3. operators
  4. ÁýÇÕ°ü·Ã ÇÔ¼ö
  5. index methods
  6. rocedural language

PostgreSQLÀº ÀÌ¿ë°ú, ¼öÁ¤, ¹èÆ÷¿¡ À־ ±×°Ô °³ÀÎÀûÀÎ ¸ñÀûÀÌ°Ç »ó¿ëÀÌ°Ç ÇнÀÀ̰ǰ£¿¡ Á¦ÇÑÀ» µÎÁö ¾Ê´Â´Ù.
EmailÀ» ±âÀÔÇϸé, ´ñ±ÛÀÌ ¸ÞÀÏ·Î Àü´ÞµË´Ï´Ù.