Mvcc Control De Concurrencia
��-�-�-� �\n�t�i�t�l�e�:� �M�V�C�C� �-� �C�o�n�t�r�o�l� �d�e� �C�o�n�c�u�r�r�e�n�c�i�a� �M�u�l�t�i�v�e�r�s�i���n� �\n�d�e�s�c�r�i�p�t�i�o�n�:� �A�p�r�e�n�d�e� �s�o�b�r�e� �M�V�C�C� �(�C�o�n�t�r�o�l� �d�e� �C�o�n�c�u�r�r�e�n�c�i�a� �M�u�l�t�i�v�e�r�s�i���n�)�,� �u�n� �m�e�c�a�n�i�s�m�o� �a�v�a�n�z�a�d�o� �q�u�e� �p�e�r�m�i�t�e� �a� �l�a�s� �b�a�s�e�s� �d�e� �d�a�t�o�s� �g�e�s�t�i�o�n�a�r� �e�l� �a�c�c�e�s�o� �c�o�n�c�u�r�r�e�n�t�e� �a� �l�o�s� �d�a�t�o�s� �s�i�n� �b�l�o�q�u�e�o�s� �e�x�c�e�s�i�v�o�s�.� �\n�i�c�o�n�:� �m�a�t�e�r�i�a�l�-�s�y�m�b�o�l�s�:�c�o�d�e�-�r�o�u�n�d�e�d� �\n�p�u�b�l�i�s�h�e�d�:� �t�r�u�e� �\n�k�e�y�w�o�r�d�s�:� �s�q�l�,� �m�v�c�c�,� �c�o�n�t�r�o�l� �d�e� �c�o�n�c�u�r�r�e�n�c�i�a�,� �m�u�l�t�i�v�e�r�s�i���n�,� �t�r�a�n�s�a�c�c�i�o�n�e�s�,� �p�o�s�t�g�r�e�s�q�l�,� �o�r�a�c�l�e�,� �s�n�a�p�s�h�o�t�,� �a�i�s�l�a�m�i�e�n�t�o� �\n�c�a�t�e�g�o�r�i�e�s�:� ��s�q�l�,� �p�r�o�g�r�a�m�a�c�i���n�,� �d�e�s�a�r�r�o�l�l�o�,� �b�a�s�e� �d�e� �d�a�t�o�s�� �\n�a�u�t�h�o�r�:� �\n� � �n�a�m�e�:� �C�r�i�s�t�i�a�n� �E�s�c�a�l�a�n�t�e� �\n� � �u�r�l�:� �h�t�t�p�s�:�/�/�g�i�t�h�u�b�.�c�o�m�/�c�a�e�h�e�r� �\n� � �i�m�a�g�e�:� �h�t�t�p�s�:�/�/�a�v�a�t�a�r�s�.�g�i�t�h�u�b�u�s�e�r�c�o�n�t�e�n�t�.�c�o�m�/�u�/�6�0�1�2�0�6�0�3�?�v�=�4� �\n�c�r�e�a�t�e�d�A�t�:� �2�0�2�5�-�0�5�-�1�2�T�0�0�:�0�0�:�0�0�Z� �\n�u�p�d�a�t�e�d�A�t�:� �2�0�2�5�-�0�5�-�1�2�T�0�0�:�0�0�:�0�0�Z� �\n�-�-�-� �\n� �\n�#�#� ���Q�u��� �e�s� �M�V�C�C�?� �\n� �\n�M�V�C�C� �(�M�u�l�t�i�v�e�r�s�i�o�n� �C�o�n�c�u�r�r�e�n�c�y� �C�o�n�t�r�o�l�)� �o� �C�o�n�t�r�o�l� �d�e� �C�o�n�c�u�r�r�e�n�c�i�a� �M�u�l�t�i�v�e�r�s�i���n� �e�s� �u�n�a� �t���c�n�i�c�a� �a�v�a�n�z�a�d�a� �u�t�i�l�i�z�a�d�a� �p�o�r� �m�u�c�h�o�s� �s�i�s�t�e�m�a�s� �d�e� �g�e�s�t�i���n� �d�e� �b�a�s�e�s� �d�e� �d�a�t�o�s� �r�e�l�a�c�i�o�n�a�l�e�s� �p�a�r�a� �p�e�r�m�i�t�i�r� �q�u�e� �m���l�t�i�p�l�e�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �a�c�c�e�d�a�n� �s�i�m�u�l�t���n�e�a�m�e�n�t�e� �a� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �s�i�n� �i�n�t�e�r�f�e�r�i�r� �e�n�t�r�e� �s���.� �\n� �\n�A� �d�i�f�e�r�e�n�c�i�a� �d�e� �l�o�s� �s�i�s�t�e�m�a�s� �t�r�a�d�i�c�i�o�n�a�l�e�s� �d�e� �b�l�o�q�u�e�o�,� �M�V�C�C� �c�r�e�a� �m���l�t�i�p�l�e�s� �"�v�e�r�s�i�o�n�e�s�"� �d�e� �l�o�s� �d�a�t�o�s�,� �p�e�r�m�i�t�i�e�n�d�o� �q�u�e� �l�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �v�e�a�n� �u�n�a� �i�n�s�t�a�n�t���n�e�a� �c�o�n�s�i�s�t�e�n�t�e� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �s�i�n� �n�e�c�e�s�i�d�a�d� �d�e� �b�l�o�q�u�e�a�r� �r�e�g�i�s�t�r�o�s� �p�a�r�a� �l�e�c�t�u�r�a�s�.� �\n� �\n�#�#� �P�r�i�n�c�i�p�i�o�s� �f�u�n�d�a�m�e�n�t�a�l�e�s� �d�e� �M�V�C�C� �\n� �\n�E�l� �f�u�n�c�i�o�n�a�m�i�e�n�t�o� �d�e� �M�V�C�C� �s�e� �b�a�s�a� �e�n� �v�a�r�i�o�s� �p�r�i�n�c�i�p�i�o�s� �c�l�a�v�e�:� �\n� �\n�1�.� ���V�e�r�s�i�o�n�a�d�o� �d�e� �d�a�t�o�s���:� �C�a�d�a� �v�e�z� �q�u�e� �s�e� �m�o�d�i�f�i�c�a� �u�n� �r�e�g�i�s�t�r�o�,� �s�e� �c�r�e�a� �u�n�a� �n�u�e�v�a� �v�e�r�s�i���n� �e�n� �l�u�g�a�r� �d�e� �s�o�b�r�e�s�c�r�i�b�i�r� �l�a� �e�x�i�s�t�e�n�t�e�.� �\n� �\n�2�.� ���V�i�s�i�b�i�l�i�d�a�d� �b�a�s�a�d�a� �e�n� �t�r�a�n�s�a�c�c�i�o�n�e�s���:� �C�a�d�a� �t�r�a�n�s�a�c�c�i���n� �s�o�l�o� �v�e� �l�a�s� �v�e�r�s�i�o�n�e�s� �d�e� �d�a�t�o�s� �q�u�e� �s�o�n� �r�e�l�e�v�a�n�t�e�s� �p�a�r�a� �e�l�l�a�,� �s�e�g���n� �s�u� �t�i�e�m�p�o� �d�e� �i�n�i�c�i�o�.� �\n� �\n�3�.� ���G�a�r�b�a�g�e� �c�o�l�l�e�c�t�i�o�n���:� �L�a�s� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �d�e� �l�o�s� �d�a�t�o�s� �s�e� �e�l�i�m�i�n�a�n� �c�u�a�n�d�o� �y�a� �n�o� �s�o�n� �n�e�c�e�s�a�r�i�a�s� �p�a�r�a� �n�i�n�g�u�n�a� �t�r�a�n�s�a�c�c�i���n� �a�c�t�i�v�a�.� �\n� �\n�4�.� ���T�i�m�e�s�t�a�m�p�s� �o� �i�d�e�n�t�i�f�i�c�a�d�o�r�e�s� �d�e� �t�r�a�n�s�a�c�c�i���n���:� �S�e� �u�t�i�l�i�z�a�n� �p�a�r�a� �d�e�t�e�r�m�i�n�a�r� �q�u��� �v�e�r�s�i�o�n�e�s� �d�e� �l�o�s� �d�a�t�o�s� �s�o�n� �v�i�s�i�b�l�e�s� �p�a�r�a� �c�a�d�a� �t�r�a�n�s�a�c�c�i���n�.� �\n� �\n�#�#� �F�u�n�c�i�o�n�a�m�i�e�n�t�o� �d�e� �M�V�C�C� �\n� �\n�#�#�#� �P�r�o�c�e�s�o� �b���s�i�c�o� �\n� �\n�1�.� ���L�e�c�t�u�r�a� �d�e� �d�a�t�o�s���:� �\n� � � �-� �C�u�a�n�d�o� �u�n�a� �t�r�a�n�s�a�c�c�i���n� �l�e�e� �d�a�t�o�s�,� �v�e� �u�n�a� �"�i�n�s�t�a�n�t���n�e�a�"� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �t�a�l� �c�o�m�o� �e�s�t�a�b�a� �a�l� �i�n�i�c�i�o� �d�e� �l�a� �t�r�a�n�s�a�c�c�i���n�.� �\n� � � �-� �S�o�l�o� �v�e� �l�o�s� �c�a�m�b�i�o�s� �c�o�n�f�i�r�m�a�d�o�s� �a�n�t�e�s� �d�e�l� �i�n�i�c�i�o� �d�e� �s�u� �t�r�a�n�s�a�c�c�i���n�.� �\n� � � �-� �N�o� �v�e� �l�o�s� �c�a�m�b�i�o�s� �r�e�a�l�i�z�a�d�o�s� �p�o�r� �t�r�a�n�s�a�c�c�i�o�n�e�s� �c�o�n�c�u�r�r�e�n�t�e�s� �q�u�e� �a���n� �n�o� �s�e� �h�a�n� �c�o�n�f�i�r�m�a�d�o� �o� �q�u�e� �s�e� �c�o�n�f�i�r�m�a�r�o�n� �d�e�s�p�u���s� �d�e�l� �i�n�i�c�i�o� �d�e� �l�a� �t�r�a�n�s�a�c�c�i���n� �a�c�t�u�a�l�.� �\n� �\n�2�.� ���E�s�c�r�i�t�u�r�a� �d�e� �d�a�t�o�s���:� �\n� � � �-� �C�u�a�n�d�o� �u�n�a� �t�r�a�n�s�a�c�c�i���n� �m�o�d�i�f�i�c�a� �d�a�t�o�s�,� �c�r�e�a� �n�u�e�v�a�s� �v�e�r�s�i�o�n�e�s� �d�e� �l�o�s� �r�e�g�i�s�t�r�o�s� �a�f�e�c�t�a�d�o�s�.� �\n� � � �-� �L�a�s� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �s�e� �m�a�n�t�i�e�n�e�n� �p�a�r�a� �l�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �q�u�e� �y�a� �e�s�t�a�b�a�n� �e�n� �c�u�r�s�o�.� �\n� � � �-� �L�a�s� �n�u�e�v�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �v�e�r���n� �l�a�s� �v�e�r�s�i�o�n�e�s� �m���s� �r�e�c�i�e�n�t�e�s� �(�s�i� �y�a� �e�s�t���n� �c�o�n�f�i�r�m�a�d�a�s�)�.� �\n� �\n�#�#�#� �E�j�e�m�p�l�o� �d�e� �f�u�n�c�i�o�n�a�m�i�e�n�t�o� �\n� �\n�S�u�p�o�n�g�a�m�o�s� �q�u�e� �t�e�n�e�m�o�s� �u�n� �r�e�g�i�s�t�r�o� �c�o�n� �u�n� �v�a�l�o�r� �i�n�i�c�i�a�l� �d�e� �1�0�0�:� �\n� �\n�1�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �A� �c�o�m�i�e�n�z�a� �y� �l�e�e� �e�l� �v�a�l�o�r� �1�0�0�.� �\n�2�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �B� �c�o�m�i�e�n�z�a� �y� �t�a�m�b�i���n� �l�e�e� �e�l� �v�a�l�o�r� �1�0�0�.� �\n�3�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �A� �a�c�t�u�a�l�i�z�a� �e�l� �v�a�l�o�r� �a� �1�5�0� �y� �h�a�c�e� �c�o�m�m�i�t�.� �\n�4�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �B� �a���n� �v�e� �e�l� �v�a�l�o�r� �1�0�0� �(�s�u� �i�n�s�t�a�n�t���n�e�a� �i�n�i�c�i�a�l�)�.� �\n�5�.� �U�n�a� �n�u�e�v�a� �t�r�a�n�s�a�c�c�i���n� �C� �c�o�m�i�e�n�z�a� �y� �v�e� �e�l� �v�a�l�o�r� �1�5�0� �(�e�l� �v�a�l�o�r� �c�o�n�f�i�r�m�a�d�o� �m���s� �r�e�c�i�e�n�t�e�)�.� �\n�6�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �B� �i�n�t�e�n�t�a� �a�c�t�u�a�l�i�z�a�r� �e�l� �v�a�l�o�r� �a� �2�0�0�.� �\n� � � �-� �E�n� �a�l�g�u�n�o�s� �s�i�s�t�e�m�a�s�,� �e�s�t�o� �c�a�u�s�a�r��� �u�n� �e�r�r�o�r� �d�e� �c�o�n�f�l�i�c�t�o� �d�e� �e�s�c�r�i�t�u�r�a�.� �\n� � � �-� �E�n� �o�t�r�o�s�,� �s�e� �p�e�r�m�i�t�i�r��� �p�e�r�o� �p�o�d�r���a� �g�e�n�e�r�a�r� �u�n� �c�o�n�f�l�i�c�t�o� �a�l� �h�a�c�e�r� �c�o�m�m�i�t�.� �\n� �\n�#�#� �V�e�n�t�a�j�a�s� �d�e� �M�V�C�C� �\n� �\n�1�.� ���M�a�y�o�r� �c�o�n�c�u�r�r�e�n�c�i�a���:� �P�e�r�m�i�t�e� �q�u�e� �l�a�s� �o�p�e�r�a�c�i�o�n�e�s� �d�e� �l�e�c�t�u�r�a� �y� �e�s�c�r�i�t�u�r�a� �s�e� �e�j�e�c�u�t�e�n� �s�i�m�u�l�t���n�e�a�m�e�n�t�e� �s�i�n� �b�l�o�q�u�e�o�s� �e�x�c�e�s�i�v�o�s�.� �\n� �\n�2�.� ���C�o�n�s�i�s�t�e�n�c�i�a� �d�e� �l�e�c�t�u�r�a���:� �L�a�s� �c�o�n�s�u�l�t�a�s� �s�i�e�m�p�r�e� �v�e�n� �u�n�a� �i�n�s�t�a�n�t���n�e�a� �c�o�n�s�i�s�t�e�n�t�e� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s�,� �i�n�c�l�u�s�o� �m�i�e�n�t�r�a�s� �o�t�r�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �e�s�t���n� �m�o�d�i�f�i�c�a�n�d�o� �l�o�s� �d�a�t�o�s�.� �\n� �\n�3�.� ���E�l�i�m�i�n�a�c�i���n� �d�e� �b�l�o�q�u�e�o�s� �p�a�r�a� �l�e�c�t�u�r�a�s���:� �L�a�s� �o�p�e�r�a�c�i�o�n�e�s� �d�e� �l�e�c�t�u�r�a� �n�o� �b�l�o�q�u�e�a�n� �l�a�s� �d�e� �e�s�c�r�i�t�u�r�a� �y� �v�i�c�e�v�e�r�s�a�.� �\n� �\n�4�.� ���R�e�d�u�c�c�i���n� �d�e� �d�e�a�d�l�o�c�k�s���:� �A�l� �m�i�n�i�m�i�z�a�r� �l�o�s� �b�l�o�q�u�e�o�s�,� �s�e� �r�e�d�u�c�e�n� �s�i�g�n�i�f�i�c�a�t�i�v�a�m�e�n�t�e� �l�a�s� �s�i�t�u�a�c�i�o�n�e�s� �d�e� �i�n�t�e�r�b�l�o�q�u�e�o� �(�d�e�a�d�l�o�c�k�)�.� �\n� �\n�5�.� ���M�e�j�o�r� �e�s�c�a�l�a�b�i�l�i�d�a�d���:� �P�e�r�m�i�t�e� �u�n� �m�a�y�o�r� �n���m�e�r�o� �d�e� �t�r�a�n�s�a�c�c�i�o�n�e�s� �c�o�n�c�u�r�r�e�n�t�e�s�,� �m�e�j�o�r�a�n�d�o� �e�l� �r�e�n�d�i�m�i�e�n�t�o� �g�e�n�e�r�a�l� �d�e�l� �s�i�s�t�e�m�a�.� �\n� �\n�#�#� �D�e�s�v�e�n�t�a�j�a�s� �y� �d�e�s�a�f���o�s� �\n� �\n�1�.� ���U�s�o� �d�e� �e�s�p�a�c�i�o���:� �M�a�n�t�e�n�e�r� �m���l�t�i�p�l�e�s� �v�e�r�s�i�o�n�e�s� �d�e� �l�o�s� �d�a�t�o�s� �c�o�n�s�u�m�e� �m���s� �e�s�p�a�c�i�o� �d�e� �a�l�m�a�c�e�n�a�m�i�e�n�t�o�.� �\n� �\n�2�.� ���C�o�m�p�l�e�j�i�d�a�d� �d�e� �i�m�p�l�e�m�e�n�t�a�c�i���n���:� �E�s� �m���s� �c�o�m�p�l�e�j�o� �d�e� �i�m�p�l�e�m�e�n�t�a�r� �q�u�e� �l�o�s� �s�i�s�t�e�m�a�s� �t�r�a�d�i�c�i�o�n�a�l�e�s� �d�e� �b�l�o�q�u�e�o�.� �\n� �\n�3�.� ���S�o�b�r�e�c�a�r�g�a� �d�e� �p�r�o�c�e�s�a�m�i�e�n�t�o���:� �L�a� �g�e�s�t�i���n� �d�e� �v�e�r�s�i�o�n�e�s� �y� �l�a� �d�e�t�e�r�m�i�n�a�c�i���n� �d�e� �v�i�s�i�b�i�l�i�d�a�d� �a���a�d�e�n� �c�i�e�r�t�a� �s�o�b�r�e�c�a�r�g�a� �d�e� �p�r�o�c�e�s�a�m�i�e�n�t�o�.� �\n� �\n�4�.� ���G�a�r�b�a�g�e� �c�o�l�l�e�c�t�i�o�n���:� �S�e� �r�e�q�u�i�e�r�e� �u�n� �p�r�o�c�e�s�o� �p�a�r�a� �e�l�i�m�i�n�a�r� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �q�u�e� �y�a� �n�o� �s�o�n� �n�e�c�e�s�a�r�i�a�s�.� �\n� �\n�5�.� ���A�n�o�m�a�l���a�s� �d�e� �e�s�c�r�i�t�u�r�a���:� �P�u�e�d�e�n� �s�u�r�g�i�r� �p�r�o�b�l�e�m�a�s� �c�o�m�o� �l�a� �a�c�t�u�a�l�i�z�a�c�i���n� �p�e�r�d�i�d�a� �s�i� �n�o� �s�e� �i�m�p�l�e�m�e�n�t�a�n� �c�o�r�r�e�c�t�a�m�e�n�t�e� �l�o�s� �m�e�c�a�n�i�s�m�o�s� �d�e� �d�e�t�e�c�c�i���n� �d�e� �c�o�n�f�l�i�c�t�o�s�.� �\n� �\n�#�#� �M�V�C�C� �e�n� �d�i�f�e�r�e�n�t�e�s� �s�i�s�t�e�m�a�s� �d�e� �b�a�s�e�s� �d�e� �d�a�t�o�s� �\n� �\n�#�#�#� �P�o�s�t�g�r�e�S�Q�L� �\n� �\n�P�o�s�t�g�r�e�S�Q�L� �i�m�p�l�e�m�e�n�t�a� �M�V�C�C� �d�e� �f�o�r�m�a� �n�a�t�i�v�a� �y� �e�s� �u�n�o� �d�e� �l�o�s� �s�i�s�t�e�m�a�s� �q�u�e� �m�e�j�o�r� �a�p�r�o�v�e�c�h�a� �e�s�t�a� �t���c�n�i�c�a�:� �\n� �\n�-� �C�a�d�a� �t�r�a�n�s�a�c�c�i���n� �r�e�c�i�b�e� �u�n� �I�D� �d�e� �t�r�a�n�s�a�c�c�i���n� �(�X�I�D�)� �a�l� �i�n�i�c�i�a�r�.� �\n�-� �C�a�d�a� �f�i�l�a� �t�i�e�n�e� �c�a�m�p�o�s� �o�c�u�l�t�o�s� �(��x�m�i�n��,� ��x�m�a�x��)� �q�u�e� �i�n�d�i�c�a�n� �q�u��� �t�r�a�n�s�a�c�c�i�o�n�e�s� �p�u�e�d�e�n� �v�e�r� �l�a� �f�i�l�a�.� �\n�-� �U�t�i�l�i�z�a� �V�A�C�U�U�M� �p�a�r�a� �l�i�m�p�i�a�r� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �d�e� �d�a�t�o�s�.� �\n� �\n����s�q�l� � �-�-� �P�o�s�t�g�r�e�S�Q�L� �u�t�i�l�i�z�a� �M�V�C�C� �e�n� �t�o�d�a�s� �l�a�s� �o�p�e�r�a�c�i�o�n�e�s� � �B�E�G�I�N�;� � �S�E�L�E�C�T� �*� �F�R�O�M� �p�r�o�d�u�c�t�o�s�;� � �-�-� �V�e� �u�n�a� �i�n�s�t�a�n�t���n�e�a� �c�o�n�s�i�s�t�e�n�t�e� � �-�-� �M�i�e�n�t�r�a�s� �t�a�n�t�o�,� �o�t�r�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �p�u�e�d�e�n� �m�o�d�i�f�i�c�a�r� �l�a� �t�a�b�l�a� � �C�O�M�M�I�T�;� � ���� �\n� �\n�#�#�#� �O�r�a�c�l�e� �\n� �\n�O�r�a�c�l�e� �t�a�m�b�i���n� �i�m�p�l�e�m�e�n�t�a� �M�V�C�C�,� �p�e�r�o� �c�o�n� �a�l�g�u�n�a�s� �d�i�f�e�r�e�n�c�i�a�s�:� �\n� �\n�-� �U�t�i�l�i�z�a� �S�C�N� �(�S�y�s�t�e�m� �C�h�a�n�g�e� �N�u�m�b�e�r�)� �e�n� �l�u�g�a�r� �d�e� �I�D�s� �d�e� �t�r�a�n�s�a�c�c�i���n�.� �\n�-� �A�l�m�a�c�e�n�a� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �e�n� �u�n� �s�e�g�m�e�n�t�o� �d�e� �r�o�l�l�b�a�c�k�.� �\n�-� �O�f�r�e�c�e� �l�a� �c�a�r�a�c�t�e�r���s�t�i�c�a� �"�F�l�a�s�h�b�a�c�k� �Q�u�e�r�y�"� �p�a�r�a� �c�o�n�s�u�l�t�a�r� �d�a�t�o�s� �h�i�s�t���r�i�c�o�s�.� �\n� �\n����s�q�l� � �-�-� �O�r�a�c�l�e� �p�e�r�m�i�t�e� �c�o�n�s�u�l�t�a�s� �a� �u�n� �p�u�n�t�o� �e�s�p�e�c���f�i�c�o� �e�n� �e�l� �t�i�e�m�p�o� � �S�E�L�E�C�T� �*� �F�R�O�M� �p�r�o�d�u�c�t�o�s� � � �A�S� �O�F� �T�I�M�E�S�T�A�M�P� �T�O�_�T�I�M�E�S�T�A�M�P�(�'�2�0�2�5�-�0�4�-�0�1� �1�2�:�0�0�:�0�0�'�,� �'�Y�Y�Y�Y�-�M�M�-�D�D� �H�H�2�4�:�M�I�:�S�S�'�)�;� � ���� �\n� �\n�#�#�#� �M�y�S�Q�L� �(�I�n�n�o�D�B�)� �\n� �\n�I�n�n�o�D�B� �i�m�p�l�e�m�e�n�t�a� �M�V�C�C� �j�u�n�t�o� �c�o�n� �b�l�o�q�u�e�o�s�:� �\n� �\n�-� �M�a�n�t�i�e�n�e� �u�n� �"�u�n�d�o� �l�o�g�"� �c�o�n� �v�e�r�s�i�o�n�e�s� �a�n�t�e�r�i�o�r�e�s� �d�e� �l�o�s� �r�e�g�i�s�t�r�o�s�.� �\n�-� �U�t�i�l�i�z�a� �b�l�o�q�u�e�o�s� �d�e� �f�i�l�a� �p�a�r�a� �o�p�e�r�a�c�i�o�n�e�s� �d�e� �e�s�c�r�i�t�u�r�a�.� �\n�-� �C�o�m�b�i�n�a� �M�V�C�C� �c�o�n� �b�l�o�q�u�e�o�s� �p�a�r�a� �p�r�o�p�o�r�c�i�o�n�a�r� �d�i�f�e�r�e�n�t�e�s� �n�i�v�e�l�e�s� �d�e� �a�i�s�l�a�m�i�e�n�t�o�.� �\n� �\n����s�q�l� � �-�-� �M�y�S�Q�L� �c�o�n� �I�n�n�o�D�B� �u�t�i�l�i�z�a� �M�V�C�C� �p�a�r�a� �l�e�c�t�u�r�a�s� �c�o�n�s�i�s�t�e�n�t�e�s� � �S�E�T� �T�R�A�N�S�A�C�T�I�O�N� �I�S�O�L�A�T�I�O�N� �L�E�V�E�L� �R�E�P�E�A�T�A�B�L�E� �R�E�A�D�;� � �B�E�G�I�N�;� � �S�E�L�E�C�T� �*� �F�R�O�M� �p�r�o�d�u�c�t�o�s�;� � �-�-� �O�t�r�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �p�u�e�d�e�n� �m�o�d�i�f�i�c�a�r� �l�a� �t�a�b�l�a� �s�i�n� �a�f�e�c�t�a�r� �e�s�t�a� �v�i�s�t�a� � �C�O�M�M�I�T�;� � ���� �\n� �\n�#�#�#� �S�Q�L� �S�e�r�v�e�r� �\n� �\n�S�Q�L� �S�e�r�v�e�r� �i�m�p�l�e�m�e�n�t�a� �u�n�a� �f�o�r�m�a� �d�e� �M�V�C�C� �l�l�a�m�a�d�a� �"�V�e�r�s�i�o�n�i�n�g� �d�e� �f�i�l�a�"�:� �\n� �\n�-� �D�i�s�p�o�n�i�b�l�e� �d�e�s�d�e� �S�Q�L� �S�e�r�v�e�r� �2�0�0�5� �c�o�n� �e�l� �n�i�v�e�l� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �"�R�E�A�D� �C�O�M�M�I�T�T�E�D� �S�N�A�P�S�H�O�T�"�.� �\n�-� �A�l�m�a�c�e�n�a� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �e�n� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �t�e�m�p�d�b�.� �\n�-� �P�e�r�m�i�t�e� �c�o�n�f�i�g�u�r�a�r� �e�l� �c�o�m�p�o�r�t�a�m�i�e�n�t�o� �a� �n�i�v�e�l� �d�e� �b�a�s�e� �d�e� �d�a�t�o�s�.� �\n� �\n����s�q�l� � �-�-� �H�a�b�i�l�i�t�a�r� �M�V�C�C� �e�n� �S�Q�L� �S�e�r�v�e�r� � �A�L�T�E�R� �D�A�T�A�B�A�S�E� �M�i�B�a�s�e�D�e�D�a�t�o�s� � �S�E�T� �R�E�A�D�_�C�O�M�M�I�T�T�E�D�_�S�N�A�P�S�H�O�T� �O�N�;� � ���� �\n� �\n�#�#� �N�i�v�e�l�e�s� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �y� �M�V�C�C� �\n� �\n�M�V�C�C� �p�e�r�m�i�t�e� �i�m�p�l�e�m�e�n�t�a�r� �d�i�f�e�r�e�n�t�e�s� �n�i�v�e�l�e�s� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �s�i�n� �d�e�p�e�n�d�e�r� �e�x�c�l�u�s�i�v�a�m�e�n�t�e� �d�e� �b�l�o�q�u�e�o�s�:� �\n� �\n�#�#�#� �R�E�A�D� �C�O�M�M�I�T�T�E�D� �\n� �\n�-� �L�a� �t�r�a�n�s�a�c�c�i���n� �s�o�l�o� �v�e� �d�a�t�o�s� �c�o�n�f�i�r�m�a�d�o�s�.� �\n�-� �C�a�d�a� �s�e�n�t�e�n�c�i�a� �v�e� �l�a� ���l�t�i�m�a� �v�e�r�s�i���n� �c�o�n�f�i�r�m�a�d�a� �a�l� �m�o�m�e�n�t�o� �d�e� �e�j�e�c�u�t�a�r�s�e�.� �\n�-� �P�u�e�d�e� �d�a�r� �l�u�g�a�r� �a� �l�e�c�t�u�r�a�s� �n�o� �r�e�p�e�t�i�b�l�e�s�.� �\n� �\n�#�#�#� �R�E�P�E�A�T�A�B�L�E� �R�E�A�D� �\n� �\n�-� �L�a� �t�r�a�n�s�a�c�c�i���n� �v�e� �l�a� �m�i�s�m�a� �i�n�s�t�a�n�t���n�e�a� �d�u�r�a�n�t�e� �t�o�d�a� �s�u� �d�u�r�a�c�i���n�.� �\n�-� �G�a�r�a�n�t�i�z�a� �q�u�e� �l�a�s� �l�e�c�t�u�r�a�s� �r�e�p�e�t�i�d�a�s� �d�e�v�u�e�l�v�a�n� �l�o�s� �m�i�s�m�o�s� �r�e�s�u�l�t�a�d�o�s�.� �\n�-� �P�u�e�d�e� �p�e�r�m�i�t�i�r� �l�e�c�t�u�r�a�s� �f�a�n�t�a�s�m�a� �e�n� �a�l�g�u�n�o�s� �s�i�s�t�e�m�a�s�.� �\n� �\n�#�#�#� �S�E�R�I�A�L�I�Z�A�B�L�E� �\n� �\n�-� �P�r�o�p�o�r�c�i�o�n�a� �e�l� �m�a�y�o�r� �n�i�v�e�l� �d�e� �a�i�s�l�a�m�i�e�n�t�o�.� �\n�-� �E�n� �s�i�s�t�e�m�a�s� �M�V�C�C�,� �g�e�n�e�r�a�l�m�e�n�t�e� �s�e� �i�m�p�l�e�m�e�n�t�a� �v�e�r�i�f�i�c�a�n�d�o� �c�o�n�f�l�i�c�t�o�s� �a�l� �c�o�n�f�i�r�m�a�r� �l�a� �t�r�a�n�s�a�c�c�i���n�.� �\n�-� �P�u�e�d�e� �r�e�q�u�e�r�i�r� �b�l�o�q�u�e�o�s� �a�d�i�c�i�o�n�a�l�e�s� �o� �v�e�r�i�f�i�c�a�c�i�o�n�e�s� �d�e� �p�r�e�d�i�c�a�d�o�s�.� �\n� �\n�#�#� �E�j�e�m�p�l�o� �p�r���c�t�i�c�o� �d�e� �M�V�C�C� �\n� �\n�C�o�n�s�i�d�e�r�e�m�o�s� �u�n� �e�s�c�e�n�a�r�i�o� �c�o�n� �u�n�a� �t�a�b�l�a� �d�e� �i�n�v�e�n�t�a�r�i�o�:� �\n� �\n����s�q�l� � �C�R�E�A�T�E� �T�A�B�L�E� �i�n�v�e�n�t�a�r�i�o� �(� � � � � � �p�r�o�d�u�c�t�o�_�i�d� �I�N�T� �P�R�I�M�A�R�Y� �K�E�Y�,� � � � � � �n�o�m�b�r�e� �V�A�R�C�H�A�R�(�1�0�0�)�,� � � � � � �s�t�o�c�k� �I�N�T� � �)�;� � � � �I�N�S�E�R�T� �I�N�T�O� �i�n�v�e�n�t�a�r�i�o� �V�A�L�U�E�S� �(�1�,� �'�L�a�p�t�o�p�'�,� �1�0�)�;� � ���� �\n� �\n�C�o�n� �M�V�C�C�,� �p�o�d�r���a�m�o�s� �t�e�n�e�r� �l�a�s� �s�i�g�u�i�e�n�t�e�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �c�o�n�c�u�r�r�e�n�t�e�s�:� �\n� �\n����s�q�l� � �-�-� �T�r�a�n�s�a�c�c�i���n� �1�:� �C�o�n�s�u�l�t�a� �d�e� �i�n�v�e�n�t�a�r�i�o� � �B�E�G�I�N� �T�R�A�N�S�A�C�T�I�O�N�;� � �S�E�L�E�C�T� �*� �F�R�O�M� �i�n�v�e�n�t�a�r�i�o� �W�H�E�R�E� �p�r�o�d�u�c�t�o�_�i�d� �=� �1�;� � �-�-� �V�e� �s�t�o�c�k� �=� �1�0� � � � �-�-� �M�i�e�n�t�r�a�s� �t�a�n�t�o�,� �l�a� �T�r�a�n�s�a�c�c�i���n� �2� �s�e� �e�j�e�c�u�t�a� �y� �c�o�n�f�i�r�m�a� � �-�-� �T�r�a�n�s�a�c�c�i���n� �2�:� �A�c�t�u�a�l�i�z�a�c�i���n� �d�e� �i�n�v�e�n�t�a�r�i�o� � �B�E�G�I�N� �T�R�A�N�S�A�C�T�I�O�N�;� � �U�P�D�A�T�E� �i�n�v�e�n�t�a�r�i�o� �S�E�T� �s�t�o�c�k� �=� �s�t�o�c�k� �-� �3� �W�H�E�R�E� �p�r�o�d�u�c�t�o�_�i�d� �=� �1�;� � �C�O�M�M�I�T�;� � � � �-�-� �D�e� �v�u�e�l�t�a� �e�n� �l�a� �T�r�a�n�s�a�c�c�i���n� �1� � �S�E�L�E�C�T� �*� �F�R�O�M� �i�n�v�e�n�t�a�r�i�o� �W�H�E�R�E� �p�r�o�d�u�c�t�o�_�i�d� �=� �1�;� � �-�-� �A���n� �v�e� �s�t�o�c�k� �=� �1�0� � �-�-� �p�o�r�q�u�e� �e�s�t��� �v�i�e�n�d�o� �s�u� �i�n�s�t�a�n�t���n�e�a� �o�r�i�g�i�n�a�l� � �C�O�M�M�I�T�;� � � � �-�-� �U�n�a� �n�u�e�v�a� �T�r�a�n�s�a�c�c�i���n� �3� �v�e�r���a� �e�l� �v�a�l�o�r� �a�c�t�u�a�l�i�z�a�d�o� � �B�E�G�I�N� �T�R�A�N�S�A�C�T�I�O�N�;� � �S�E�L�E�C�T� �*� �F�R�O�M� �i�n�v�e�n�t�a�r�i�o� �W�H�E�R�E� �p�r�o�d�u�c�t�o�_�i�d� �=� �1�;� � �-�-� �V�e� �s�t�o�c�k� �=� �7� � �C�O�M�M�I�T�;� � ���� �\n� �\n�#�#� �M�e�j�o�r�e�s� �p�r���c�t�i�c�a�s� �a�l� �t�r�a�b�a�j�a�r� �c�o�n� �M�V�C�C� �\n� �\n�1�.� ���T�r�a�n�s�a�c�c�i�o�n�e�s� �c�o�r�t�a�s���:� �M�a�n�t���n� �l�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �l�o� �m���s� �c�o�r�t�a�s� �p�o�s�i�b�l�e� �p�a�r�a� �r�e�d�u�c�i�r� �l�a� �a�c�u�m�u�l�a�c�i���n� �d�e� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s�.� �\n� �\n�2�.� ���M�a�n�t�e�n�i�m�i�e�n�t�o� �r�e�g�u�l�a�r���:� �C�o�n�f�i�g�u�r�a� �p�r�o�c�e�s�o�s� �d�e� �l�i�m�p�i�e�z�a� �(�c�o�m�o� �V�A�C�U�U�M� �e�n� �P�o�s�t�g�r�e�S�Q�L�)� �p�a�r�a� �e�l�i�m�i�n�a�r� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s�.� �\n� �\n�3�.� ���M�o�n�i�t�o�r�e�o���:� �V�i�g�i�l�a� �e�l� �c�r�e�c�i�m�i�e�n�t�o� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �y� �l�o�s� �s�e�g�m�e�n�t�o�s� �d�e� �r�o�l�l�b�a�c�k�/�u�n�d�o�.� �\n� �\n�4�.� ���N�i�v�e�l�e�s� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �a�d�e�c�u�a�d�o�s���:� �E�l�i�g�e� �e�l� �n�i�v�e�l� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �a�p�r�o�p�i�a�d�o� �s�e�g���n� �t�u�s� �n�e�c�e�s�i�d�a�d�e�s� �d�e� �c�o�n�s�i�s�t�e�n�c�i�a� �y� �r�e�n�d�i�m�i�e�n�t�o�.� �\n� �\n�5�.� ���E�v�i�t�a� �t�r�a�n�s�a�c�c�i�o�n�e�s� �d�e� �l�a�r�g�a� �d�u�r�a�c�i���n���:� �E�s�t�a�s� �p�u�e�d�e�n� �i�m�p�e�d�i�r� �l�a� �l�i�m�p�i�e�z�a� �d�e� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �y� �c�a�u�s�a�r� �c�r�e�c�i�m�i�e�n�t�o� �e�x�c�e�s�i�v�o� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s�.� �\n� �\n�#�#� �C�o�n�c�l�u�s�i���n� �\n� �\n�M�V�C�C� �e�s� �u�n�a� �t���c�n�i�c�a� �s�o�f�i�s�t�i�c�a�d�a� �q�u�e� �p�e�r�m�i�t�e� �a� �l�a�s� �b�a�s�e�s� �d�e� �d�a�t�o�s� �m�o�d�e�r�n�a�s� �m�a�n�e�j�a�r� �a�l�t�o�s� �n�i�v�e�l�e�s� �d�e� �c�o�n�c�u�r�r�e�n�c�i�a� �s�i�n� �s�a�c�r�i�f�i�c�a�r� �l�a� �c�o�n�s�i�s�t�e�n�c�i�a�.� �A�l� �c�r�e�a�r� �m���l�t�i�p�l�e�s� �v�e�r�s�i�o�n�e�s� �d�e� �l�o�s� �d�a�t�o�s� �e�n� �l�u�g�a�r� �d�e� �b�l�o�q�u�e�a�r�l�o�s�,� �M�V�C�C� �o�f�r�e�c�e� �u�n� �e�q�u�i�l�i�b�r�i�o� ���p�t�i�m�o� �e�n�t�r�e� �r�e�n�d�i�m�i�e�n�t�o� �y� �c�o�n�s�i�s�t�e�n�c�i�a�.� �\n� �\n�A�u�n�q�u�e� �s�u� �i�m�p�l�e�m�e�n�t�a�c�i���n� �v�a�r���a� �e�n�t�r�e� �l�o�s� �d�i�f�e�r�e�n�t�e�s� �s�i�s�t�e�m�a�s� �d�e� �g�e�s�t�i���n� �d�e� �b�a�s�e�s� �d�e� �d�a�t�o�s�,� �c�o�m�p�r�e�n�d�e�r� �l�o�s� �p�r�i�n�c�i�p�i�o�s� �f�u�n�d�a�m�e�n�t�a�l�e�s� �d�e� �M�V�C�C� �e�s� �e�s�e�n�c�i�a�l� �p�a�r�a� �d�e�s�a�r�r�o�l�l�a�r� �a�p�l�i�c�a�c�i�o�n�e�s� �e�f�i�c�i�e�n�t�e�s� �q�u�e� �a�p�r�o�v�e�c�h�e�n� �a�l� �m���x�i�m�o� �l�a� �c�o�n�c�u�r�r�e�n�c�i�a� �e�n� �e�n�t�o�r�n�o�s� �d�e� �b�a�s�e�s� �d�e� �d�a�t�o�s� �r�e�l�a�c�i�o�n�a�l�e�s�.� �\n� �\n�:�:�A�p�p�S�u�r�r�o�u�n�d�{�:�s�u�r�r�o�u�n�d�=�'�s�u�r�r�o�u�n�d�'�}� �\n�:�:� �\n� �\n�<�A�p�p�A�p�a�S�e�p�t�i�m�a� �\n� � �:�r�e�f�e�r�e�n�c�e�s�=�'�� �\n� � � � �{� �\n� � � � � � �"�t�i�t�l�e�"�:� �"�P�o�s�t�g�r�e�S�Q�L� �D�o�c�u�m�e�n�t�a�t�i�o�n�:� �M�V�C�C�"�,� �\n� � � � � � �"�a�u�t�h�o�r�"�:� �"�P�o�s�t�g�r�e�S�Q�L� �G�l�o�b�a�l� �D�e�v�e�l�o�p�m�e�n�t� �G�r�o�u�p�"�,� �\n� � � � � � �"�u�r�l�"�:� �"�h�t�t�p�s�:�/�/�w�w�w�.�p�o�s�t�g�r�e�s�q�l�.�o�r�g�/�d�o�c�s�/�c�u�r�r�e�n�t�/�m�v�c�c�-�i�n�t�r�o�.�h�t�m�l�"� �\n� � � � �}�,� �\n� � � � �{� �\n� � � � � � �"�t�i�t�l�e�"�:� �"�U�n�d�e�r�s�t�a�n�d�i�n�g� �M�V�C�C� �i�n� �O�r�a�c�l�e� �D�a�t�a�b�a�s�e�"�,� �\n� � � � � � �"�a�u�t�h�o�r�"�:� �"�O�r�a�c�l�e� �D�o�c�u�m�e�n�t�a�t�i�o�n�"�,� �\n� � � � � � �"�u�r�l�"�:� �"�h�t�t�p�s�:�/�/�d�o�c�s�.�o�r�a�c�l�e�.�c�o�m�/�e�n�/�d�a�t�a�b�a�s�e�/�o�r�a�c�l�e�/�o�r�a�c�l�e�-�d�a�t�a�b�a�s�e�/�1�9�/�c�n�c�p�t�/�d�a�t�a�-�c�o�n�c�u�r�r�e�n�c�y�-�a�n�d�-�c�o�n�s�i�s�t�e�n�c�y�.�h�t�m�l�"� �\n� � � � �}�,� �\n� � � � �{� �\n� � � � � � �"�t�i�t�l�e�"�:� �"�T�r�a�n�s�a�c�t�i�o�n� �P�r�o�c�e�s�s�i�n�g�:� �C�o�n�c�e�p�t�s� �a�n�d� �T�e�c�h�n�i�q�u�e�s�"�,� �\n� � � � � � �"�a�u�t�h�o�r�"�:� �"�J�i�m� �G�r�a�y� �a�n�d� �A�n�d�r�e�a�s� �R�e�u�t�e�r�"�,� �\n� � � � � � �"�u�r�l�"�:� �"�h�t�t�p�s�:�/�/�d�l�.�a�c�m�.�o�r�g�/�d�o�i�/�b�o�o�k�/�1�0�.�5�5�5�5�/�5�7�3�3�0�4�"� �\n� � � � �}� �\n� � ��'� �\n�/�>� �\n�
��-�-�-�
�
�t�i�t�l�e�:� �M�V�C�C� �-� �C�o�n�t�r�o�l� �d�e� �C�o�n�c�u�r�r�e�n�c�i�a� �M�u�l�t�i�v�e�r�s�i���n�
�
�d�e�s�c�r�i�p�t�i�o�n�:� �A�p�r�e�n�d�e� �s�o�b�r�e� �M�V�C�C� �(�C�o�n�t�r�o�l� �d�e� �C�o�n�c�u�r�r�e�n�c�i�a� �M�u�l�t�i�v�e�r�s�i���n�)�,� �u�n� �m�e�c�a�n�i�s�m�o� �a�v�a�n�z�a�d�o� �q�u�e� �p�e�r�m�i�t�e� �a� �l�a�s� �b�a�s�e�s� �d�e� �d�a�t�o�s� �g�e�s�t�i�o�n�a�r� �e�l� �a�c�c�e�s�o� �c�o�n�c�u�r�r�e�n�t�e� �a� �l�o�s� �d�a�t�o�s� �s�i�n� �b�l�o�q�u�e�o�s� �e�x�c�e�s�i�v�o�s�.�
�
�i�c�o�n�:� �m�a�t�e�r�i�a�l�-�s�y�m�b�o�l�s�:�c�o�d�e�-�r�o�u�n�d�e�d�
�
�p�u�b�l�i�s�h�e�d�:� �t�r�u�e�
�
�k�e�y�w�o�r�d�s�:� �s�q�l�,� �m�v�c�c�,� �c�o�n�t�r�o�l� �d�e� �c�o�n�c�u�r�r�e�n�c�i�a�,� �m�u�l�t�i�v�e�r�s�i���n�,� �t�r�a�n�s�a�c�c�i�o�n�e�s�,� �p�o�s�t�g�r�e�s�q�l�,� �o�r�a�c�l�e�,� �s�n�a�p�s�h�o�t�,� �a�i�s�l�a�m�i�e�n�t�o�
�
�c�a�t�e�g�o�r�i�e�s�:� ��s�q�l�,� �p�r�o�g�r�a�m�a�c�i���n�,� �d�e�s�a�r�r�o�l�l�o�,� �b�a�s�e� �d�e� �d�a�t�o�s��
�
�a�u�t�h�o�r�:�
�
� � �n�a�m�e�:� �C�r�i�s�t�i�a�n� �E�s�c�a�l�a�n�t�e�
�
� � �u�r�l�:� �h�t�t�p�s�:�/�/�g�i�t�h�u�b�.�c�o�m�/�c�a�e�h�e�r�
�
� � �i�m�a�g�e�:� �h�t�t�p�s�:�/�/�a�v�a�t�a�r�s�.�g�i�t�h�u�b�u�s�e�r�c�o�n�t�e�n�t�.�c�o�m�/�u�/�6�0�1�2�0�6�0�3�?�v�=�4�
�
�c�r�e�a�t�e�d�A�t�:� �2�0�2�5�-�0�5�-�1�2�T�0�0�:�0�0�:�0�0�Z�
�
�u�p�d�a�t�e�d�A�t�:� �2�0�2�5�-�0�5�-�1�2�T�0�0�:�0�0�:�0�0�Z�
�
�-�-�-�
�
�
�
�#�#� ���Q�u��� �e�s� �M�V�C�C�?�
�
�
�
�M�V�C�C� �(�M�u�l�t�i�v�e�r�s�i�o�n� �C�o�n�c�u�r�r�e�n�c�y� �C�o�n�t�r�o�l�)� �o� �C�o�n�t�r�o�l� �d�e� �C�o�n�c�u�r�r�e�n�c�i�a� �M�u�l�t�i�v�e�r�s�i���n� �e�s� �u�n�a� �t���c�n�i�c�a� �a�v�a�n�z�a�d�a� �u�t�i�l�i�z�a�d�a� �p�o�r� �m�u�c�h�o�s� �s�i�s�t�e�m�a�s� �d�e� �g�e�s�t�i���n� �d�e� �b�a�s�e�s� �d�e� �d�a�t�o�s� �r�e�l�a�c�i�o�n�a�l�e�s� �p�a�r�a� �p�e�r�m�i�t�i�r� �q�u�e� �m���l�t�i�p�l�e�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �a�c�c�e�d�a�n� �s�i�m�u�l�t���n�e�a�m�e�n�t�e� �a� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �s�i�n� �i�n�t�e�r�f�e�r�i�r� �e�n�t�r�e� �s���.�
�
�
�
�A� �d�i�f�e�r�e�n�c�i�a� �d�e� �l�o�s� �s�i�s�t�e�m�a�s� �t�r�a�d�i�c�i�o�n�a�l�e�s� �d�e� �b�l�o�q�u�e�o�,� �M�V�C�C� �c�r�e�a� �m���l�t�i�p�l�e�s� �"�v�e�r�s�i�o�n�e�s�"� �d�e� �l�o�s� �d�a�t�o�s�,� �p�e�r�m�i�t�i�e�n�d�o� �q�u�e� �l�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �v�e�a�n� �u�n�a� �i�n�s�t�a�n�t���n�e�a� �c�o�n�s�i�s�t�e�n�t�e� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �s�i�n� �n�e�c�e�s�i�d�a�d� �d�e� �b�l�o�q�u�e�a�r� �r�e�g�i�s�t�r�o�s� �p�a�r�a� �l�e�c�t�u�r�a�s�.�
�
�
�
�#�#� �P�r�i�n�c�i�p�i�o�s� �f�u�n�d�a�m�e�n�t�a�l�e�s� �d�e� �M�V�C�C�
�
�
�
�E�l� �f�u�n�c�i�o�n�a�m�i�e�n�t�o� �d�e� �M�V�C�C� �s�e� �b�a�s�a� �e�n� �v�a�r�i�o�s� �p�r�i�n�c�i�p�i�o�s� �c�l�a�v�e�:�
�
�
�
�1�.� ���V�e�r�s�i�o�n�a�d�o� �d�e� �d�a�t�o�s���:� �C�a�d�a� �v�e�z� �q�u�e� �s�e� �m�o�d�i�f�i�c�a� �u�n� �r�e�g�i�s�t�r�o�,� �s�e� �c�r�e�a� �u�n�a� �n�u�e�v�a� �v�e�r�s�i���n� �e�n� �l�u�g�a�r� �d�e� �s�o�b�r�e�s�c�r�i�b�i�r� �l�a� �e�x�i�s�t�e�n�t�e�.�
�
�
�
�2�.� ���V�i�s�i�b�i�l�i�d�a�d� �b�a�s�a�d�a� �e�n� �t�r�a�n�s�a�c�c�i�o�n�e�s���:� �C�a�d�a� �t�r�a�n�s�a�c�c�i���n� �s�o�l�o� �v�e� �l�a�s� �v�e�r�s�i�o�n�e�s� �d�e� �d�a�t�o�s� �q�u�e� �s�o�n� �r�e�l�e�v�a�n�t�e�s� �p�a�r�a� �e�l�l�a�,� �s�e�g���n� �s�u� �t�i�e�m�p�o� �d�e� �i�n�i�c�i�o�.�
�
�
�
�3�.� ���G�a�r�b�a�g�e� �c�o�l�l�e�c�t�i�o�n���:� �L�a�s� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �d�e� �l�o�s� �d�a�t�o�s� �s�e� �e�l�i�m�i�n�a�n� �c�u�a�n�d�o� �y�a� �n�o� �s�o�n� �n�e�c�e�s�a�r�i�a�s� �p�a�r�a� �n�i�n�g�u�n�a� �t�r�a�n�s�a�c�c�i���n� �a�c�t�i�v�a�.�
�
�
�
�4�.� ���T�i�m�e�s�t�a�m�p�s� �o� �i�d�e�n�t�i�f�i�c�a�d�o�r�e�s� �d�e� �t�r�a�n�s�a�c�c�i���n���:� �S�e� �u�t�i�l�i�z�a�n� �p�a�r�a� �d�e�t�e�r�m�i�n�a�r� �q�u��� �v�e�r�s�i�o�n�e�s� �d�e� �l�o�s� �d�a�t�o�s� �s�o�n� �v�i�s�i�b�l�e�s� �p�a�r�a� �c�a�d�a� �t�r�a�n�s�a�c�c�i���n�.�
�
�
�
�#�#� �F�u�n�c�i�o�n�a�m�i�e�n�t�o� �d�e� �M�V�C�C�
�
�
�
�#�#�#� �P�r�o�c�e�s�o� �b���s�i�c�o�
�
�
�
�1�.� ���L�e�c�t�u�r�a� �d�e� �d�a�t�o�s���:�
�
� � � �-� �C�u�a�n�d�o� �u�n�a� �t�r�a�n�s�a�c�c�i���n� �l�e�e� �d�a�t�o�s�,� �v�e� �u�n�a� �"�i�n�s�t�a�n�t���n�e�a�"� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �t�a�l� �c�o�m�o� �e�s�t�a�b�a� �a�l� �i�n�i�c�i�o� �d�e� �l�a� �t�r�a�n�s�a�c�c�i���n�.�
�
� � � �-� �S�o�l�o� �v�e� �l�o�s� �c�a�m�b�i�o�s� �c�o�n�f�i�r�m�a�d�o�s� �a�n�t�e�s� �d�e�l� �i�n�i�c�i�o� �d�e� �s�u� �t�r�a�n�s�a�c�c�i���n�.�
�
� � � �-� �N�o� �v�e� �l�o�s� �c�a�m�b�i�o�s� �r�e�a�l�i�z�a�d�o�s� �p�o�r� �t�r�a�n�s�a�c�c�i�o�n�e�s� �c�o�n�c�u�r�r�e�n�t�e�s� �q�u�e� �a���n� �n�o� �s�e� �h�a�n� �c�o�n�f�i�r�m�a�d�o� �o� �q�u�e� �s�e� �c�o�n�f�i�r�m�a�r�o�n� �d�e�s�p�u���s� �d�e�l� �i�n�i�c�i�o� �d�e� �l�a� �t�r�a�n�s�a�c�c�i���n� �a�c�t�u�a�l�.�
�
�
�
�2�.� ���E�s�c�r�i�t�u�r�a� �d�e� �d�a�t�o�s���:�
�
� � � �-� �C�u�a�n�d�o� �u�n�a� �t�r�a�n�s�a�c�c�i���n� �m�o�d�i�f�i�c�a� �d�a�t�o�s�,� �c�r�e�a� �n�u�e�v�a�s� �v�e�r�s�i�o�n�e�s� �d�e� �l�o�s� �r�e�g�i�s�t�r�o�s� �a�f�e�c�t�a�d�o�s�.�
�
� � � �-� �L�a�s� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �s�e� �m�a�n�t�i�e�n�e�n� �p�a�r�a� �l�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �q�u�e� �y�a� �e�s�t�a�b�a�n� �e�n� �c�u�r�s�o�.�
�
� � � �-� �L�a�s� �n�u�e�v�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �v�e�r���n� �l�a�s� �v�e�r�s�i�o�n�e�s� �m���s� �r�e�c�i�e�n�t�e�s� �(�s�i� �y�a� �e�s�t���n� �c�o�n�f�i�r�m�a�d�a�s�)�.�
�
�
�
�#�#�#� �E�j�e�m�p�l�o� �d�e� �f�u�n�c�i�o�n�a�m�i�e�n�t�o�
�
�
�
�S�u�p�o�n�g�a�m�o�s� �q�u�e� �t�e�n�e�m�o�s� �u�n� �r�e�g�i�s�t�r�o� �c�o�n� �u�n� �v�a�l�o�r� �i�n�i�c�i�a�l� �d�e� �1�0�0�:�
�
�
�
�1�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �A� �c�o�m�i�e�n�z�a� �y� �l�e�e� �e�l� �v�a�l�o�r� �1�0�0�.�
�
�2�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �B� �c�o�m�i�e�n�z�a� �y� �t�a�m�b�i���n� �l�e�e� �e�l� �v�a�l�o�r� �1�0�0�.�
�
�3�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �A� �a�c�t�u�a�l�i�z�a� �e�l� �v�a�l�o�r� �a� �1�5�0� �y� �h�a�c�e� �c�o�m�m�i�t�.�
�
�4�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �B� �a���n� �v�e� �e�l� �v�a�l�o�r� �1�0�0� �(�s�u� �i�n�s�t�a�n�t���n�e�a� �i�n�i�c�i�a�l�)�.�
�
�5�.� �U�n�a� �n�u�e�v�a� �t�r�a�n�s�a�c�c�i���n� �C� �c�o�m�i�e�n�z�a� �y� �v�e� �e�l� �v�a�l�o�r� �1�5�0� �(�e�l� �v�a�l�o�r� �c�o�n�f�i�r�m�a�d�o� �m���s� �r�e�c�i�e�n�t�e�)�.�
�
�6�.� �L�a� �t�r�a�n�s�a�c�c�i���n� �B� �i�n�t�e�n�t�a� �a�c�t�u�a�l�i�z�a�r� �e�l� �v�a�l�o�r� �a� �2�0�0�.�
�
� � � �-� �E�n� �a�l�g�u�n�o�s� �s�i�s�t�e�m�a�s�,� �e�s�t�o� �c�a�u�s�a�r��� �u�n� �e�r�r�o�r� �d�e� �c�o�n�f�l�i�c�t�o� �d�e� �e�s�c�r�i�t�u�r�a�.�
�
� � � �-� �E�n� �o�t�r�o�s�,� �s�e� �p�e�r�m�i�t�i�r��� �p�e�r�o� �p�o�d�r���a� �g�e�n�e�r�a�r� �u�n� �c�o�n�f�l�i�c�t�o� �a�l� �h�a�c�e�r� �c�o�m�m�i�t�.�
�
�
�
�#�#� �V�e�n�t�a�j�a�s� �d�e� �M�V�C�C�
�
�
�
�1�.� ���M�a�y�o�r� �c�o�n�c�u�r�r�e�n�c�i�a���:� �P�e�r�m�i�t�e� �q�u�e� �l�a�s� �o�p�e�r�a�c�i�o�n�e�s� �d�e� �l�e�c�t�u�r�a� �y� �e�s�c�r�i�t�u�r�a� �s�e� �e�j�e�c�u�t�e�n� �s�i�m�u�l�t���n�e�a�m�e�n�t�e� �s�i�n� �b�l�o�q�u�e�o�s� �e�x�c�e�s�i�v�o�s�.�
�
�
�
�2�.� ���C�o�n�s�i�s�t�e�n�c�i�a� �d�e� �l�e�c�t�u�r�a���:� �L�a�s� �c�o�n�s�u�l�t�a�s� �s�i�e�m�p�r�e� �v�e�n� �u�n�a� �i�n�s�t�a�n�t���n�e�a� �c�o�n�s�i�s�t�e�n�t�e� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s�,� �i�n�c�l�u�s�o� �m�i�e�n�t�r�a�s� �o�t�r�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �e�s�t���n� �m�o�d�i�f�i�c�a�n�d�o� �l�o�s� �d�a�t�o�s�.�
�
�
�
�3�.� ���E�l�i�m�i�n�a�c�i���n� �d�e� �b�l�o�q�u�e�o�s� �p�a�r�a� �l�e�c�t�u�r�a�s���:� �L�a�s� �o�p�e�r�a�c�i�o�n�e�s� �d�e� �l�e�c�t�u�r�a� �n�o� �b�l�o�q�u�e�a�n� �l�a�s� �d�e� �e�s�c�r�i�t�u�r�a� �y� �v�i�c�e�v�e�r�s�a�.�
�
�
�
�4�.� ���R�e�d�u�c�c�i���n� �d�e� �d�e�a�d�l�o�c�k�s���:� �A�l� �m�i�n�i�m�i�z�a�r� �l�o�s� �b�l�o�q�u�e�o�s�,� �s�e� �r�e�d�u�c�e�n� �s�i�g�n�i�f�i�c�a�t�i�v�a�m�e�n�t�e� �l�a�s� �s�i�t�u�a�c�i�o�n�e�s� �d�e� �i�n�t�e�r�b�l�o�q�u�e�o� �(�d�e�a�d�l�o�c�k�)�.�
�
�
�
�5�.� ���M�e�j�o�r� �e�s�c�a�l�a�b�i�l�i�d�a�d���:� �P�e�r�m�i�t�e� �u�n� �m�a�y�o�r� �n���m�e�r�o� �d�e� �t�r�a�n�s�a�c�c�i�o�n�e�s� �c�o�n�c�u�r�r�e�n�t�e�s�,� �m�e�j�o�r�a�n�d�o� �e�l� �r�e�n�d�i�m�i�e�n�t�o� �g�e�n�e�r�a�l� �d�e�l� �s�i�s�t�e�m�a�.�
�
�
�
�#�#� �D�e�s�v�e�n�t�a�j�a�s� �y� �d�e�s�a�f���o�s�
�
�
�
�1�.� ���U�s�o� �d�e� �e�s�p�a�c�i�o���:� �M�a�n�t�e�n�e�r� �m���l�t�i�p�l�e�s� �v�e�r�s�i�o�n�e�s� �d�e� �l�o�s� �d�a�t�o�s� �c�o�n�s�u�m�e� �m���s� �e�s�p�a�c�i�o� �d�e� �a�l�m�a�c�e�n�a�m�i�e�n�t�o�.�
�
�
�
�2�.� ���C�o�m�p�l�e�j�i�d�a�d� �d�e� �i�m�p�l�e�m�e�n�t�a�c�i���n���:� �E�s� �m���s� �c�o�m�p�l�e�j�o� �d�e� �i�m�p�l�e�m�e�n�t�a�r� �q�u�e� �l�o�s� �s�i�s�t�e�m�a�s� �t�r�a�d�i�c�i�o�n�a�l�e�s� �d�e� �b�l�o�q�u�e�o�.�
�
�
�
�3�.� ���S�o�b�r�e�c�a�r�g�a� �d�e� �p�r�o�c�e�s�a�m�i�e�n�t�o���:� �L�a� �g�e�s�t�i���n� �d�e� �v�e�r�s�i�o�n�e�s� �y� �l�a� �d�e�t�e�r�m�i�n�a�c�i���n� �d�e� �v�i�s�i�b�i�l�i�d�a�d� �a���a�d�e�n� �c�i�e�r�t�a� �s�o�b�r�e�c�a�r�g�a� �d�e� �p�r�o�c�e�s�a�m�i�e�n�t�o�.�
�
�
�
�4�.� ���G�a�r�b�a�g�e� �c�o�l�l�e�c�t�i�o�n���:� �S�e� �r�e�q�u�i�e�r�e� �u�n� �p�r�o�c�e�s�o� �p�a�r�a� �e�l�i�m�i�n�a�r� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �q�u�e� �y�a� �n�o� �s�o�n� �n�e�c�e�s�a�r�i�a�s�.�
�
�
�
�5�.� ���A�n�o�m�a�l���a�s� �d�e� �e�s�c�r�i�t�u�r�a���:� �P�u�e�d�e�n� �s�u�r�g�i�r� �p�r�o�b�l�e�m�a�s� �c�o�m�o� �l�a� �a�c�t�u�a�l�i�z�a�c�i���n� �p�e�r�d�i�d�a� �s�i� �n�o� �s�e� �i�m�p�l�e�m�e�n�t�a�n� �c�o�r�r�e�c�t�a�m�e�n�t�e� �l�o�s� �m�e�c�a�n�i�s�m�o�s� �d�e� �d�e�t�e�c�c�i���n� �d�e� �c�o�n�f�l�i�c�t�o�s�.�
�
�
�
�#�#� �M�V�C�C� �e�n� �d�i�f�e�r�e�n�t�e�s� �s�i�s�t�e�m�a�s� �d�e� �b�a�s�e�s� �d�e� �d�a�t�o�s�
�
�
�
�#�#�#� �P�o�s�t�g�r�e�S�Q�L�
�
�
�
�P�o�s�t�g�r�e�S�Q�L� �i�m�p�l�e�m�e�n�t�a� �M�V�C�C� �d�e� �f�o�r�m�a� �n�a�t�i�v�a� �y� �e�s� �u�n�o� �d�e� �l�o�s� �s�i�s�t�e�m�a�s� �q�u�e� �m�e�j�o�r� �a�p�r�o�v�e�c�h�a� �e�s�t�a� �t���c�n�i�c�a�:�
�
�
�
�-� �C�a�d�a� �t�r�a�n�s�a�c�c�i���n� �r�e�c�i�b�e� �u�n� �I�D� �d�e� �t�r�a�n�s�a�c�c�i���n� �(�X�I�D�)� �a�l� �i�n�i�c�i�a�r�.�
�
�-� �C�a�d�a� �f�i�l�a� �t�i�e�n�e� �c�a�m�p�o�s� �o�c�u�l�t�o�s� �(��x�m�i�n�
�,� ��x�m�a�x�
�)� �q�u�e� �i�n�d�i�c�a�n� �q�u��� �t�r�a�n�s�a�c�c�i�o�n�e�s� �p�u�e�d�e�n� �v�e�r� �l�a� �f�i�l�a�.�
�
�-� �U�t�i�l�i�z�a� �V�A�C�U�U�M� �p�a�r�a� �l�i�m�p�i�a�r� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �d�e� �d�a�t�o�s�.�
�
�
�
��
��s�q�l� � �-�-� �P�o�s�t�g�r�e�S�Q�L� �u�t�i�l�i�z�a� �M�V�C�C� �e�n� �t�o�d�a�s� �l�a�s� �o�p�e�r�a�c�i�o�n�e�s� � �B�E�G�I�N�;� � �S�E�L�E�C�T� �*� �F�R�O�M� �p�r�o�d�u�c�t�o�s�;� � �-�-� �V�e� �u�n�a� �i�n�s�t�a�n�t���n�e�a� �c�o�n�s�i�s�t�e�n�t�e� � �-�-� �M�i�e�n�t�r�a�s� �t�a�n�t�o�,� �o�t�r�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �p�u�e�d�e�n� �m�o�d�i�f�i�c�a�r� �l�a� �t�a�b�l�a� � �C�O�M�M�I�T�;� � �
��
�
�
�
�
�#�#�#� �O�r�a�c�l�e�
�
�
�
�O�r�a�c�l�e� �t�a�m�b�i���n� �i�m�p�l�e�m�e�n�t�a� �M�V�C�C�,� �p�e�r�o� �c�o�n� �a�l�g�u�n�a�s� �d�i�f�e�r�e�n�c�i�a�s�:�
�
�
�
�-� �U�t�i�l�i�z�a� �S�C�N� �(�S�y�s�t�e�m� �C�h�a�n�g�e� �N�u�m�b�e�r�)� �e�n� �l�u�g�a�r� �d�e� �I�D�s� �d�e� �t�r�a�n�s�a�c�c�i���n�.�
�
�-� �A�l�m�a�c�e�n�a� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �e�n� �u�n� �s�e�g�m�e�n�t�o� �d�e� �r�o�l�l�b�a�c�k�.�
�
�-� �O�f�r�e�c�e� �l�a� �c�a�r�a�c�t�e�r���s�t�i�c�a� �"�F�l�a�s�h�b�a�c�k� �Q�u�e�r�y�"� �p�a�r�a� �c�o�n�s�u�l�t�a�r� �d�a�t�o�s� �h�i�s�t���r�i�c�o�s�.�
�
�
�
��
��s�q�l� � �-�-� �O�r�a�c�l�e� �p�e�r�m�i�t�e� �c�o�n�s�u�l�t�a�s� �a� �u�n� �p�u�n�t�o� �e�s�p�e�c���f�i�c�o� �e�n� �e�l� �t�i�e�m�p�o� � �S�E�L�E�C�T� �*� �F�R�O�M� �p�r�o�d�u�c�t�o�s� � � �A�S� �O�F� �T�I�M�E�S�T�A�M�P� �T�O�_�T�I�M�E�S�T�A�M�P�(�'�2�0�2�5�-�0�4�-�0�1� �1�2�:�0�0�:�0�0�'�,� �'�Y�Y�Y�Y�-�M�M�-�D�D� �H�H�2�4�:�M�I�:�S�S�'�)�;� � �
��
�
�
�
�
�#�#�#� �M�y�S�Q�L� �(�I�n�n�o�D�B�)�
�
�
�
�I�n�n�o�D�B� �i�m�p�l�e�m�e�n�t�a� �M�V�C�C� �j�u�n�t�o� �c�o�n� �b�l�o�q�u�e�o�s�:�
�
�
�
�-� �M�a�n�t�i�e�n�e� �u�n� �"�u�n�d�o� �l�o�g�"� �c�o�n� �v�e�r�s�i�o�n�e�s� �a�n�t�e�r�i�o�r�e�s� �d�e� �l�o�s� �r�e�g�i�s�t�r�o�s�.�
�
�-� �U�t�i�l�i�z�a� �b�l�o�q�u�e�o�s� �d�e� �f�i�l�a� �p�a�r�a� �o�p�e�r�a�c�i�o�n�e�s� �d�e� �e�s�c�r�i�t�u�r�a�.�
�
�-� �C�o�m�b�i�n�a� �M�V�C�C� �c�o�n� �b�l�o�q�u�e�o�s� �p�a�r�a� �p�r�o�p�o�r�c�i�o�n�a�r� �d�i�f�e�r�e�n�t�e�s� �n�i�v�e�l�e�s� �d�e� �a�i�s�l�a�m�i�e�n�t�o�.�
�
�
�
��
��s�q�l� � �-�-� �M�y�S�Q�L� �c�o�n� �I�n�n�o�D�B� �u�t�i�l�i�z�a� �M�V�C�C� �p�a�r�a� �l�e�c�t�u�r�a�s� �c�o�n�s�i�s�t�e�n�t�e�s� � �S�E�T� �T�R�A�N�S�A�C�T�I�O�N� �I�S�O�L�A�T�I�O�N� �L�E�V�E�L� �R�E�P�E�A�T�A�B�L�E� �R�E�A�D�;� � �B�E�G�I�N�;� � �S�E�L�E�C�T� �*� �F�R�O�M� �p�r�o�d�u�c�t�o�s�;� � �-�-� �O�t�r�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �p�u�e�d�e�n� �m�o�d�i�f�i�c�a�r� �l�a� �t�a�b�l�a� �s�i�n� �a�f�e�c�t�a�r� �e�s�t�a� �v�i�s�t�a� � �C�O�M�M�I�T�;� � �
��
�
�
�
�
�#�#�#� �S�Q�L� �S�e�r�v�e�r�
�
�
�
�S�Q�L� �S�e�r�v�e�r� �i�m�p�l�e�m�e�n�t�a� �u�n�a� �f�o�r�m�a� �d�e� �M�V�C�C� �l�l�a�m�a�d�a� �"�V�e�r�s�i�o�n�i�n�g� �d�e� �f�i�l�a�"�:�
�
�
�
�-� �D�i�s�p�o�n�i�b�l�e� �d�e�s�d�e� �S�Q�L� �S�e�r�v�e�r� �2�0�0�5� �c�o�n� �e�l� �n�i�v�e�l� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �"�R�E�A�D� �C�O�M�M�I�T�T�E�D� �S�N�A�P�S�H�O�T�"�.�
�
�-� �A�l�m�a�c�e�n�a� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �e�n� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �t�e�m�p�d�b�.�
�
�-� �P�e�r�m�i�t�e� �c�o�n�f�i�g�u�r�a�r� �e�l� �c�o�m�p�o�r�t�a�m�i�e�n�t�o� �a� �n�i�v�e�l� �d�e� �b�a�s�e� �d�e� �d�a�t�o�s�.�
�
�
�
��
��s�q�l� � �-�-� �H�a�b�i�l�i�t�a�r� �M�V�C�C� �e�n� �S�Q�L� �S�e�r�v�e�r� � �A�L�T�E�R� �D�A�T�A�B�A�S�E� �M�i�B�a�s�e�D�e�D�a�t�o�s� � �S�E�T� �R�E�A�D�_�C�O�M�M�I�T�T�E�D�_�S�N�A�P�S�H�O�T� �O�N�;� � �
��
�
�
�
�
�#�#� �N�i�v�e�l�e�s� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �y� �M�V�C�C�
�
�
�
�M�V�C�C� �p�e�r�m�i�t�e� �i�m�p�l�e�m�e�n�t�a�r� �d�i�f�e�r�e�n�t�e�s� �n�i�v�e�l�e�s� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �s�i�n� �d�e�p�e�n�d�e�r� �e�x�c�l�u�s�i�v�a�m�e�n�t�e� �d�e� �b�l�o�q�u�e�o�s�:�
�
�
�
�#�#�#� �R�E�A�D� �C�O�M�M�I�T�T�E�D�
�
�
�
�-� �L�a� �t�r�a�n�s�a�c�c�i���n� �s�o�l�o� �v�e� �d�a�t�o�s� �c�o�n�f�i�r�m�a�d�o�s�.�
�
�-� �C�a�d�a� �s�e�n�t�e�n�c�i�a� �v�e� �l�a� ���l�t�i�m�a� �v�e�r�s�i���n� �c�o�n�f�i�r�m�a�d�a� �a�l� �m�o�m�e�n�t�o� �d�e� �e�j�e�c�u�t�a�r�s�e�.�
�
�-� �P�u�e�d�e� �d�a�r� �l�u�g�a�r� �a� �l�e�c�t�u�r�a�s� �n�o� �r�e�p�e�t�i�b�l�e�s�.�
�
�
�
�#�#�#� �R�E�P�E�A�T�A�B�L�E� �R�E�A�D�
�
�
�
�-� �L�a� �t�r�a�n�s�a�c�c�i���n� �v�e� �l�a� �m�i�s�m�a� �i�n�s�t�a�n�t���n�e�a� �d�u�r�a�n�t�e� �t�o�d�a� �s�u� �d�u�r�a�c�i���n�.�
�
�-� �G�a�r�a�n�t�i�z�a� �q�u�e� �l�a�s� �l�e�c�t�u�r�a�s� �r�e�p�e�t�i�d�a�s� �d�e�v�u�e�l�v�a�n� �l�o�s� �m�i�s�m�o�s� �r�e�s�u�l�t�a�d�o�s�.�
�
�-� �P�u�e�d�e� �p�e�r�m�i�t�i�r� �l�e�c�t�u�r�a�s� �f�a�n�t�a�s�m�a� �e�n� �a�l�g�u�n�o�s� �s�i�s�t�e�m�a�s�.�
�
�
�
�#�#�#� �S�E�R�I�A�L�I�Z�A�B�L�E�
�
�
�
�-� �P�r�o�p�o�r�c�i�o�n�a� �e�l� �m�a�y�o�r� �n�i�v�e�l� �d�e� �a�i�s�l�a�m�i�e�n�t�o�.�
�
�-� �E�n� �s�i�s�t�e�m�a�s� �M�V�C�C�,� �g�e�n�e�r�a�l�m�e�n�t�e� �s�e� �i�m�p�l�e�m�e�n�t�a� �v�e�r�i�f�i�c�a�n�d�o� �c�o�n�f�l�i�c�t�o�s� �a�l� �c�o�n�f�i�r�m�a�r� �l�a� �t�r�a�n�s�a�c�c�i���n�.�
�
�-� �P�u�e�d�e� �r�e�q�u�e�r�i�r� �b�l�o�q�u�e�o�s� �a�d�i�c�i�o�n�a�l�e�s� �o� �v�e�r�i�f�i�c�a�c�i�o�n�e�s� �d�e� �p�r�e�d�i�c�a�d�o�s�.�
�
�
�
�#�#� �E�j�e�m�p�l�o� �p�r���c�t�i�c�o� �d�e� �M�V�C�C�
�
�
�
�C�o�n�s�i�d�e�r�e�m�o�s� �u�n� �e�s�c�e�n�a�r�i�o� �c�o�n� �u�n�a� �t�a�b�l�a� �d�e� �i�n�v�e�n�t�a�r�i�o�:�
�
�
�
��
��s�q�l� � �C�R�E�A�T�E� �T�A�B�L�E� �i�n�v�e�n�t�a�r�i�o� �(� � � � � � �p�r�o�d�u�c�t�o�_�i�d� �I�N�T� �P�R�I�M�A�R�Y� �K�E�Y�,� � � � � � �n�o�m�b�r�e� �V�A�R�C�H�A�R�(�1�0�0�)�,� � � � � � �s�t�o�c�k� �I�N�T� � �)�;� � � � �I�N�S�E�R�T� �I�N�T�O� �i�n�v�e�n�t�a�r�i�o� �V�A�L�U�E�S� �(�1�,� �'�L�a�p�t�o�p�'�,� �1�0�)�;� � �
��
�
�
�
�
�C�o�n� �M�V�C�C�,� �p�o�d�r���a�m�o�s� �t�e�n�e�r� �l�a�s� �s�i�g�u�i�e�n�t�e�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �c�o�n�c�u�r�r�e�n�t�e�s�:�
�
�
�
��
��s�q�l� � �-�-� �T�r�a�n�s�a�c�c�i���n� �1�:� �C�o�n�s�u�l�t�a� �d�e� �i�n�v�e�n�t�a�r�i�o� � �B�E�G�I�N� �T�R�A�N�S�A�C�T�I�O�N�;� � �S�E�L�E�C�T� �*� �F�R�O�M� �i�n�v�e�n�t�a�r�i�o� �W�H�E�R�E� �p�r�o�d�u�c�t�o�_�i�d� �=� �1�;� � �-�-� �V�e� �s�t�o�c�k� �=� �1�0� � � � �-�-� �M�i�e�n�t�r�a�s� �t�a�n�t�o�,� �l�a� �T�r�a�n�s�a�c�c�i���n� �2� �s�e� �e�j�e�c�u�t�a� �y� �c�o�n�f�i�r�m�a� � �-�-� �T�r�a�n�s�a�c�c�i���n� �2�:� �A�c�t�u�a�l�i�z�a�c�i���n� �d�e� �i�n�v�e�n�t�a�r�i�o� � �B�E�G�I�N� �T�R�A�N�S�A�C�T�I�O�N�;� � �U�P�D�A�T�E� �i�n�v�e�n�t�a�r�i�o� �S�E�T� �s�t�o�c�k� �=� �s�t�o�c�k� �-� �3� �W�H�E�R�E� �p�r�o�d�u�c�t�o�_�i�d� �=� �1�;� � �C�O�M�M�I�T�;� � � � �-�-� �D�e� �v�u�e�l�t�a� �e�n� �l�a� �T�r�a�n�s�a�c�c�i���n� �1� � �S�E�L�E�C�T� �*� �F�R�O�M� �i�n�v�e�n�t�a�r�i�o� �W�H�E�R�E� �p�r�o�d�u�c�t�o�_�i�d� �=� �1�;� � �-�-� �A���n� �v�e� �s�t�o�c�k� �=� �1�0� � �-�-� �p�o�r�q�u�e� �e�s�t��� �v�i�e�n�d�o� �s�u� �i�n�s�t�a�n�t���n�e�a� �o�r�i�g�i�n�a�l� � �C�O�M�M�I�T�;� � � � �-�-� �U�n�a� �n�u�e�v�a� �T�r�a�n�s�a�c�c�i���n� �3� �v�e�r���a� �e�l� �v�a�l�o�r� �a�c�t�u�a�l�i�z�a�d�o� � �B�E�G�I�N� �T�R�A�N�S�A�C�T�I�O�N�;� � �S�E�L�E�C�T� �*� �F�R�O�M� �i�n�v�e�n�t�a�r�i�o� �W�H�E�R�E� �p�r�o�d�u�c�t�o�_�i�d� �=� �1�;� � �-�-� �V�e� �s�t�o�c�k� �=� �7� � �C�O�M�M�I�T�;� � �
��
�
�
�
�
�#�#� �M�e�j�o�r�e�s� �p�r���c�t�i�c�a�s� �a�l� �t�r�a�b�a�j�a�r� �c�o�n� �M�V�C�C�
�
�
�
�1�.� ���T�r�a�n�s�a�c�c�i�o�n�e�s� �c�o�r�t�a�s���:� �M�a�n�t���n� �l�a�s� �t�r�a�n�s�a�c�c�i�o�n�e�s� �l�o� �m���s� �c�o�r�t�a�s� �p�o�s�i�b�l�e� �p�a�r�a� �r�e�d�u�c�i�r� �l�a� �a�c�u�m�u�l�a�c�i���n� �d�e� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s�.�
�
�
�
�2�.� ���M�a�n�t�e�n�i�m�i�e�n�t�o� �r�e�g�u�l�a�r���:� �C�o�n�f�i�g�u�r�a� �p�r�o�c�e�s�o�s� �d�e� �l�i�m�p�i�e�z�a� �(�c�o�m�o� �V�A�C�U�U�M� �e�n� �P�o�s�t�g�r�e�S�Q�L�)� �p�a�r�a� �e�l�i�m�i�n�a�r� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s�.�
�
�
�
�3�.� ���M�o�n�i�t�o�r�e�o���:� �V�i�g�i�l�a� �e�l� �c�r�e�c�i�m�i�e�n�t�o� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s� �y� �l�o�s� �s�e�g�m�e�n�t�o�s� �d�e� �r�o�l�l�b�a�c�k�/�u�n�d�o�.�
�
�
�
�4�.� ���N�i�v�e�l�e�s� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �a�d�e�c�u�a�d�o�s���:� �E�l�i�g�e� �e�l� �n�i�v�e�l� �d�e� �a�i�s�l�a�m�i�e�n�t�o� �a�p�r�o�p�i�a�d�o� �s�e�g���n� �t�u�s� �n�e�c�e�s�i�d�a�d�e�s� �d�e� �c�o�n�s�i�s�t�e�n�c�i�a� �y� �r�e�n�d�i�m�i�e�n�t�o�.�
�
�
�
�5�.� ���E�v�i�t�a� �t�r�a�n�s�a�c�c�i�o�n�e�s� �d�e� �l�a�r�g�a� �d�u�r�a�c�i���n���:� �E�s�t�a�s� �p�u�e�d�e�n� �i�m�p�e�d�i�r� �l�a� �l�i�m�p�i�e�z�a� �d�e� �v�e�r�s�i�o�n�e�s� �a�n�t�i�g�u�a�s� �y� �c�a�u�s�a�r� �c�r�e�c�i�m�i�e�n�t�o� �e�x�c�e�s�i�v�o� �d�e� �l�a� �b�a�s�e� �d�e� �d�a�t�o�s�.�
�
�
�
�#�#� �C�o�n�c�l�u�s�i���n�
�
�
�
�M�V�C�C� �e�s� �u�n�a� �t���c�n�i�c�a� �s�o�f�i�s�t�i�c�a�d�a� �q�u�e� �p�e�r�m�i�t�e� �a� �l�a�s� �b�a�s�e�s� �d�e� �d�a�t�o�s� �m�o�d�e�r�n�a�s� �m�a�n�e�j�a�r� �a�l�t�o�s� �n�i�v�e�l�e�s� �d�e� �c�o�n�c�u�r�r�e�n�c�i�a� �s�i�n� �s�a�c�r�i�f�i�c�a�r� �l�a� �c�o�n�s�i�s�t�e�n�c�i�a�.� �A�l� �c�r�e�a�r� �m���l�t�i�p�l�e�s� �v�e�r�s�i�o�n�e�s� �d�e� �l�o�s� �d�a�t�o�s� �e�n� �l�u�g�a�r� �d�e� �b�l�o�q�u�e�a�r�l�o�s�,� �M�V�C�C� �o�f�r�e�c�e� �u�n� �e�q�u�i�l�i�b�r�i�o� ���p�t�i�m�o� �e�n�t�r�e� �r�e�n�d�i�m�i�e�n�t�o� �y� �c�o�n�s�i�s�t�e�n�c�i�a�.�
�
�
�
�A�u�n�q�u�e� �s�u� �i�m�p�l�e�m�e�n�t�a�c�i���n� �v�a�r���a� �e�n�t�r�e� �l�o�s� �d�i�f�e�r�e�n�t�e�s� �s�i�s�t�e�m�a�s� �d�e� �g�e�s�t�i���n� �d�e� �b�a�s�e�s� �d�e� �d�a�t�o�s�,� �c�o�m�p�r�e�n�d�e�r� �l�o�s� �p�r�i�n�c�i�p�i�o�s� �f�u�n�d�a�m�e�n�t�a�l�e�s� �d�e� �M�V�C�C� �e�s� �e�s�e�n�c�i�a�l� �p�a�r�a� �d�e�s�a�r�r�o�l�l�a�r� �a�p�l�i�c�a�c�i�o�n�e�s� �e�f�i�c�i�e�n�t�e�s� �q�u�e� �a�p�r�o�v�e�c�h�e�n� �a�l� �m���x�i�m�o� �l�a� �c�o�n�c�u�r�r�e�n�c�i�a� �e�n� �e�n�t�o�r�n�o�s� �d�e� �b�a�s�e�s� �d�e� �d�a�t�o�s� �r�e�l�a�c�i�o�n�a�l�e�s�.�
�
�
�
�:�:�A�p�p�S�u�r�r�o�u�n�d�{�:�s�u�r�r�o�u�n�d�=�'�s�u�r�r�o�u�n�d�'�}�
�
�:�:�
�
�
�
�<�A�p�p�A�p�a�S�e�p�t�i�m�a�
�
� � �:�r�e�f�e�r�e�n�c�e�s�=�'��
�
� � � � �{�
�
� � � � � � �"�t�i�t�l�e�"�:� �"�P�o�s�t�g�r�e�S�Q�L� �D�o�c�u�m�e�n�t�a�t�i�o�n�:� �M�V�C�C�"�,�
�
� � � � � � �"�a�u�t�h�o�r�"�:� �"�P�o�s�t�g�r�e�S�Q�L� �G�l�o�b�a�l� �D�e�v�e�l�o�p�m�e�n�t� �G�r�o�u�p�"�,�
�
� � � � � � �"�u�r�l�"�:� �"�h�t�t�p�s�:�/�/�w�w�w�.�p�o�s�t�g�r�e�s�q�l�.�o�r�g�/�d�o�c�s�/�c�u�r�r�e�n�t�/�m�v�c�c�-�i�n�t�r�o�.�h�t�m�l�"�
�
� � � � �}�,�
�
� � � � �{�
�
� � � � � � �"�t�i�t�l�e�"�:� �"�U�n�d�e�r�s�t�a�n�d�i�n�g� �M�V�C�C� �i�n� �O�r�a�c�l�e� �D�a�t�a�b�a�s�e�"�,�
�
� � � � � � �"�a�u�t�h�o�r�"�:� �"�O�r�a�c�l�e� �D�o�c�u�m�e�n�t�a�t�i�o�n�"�,�
�
� � � � � � �"�u�r�l�"�:� �"�h�t�t�p�s�:�/�/�d�o�c�s�.�o�r�a�c�l�e�.�c�o�m�/�e�n�/�d�a�t�a�b�a�s�e�/�o�r�a�c�l�e�/�o�r�a�c�l�e�-�d�a�t�a�b�a�s�e�/�1�9�/�c�n�c�p�t�/�d�a�t�a�-�c�o�n�c�u�r�r�e�n�c�y�-�a�n�d�-�c�o�n�s�i�s�t�e�n�c�y�.�h�t�m�l�"�
�
� � � � �}�,�
�
� � � � �{�
�
� � � � � � �"�t�i�t�l�e�"�:� �"�T�r�a�n�s�a�c�t�i�o�n� �P�r�o�c�e�s�s�i�n�g�:� �C�o�n�c�e�p�t�s� �a�n�d� �T�e�c�h�n�i�q�u�e�s�"�,�
�
� � � � � � �"�a�u�t�h�o�r�"�:� �"�J�i�m� �G�r�a�y� �a�n�d� �A�n�d�r�e�a�s� �R�e�u�t�e�r�"�,�
�
� � � � � � �"�u�r�l�"�:� �"�h�t�t�p�s�:�/�/�d�l�.�a�c�m�.�o�r�g�/�d�o�i�/�b�o�o�k�/�1�0�.�5�5�5�5�/�5�7�3�3�0�4�"�
�
� � � � �}�
�
� � ��'�
�
�/�>�
�
