Multi Version VS Locking in banking environments

While one of the ACID rules for database transactions is consistency. We can obviously see users asking for more concurrency, in other words, PERFORMANCE.

12

Almost all you need to know about triggers in SAP Sybase ASE

What is a Trigger: In ASE, trigger is a piece of SQL code that gets executed automatically when a specific action on a specific table happens. What are the actions that fire the trigger? A Trigger can be fired on 3 actions: Insert, Update or Delete or any combination of them. How many Triggers we can have per table? Prior to ASE 16.0 you could have one code running for Inserts, Updates or Deletes or for partial or total group. I.e. one trigger...

Multi Version concurrency control VS Locking in banking environments

While one of the ACID rules for database transactions is consistency. We can obviously see users asking for more concurrency, that’s simply because concurrency and response time form the equation of database throughput, in other words, PERFORMANCE. Measuring the database performance depends not only on how many transactions the database server (RDBMS) can perform, but also if it’s capable of keeping this number as high when multiple users are...