What are the main advantages of a column based database?

Подробнее
1 нед. 2 дн. назад #67187 от charlesjone
charlesjone создал тему: What are the main advantages of a column based database?
A column based database is designed to optimize analytical queries, which are queries that retrieve data from the database to analyze and get insights, by storing data in the individual fields. There is one major benefit and that is that the queries do not have to scan irrelevant columns and hence do not have to process the data to that extent. Also, similar values can be stored in a column-oriented system, which can give good compression. Their use is often recommended for business intelligence, reporting and big data analysis. Also take the time to see if you're primarily an analytical or transactional user, as frequent row level updates may not be the best use of one.

Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.

Модераторы: nug, otetz, $aylo, bgleo
Время создания страницы: 0.113 секунд
Работает на Kunena форум