CS657 Database Management Systems
Semester Programming Assignment
Bioinformatics in distributed database
Objective
The goal of this assignment is to create distributed mini database functionality.
The communication between the client and server is through a named pipe.
By using the MFC dialog, the client sends commands to server. Server takes the command, parses it.
It creates database, initialize it. Then user inserts Genes sequence (A, C, T, G) into the database. User also
searches a substring of the gene. Once the substring is found in the database, the information about the gene
sequence (name of gene, species found in, date of discovery, name of discoverer) is returned to the MFC dialog box.
Operation Instruction with screen shots:
We have to run server code, first. And then client code, which is an MFC dialog.
Click on the "Connect" button to establish the named pipe between client and server.
Then, in the longest text box on the MFC dialog, I inserted;
createdb testdb // Creates DB named as testdb
createtable genes in testdb // Creates a table named genes in testdb database
init genes table in testdb // Initialize genes table in testdb with # character
Below is the content of genes table text file at this point.
Then, in the longest text box on the MFC dialog, I inserted;
tablewrite genes in testdb ACGACG;gn1;sp1;81;disc1; // Inserts information about a gene
tablewrite genes in testdb GCAGCA;gn2;sp2;82;disc2; // Inserts information about a gene
tablewrite genes in testdb CGTCGT;gn3;sp3;83;disc3; // Inserts information about a gene
Below is the content of genes table text file at this point.
Then, I search inserted; find GCA in genes in testdb
This command searches the substring "GCA" in the genes table, and finds the gene string in the second record
along with the information related to that gene, e.g., gene name, date of discovery, discoverer.
It also insert those related information in the text boxes on the MFC dialog.
A's are red dot
C's are green dot
G's are blue dot
T's are black dots
Then, I search inserted; find GCA in genes in testdb
Then, I search inserted; find GCA in genes in testdb
|