DBMS selection criteria

Question

Database design

What determines the choice of a DBMS for a task? Can you recommend reading something about the characteristics of various DBMSs in a more or less compressed form?

Answer 1

Very much on the type of project, money + on the framework in which you work ...
1. look at the database: data storage, nothing else (muscle, sqlight (shallow data storage, for >> local<< purposes))
2. look at the database: one of the modules (if not the heart) of your system, everything that you program is inside the database, the logic of the actions and behavior of the system. Here Orakl is more likely to come under the arm (with a small part of postgres).
Let me give you an example:
Knowing the muscle to everyone: it actually contains 3 types of database: InnoDB => transactions, MyISSAM => no transactions and high speed + Memory = huge speed of working with data, but eating ram.
All this is good, but mayissa and memors work without transactions, although they are fast but not reliable. InnoDB is ok for transactions, but a bit slower. unfortunately on muscle don't put the core of your program in the database.
Postgres:
Transactional db, theoretically everything is OK, it works reliably, everything can be adjusted, there are good triggers, etc. etc. but again, the core of the program cannot be put on it, it does not allow much, the namespaces are poorly resolved. (pg/square)
Oracle:
It's not fast, but reliable DB. Reliable in the sense there are transactions and works with data a little differently. And of course, not with free support. Here you can put the kernel of anything directly into the database (pl/skvl).

Answer 2

For the described situation, I recommend taking Oracle as the main DBMS, there may, of course, be additional databases for operational data per day, some kind of caching solution, in order to keep part of the data in memory for quick access. But if you are not tied to technology yet, take an Enterprise class solution - Oracle. Have you already chosen programming languages ​​and technologies? The fact is that the choice of a DBMS very much depends on the software with which you will integrate your solution, if you then decide to hang Microsoft BizTalk or SAP or 1C somewhere there, then you should think about it now, when choosing tools to do not change the DBMS and then do not make crutches in the form of a nightly copy to another DBMS.

Answer 3

You are actually asking a very difficult question. I would go the other way and proceed from the criterion, what kind of specialists do you have to support the chosen solution, how many people are in the team and what experience do they have?

Answer 4

www.interface.ru/cafedra/dipl/anos.doc