User Input File Requirements
Database Initialization File
Database Initialization File is used for initializing the state of a database. By starting each experiment in the same initial database state, the results of different experiments can be meaningfully compared. The user must provide the path to this file through user interface before an experiment can be executed.
File Name Restriction
None
Content Convention
This file should only contain SQL INSERT
statements. All statements must be Sybase compatible and each statement
must be written on one line.
It is highly recommended
that you add the statement "go" after a block of INSERT statements (see
example below).
NOTE: You may also create stored procedures in Database Schema File to perform data insertion, then you may write stored procedure calls in this file.
Sample File
INSERT INTO Students (sid, password) VALUES ('000000000',
'aaaaaa')
INSERT INTO Students (sid, password) VALUES ('111111111',
'bbbbb')
INSERT INTO Students (sid, password) VALUES ('222222222',
'cccccc')
INSERT INTO Students (sid, password) VALUES ('333333333',
'ddddd')
go
INSERT INTO Courses (cid, cname) VALUES ('CSE100', 'Intro
to CS')
INSERT INTO Courses (cid, cname) VALUES ('CSE200', 'Advanced
CS')
go
INSERT INTO Registered (sid, cid) VALUES ('111111111',
'CSE100')
INSERT INTO Registered (sid, cid) VALUES ('222222222',
'CSE200')
INSERT INTO Registered (sid, cid) VALUES ('333333333',
'CSE100')
go
Back
to User Input File Requirements