9. Consistency and Consensus
This chapter is all about building fault tolerant distributed systems. We will look at tow measures for these - Consistency and consensus.
Consensus means all nodes of a distributed system agree on something(leader election, state of data etc.).
Con...
Read: https://rparthas.hashnode.dev/9-consistency-and-consensus-cl0zf26o404gisynv5rvdh8wz
This chapter is all about building fault tolerant distributed systems. We will look at tow measures for these - Consistency and consensus.
Consensus means all nodes of a distributed system agree on something(leader election, state of data etc.).
Con...
Read: https://rparthas.hashnode.dev/9-consistency-and-consensus-cl0zf26o404gisynv5rvdh8wz
SQL Queries For Mere Mortals: Creating a Simple Query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-creating-a-simple-query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-creating-a-simple-query
Building a data tech-stack
Data stack
A data stack is a set of tools and technologies built to facilitate the movement, storage and access to data in a business and transforming the data into actionable insights.
Components of data stack
Data source-This is where the data or...
Read: https://dorothycheruiyot.hashnode.dev/building-a-data-tech-stack
Data stack
A data stack is a set of tools and technologies built to facilitate the movement, storage and access to data in a business and transforming the data into actionable insights.
Components of data stack
Data source-This is where the data or...
Read: https://dorothycheruiyot.hashnode.dev/building-a-data-tech-stack
Updates, Order, & the Binlog
Imagine you had two separate databases, a read-write master and a read-only slave, and you wanted to keep a table between them synchronized. Writes would occur on the master table and should eventually appear on the slave table. To synchronize the da...
Read: https://nav610.hashnode.dev/updates-order-and-the-binlog
Imagine you had two separate databases, a read-write master and a read-only slave, and you wanted to keep a table between them synchronized. Writes would occur on the master table and should eventually appear on the slave table. To synchronize the da...
Read: https://nav610.hashnode.dev/updates-order-and-the-binlog
Flutter Hive: Blazing fast Key-Value storage
Intro to Hive
Data persistence is one of the most important aspects of any mobile application. A mobile application always keeps some type of state, such as user information, game scores, the user's current position, and so on.
Data persistence inv...
Read: https://dhruvnakum.xyz/flutter-hive-blazing-fast-key-value-storage
Intro to Hive
Data persistence is one of the most important aspects of any mobile application. A mobile application always keeps some type of state, such as user information, game scores, the user's current position, and so on.
Data persistence inv...
Read: https://dhruvnakum.xyz/flutter-hive-blazing-fast-key-value-storage
Query Editor In Azure Portal
In today’s article, we will talk about Query Editor In Azure Portal. Microsoft Azure added a previewer feature for SQL Databases called Query Editor. This feature is browser-based and is a query editor used on the portal. As seen in the picture below, we can access the required field in the SQL database through the …
Read: Query Editor In Azure Portal.
In today’s article, we will talk about Query Editor In Azure Portal. Microsoft Azure added a previewer feature for SQL Databases called Query Editor. This feature is browser-based and is a query editor used on the portal. As seen in the picture below, we can access the required field in the SQL database through the …
Read: Query Editor In Azure Portal.
Executing Files with .Bin and .Sh Extensions on Linux OS
In this article, we will talk about Executing Files with .Bin and .Sh Extensions on Linux OS. This simple subject is one of the first commands to learn for beginners to the Linux operating system. As usual in Windows operating systems, all .exe , .bat etc. extensions can be run with the ease of double-clicking, …
Read: Executing Files with .Bin and .Sh Extensions on Linux OS.
In this article, we will talk about Executing Files with .Bin and .Sh Extensions on Linux OS. This simple subject is one of the first commands to learn for beginners to the Linux operating system. As usual in Windows operating systems, all .exe , .bat etc. extensions can be run with the ease of double-clicking, …
Read: Executing Files with .Bin and .Sh Extensions on Linux OS.
Standby Max Data Delay
In today’s article, we will talk about Standby Max Data Delay. While some of the reporting users who make inquiries from Active Data Guard expect the retrieved data to be the same as the Production at that moment, others do not care if LAG has been formed for a few seconds. The time until this …
Read: Standby Max Data Delay.
In today’s article, we will talk about Standby Max Data Delay. While some of the reporting users who make inquiries from Active Data Guard expect the retrieved data to be the same as the Production at that moment, others do not care if LAG has been formed for a few seconds. The time until this …
Read: Standby Max Data Delay.
How To Setup Physical Standby Database
In today’s article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard installation on Primary and Standby databases in Oracle 11g R2 architecture is explained using SQL*Plus and RMAN without using OEM. Operating system : RedHat 5.9 Database Software : Oracle 11g R2 Cluster …
Read: How To Setup Physical Standby Database.
In today’s article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard installation on Primary and Standby databases in Oracle 11g R2 architecture is explained using SQL*Plus and RMAN without using OEM. Operating system : RedHat 5.9 Database Software : Oracle 11g R2 Cluster …
Read: How To Setup Physical Standby Database.
Import Dat File Into PostgreSQL
In today’s article we will cover the topic of Import Dat File Into PostgreSQL. Sometimes we need to import/export some tables in PostgreSQL. In this article, we will import the .dat file on PostgreSQL into the table. While doing this, we will do it through pgadmin, which is the simplest and easiest way. First of …
Read: Import Dat File Into PostgreSQL.
In today’s article we will cover the topic of Import Dat File Into PostgreSQL. Sometimes we need to import/export some tables in PostgreSQL. In this article, we will import the .dat file on PostgreSQL into the table. While doing this, we will do it through pgadmin, which is the simplest and easiest way. First of …
Read: Import Dat File Into PostgreSQL.
Remotely Connect PostgreSQL Running on Azure Linux VM
In today’s article, I will explain the topic of Remotely Connect PostgreSQL Running on Azure Linux VM. In order to do this, we need to edit the pg_hba.conf and postgresql.conf files. These files are located in /etc/postgresql/version_info/main. The version information here varies according to the installed PostgreSQL version information. On our server, the access method …
Read: Remotely Connect PostgreSQL Running on Azure Linux VM.
In today’s article, I will explain the topic of Remotely Connect PostgreSQL Running on Azure Linux VM. In order to do this, we need to edit the pg_hba.conf and postgresql.conf files. These files are located in /etc/postgresql/version_info/main. The version information here varies according to the installed PostgreSQL version information. On our server, the access method …
Read: Remotely Connect PostgreSQL Running on Azure Linux VM.
Basic Linux Command
In today’s article I will give information about Basic Linux Command. Cd : You can enter the specified folder with the cd command and you can go to the home directory of the user you are connected to from the directory you are connected to by simply typing cd. After the cd command, you write …
Read: Basic Linux Command.
In today’s article I will give information about Basic Linux Command. Cd : You can enter the specified folder with the cd command and you can go to the home directory of the user you are connected to from the directory you are connected to by simply typing cd. After the cd command, you write …
Read: Basic Linux Command.
Why CockroachDB Serverless is the real deal
After writing my last article about Next Gen databases, I wanted to dig into CockroachDB and all it had to offer. It seemed like such an interesting new technology to me. I had heard of them before but never put aside the time to dive in and see how ...
Read: https://pythondev.hashnode.dev/why-cockroachdb-serverless-is-the-real-deal
After writing my last article about Next Gen databases, I wanted to dig into CockroachDB and all it had to offer. It seemed like such an interesting new technology to me. I had heard of them before but never put aside the time to dive in and see how ...
Read: https://pythondev.hashnode.dev/why-cockroachdb-serverless-is-the-real-deal
Physical migration of Oracle databases to Amazon RDS Custom using Data Guard
Read: https://aws.amazon.com/blogs/database/physical-migration-of-oracle-databases-to-amazon-rds-custom-using-data-guard/
Read: https://aws.amazon.com/blogs/database/physical-migration-of-oracle-databases-to-amazon-rds-custom-using-data-guard/
Day 1/100
HDFS - [Hadoop Distributed File System]
HDFS architecture looks like this -
NameNode holds all the metadata about files and directory structure and then there are
DataNodes which basically hold files in the form of blocks so DataNode holds blocks o...
Read: https://rawdatareaders.hashnode.dev/day-1
HDFS - [Hadoop Distributed File System]
HDFS architecture looks like this -
NameNode holds all the metadata about files and directory structure and then there are
DataNodes which basically hold files in the form of blocks so DataNode holds blocks o...
Read: https://rawdatareaders.hashnode.dev/day-1
Oracle Database 19c Running @Memory Speed
Persistent Memory Database starting Oracle 19.12 using Oracle Memory Speed (OMS).
Read: https://blogs.oracle.com/database/post/oracle-database-19c-running-memory-speed
Persistent Memory Database starting Oracle 19.12 using Oracle Memory Speed (OMS).
Read: https://blogs.oracle.com/database/post/oracle-database-19c-running-memory-speed
Oracle
Oracle Database 19c Running @Memory Speed
Persistent Memory Database starting Oracle 19.12 using Oracle Memory Speed (OMS).
Building a Vector Database for Scalable Similarity Search
According to statistics, about 80%-90% of the world's data is unstructured. Fueled by the rapid growth of the Internet, an explosion of unstructured data is expected in the coming years. Consequently, companies are in urgent need of a powerful databa...
Read: https://angela.hashnode.dev/building-a-vector-database-for-scalable-similarity-search
According to statistics, about 80%-90% of the world's data is unstructured. Fueled by the rapid growth of the Internet, an explosion of unstructured data is expected in the coming years. Consequently, companies are in urgent need of a powerful databa...
Read: https://angela.hashnode.dev/building-a-vector-database-for-scalable-similarity-search
Accelerating Similarity Search on Really Big Data with Vector Indexing (Part II)
From computer vision to new drug discovery, many popular artificial intelligence (AI) applications are powered by vector databases. Indexing, a process of organizing data that drastically accelerates big data search, enables us to efficiently query m...
Read: https://angela.hashnode.dev/accelerating-similarity-search-on-really-big-data-with-vector-indexing-part-ii
From computer vision to new drug discovery, many popular artificial intelligence (AI) applications are powered by vector databases. Indexing, a process of organizing data that drastically accelerates big data search, enables us to efficiently query m...
Read: https://angela.hashnode.dev/accelerating-similarity-search-on-really-big-data-with-vector-indexing-part-ii