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

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

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

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

Другие наши проекты: https://tprg.ru/media
Download Telegram
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
Онлайн-доски: обзор российских решений

Удаленным командам нужно пространство для совместной работы. Где можно и простой мозговой штурм устроить, и сложные схемы построить.

Давайте вместе посмотрим, что есть на российском рынке. Сама начала активно искать замену Miro для своей команды — делюсь тем, что удалось найти.

Я взяла три российских решения: Pruffme, GetLocus и sBoard и сравнила их по ключевым параметрам.
Читать

Читать: https://habr.com/ru/post/684438/
Everything you should know about MongoDB

MongoDB : Introduction
MongoDB, the most popular NoSQL database, is an open-source document-oriented database. The term ‘NoSQL’ means ‘non-relational’. It means that MongoDB isn’t based on the table-like relational database structure but provides an ...

Read: https://sarthaksavvy.hashnode.dev/everything-you-should-know-about-mongodb
MariaDB MaxScale 6.0 Native Clustering

Read: https://mariadb.com/?p=32605
7 Ways to Reduce Your Database's Carbon Footprint

Read: https://www.mongodb.com/blog/post/seven-ways-reduce-databases-carbon-footprint
Automate schema version control and migration with Flyway and AWS Lambda on Amazon Aurora PostgreSQL

Read: https://aws.amazon.com/blogs/database/automate-schema-version-control-and-migration-with-flyway-and-aws-lambda-on-amazon-aurora-postgresql/
Using the MongoDB Shell

Open your MongoDB shell from MongoDB Compass by clicking the up arrow.

To get a list of all databases, type:
show dbs

Use Database
To use a particular database in MongoDB, type:
use <databaseuse bookstore

Note: I can use a database instanc...

Read: https://rukayat-balogun.hashnode.dev/using-the-mongodb-shell
4 Ways Telcos Deliver Mission-Critical Network Performance and Reliability

Read: https://www.mongodb.com/blog/post/four-ways-telcos-deliver-mission-critical-network-performance-reliability
Migrate Amazon Aurora across AWS Regions with minimum downtime using Aurora Global Database

Read: https://aws.amazon.com/blogs/database/migrate-amazon-aurora-across-aws-regions-with-minimum-downtime-using-aurora-global-database/
Swipe Right on Redshift

As a “top pick” in the direct mail automation space, Lob prints and sends millions of mailpieces each year. As such, it's been Lob's commitment from the get-go to minimize our footprint and build a more sustainable approach to direct mail. As a part ...

Read: https://lob.hashnode.dev/swipe-right-on-redshift
Transactional Messaging in Microservices

Introduction
Problem Statement
Transactional messaging is a common problem in Microservices - how do you integrate message publishing with database transactions that update business entities or data. For e.g., we may require to publish domain events ...

Read: https://krishnakrmahto.com/transactional-messaging-in-microservices