P
P
Pavel Sachenko2020-03-01 23:00:27
Books
Pavel Sachenko, 2020-03-01 23:00:27

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

2 answer(s)
M
mayton2019, 2020-03-09
@PavelSachenko

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.

A
Antonio Solo, 2020-03-01
@solotony

https://yandex.ru/search/?clid=9582&text=relational...
you can not thank

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question