Team:ZJU-China/Software
Part 1. Introduction
In the process of the experimental design, because we found that Cas12a is highly portable, in that other biomarkers can be detected by similar methods, and correspondingly can be extended to more diseases. But for a large amount of biomarker data, how to manage it effectively is a problem which is worth of attention.
In fact, the current online database has emerged in an endless stream, but there seems to be no database management system developed for Biomarker on the local side. Therefore, we designed a simple database management system: BiomarkerSQL, a lightweight DBMS that manages Biomarker data locally as a researcher.
The BiomarkerSQL here is based on the design of the simple DBMS: MiniSQL by three Zhejiang University students including our team members. Based on this, some improvements have been made, including the addition, deletion, modification, query, index establishment, etc. The syntax is mainly based on the basic syntax of MySQL.
The development of BiomarkerSQL is based on the basic architecture shown in the figure above, and the user performs related operations on the data in the existing file through the executable file. When the amount of data is large enough, the process of querying the file can be accelerated by indexing. Picture shown below is the process by which the database successfully implements inserts and queries.
Insert
Query
Part 2. Prospection
In fact, what is shown in this project is just a simple demo. The practical and commercialized Biomarker-specific DBMS requires a lot of programmers to work hard to complete this successfully. What is more, we hope that this can be realized indeed in the future, and more software designed initially for iGEM can finally be completed and play an important role in biologists’ daily work.
