|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
... Among the typical problems seen in a multi-user application are loss of updates when two users access the database and temporary updates in which a value update fails and rolls back but not before being read by a second user. ... Another problem is having incorrect summary problems, in which two users access the database and are presented with inconsistent data because of simultaneous tasks being performed. To address these issues, database server vendors offer lock features, which may be table-level, page-level or row-level, or shared and exclusive locks.” (Zurek,1992) Through file locking a database can be read and updated by multiple users. ... Database security can come in several forms, the two front line means of security are network access rights and users level security within a database. ... Most often a user has to have “read/write” access to database in order to add data & view certain parts. Database security is where user level security can be used the most effectively by enabling through the database a user level security policy so that only administrators or manager type people can modify or delete data.
What drives the requirements for transactions involving more than one database? ...
Physically separated locations that run off of a central database server and have a transaction server (local database server), the transaction server will take care of all of the day to day database operations.
Approximate Word count = 1077
Approximate Pages = 4.3
(250 words per page double spaced)
|
|
|
|
|
|