| How Website Testing is different from Database Testing | |
|---|---|
| Website testing | Database testing |
| Event Driven - Actions Depend on Options Choosen by the User | Data Driven, Fixed Set of Steps Executed by a Procedure |
| Website Testing is Black Box Testing, Focus is on end-to-end Functionality | Database Testing is more driven towards white box Testing, Need to verify TSQL Code, Logic, Datatypes, Constraints at Table Level, Refer Database Testing |
| Page Load time is very critical for better user experience | For OLTP Applications Ex-online ticket booking procedures need to be optimal to ensure maximum level of concurrency |
| Performance Points - User Response Time, Response Time with Concurrent Users | Performance Points - Blocking, Locking, Deadlocking during Performance Testing. Detailed notes are provided in blog for each of the listed items |
| Black Box Testing Predominantly | It is possible to trasition from a DB tester to DB Developer Since you work the code, You understand the code/logic |
| Checking SQL Jobs, Database Migrations Ex- SQL 2000 to SQL 2005, SQL 2005 to SQL 2008 | |
| OLTP Vs OLAP Systems. Both are very different and has its own learning. I have mainly worked on OLTP | |
Website would multi-tier app. Client-Business Layer-Database Layer. Database would also be covered at certain point.
Happy Reading!!
1 comment:
These ways are very simple and very much useful, as a beginner level these helped to understand the differnces of datascience and databases thanks for sharing these kinds of useful and knowledgeable information.
Post a Comment