Transcript Research plan - Sybase

Research plan – LSRT Consortium
Targets
• Correctness approval Vs. Sybase database.
• Implementation of a validation scenario
with TTI database.
• Demo preparations and participation
Correctness approval
Targets: validate the consistency of the LSRT database
Execution: This evaluation will be done by comparing the
LSRT database to the commercial Sybase by comparing
the results under traffic.
Testing environment: with the following capabilities:
(1) Traffic generation that will generate load on both
databases according to parameters
(2) Comparator process that will compare the results of the
two processes and will report after comparing the
databases if the databases are equal or not.
Environment
•Traffic generator. The traffic generator is responsible
to generate traffic according to predefined parameters.
The user can control the traffic pattern like the number of
transactions per second, the number of transactions in
every batch etc.
•Sybase. The Sybase engine used in this test is the
same database engine used by TTI.
Environment cont.
•LSRT database. The LSRT database is the database
engine developed during this research in the Technion.
The purpose of this test is to prove that this engine is
consistent with Sybase.
•Comparator. The comparator is responsible for the logical
checks of the two databases. As both engines run the
same set of transactions, the comparator will check the
physical content of the disk and will report on any
discrepancies.
Research Targets
•Proving correctness and completeness
•Elementary integration with TTI
•Demo preparations and participation
Correctness and Completeness
Will be performed in 3 phases
Construction of the basic environment and the development of
the first version of the transactions generator
Phase 2
This phase include the integration of the LSRT database engine
developed in the Technion to one unified system. It also
includes an upgrade of the Transaction generator capabilities
Phase 3
This phase includes the integration from the comparator with the
capabilities to check the differences between the LSRT database
engine developed in the Technion and Sybase.
Correctness and Completeness Timetable
Iteration
Sub step activity
Duration
Total
2 weeks
Phase 1
Installation and activation
1
First version of transaction generator
1
5 weeks
Enhancement of transaction
Phase 2
2
generator (parameters)
Connection to scheduler
3
4 weeks
Phase 3
Total
Comparator development
2
tests
2
11 weeks
Elementary integration with TTI
Targets:
1. Definition
2. Implementation
3. Summarizing and results analysis
Application
Elementary integration with TTI - Timetable
1. Definition
-2
weeks
2. Implementation
- 3-4 weeks
3. Summarizing and results analysis
-2
weeks
Demo preparations and participation
1. Definition
-2
2. Implementation
- 3-4 weeks
3. Participation
weeks
Global Timetable