OrientDB Docker database in your local machine.

OrientDB is the first Multi-Model Open Source NoSQL DBMS that combines the power of graphs and the flexibility of documents into one scalable, high-performance operational database.
https://youtu.be/ts_NgMG3Gz4
Steps For OrientDB

OrientDB is a Multi...

Read: https://techwasti.com/orientdb-docker-database-in-your-local-machine

Oracle PL/SQL Fundamentals

What is PL/SQL ?

PL/SQL is Oracle's procedural language extension to SQL
Oracle database allows us to create tables, objects, execute all the familiar SQL statements, like INSERT, UPDATE, and DELETE.
-also offers PL/SQL a very powerful, and flexible...

Read: https://onkarpawar.hashnode.dev/oracle-plsql-fundamentals

BI с Redshift от ETL до бордов

Привет, хабр, я 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

Digital Underwriting: A Digital Transformation Wave in 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

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

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

Шпаргалки по 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

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

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

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

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

Подготовили для вас подборки полезной информации по различным направлениям

— для веб-разработчиков: @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

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

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