PostgreSQL 8.4.2 ��
이전	이전으로 건너뜀	�Ӹ��	다음으로 건너뜀	다음

PostgreSQL ��߸� ��

PostgreSQL�̶�� ü-�� ͺ��̽� �� ý�� Ķ��Ͼ�� Ŭ�� б�� POSTGRES�� ̸�� ó�� Ǿ��. �̰�� 20�� Ѱ� ��ߵǾ�, PostgreSQL�� ִ� �� ҽ� ��ͺ��̽�� ް� �ִ�.

��Ŭ�� POSTGRES ��Ʈ

POSTGRES ��Ʈ�� Ŭ ��Ϻ귡Ŀ �� ̲��, �̱� ��漺 ���� ȹ��(DARPA), �� (ARO), �� (NSF), ESL �ֽ�ȸ�� Ŀ�� ޾Ƽ� ��Ǿ��. POSTGRES ��Ʈ�� 1986�⿡ ��۵Ǿ��. �� ý�� The design of POSTGRES �� , �� ڷ� �� Ǵ� The POSTGRES data model �� ߴ�. �� rule�� The design of the POSTGRES rules system �� ϰ� �ִ�. �ڷ� �� ̷�� ٰſ� ��迡 �� The design of the POSTGRES storage system �� ڼ�� ϰ� �ִ�.

POSTGRES�� . ù��° "��" �ý�� 1987�⿡ �۵��Ǿ��, 1988�� ACM-SIGMOD ȸ�߿�� Ǿ��. The implementation of POSTGRES �� 1 �ý�� 1989�� 6�� ܺΰ��ڵ鿡�� Ǿ��. A commentary on the POSTGRES rules system �� ù��° rule �ý�� Ͽ�, rule �ý�� ٽ� �� Ǿ��( On Rules, Procedures, Caching and Views in Database Systems �� ), �� 2�� ο� rule �ý�� ؼ�, 1990�� 6�� ǥ�Ǿ��. �̾�, 1991�⿡ �� 3�� , �� , ��ۼ�� rule �ý�� ϱ� ��ߴ�. Postgres95 (�Ʒ� ��) ��ǥ �� κ� �� ̽ļ��, �ŷڼ�� ΰ� ��ߵǾ��.

POSTGRES�� پ�� ۾��, ��α׷� ��߿� ��Ǿ��. �� ڷ� �м� �ý��, ��Ʈ �� ˻� ��Ű��, ��༺ �� ͺ��̽�, �Ƿ� �� ͺ��̽�, �� ý��ۿ�� Ǿ��. �� POSTGRES�� б�� ε� ��Ǿ��. ��ħ��, Illustra Information Technologies(�޳� Informix - ��, IBM�� ִ� - �� պ��)�� ڵ尡 ��ǰ�, ��ȭ �Ǿ��. �׵�, 1992�⿡ Sequoia 2000 scientific computing project�� ⺻ �ڷ� ��ڷ� ��Ǿ��.

1993�⿡ �ͼ�� ܺ� �� ι� �� ϰ� �Ǿ��. �̷�� Ǹ鼭, �ڵ� �� ϰ�, ��ͺ��̽� ��翡 �Ҿ�� ð�� ʿ��ϰ� �Ǿ��. �ᱹ �̷� �� ۾�� ̱� ��ؼ�, ��Ŭ�� POSTGRES ��Ʈ�� 4.2�� Ǿ��.

Postgres95

1994�⿡ �ص�� , �� þ�� POSTGRES �� SQL �� ͸� �߰��ߴ�. �׸�� Postgres95�� ο� �̸�� POSTGRES ��Ŭ�� ڵ�� ҽ� ��å�� ̾� �޾�, �� ؼ� ��ǥ�ߴ�.

Postgres95 �ڵ�� ANSI C ȣȯ�� ۼ��Ǿ��, �ڵ� �з�� 25%�� ٿ��. �� ۾�� Ǿ��, �� . ��ܽ� ��ġ��ũ�� , Postgres95 1.0.x �� POSTGRES �� 4.2�� 30-50% �� ӵ�� ۵��ߴٰ� �Ѵ�. �� ϰ�, �Ʒ�� ߴ�:

�� Ǿ��, PostQUEL�̶��  SQL�� ٲپ��. �� PostgreSQL �� Ǳ� ��, Postgres95�� SQL �Լ��  �װ�� ־��. �� Լ�� ٽ� ��Ǿ��, �̸� ��ϱ� ��, GROUP BY �� ߴ�.
SQL �� ȭ�� ֵ�� ο� ��α׷�(psql)�� ߴ�. �̰�� monitor ��α׷�� ϴ� �۾�� κ�� ü�ϰ� �Ǿ��.
Tcl �� Ŭ��̾�Ʈ�� ִ� ��ο� libpgtcl ��̺귯�� ߴ�. pgtclsh �̶�� Postgres95 �� Tcl ��α׷�� ̿�� ֵ�� ο� Tcl ��ɵ�� ߴ�.
��ü(large-object) ��̽�� , �� ü inversion�� ü ��ϴ� ��ī��θ� ��Ǿ��. (inversion �� ý�� )
�� rule �ý�� ְ�, ��ۼ�� rule�� ־��.
Postgres95�� ִ� �Ϲ�� SQL �� Ұ�� ڽ�� ڵ�� Բ� ��Ǿ��.
BSD make ��ſ�, GNU make�� ߴ�. �� Postgres95 �ڵ�� ġ(doubles�� ڷ� ��Ĺ�� ) �� GCC�ε� �� ־��.

PostgreSQL

1996�� Ǹ鼭 "Postgres95" �̸�� ٲٱ�� ߴ�. �ֳ��ϸ�, �⵵ �̸�� ϴ� �� Ÿ��ġ �ʾұ� ��̴�. �׷��, ��ο� �̸�� PostgreSQL�� ߴ�. ��ü�� , POSTGRES��, SQL �� ߰��Ǿ��⿡ �� ܾ�� ռ�� ߴ�. �׸��, ��Ŭ�� POSTGRES ��Ʈ�� ̾�޾Ҵ� �� ϱ� ��ؼ�, �� 6.0�� ϱ�� ߴ�. (Postgres95�� 5.0�� ϱ�� ϰ�)

�� ̰ų�, ��ϱ� ��ٴ� �� PostgreSQL�� "Postgres"�� θ�� (�� 빮�ڷ� ǥ��ϴ� �� 幰��). �̰�� Ǵ� ��Ī�� θ� ��ǰ� �ִ�.

Postgres95 ��߿�� ڵ忡 �ִ� �� ã��, ��ϴ� �Ϳ� �� ξ��. PostgreSQL�� ư�, �̰͵�� ϰ�, �� Ȯ��ϰ�, ȣȯ�� о�� ۾�� ̷��.

PostgreSQL �� õ�� 부록 E �� ڼ�� ϰ� �ִ�.

이전	처음으로	다음
PostgreSQL�� ΰ�?	위로	�Ϸ��α�

PostgreSQL ���߸� ����

��Ŭ�� POSTGRES ������Ʈ

Postgres95

PostgreSQL

PostgreSQL ��߸� ��

��Ŭ�� POSTGRES ��Ʈ