day41 Numeric type Integer type
mysql> create table t1(id tinyint); # The default is signed, that is, there is a sign before the number Unsigned setting mysql> create table t1(id tinyint uns
Month: September 2021
Nosql: MongoDB or BigTable is not always “available”
Read Nathan Hurst’s Visual Guide to NoSQL Systems, he includes the CAP triangle:
>Consistency
>Availability
> Partition tolerance
SQL Server is an AC system, and MongoDB is a CP system.
Why do we use NOSQL?
Knowing some of the advantages provided by NoSQL (scalability, usability, etc.), I still don’t know why a website wants to use a non-relational database.
Can I get some help, is it best to use an
Data Warehouse – Data Warehouse Principle and NOSQL
Using MongoDB, CouchDB and related technologies, we can query faster, is this still valid?
“A copy of transaction data, specifically for query and analysis.” (R. Kimball The Data Warehouse To
Riak performance – unexpected results
In the last days, I had a fight with Riak. The initial setup was easier than I thought. Now I have a 3-node cluster. For testing purposes, all nodes are running on the same vm.
I admit that t
How many data have each node in the NOSQL – Cassandra cluster?
When do the boundaries of SSTables compression (primary and secondary) become invalid?
If I have the main compression of 500G SSTables and my final SSTable will exceed 1TB-is this effective f
PostgreSQL – PG_RESTORE: [Archiver] Input file is too short in Postgres
I am trying to dump the database in my local system by using the command:
pg_restore –host=localhost- -port=5432 –dbname=dev_db –no-owner –no-privileges db_dump_new.backup But I get an er
PostgreSQL common statement
postgres=# create database mydb;
CREATE DATABASE
postgres=# alter database mydb;
ALTER DATABASE
postgres=# create table mydbtable(name varchar(80),year int);
CREATE TABLE
postgre
Interpretation of the four families of the NOSQL database
In the current enterprise IT architecture, system administrators and DBAs will consider using NoSQL databases to solve problems that RDBMS cannot solve, especially in the Internet industry. Traditi
PostgreSQL Update the JSONB column using another list
I want to migrate data from one column (varchar) to another (jsonb)
Column | Type | Modifiers < br />————+—————————–+—- ——————————————