L
L
lordekar2015-09-08 19:03:18
Database
lordekar, 2015-09-08 19:03:18

How to implement a simple DBMS?

Hello, the university issued a project work to write a system for recording scientific papers. The data will need to be collected from sites such as Google Schoral, DBLP, etc.
The task includes developing an ER database model, writing data to any database I want and implementing a web interface.
The most difficult task is to develop your own DBMS and transfer data to it, it must be able to: SELECT, UPDATE, DELETE, INSERT, JOIN, SORT BY, GROUP BY. There is also a restriction on the use of only 1 file for storing the database in physical form. I was looking for what data structures modern databases use. Found B+ tree. I plan to load everything into RAM when initializing the DB application.
There are many questions about this:
1) Is my choice successful?
2) How can I write all this into 1 file.
3) Question on keys. Each article, author, etc. will have a numeric key with an increment of 1. But there will also be a search by the author's name, article title, tags, etc. How to do it? Table hash? In this matter, I still don’t even know what to do.
The task itself
10242bb20fcd46c5bf57c4a4bc458874.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dimonchik, 2015-09-08
@dimonchik2013

fallabs.com/tokyocabinet

0
0leg5ergeev, 2015-09-08
@0leg5ergeev

simple

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question