DATABASE DESIGN – Telegram
DATABASE DESIGN
1.41K subscribers
2.08K photos
3 videos
5.31K links
Лучшие материалы по работе с хранилищами данных на русском и английском языке

Разместить рекламу: @tproger_sales_bot

Правила общения: https://tprg.ru/rules

Другие каналы: @tproger_channels

Другие наши проекты: https://tprg.ru/media
Download Telegram
Writing your first MongoDB Document

Open your terminal and type mongosh

At this point, you should have mongoDB compass installed on your system. Open this software,

Click on connect
If for any reason you do not have the mongosh instance running, type Services in the search bar

Scrol...

Read: https://rukayat-balogun.hashnode.dev/writing-your-first-mongodb-document
What's the difference between a column oriented database and a column-family store?

Hello everyone. Today I'm going to briefly explain the difference between column oriented databases (e.g Vertica, MonetDB, Clickhouse) and column-family stores (e.g Cassandra) because throughout many system design courses I've seen and also throughou...

Read: https://hewi.hashnode.dev/whats-the-difference-between-a-column-oriented-database-and-a-column-family-store
Pattern Matching In Sql

Hello there. We all have faced situations where we remembered a part of the word or line but not entirely. This happens with analysts all the time and hence SQL has the perfect solution to this called Pattern Matching and today we are going to dive t...

Read: https://sourajitad.hashnode.dev/pattern-matching-in-sql
How to Create a Linux MariaBD Galera Cluster 2022

Install CentOs
Firstly we will use three machine instances with CentOs 7 operative system installed, in my case i used this image [CentOS-7-x86_64-DVD-2009].
Internet Config
nano /etc/sysconfig/network-noscripts/ifcfg-enp0s3

Ctrl+O + enter + Ctrl+X
yu...

Read: https://juliang.hashnode.dev/how-to-create-a-linux-mariabd-galera-cluster-2022
The Great Mind-Shift: Why I Decided To Be A Data Analyst.

Dear Reader,
This journey you are about to engage in is that of self-discovery. A story of a girl who was once lost, now found. We all have a story. Something that shapes us, a desire that makes us want to take the world by surprise. A dream to liv...

Read: https://chisom111.hashnode.dev/the-great-mind-shift-why-i-decided-to-be-a-data-analyst
How to create a test database with Laravel Sail

Introduction
I have worked on projects that required the production and testing database to be the same.
This could be because some features work in MariaDB, but not in SQLite. Or some bugs appear in MySQL, but not in PostgreSQL.
When you're working ...

Read: https://blog.akbal.dev/how-to-create-a-test-database-with-laravel-sail
Session Storage and Local Storage APIs

Hi , Zenkin's here .
Usually for a growing application you'd need data , and thus must be stored somewhere . Now , you'd likely never want to set up a database if your data is really miniscule and small . Therefore in the newer web browsers , the We...

Read: https://zenkin.hashnode.dev/session-storage-and-local-storage-apis
Structured Query Language (SQL)

Use of minimal columns in table creation. (max 100 columns).
Avoid use of distinct; use ‘group by’ instead.
Use of LIMIT when fetching records.
Avoid use of * in the select statement. Define columns instead.
Indexing tables. Try using composite index...

Read: https://bikash8848.hashnode.dev/structured-query-language-sql
MongoDB: Capped Collections & Time-To-Live Index

When you use MongoDB in a production environment, you may eventually need to lower the amount of memory your database needs or increase how much it can read and write. The good news is that MongoDB has several ways to deal with these problems. One of...

Read: https://blog.sofwancoder.com/mongodb-capped-collections-and-time-to-live-index
Почему децентрализованный хостинг не работает

(cc) Пирамиды Гизы за окном пиццерии

