73
DAFTAR PUSTAKA Connolly T, Begg. C 1996. Database System A Practical Approach to Design, Implementation and Management. New York : Addison Wesley Publishing Company. hlm. 163-191 Erik va Kuijk. 2000. Semantic Query Optimization in Distributed Database Systems. Netherlands: Universiteit Twente. hlm. 13-28 Fathansyah. 2004 .Sistem Basis Data , Informatika Bandung. hlm. 21-50 Fuad Harahap, 2004 Optimisasi Query. http://www.geociteis.com/visiweb. hlm. 64-65 [ 22 Desember 2004] Jacobs Ken. 2002. Perspective DR.DBA Query Optimization . Documentation Discussion Forums Articles Sample Code Training RSS Resources As Published. hlm 1-4 http://www./oracle.com/ken.jacobs/drdba [6 Juli 2005] Jia li, Rada Chirkova, Chen Li. 2003. Minimizing Data-Communication Costs by Decomposing Query Results in Client-Server Environments. Deparment of Computers Science UCI ICS Technical Report. hlm 10-18. http://www.cse.iitk.ac.in/researc/mtech_1997 [25 September 2004] Özsu MT, Valduriez P. 1999. Principles of Distributed Database Systems. Ed ke-2 New Jersey : Prentice Hall. hlm. 75-233 Ramakrishna Raghu & Gehrke Johanes. 2003. Database Management Systems. Third Edition The McGraw-Hill Companies, Inc. Ed. ke 3 hlm. 299-317, 336-354, 559-564 Vadali V R L Swamy. 2001. Applying Parametric Query Optimization to NonParametric Query Metrics. Departement of Computer Science & Engineering Indian Instititute of Technologi, Kanpur. hlm 2-5.
74
Vlach Richard. 2000. Query Processing in Distributed Database Systems. Departement of Software Engineering, Charles University. hlm. 1-3 http://www.cs.umd.edu/~keleher/818s97/ryan/paper.html. [6 September 2004]
75 Lampiran 1 : Contoh kamus data tabel relasi pst_ke1 4 buah atribut 3.873.324 record
Nama Attribut
Type
NO_TSP
VarChar
Ukuran 10
Key
Keterangan
Primary
No Taspen dari
Key
NIP Pegawai
TGL_LHR
DateTime
-
-
Tanggal Lahir
TMT_PST
DateTime
-
-
Terhitung
Mulai
Tanggal Peserta KD_BUP
VarChar
3
-
Kode
76
Lampiran 2 : Contoh kamus data tabel relasi pstaktif dengan 8 buah attribut 3.619.423 record.
Nama Attribut
Type
NIPPA
VarChar
Ukuran 10
Key
Keterangan
Primary
No. Taspen dari
Key
NIP Pegawai
TGL_LHR
DateTime
-
-
Tanggal Lahir
TMT_PST
DateTime
-
-
Terhitung Mulai Tanggal
SEX
Char
1
-
Jenis Kelamin
GAJI_POKOK
Float
-
-
Gaji Pokok
BLTH_GAPOK Varchar
6
-
Gaji Pokok Terakhir
SUSKEL
Varchar
3
-
Status Keluarga
PANGKAT
Char
2
-
Pangkat
77 Lampiran 3 : Contoh kamus data tabel relasi pmk_ke1 dengan 6 buah attribut 1.401.040 record. Nama Attribut NO_TSP
Type VarChar
Ukuran 10
Key
Keterangan
Primary No Taspen dari NIP Pegawai Key
TMT_PST
DateTime
-
-
Terhitung
Mulai
Tanggal
Peserta TGL_KEJ
DateTime
-
-
Tanggal Kejadian
TGLHR_YMK
DateTime
-
-
Tanggal
lahir
yang
mengajukan klaim KD_KEJ
VarChar
4
-
Kode Kejadian B(pensiun), C(meninggal pensiun, setelah pensiun)
sebelum E(meninggal
78
Lampiran 4 : Contoh kamus data tabel relasi pmk_fd1 dengan 13 buah attribut 1.261.239 record
Nama Attribut
Type
NIPPA
VarChar
TMT_PST
DateTime
Ukuran Key 10
-
Keterangan
Primary No Taspen dari Key
NIP Pegawai
-
Terhitung
Mulai
Tanggal
Peserta KD_KEJ
VarChar
4
-
Kode Kejadian B(pensiun),
C(meninggal
sebelum
pensiun,
E(meninggal
setelah
pensiun) TGL_KEJ
DateTime
-
-
Tanggal Kejadian
TGL_KLIM
DateTime
-
-
Tanggal Klaim
TGL_TRANS
DateTime
-
-
Tanggal Transaksi
PANGKAT
Char
2
-
Pangkat
GAJI_POKOK
Float
-
-
Gaji Pokok
THP
Float
-
-
Tunjangan Hari Pensiun
SUSKEL
Char
3
-
Status Keluarga
NAMA_YMK
VarChar
30
-
Nama
yang
mengajukan
klaim TGLLHR_YMK DateTime
-
-
Tanggal
lahir
yang
mengajukan klaim RP_HAK
Float
-
Jumlah uang hak terima uang
79 Lampiran 5 : Kamus data tabel relasi pstpens dengan 11 buah attribut 1.264.037 record
Nama Attribut
Type
NOPEN
VarChar
Ukuran 10
Key
Keterangan
Primary
No Identitas Pensiun
Key JENIS
Char
1
-
Jenis
KP030
DateTime
-
-
Tanggal Lahir
KP040
Char
2
-
Golongan
KP080
Float
-
-
Tunjangan Kel
KP180
DateTime
-
-
Tanggal Pensiun
KP380
Float
-
-
Gaji Pokok
KP570
VarChar
4
-
Jenis Pensiun
KP550
Float
-
-
Jumlah uang hak diterima
KP710
VarChar
6
-
Status Keluarga
TMT_KERJA
DateTime
-
-
Terhitung Mulai Tanggal Kerja
80 Lampiran 6 : Contoh isi data tabel relasi pst_ke1 NO_TSP 000130985 010018391 010018826 010022921 010027958 010028654 010031869 010033046 010033069 010033707 010037805 010037812 010037815 010037828 010037869 010038434 010038436 010038437 010042845 010042859 010042860 010042884 010042889 010042900 010042910 010042920 010042939 010042955 010042971 010042977 010042989 010043669 010047214 010047216 010047219 010047225 010047231 010047237 010047248 010047257 010047258
TGL_LHR 31/12/1955 18/12/1952 30/03/1966 29/08/1955 19/10/1943 07/07/1942 02/09/1959 17/08/1943 31/12/1943 03/06/1943 29/08/1942 05/05/1942 11/11/1941 16/07/1943 25/07/1942 16/06/1943 15/12/1941 13/07/1941 08/05/1944 02/08/1943 08/09/1948 09/08/1946 10/10/1946 12/12/1942 31/12/1940 16/08/1943 13/06/1943 31/12/1947 01/10/1942 20/06/1942 06/06/1943 29/09/1943 29/04/1946 02/02/1948 16/05/1943 11/11/1943 02/08/1943 26/07/1943 23/05/1945 16/02/1948 22/05/1944
TMT_PST KD_BUP 01/01/1975 100 01/03/1983 100 01/03/1991 100 01/10/1975 100 01/12/1961 100 01/11/1961 100 01/03/1976 100 01/01/1962 100 01/01/1962 100 01/02/1962 100 01/04/1966 100 01/10/1963 100 01/04/1963 100 01/07/1963 100 01/10/1963 100 01/01/1963 100 01/07/1961 100 01/06/1962 100 01/09/1964 100 01/12/1964 100 01/12/1964 100 01/12/1964 100 01/12/1964 100 01/07/1964 100 01/07/1964 100 01/12/1964 100 01/07/1964 100 01/03/1964 100 01/07/1964 603 01/07/1964 100 01/04/1964 100 01/05/1964 100 01/02/1965 100 01/11/1965 100 01/11/1965 100 01/11/1965 100 01/09/1965 100 01/12/1965 100 01/11/1965 100 01/09/1969 100 01/10/1965 100
81 Lampiran 7 : Contoh isi tabel relasi pstaktif
NIPPA 010035956 010035980 010035987 010036013 010036019 010036084 010036094 010036095 010036115 010036148 010036150 010036152 010036153 010036188 010036197 010036256 010036276 010036278 010036282 010036410 010036428 010036430 010036447 010036469 010036471 010036491 010036505 010036530 010036541 010036578 010036580 010036590 010036598 010036624 010036630 010036651 010036652 010036670 010036671
TGL_LHR 15/11/1943 25/09/1943 26/01/1944 26/11/1943 01/01/1977 26/07/1943 01/12/1943 01/12/1943 26/08/1943 12/08/1944 01/12/1943 31/12/1943 01/12/1943 08/08/1943 17/09/1943 06/06/1944 08/09/1943 28/04/1943 06/07/1943 31/12/1946 01/12/1944 14/02/1943 20/06/1946 11/09/1943 03/04/1947 03/04/1943 20/03/1944 01/01/1977 31/12/1946 10/06/1943 16/03/1943 31/12/1943 27/03/1943 04/05/1943 02/02/1943 21/06/1943 15/04/1947 01/01/1944 25/08/1943
TMT_PST SEX GAJI_POKOK BLTH_GAPOK SUSKEL 01/10/1963 L 897500 082001 000 01/08/1963 L 866200 082001 100 01/01/1963 L 498000 012000 100 01/07/1963 L 973900 082001 100 01/01/1997 L 929900 082001 101 01/12/1963 L 875600 082001 103 01/08/1963 L 887900 082001 100 01/12/1963 L 940000 082001 101 01/03/1963 L 513000 021998 101 01/07/1963 L 1138100 082001 102 01/03/1963 L 887900 082001 102 01/03/1963 L 963500 082001 102 01/03/1963 L 885100 082001 103 02/12/1963 L 1060200 082001 000 01/10/1963 L 367700 091999 102 01/11/1963 L 973900 082001 101 01/04/1963 L 1125900 082001 100 01/06/1964 L 953100 082001 101 01/02/1963 L 987600 082001 100 01/01/1963 L 1098400 082001 102 01/08/1963 L 1060200 082001 102 01/12/1963 L 1060200 082001 103 01/08/1963 L 1034300 082001 103 01/07/1963 L 1363200 092002 100 01/10/1963 L 845100 082001 103 01/07/1963 L 1166500 082001 100 01/01/1963 L 1166500 082001 102 01/01/1997 L 947200 082001 103 01/08/1963 L 940000 012001 103 01/02/1963 L 216800 121990 102 01/11/1963 L 963500 082001 103 01/09/1963 L 804400 082001 102 01/12/1963 L 963500 082001 102 01/06/1963 L 897500 082001 102 01/06/1963 L 998300 082001 101 01/06/1963 L 367700 061999 000 01/12/1963 L 887900 012001 103 01/12/1963 L 180600 121990 102 01/06/1963 L 998300 082001 103
PANGKAT 2B 2A 3B 3A 2C 2B 2A 2D 3D 3D 2A 2D 2C 3B 2B 3A 3C 2C 2D 3C 3B 3B 3B 4C 2A 3D 3D 3C 2D 1D 2D 2A 2D 2B 3A 2B 2A 1B 3A
82 Lampiran 8 : Contoh isi tabel relasi pmk_ke1 NO_TSP 010037875 010037876 010037877 010037877 010037878 010037878 010037881 010037881 010038341 010038410 010038420 010038421 010038422 010038423 010038423 010038423 010038426 010038426 010038427 010038427 010038428 010038429 010038431 010038432 010038435 010038443 010038446 010038447 010038450 010038451 010038452 010038453 010038454 010038455
TMT_PST 01/09/1963 01/04/1963 01/07/1963 01/07/1963 01/11/1963 01/11/1963 01/09/1963 01/09/1963 01/04/1963 01/12/1963 01/09/1963 01/06/1963 01/01/1963 01/01/1963 01/01/1963 01/01/1963 01/08/1963 01/08/1963 01/06/1963 01/06/1963 01/06/1963 01/08/1963 01/01/1963 01/01/1963 01/01/1963 01/12/1963 01/04/1963 01/06/1963 01/07/1963 01/07/1963 01/08/1963 01/06/1963 01/01/1963 01/01/1963
TGLHR_YMK 30/07/1938 09/06/1943 31/12/1929 31/12/1929 16/04/1927 18/10/1929 09/07/1945 09/07/1945 21/07/1932 07/12/1941 17/08/1940 21/08/1936 01/04/1942 18/03/1930 18/03/1930 18/03/1930 01/07/1932 01/07/1932 18/08/1935 18/08/1935 10/05/1936 23/02/1934 09/03/1942 03/12/1941 30/12/1942 18/12/1937 10/10/1936 01/08/1937 27/09/1937 25/04/1943 03/02/1942 12/08/1945 01/07/1942 21/05/1941
TGL_KEJ KD_KEJ 31/07/1994 B110 30/06/1999 B110 31/12/1985 B111 16/06/1991 E110 31/12/1983 B110 18/10/1996 B210 30/12/1991 C110 30/12/1991 C111 27/01/1985 C110 31/12/1997 B110 31/08/1996 B110 31/08/1992 B110 30/04/1998 B110 31/03/1986 B110 31/03/1986 B111 07/11/1993 E110 31/07/1988 B110 13/05/1990 E110 31/08/1991 B110 31/08/1991 B111 31/05/1992 B110 24/06/1987 C110 31/03/1998 B110 31/12/1997 B110 31/12/1998 B110 31/12/1993 B110 31/10/1992 B110 03/07/1984 C110 30/09/1993 B110 30/04/1999 B110 28/02/1998 B110 31/08/1998 B110 30/11/1995 B110 31/05/1997 B110
83 Lampiran 9 : Contoh isi tabel relasi pstpens
NOPEN 0003819710 0003819720 0003819760 0003819780 0003819820 0003819950 0003819960 0003819970 0003819990 0003820040 0003820050 0003820060 0003820210 0003820240 0003820250 0003820280 0003820500 0003820510 0003820580 0003820610 0003820950 0003821000 0003821020 0003821080 0003821170 0003821400 0003821420 0003821430 0003821440 0003821450 0003821460 0003821470
JENIS KP030 KP040 KP080 1 12/09/1928 1C 257 2 11/11/1919 1B 239 2 01/12/1919 1B 290 1 27/09/1922 1B 205 1 31/12/1926 1B 205 1 31/12/1924 1B 222 1 23/02/1923 1B 205 2 12/12/1922 1B 308 1 31/12/1923 1C 311 1 11/05/1926 1B 222 1 01/12/1922 1B 205 2 31/12/1926 1C 265 1 31/12/1924 1C 857 1 22/11/1928 1D 778 2 09/01/1926 1B 569 1 31/12/1927 1B 569 1 01/01/1926 1B 569 2 01/06/1925 1A 33200 1 27/08/1919 1C 680 2 01/12/1925 1B 764 2 31/12/1929 1B 569 1 01/12/1930 1B 569 2 31/12/1919 1D 29700 2 10/07/1917 1B 29100 2 31/12/1921 1C 739 2 27/12/1927 1B 621 2 15/07/1923 1B 673 2 20/12/1928 1B 29100 2 01/12/1913 1C 503 2 30/06/1924 2D 1608 2 05/03/1923 1B 29500 2 31/12/1908 1B 30300
KP180 KP380 KP570 01/10/1978 500000 1100 01/05/1998 187500 1000 01/11/1990 375000 1000 01/10/1972 500000 1100 01/01/1967 500000 1101 01/04/1985 500000 1100 01/03/1993 500000 1000 01/04/1999 375000 1000 01/04/1985 500000 1000 01/04/1979 500000 1101 01/01/1973 500000 1000 01/03/2001 375000 1000 01/04/1979 500000 1100 30/10/1990 500000 1100 01/08/1997 187500 1000 01/04/1979 500000 1100 01/04/1979 500000 1100 01/07/1975 375000 1000 01/09/1969 500000 1100 01/08/1987 375000 1000 01/11/1993 375000 1001 01/01/1981 500000 1100 01/12/1986 375000 1000 01/07/1987 375000 1000 01/05/1998 375000 1000 01/06/1989 375000 1000 01/04/1974 375000 1000 01/06/1985 375000 1000 01/08/1998 375000 1000 01/08/2000 375000 1000 01/08/1985 375000 1000 01/06/1981 375000 1000
KP550 KP710 589500 102002 225000 102002 424800 102002 589500 102002 624600 102002 589500 102002 515300 102002 424800 102002 515300 102002 624600 102002 515300 102002 424800 102002 589500 102002 589500 102002 225000 102002 589500 102002 589500 102002 424800 102002 589500 102002 424800 102002 425400 102002 589500 102002 424800 102002 424800 102002 424800 102002 424800 102002 424800 102002 424800 102002 424800 102002 392800 102002 424800 102002 424800 102002
84
Lampiran 10 : Contoh isi data dari tabel relasi pmk_fd1 NIPPA
PANG GAJI_POKOK THP SUSKEL NAMA_YMK KAT 09/05/1988 2A 58200 0 000 TOGA NAPITUPULU 24/08/1989 1A 12000 52392 000 BACHTIAR EFFENDY 07/10/1998 2C 330400 376656 102 WILMAR SIMORANGKIR 13/06/1992 1C 91000 105560 103 MUHAMMAD NASIR LUBIS 24/02/1997 2C 192700 219678 102 AKMALUDDIN NASUTION 08/02/1992 2C 83000 83000 000 SYAHRIAL SIHITE 18/02/1993 2D 188900 211568 101 SYAIFUL MASRUL,BSC 21/12/1988 2B 72800 80808 103 LEGIMIN SUKARDI 22/01/1999 2D 327200 379552 103 MASA SEMBIRING 08/02/1996 2D 215700 241584 101 JAMALEM SITEPU 28/07/1995 2D 215700 250212 103 MUHAMMAD MUNIR 29/12/1993 1C 142700 165532 103 AMIR HUSIN 22/03/1999 2D 296800 326480 100 HERRY TH. PANGARIBUAN 07/12/1988 2A 69100 69100 000 M IRWAN 20/07/1995 3A 220200 242220 100 ERNAWATY BR SURBAKTI
TMT_PST KD_KEJ TGL_KEJ TGL_KLIM TGL_TRANS
010158936 01/03/1983 D110
29/02/1988 09/05/1988
010159184 01/03/1983 C110
30/05/1989 24/08/1989
010159312 01/01/1993 C110
31/08/1998 07/10/1998
010159318 01/03/1983 C110
11/05/1992 13/06/1992
010159363 01/01/1993 C110
14/01/1997 24/02/1997
010159371 01/03/1983 C110
14/01/1992 08/02/1992
010160176 01/03/1983 C110
11/01/1993 17/02/1993
010160189 01/03/1983 C110
17/11/1988 21/12/1988
010160980 01/01/1993 C110
10/11/1998 22/01/1999
010161545 01/01/1993 B110
31/01/1996 08/02/1996
010161547 01/01/1993 B110
31/05/1995 28/07/1995
010161548 01/01/1981 C110 010162569 01/03/1983 C110
07/12/1993 29/12/1993 21/01/1999 19/03/1999
010162981 01/03/1983 C110 010 01/03/1983 C110
30/06/1988 07/12/1988 20/04/1995 20/07/1995
TGLHR_YMK RP_HAK 02/07/1960
162700
20/08/1948
616600
26/05/1950 5567800 21/07/1946 1337400 30/08/1960 4484900 10/04/1957 1307200 23/04/1954 3583300 15/07/1946
873800
16/08/1948 5245300 14/01/1940 2002100 05/11/1935 1984000 09/08/1947 2387100 12/05/1958 6247400 01/12/1959 1145100 08/07/1960 4925100
