Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Testting DataBase (Read 4873 times)
John
YaBB Newbies
*


I Love SQL*XL

Posts: 1
Testting DataBase
05.04.09 at 07:20:29
 
How could you test that a database allows appropriate multi user access?
 
anyone help please...
Back to top
 
« Last Edit: 05.04.09 at 07:21:44 by John »  
  IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Testting DataBase
Reply #1 - 05.04.09 at 09:55:10
 
Hi,
 
You need to simulate logging in with multiple users. It would be handy if you have multiple PC's that are part of the same LAN network.
 
What you would do is to put the database on a shared drive so both PC's can access it. This would be the case for MS Access for example. When you use Oracle or SQL Server or MySQL, e.g. you would not need to do this. You then need to ensure the database is "visible" from outside of the PC. For example with Oracle you would need to start a listener service. What you need to do is specific for each database type.
 
Then the testing is rather simpel. Just start SQL*XL on both PC's and connect to the same database.
 
Interesting scenario's to test are read consitency tests where you for example update on one PC the same data you are retrieving on the second PC. Before you commit the updated changes the other database users should see the old data when read consistency is supported in the database.
 
Hope this helps,
 
Gerrit-Jan Linker
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
keithfer15
YaBB Newbies
*


I Love SQL*XL

Posts: 1
Re: Testting DataBase
Reply #2 - 25.08.09 at 15:56:39
 
you can use synchrinized access by splitting into tiers, if it is a distributed system, then it is the only choice
sychronization is the answer
 
Back to top
 
« Last Edit: 26.08.09 at 07:54:02 by Gerrit-Jan Linker »  
Email   IP Logged
Pages: 1