Shortly put, an exclusive lock (X) is placed on a database object whenever it is updated with an INSERT or UPDATE statement.
As you read this article you will find that views are very useful when implemented wisely, but can be an administrative burden if implemented without planning.
Intent locks are used to indicate that a certain lock will be later placed on a certain database object.
Intent locks are used because locks can form hierarchies.
We always upload the data to a table and then begin the process.
Although this process works are you familiar with any other options to directly perform the INSERT, UPDATE or DELETE operations?