Tải bản đầy đủ (.doc) (6 trang)

Công cụ phát sinh dữ liệu lớn

Bạn đang xem bản rút gọn của tài liệu. Xem và tải ngay bản đầy đủ của tài liệu tại đây (457.08 KB, 6 trang )

BÁO CÁO
TÌM HIỂU CÔNG CỤ PHÁT SINH CỤ THỂ
MÔN CSDL NÂNG CAO – LỚP TH09/01
MSSV 
Họ và tên 
Công cụ phát sinh dữ liệu cần 3m hiểu: !"#$#%#&'(
)*(
Công dụng:+,-!"./01(23456.7489:4;<43=>(2345?#@ ;4!A#B9
+C;$0D(%+=>###E80#F##(2345?#@+,G%#9%#945#;4,!##H(%
=:#;4+=#I9A0D(%?#@
J K:4E-#B,+=(2345?#@9A2E8#L=:#M#3AA
E".
J .B,0D(%+,+=(2345?#@9A##.#&9 
9N (9
J .B,(O+,G04(2345##8##;4,(23459+=>#
##G 0D(%##PQ#RG04+=>###GSO#T2G04O
#U#%V#&=W4(OS-!"##G04!:4(?Q!"2##
G04(2345#+X##G
Sử dụng SQL Data Generator:
.#4@3YG+,-(2345
Z@##U03=3-4.=:#;4?#45SE-#B,+4C#T3-4##4@3YG9A
?#45G04(23453-4@E-;$A43[9:4;@\8=:#
],-(2345 +UPQ-!"G^#E_###L99A#/01(2345!AE-
!<+,+=9A^##F`#+a!"0<O#L#945#G04(2345 9AE-#B,#T
+aE;b0<3=>##0#4G0!AE-!<##-?+"=:#M#0;4
-##(2345
Z4E-+X-!"G^# ##3=>#+c#&.!AE-+X#L+=>#345;Q!";d
E30GG3
e-#Tf##E8!AE-!<+=(23459AE_##+(#L9A$9$=:#
##E81#"G3gM#+a#=/d#L#8##E8 E-#B,#T3-4!M#+a
3hiG34#PjGP0


.34#;#"G849AQE89A#34#;9AShow Schema Crea>on Script +,`!0#4G
Z4+X3?#LPopulate #!"E8 E-#B,`#+a##!AE-!<(2345+=>#
-@A#34#;9AQE8EQE30GG39A#T+a###4P@EQ9OTable
genera>on se@ngs.

E30GG3
k9OAE-#B,#L
J -(2345E_##G04(2345!:40l?+"G04#
!m4#"(?9AQE8 Q#" ;4,(2345 9A("(A4
J YG(2345#B0ne-#B,YG!"E8M#;do!".+Xc-4 
M#!"p3.K#B=:#
945##A4+MG04!"E8 E-#B,#T+a0<3=>A!AE-!<+=>#
- 9AE-#B!<Q!9AG04!:4(2345E_945##L`B;$##(2345
45#BE863(q!E3EqP7
Table genera>on se@ngs
e-#B,`!=:#(2345+=>#-#&!m4E8;Preview
Z4E-+X4@3YG##$0<#E8 E-#B,;4,!#A4+M###"E8 9A
#T@#U],#L!"#"#945#P#T E-#L9AQ#"EQ;Tables to
populateM##L9A#"1;Preview. g";Column genera>on se@ngs 45;Table
genera>on se@ngs.
Z4+X#A4+M P#T` E-9Ag"E8;@-#?#45r
\0l453Q=:#;4Es+U945#G04(2345
Preview
KA0l#B!"E#?#450\dG04(4
.34#;t(4^#(#LE#4G0
k+uE-#B,Q!9A!"6270#4G+X#B0n 3A-0#4G!:4 +,#=/
d#-=:#3A0;4?#45945#G04(2345
Z4E-!1!"G^# @3=>#+c.+X+r4;,o;4E--G^# 3=>#+c+B
0l+=>#+(],`B+( #34#;9AIRefresh Schema.
],#BQ!$P =:(vfA/X9A34;

wGhh***(J#!h0GG#h(#xGyzz
END

×