Минуло 13 лет с появления биткоина, который породил сотни платформ со своими блокчейнами, протоколами и смарт-контрактами. И некоторые умные люди жалуются, что за прошедшее время мы так не нашли новых полезныхприменений для всего этого хозяйства. Кроме хранения и передачи ценности, разумеется. Максималисты могут сказать, что этого и так более чем достаточно. С другой стороны, а где полезные варианты использования для остальных 4000+ токенов, которые сейчас в обращении. Ведь они же создавались с какой-то хорошей целью, кроме строительства пирамид за фасадом легального бизнеса, верно ведь?

Например, одним из утилитарных применений считается децентрализованный P2P-хостинг типа Filecoin (за 0,0017% от стоимости Amazon S3) и StorJ. Они обещали кардинально изменить рынок хранения данных. Что же на самом деле? На самом деле всё не очень хорошо…


Читать: https://habr.com/ru/post/682540/
👍1
The Great Mind-Shift: Why I Decided To Learn Data Analysis.

Dear Reader,
This journey you are about to engage in is that of self-discovery. A story of a girl who was once lost, now found. We all have a story. Something that shapes us, a desire that makes us want to take the world by surprise. A dream to liv...

Read: https://chisom111.hashnode.dev/the-great-mind-shift-why-i-decided-to-learn-data-analysis
Fact and Dimension In Data Warehouse

Fact and Dimension are building blocks of Data Warehouse. Understanding these terminologies is important so that we can model the warehouse correctly. Fact and Dimension work together to give each other real meaning.
Fact
Fact are generally measureme...

Read: https://rochakdh.hashnode.dev/fact-and-dimension-in-data-warehouse
Migrating to the Cloud Isn't As Easy As Most People Think: A Conversation With Mark Porter and Accenture’s Michael Ljung

Read: https://www.mongodb.com/blog/post/migrating-to-cloud-not-easy-most-people-think-conversation-accenture
Announcing MariaDB Community Server 10.9 GA and 10.10 RC

Read: https://mariadb.com/?p=32546
MariaDB C Connector 3.3.2 and 3.1.18 now available

Read: https://mariadb.com/?p=32597
Make configuration changes to an Amazon RDS Custom for Oracle instance: Part 1

Read: https://aws.amazon.com/blogs/database/part-1-make-configuration-changes-to-an-amazon-rds-custom-for-oracle-instance/
GraphQL API design

Introduction
API design refers to the process of developing application programming interfaces (APIs) that expose data and application functionality for use by developers and users.
There are many different ways to develop such an API, we can use SOA...

Read: https://mohammedev.hashnode.dev/graphql-api-design
Без искр, теплового удара и безопасно: как будут жить 500 стоек в одном здании

2022 год стал непростым для инфраструктурных проектов, но МТС не изменила план развития сети ЦОДов. В ближайшие годы появятся 4 больших дата-центра в Ростове, Туле, Екатеринбурге и Хабаровске, и еще 15 ЦОДов на подходе.

Сергей Рубцов, директор дата-центра GreenBushDC, провел виртуальную экскурсию для Хабра и рассказал, как сейчас живет один из самых современных ЦОДов МТС. GreenBushDC буквально пару месяцев назад получил сертификацию Uptime Institute — Constructed Facility — и подтвердил ранее полученный на этапе проектирования статус Tier III — Detailed Design.

Дата-центр практически все ресурсы ориентировал на услугу колокейшн, которая требует от инженеров специализированных навыков и наличия обширной технической базы.


Читать: https://habr.com/ru/post/684266/
MySQL SHOW DATABASES: List All Databases in Different Ways

In this article, you can check out a detailed guide on how to show all databases in MySQL and filter them by specific criteria - https://www.devart.com/dbforge/mysql/studio/how-to-show-all-database-list-in-mysql.html

Read: https://alextomson.hashnode.dev/mysql-show-databases-list-all-databases-in-different-ways
Simple Oracle Database Migration with dbForge Tools

There are several different ways to migrate an Oracle database, and in this article we will try to cover the most popular ones - https://www.devart.com/dbforge/oracle/studio/oracle-database-migration-tool.html

Read: https://alextomson.hashnode.dev/simple-oracle-database-migration-with-dbforge-tools