141
ɟɫɬɶ ɢ ɧɟɞɨɫɬɚɬɤɢ. ɇɚɩɪɢɦɟɪ, ɧɟɥɶɡɹ ɫɮɨɪɦɭɥɢɪɨɜɚɬɶ SQL ɡɚɩɪɨɫ ɩɨɬɨɦɭ,
ɱɬɨ ɧɟ ɢɡɜɟɫɬɧɵ ɜɫɟ ɨɛɴɟɤɬɵ, ɤɨɬɨɪɵɟ ɧɚɞɨ ɩɪɨɫɦɨɬɪɟɬɶ [7]. ɋɩɢɫɨɤ ɷɬɢɯ
ɨɛɴɟɤɬɨɜ ɨɩɪɟɞɟɥɹɟɬɫɹ ɬɨɥɶɤɨ ɜ ɯɨɞɟ ɜɵɩɨɥɧɟɧɢɹ ɡɚɩɪɨɫɚ. ɋɨɨɬɜɟɬɫɬɜɟɧɧɨ
ɧɟɨɛɯɨɞɢɦɨ ɪɚɡɪɚɛɚɬɵɜɚɬɶ ɩɪɨɝɪɚɦɦɭ, ɨɫɭɳɟɫɬɜɥɹɸɳɭɸ ɩɪɨɰɟɞɭɪɭ
ɢɟɪɚɪɯɢɱɟɫɤɨɝɨ ɡɚɩɪɨɫɚ.
Ɋɚɫɫɦɨɬɪɢɦ ɨɫɧɨɜɧɵɟ ɷɬɚɩɵ ɞɟɣɫɬɜɢɹ ɬɚɤɨɣ ɩɪɨɝɪɚɦɦɵ. ɂɯ ɛɭɞɟɬ
ɬɪɢ: ɨɩɪɟɞɟɥɟɧɢɟ ɨɛɴɟɤɬɚ, ɧɟɩɨɫɪɟɞɫɬɜɟɧɧɨ ɜɵɛɨɪ ɢɧɮɨɪɦɚɰɢɢ ɢ ɩɪɨɜɟɪɤɚ
ɭɫɥɨɜɢɹ ɨɫɬɚɧɨɜɚ. ɇɚ ɩɟɪɜɨɦ ɷɬɚɩɟ ɜ ɧɚɱɚɥɟ ɜɵɩɨɥɧɟɧɢɹ ɩɪɨɝɪɚɦɦɵ
ɨɩɪɟɞɟɥɹɟɬɫɹ ɨɛɴɟɤɬ, ɩɨ ɤɨɬɨɪɨɦɭ ɢɳɟɬɫɹ ɬɪɟɛɭɟɦɚɹ ɢɧɮɨɪɦɚɰɢɹ. Ⱦɚɥɟɟ, ɫ
ɩɨɦɨɳɶɸ ɡɚɩɪɨɫɚ ɜɵɛɢɪɚɟɬɫɹ, ɜɨ-ɩɟɪɜɵɯ, ɫɨɫɬɚɜ ɨɛɴɟɤɬɚ, ɬɨ ɟɫɬɶ ɫɩɢɫɨɤ
ɨɛɴɟɤɬɨɜ, ɜɯɨɞɹɳɢɯ ɜ ɪɚɫɫɦɚɬɪɢɜɚɟɦɵɣ. ɂ, ɜɨ-ɜɬɨɪɵɯ, ɢɫɤɨɦɚɹ
ɢɧɮɨɪɦɚɰɢɹ, ɟɫɥɢ ɨɧɚ ɢɦɟɟɬɫɹ. ɍɫɥɨɜɢɟɦ ɨɤɨɧɱɚɧɢɹ ɹɜɥɹɟɬɫɹ ɩɭɫɬɨɣ
ɫɩɢɫɨɤ ɫɨɫɬɚɜɚ ɪɚɫɫɦɚɬɪɢɜɚɟɦɨɝɨ ɨɛɴɟɤɬɚ. Ɉɩɢɫɚɧɧɵɣ ɚɥɝɨɪɢɬɦ ɹɜɥɹɟɬɫɹ
ɪɟɤɭɪɫɢɜɧɵɦ. ɉɭɬɶ, ɩɪɨɣɞɟɧɧɵɣ ɩɪɨɝɪɚɦɦɨɣ, ɩɨ ɨɛɴɟɤɬɚɦ ɛɚɡɵ ɞɚɧɧɵɯ
ɦɨɠɧɨ ɩɪɟɞɫɬɚɜɢɬɶ ɜ ɜɢɞɟ ɞɟɪɟɜɚ.
ɗɬɨɬ ɠɟ ɜɨɩɪɨɫ ɦɨɠɧɨ ɪɟɲɚɬɶ ɫɩɨɫɨɛɨɦ ɪɚɫɩɚɪɚɥɥɟɥɢɜɚɧɢɹ
ɜɵɱɢɫɥɟɧɢɣ. Ɍɨɝɞɚ ɩɪɨɝɪɚɦɦɚ ɞɨɥɠɧɚ ɛɵɬɶ ɪɟɟɧɬɟɪɚɛɟɥɶɧɨɣ ɢ ɜɵɝɥɹɞɟɬɶ
ɢɧɚɱɟ. ɇɚɱɚɥɶɧɨɟ ɭɫɥɨɜɢɟ – ɨɛɴɟɤɬ, ɩɨ ɤɨɬɨɪɨɦɭ ɢɳɟɬɫɹ ɢɧɮɨɪɦɚɰɢɹ,
ɨɩɪɟɞɟɥɹɟɬɫɹ ɢɡɜɧɟ ɢ ɩɟɪɟɞɚɟɬɫɹ ɤɚɤ ɜɯɨɞɧɨɣ ɩɚɪɚɦɟɬɪ. ɗɬɚɩɵ ɪɚɛɨɬɵ
ɩɪɨɝɪɚɦɦɵ ɫɥɟɞɭɸɳɢɟ. ȼɨ-ɩɟɪɜɵɯ, ɜɵɛɨɪ ɢɫɤɨɦɨɣ ɢɧɮɨɪɦɚɰɢɢ ɢ ɫɩɢɫɤɚ
ɩɨɞɱɢɧɟɧɧɵɯ ɨɛɴɟɤɬɨɜ (ɜɯɨɞɹɳɢɯ ɜ ɪɚɫɫɦɚɬɪɢɜɚɟɦɵɣ). ȼɨ-ɜɬɨɪɵɯ, ɡɚɩɭɫɤ
ɧɨɜɵɯ ɡɚɞɚɱ (ɟɫɥɢ ɫɩɢɫɨɤ ɩɨɞɱɢɧɟɧɧɵɯ ɨɛɴɟɤɬɨɜ ɧɟ ɩɭɫɬ), ɜɵɩɨɥɧɹɸɳɢɯ
ɤɨɩɢɸ ɩɪɨɝɪɚɦɦɵ ɞɥɹ ɜɫɟɯ ɩɨɞɱɢɧɟɧɧɵɯ ɨɛɴɟɤɬɨɜ, ɢ ɨɫɬɚɧɨɜ ɩɪɨɝɪɚɦɦɵ.
ȼ ɪɚɫɫɦɨɬɪɟɧɧɨɦ ɫɥɭɱɚɟ, ɦɵ ɢɦɟɟɦ ɞɟɥɨ ɫ ɮɪɚɤɬɚɥɶɧɨ-ɩɨɞɨɛɧɵɦ
ɩɪɨɰɟɫɫɨɦ. Ɉɩɢɫɚɧɧɵɟ ɞɟɣɫɬɜɢɹ ɦɨɠɧɨ ɨɩɪɟɞɟɥɢɬɶ ɤɚɤ ɮɪɚɤɬɚɥɶɧɵɣ
ɚɥɝɨɪɢɬɦ ɩɨɢɫɤɚ ɢɧɮɨɪɦɚɰɢɢ ɧɚ ɩɪɨɫɬɪɚɧɫɬɜɟ ɢɟɪɚɪɯɢɱɟɫɤɢɯ ɫɬɪɭɤɬɭɪ.
ɉɪɟɞɩɨɥɨɠɢɦ ɜ ɩɟɪɜɨɦ ɩɪɢɛɥɢɠɟɧɢɢ, ɱɬɨ ɜɪɟɦɹ ɜɵɩɨɥɧɟɧɢɹ ɡɚɞɚɱ
ɨɞɢɧɚɤɨɜɨɟ -
p
t
. Ⱦɚɥɟɟ, ɛɭɞɟɦ ɫɱɢɬɚɬɶ, ɱɬɨ ɜɵɱɢɫɥɟɧɢɹ ɜɵɩɨɥɧɹɸɬɫɹ ɜ
ɢɞɟɚɥɶɧɨɣ ɦɧɨɝɨɡɚɞɚɱɧɨɣ ɫɪɟɞɟ, ɬɚɤɨɣ, ɱɬɨ ɟɫɥɢ ɦɨɦɟɧɬ ɧɚɱɚɥɚ
ɜɵɩɨɥɧɟɧɢɹ ɞɜɭɯ ɨɞɢɧɚɤɨɜɵɯ ɡɚɞɚɱ ɫɨɜɩɚɞɚɟɬ, ɬɨ ɫɨɜɩɚɞɚɟɬ ɢ ɦɨɦɟɧɬ