BI с Redshift от ETL до бордов
Привет, хабр, я Node.js разработчик, и я хочу поделиться с вами опытом по реализации business intelligence (BI) процесса.
В какой-то момент наш бизнес вырос до размера, пусть и небольшого, когда считать различные цифры и проводить аналитику в excel таблицах уже сложно и медленно, да и количество людей работающих с данными значительно выросло. Тогда зашла речь об автоматизации этого процесса и визуализации различного рода аналитики. Так мы подошли к мысли, что пора реализовывать BI внутри компании.
Читать: https://habr.com/ru/post/669240/
Привет, хабр, я Node.js разработчик, и я хочу поделиться с вами опытом по реализации business intelligence (BI) процесса.
В какой-то момент наш бизнес вырос до размера, пусть и небольшого, когда считать различные цифры и проводить аналитику в excel таблицах уже сложно и медленно, да и количество людей работающих с данными значительно выросло. Тогда зашла речь об автоматизации этого процесса и визуализации различного рода аналитики. Так мы подошли к мысли, что пора реализовывать BI внутри компании.
Читать: https://habr.com/ru/post/669240/
LSM Tree - Introduction
What is LSM
Two-Component LSM-Tree Algorithm
Performance of LSM Tree
Read: https://codeforfun.hashnode.dev/lsm-tree-introduction
What is LSM
Two-Component LSM-Tree Algorithm
Performance of LSM Tree
Read: https://codeforfun.hashnode.dev/lsm-tree-introduction
Digital Underwriting: A Digital Transformation Wave in Insurance
Read: https://www.mongodb.com/blog/post/digital-underwriting-digital-transformation-wave-insurance
Read: https://www.mongodb.com/blog/post/digital-underwriting-digital-transformation-wave-insurance
Improving performance in a hierarchical SQL table structure with column propagation
This article will show how column propagation can represent an easy approach to improving query performance when dealing with a hierarchical data structure.
We'll do this with a real-world scenario based on a data-driven project involving a live data...
Read: https://arctype.hashnode.dev/improving-performance-in-a-hierarchical-sql-table-structure-with-column-propagation
This article will show how column propagation can represent an easy approach to improving query performance when dealing with a hierarchical data structure.
We'll do this with a real-world scenario based on a data-driven project involving a live data...
Read: https://arctype.hashnode.dev/improving-performance-in-a-hierarchical-sql-table-structure-with-column-propagation
Oracle Base Database Service Adds AMD Standard E4 Flex Shapes and Higher Performance Storage
This blog announces the AMD Standard E4 Flex Shapes and Higher Performance Storage for the Oracle Base Database Service.
Read: https://blogs.oracle.com/database/post/oracle-base-database-service-adds-amd-standard-e4-flex-shapes-and-higher-performance-storage
This blog announces the AMD Standard E4 Flex Shapes and Higher Performance Storage for the Oracle Base Database Service.
Read: https://blogs.oracle.com/database/post/oracle-base-database-service-adds-amd-standard-e4-flex-shapes-and-higher-performance-storage
Oracle
Oracle Base Database Service Adds AMD Standard E4 Flex Shapes and Higher Performance Storage
This blog announces the AMD Standard E4 Flex Shapes and Higher Performance Storage for the Oracle Base Database Service.
Redis: Data Caching
As developers we want to make our data queries from the server to the database seamless, inexpensive and fast.
While there are a number of approaches to speed up this process, including data indexing, caching, clustering, and so on, let's focus on c...
Read: https://drsimplegraffiti.hashnode.dev/redis-data-caching
As developers we want to make our data queries from the server to the database seamless, inexpensive and fast.
While there are a number of approaches to speed up this process, including data indexing, caching, clustering, and so on, let's focus on c...
Read: https://drsimplegraffiti.hashnode.dev/redis-data-caching
👍1
Шпаргалки по SQL: сохранить и не забыть
Держите полезные шпаргалки по SQL, с которыми вы никогда не забудете основное из работы с реляционными базами данных.
Читать: «Шпаргалки по SQL: сохранить и не забыть»
Держите полезные шпаргалки по SQL, с которыми вы никогда не забудете основное из работы с реляционными базами данных.
Читать: «Шпаргалки по SQL: сохранить и не забыть»
How to Get a Faster and More Accurate Data Collection
Data is a big part of every business. No matter what industry you're in, data can help you make the best decisions for your company and even increase your profits. But if the data isn't accurate or doesn't provide enough information, it could be hurt...
Read: https://maggieb.hashnode.dev/how-to-get-a-faster-and-more-accurate-data-collection
Data is a big part of every business. No matter what industry you're in, data can help you make the best decisions for your company and even increase your profits. But if the data isn't accurate or doesn't provide enough information, it could be hurt...
Read: https://maggieb.hashnode.dev/how-to-get-a-faster-and-more-accurate-data-collection
How Object-Relational Mapping (ORM) Can Make Your Life Easier
When it comes to web development, it's no secret that data management is one of the most crucial aspects of any project. The ability to properly manage and interact with our database(s) is absolutely imperative to the overall success of our applicati...
Read: https://brodylosh.hashnode.dev/how-object-relational-mapping-orm-can-make-your-life-easier
When it comes to web development, it's no secret that data management is one of the most crucial aspects of any project. The ability to properly manage and interact with our database(s) is absolutely imperative to the overall success of our applicati...
Read: https://brodylosh.hashnode.dev/how-object-relational-mapping-orm-can-make-your-life-easier
Custom Data Types
Before, we dive in. PL SQL is a strongly typed language. For every variable used in a program or subprogram, the variable must be declared with a data type. PL SQL comes with some data types already defined. Examples of these data types are VARCHAR, ...
Read: https://co.hashnode.dev/custom-data-types
Before, we dive in. PL SQL is a strongly typed language. For every variable used in a program or subprogram, the variable must be declared with a data type. PL SQL comes with some data types already defined. Examples of these data types are VARCHAR, ...
Read: https://co.hashnode.dev/custom-data-types
Renaming a table in production in PostgreSQL
Sometimes you don't get it right in the first attempt.
When some time ago I announced that we need to rename one of the database tables in our recently launched service, some of my colleagues looked at me like I said something really stupid. Their ar...
Read: https://solid-dry-kiss.hashnode.dev/renaming-a-table-in-production-in-postgresql
Sometimes you don't get it right in the first attempt.
When some time ago I announced that we need to rename one of the database tables in our recently launched service, some of my colleagues looked at me like I said something really stupid. Their ar...
Read: https://solid-dry-kiss.hashnode.dev/renaming-a-table-in-production-in-postgresql
👍1
Deploy AWS DMS in a multi-tiered secure network using an Nginx proxy server
Read: https://aws.amazon.com/blogs/database/deploy-aws-dms-in-a-multi-tiered-secure-network-using-an-nginx-proxy-server/
Read: https://aws.amazon.com/blogs/database/deploy-aws-dms-in-a-multi-tiered-secure-network-using-an-nginx-proxy-server/
Azure SQL Database Tools Part 1: ApexSQL
Microsoft Azure has a robust set of SQL database tools to cover you for every operation you may need. These include fundamental tasks such as creating and managing databases or allowing you to automate database-related tasks, test data generators, an...
Read: https://arctype.hashnode.dev/azure-sql-database-tools-part-1-apexsql
Microsoft Azure has a robust set of SQL database tools to cover you for every operation you may need. These include fundamental tasks such as creating and managing databases or allowing you to automate database-related tasks, test data generators, an...
Read: https://arctype.hashnode.dev/azure-sql-database-tools-part-1-apexsql
I built a Firebase / Mongodb alternative!
Introduction
Hi Developers, I wrote this as a motivation for me at first place to continue doing what i love, and for you guys to stay laways motivated about your work
Motivation behind
So Let's start one year from now, when i start building a Shopif...
Read: https://kamatil.hashnode.dev/i-built-a-firebase-mongodb-alternative
Introduction
Hi Developers, I wrote this as a motivation for me at first place to continue doing what i love, and for you guys to stay laways motivated about your work
Motivation behind
So Let's start one year from now, when i start building a Shopif...
Read: https://kamatil.hashnode.dev/i-built-a-firebase-mongodb-alternative
Designing Data Intensive Applications CH 7 - Part II 'Weak Isolation Levels'
Welcome again to the second part of chapter 7 in Designing Data-Intensive Applications where we discuss isolation levels and different problems that can occur and their possible solutions.
Transactions can safely run in parallel if they don't touch t...
Read: https://hewi.hashnode.dev/designing-data-intensive-applications-ch-7-part-ii-weak-isolation-levels
Welcome again to the second part of chapter 7 in Designing Data-Intensive Applications where we discuss isolation levels and different problems that can occur and their possible solutions.
Transactions can safely run in parallel if they don't touch t...
Read: https://hewi.hashnode.dev/designing-data-intensive-applications-ch-7-part-ii-weak-isolation-levels
👍1
Подготовили для вас подборки полезной информации по различным направлениям
— для веб-разработчиков: @tproger_web;
— любителям Java: @a_cup_of_java;
— всё о нейросетях: @neuro_channel;
— нужные инструменты для разработчиков: @prog_tools.
Выбирайте, что вам интересно, переходите по ссылке и жмите на закреп. И не забудьте подписаться — там ещё много всего интересного!
— для веб-разработчиков: @tproger_web;
— любителям Java: @a_cup_of_java;
— всё о нейросетях: @neuro_channel;
— нужные инструменты для разработчиков: @prog_tools.
Выбирайте, что вам интересно, переходите по ссылке и жмите на закреп. И не забудьте подписаться — там ещё много всего интересного!
Recreating MYSQL's LPAD Function in SQL Server
If you've had to write SQL the chances are that you've had to write some queries that utilize some handy platform specific functions. You may use them for so long you even forget that they are platform specific ! Fast forward to a new job and you're ...
Read: https://hashnode.com/post/recreating-mysqls-lpad-function-in-sql-server-cl41ed22n0067pmnvaqev3tu3
If you've had to write SQL the chances are that you've had to write some queries that utilize some handy platform specific functions. You may use them for so long you even forget that they are platform specific ! Fast forward to a new job and you're ...
Read: https://hashnode.com/post/recreating-mysqls-lpad-function-in-sql-server-cl41ed22n0067pmnvaqev3tu3
Snowflake Data Migration - Part 2
Hello Folks, Today I am back With another article On Snowflake, Data ingestion. And How to handle Data Engineering on Snowflake.
Todays Agenda
I will walk you through a sample architectural pattern, which ingests the data.
And will give few point...
Read: https://naveenvadlamudi.hashnode.dev/snowflake-data-migration-part-2
Hello Folks, Today I am back With another article On Snowflake, Data ingestion. And How to handle Data Engineering on Snowflake.
Todays Agenda
I will walk you through a sample architectural pattern, which ingests the data.
And will give few point...
Read: https://naveenvadlamudi.hashnode.dev/snowflake-data-migration-part-2
👍1
We Rate Dogs: A Data Analytics And Data Wrangling Project On We Rate Dog Twitter Data Archive
THE CHALLENGE
There are so many dog lovers all over the world and lately, there is a trend where people post pictures
of their dogs and other dog lovers rate them. WeRateDogs is a popular tweet handle with over
9.2million followers that post and ra...
Read: https://onabajomonsurat.hashnode.dev/we-rate-dogs-a-data-analytics-and-data-wrangling-project-on-we-rate-dog-twitter-data-archive
THE CHALLENGE
There are so many dog lovers all over the world and lately, there is a trend where people post pictures
of their dogs and other dog lovers rate them. WeRateDogs is a popular tweet handle with over
9.2million followers that post and ra...
Read: https://onabajomonsurat.hashnode.dev/we-rate-dogs-a-data-analytics-and-data-wrangling-project-on-we-rate-dog-twitter-data-archive
Мониторинг исходящего и входящего трафика в облачном хранилище Nextcloud
Всем привет! Снова на связи Алексей Холодаев из Cloud4Y.
Возникла у меня необходимость мониторить исходящий и входящий трафик на личном облачном хранилище Nextcloud. О том, как я решал эту задачу и какие трудности возникли в процессе, сегодня и рассскажу.
Читать: https://habr.com/ru/post/669716/
Всем привет! Снова на связи Алексей Холодаев из Cloud4Y.
Возникла у меня необходимость мониторить исходящий и входящий трафик на личном облачном хранилище Nextcloud. О том, как я решал эту задачу и какие трудности возникли в процессе, сегодня и рассскажу.
Читать: https://habr.com/ru/post/669716/
Consistent против Rendezvous — чем отличаются подходы для хэширования данных на сервере
Всем привет, меня зовут Михаил Алексеев, я работаю программистом в студии ITT, пишу бэкенд на Java. Перформанс — это моя страсть, как и распределенные системы. Но еще больше я люблю, когда математика встраивается в перформансные цели и задумки.
В этом тексте я расскажу про разницу между Consistent и Rendezvous хэшированием, а также на примерах покажу, с какими проблемами мы сталкиваемся в работе.
Читать: https://habr.com/ru/post/669390/
Всем привет, меня зовут Михаил Алексеев, я работаю программистом в студии ITT, пишу бэкенд на Java. Перформанс — это моя страсть, как и распределенные системы. Но еще больше я люблю, когда математика встраивается в перформансные цели и задумки.
В этом тексте я расскажу про разницу между Consistent и Rendezvous хэшированием, а также на примерах покажу, с какими проблемами мы сталкиваемся в работе.
Читать: https://habr.com/ru/post/669390/