Answer the question
In order to leave comments, you need to log in
What are the books on database architecture?
What is a good book to read on database architecture? Perhaps a cookbook of successful solutions, something like database architecture design patterns.
Answer the question
In order to leave comments, you need to log in
Most likely there are no such patterns. The most important pattern is the Normal Forms (usually 1 to 3).
Normalization of higher orders is usually not done in product databases. (almost never done).
In general, it is dangerous to give patterns in this subject area. there will always be a problem where even
de-normalization (anti-pattern) gives, for example, a performance boost and this does not fit
into the theory. Although any basic writer will confirm to you that sometimes denormalization is useful and is being done).
By books - see
Date - An Introduction to Database Systems.
There is also a huge ton of books specific to the database vendor (Oracle/MSSQL/Db2) and each
of them will have their own recommended patterns. Therefore, it makes no sense to give them or a pattern in one DBMS
may become an anti-pattern in another (MSSQL/Oracle temporary tables).
Or you need to immediately decide on which DBMS you will work on.
https://yandex.ru/search/?clid=9582&text=relational...
you can not thank
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question