ProHoster > Блог > Nchịkwa > Ihe nrụnye nchekwa data - atụnyere PostgreSQL, Cassandra na MongoDB

Ihe nrụnye nchekwa data - atụnyere PostgreSQL, Cassandra na MongoDB

Ndewo, enyi. Tupu ị pụọ maka akụkụ nke abụọ nke ezumike May, anyị na-eso gị kerịta ihe anyị tụgharịrị na atụmanya mmalite nke iyi ọhụrụ na usoro ahụ. "DBMS mmekọrịta".

Ihe nrụnye nchekwa data - atụnyere PostgreSQL, Cassandra na MongoDB

Ndị na-emepụta ngwa na-etinye oge dị ukwuu na-atụnyere ọtụtụ ọdụ data arụ ọrụ iji họrọ nke kacha dabara maka ọrụ a chọrọ. Mkpa nwere ike ịgụnye nhazi data dị mfe, nkwenye azụmahịa, ịrụ ọrụ ọgụgụ/dee, nlegharị anya kwụ ọtọ, na nnabata mmejọ. Na omenala, nhọrọ na-amalite site na ngalaba nchekwa data, SQL ma ọ bụ NoSQL, ebe ọ bụ na otu ọ bụla na-enye usoro ahia ahia doro anya. A na-ahụkarị arụmọrụ dị elu n'ihe gbasara nkwụsịtụ dị ala na ntinye dị elu dị ka ihe na-adịghị agwụ agwụ na ya mere ọ dị mkpa maka nchekwa data ọ bụla.

Ebumnuche nke edemede a bụ inyere ndị mmepe ngwa aka ime nhọrọ ziri ezi n'etiti SQL na NoSQL n'ihe gbasara nhazi data ngwa. Anyị ga-eleba anya na otu nchekwa data SQL, ya bụ PostgreSQL, na ọdụ data NoSQL abụọ, Cassandra na MongoDB, iji kpuchie ihe ndabere nke imepụta nchekwa data, dị ka imepụta tebụl, ibipụta ya, ịgụ data sitere na tebụl, na ihichapụ ya. N'edemede na-esote, anyị ga-ahụ na anyị ga-eleba anya na ndenye aha, azụmahịa, JOINs, ntuziaka TTL na imewe nchekwa data dabere na JSON.

Kedu ihe dị iche n'etiti SQL na NoSQL?

Ebe nchekwa data SQL na-abawanye mgbanwe ngwa site na nkwa azụmahịa ACID, yana ike ha ịjụ data site na iji JOIN n'ụzọ ndị a na-atụghị anya ya n'elu ụdị nchekwa data mmekọrịta ahaziri ahazi.

Nyere ha monolithic / otu ọnụ architecture na ojiji nke nna ukwu-ohu replication nlereanya maka redundancy, omenala SQL ọdụ data enweghị ihe abụọ dị mkpa atụmatụ - linear dee scalability (ya bụ akpaka partitioning gafee multiple nodes) na akpaka / efu data ọnwụ. Nke a pụtara na ọnụọgụ data enwetara enweghị ike ịgafe oke ederede nke otu ọnụ. Na mgbakwunye, a ga-eburu n'uche ụfọdụ mfu data nwa oge na nnabata mmejọ (n'ime ụlọ na-ekekọrịta-enweghị ihe ọ bụla). N'ebe a, ị kwesịrị iburu n'uche na ihe omume ndị e mere n'oge na-adịbeghị anya egosipụtabeghị na akwụkwọ ohu ahụ. Mmelite ndị na-adịghị ala ala na-esikwa ike inweta na ọdụ data SQL.

A na-ekesakarị ọdụ data NoSQL site na okike, ya bụ. n'ime ha, a na-ekewa data na ngalaba ma kesaa n'ọtụtụ ọnụ. Ha chọrọ denormalization. Nke a pụtara na a ga-eṅomikwa data etinyere ọtụtụ oge iji zaghachi arịrịọ ndị ị zigara. Ebumnuche n'ozuzu ya bụ ịnweta arụmọrụ dị elu site n'ibelata ọnụ ọgụgụ nke shards dị n'oge a na-agụ. Nke a na-egosi na NoSQL chọrọ ka ị ṅomie ajụjụ gị, ebe SQL chọrọ ka ịmee data gị.

NoSQL na-elekwasị anya n'inweta arụmọrụ dị elu na ụyọkọ kesara na nke a bụ isi ihe kpatara ọtụtụ azụmaahịa imewe nchekwa data gụnyere mfu azụmahịa ACID, JOINs, yana ndenye aha abụọ zuru ụwa ọnụ na-agbanwe agbanwe.

Enwere arụmụka na ebe nchekwa data NoSQL na-enye scalability ederede na oke mmejọ, mfu nke nkwa azụmahịa na-eme ka ha ghara ịdị mma maka data dị mkpa.

Tebụlụ na-esote na-egosi ka nhazi data na NoSQL si dị iche na SQL.

Ihe nrụnye nchekwa data - atụnyere PostgreSQL, Cassandra na MongoDB

SQL na NoSQL: Gịnị mere ha abụọ ji dị mkpa?

Ngwa n'ezie nwere ọnụ ọgụgụ buru ibu nke ndị ọrụ, dị ka Amazon.com, Netflix, Uber, na Airbnb, na-arụ ọrụ dị mgbagwoju anya, ọrụ dị iche iche. Dịka ọmụmaatụ, ngwa e-azụmahịa dị ka Amazon.com kwesịrị ịchekwa data dị fechaa, dị elu dị ka ozi njirimara, ngwaahịa, iwu, akwụkwọ ọnụahịa, yana data dị arọ, na-enwechaghị mmetụta dị ka nyocha ngwaahịa, ozi nkwado, ọrụ onye ọrụ. nyocha onye ọrụ na ndụmọdụ. Dị ka o kwesịrị ịdị, ngwa ndị a dabere na opekata mpe otu nchekwa data SQL yana opekata mpe otu nchekwa data NoSQL. Na sistemu mpaghara na mpaghara ụwa, nchekwa data NoSQL na-arụ ọrụ dị ka ebe nchekwa geo-ekesa maka data echekwara na ebe nchekwa data SQL tụkwasịrị obi na-agba na mpaghara ụfọdụ.

Kedu ka YugaByte DB si ejikọta SQL na NoSQL?

Ewubere na injin nchekwa agwakọta gbanyere mkpọrọgwụ, nzacha akpaaka, mmeghari nkwekọrịta nkesa nkesa na azụmahịa nkesa ACID (nke Google Spanner sitere n'ike mmụọ nsọ), YugaByte DB bụ nchekwa data mepere emepe nke mbụ n'ụwa nke dabara na NoSQL (Cassandra & Redis) na n'otu oge. SQL (PostgreSQL). Dị ka egosiri na tebụl dị n'okpuru, YCQL, YugaByte DB API dakọtara na Cassandra, na-agbakwụnye echiche nke azụmahịa ACID otu na multi-key yana akara nke abụọ zuru ụwa ọnụ na NoSQL API, si otú ahụ na-ebute oge nke nchekwa data NoSQL azụmahịa. Na mgbakwunye, YCQL, YugaByte DB API dakọtara na PostgreSQL, na-agbakwunye echiche nke akara ederede linear na nnabata mmejọ akpaka na SQL API, na-ebute ọdụ data SQL kesara ụwa. N'ihi na YugaByte DB bụ azụmahịa na okike, enwere ike iji NoSQL API ugbu a na ọnọdụ nke data dị mkpa.

Ihe nrụnye nchekwa data - atụnyere PostgreSQL, Cassandra na MongoDB

Dị ka e kwuru na mbụ n'isiokwu ahụ "Na-ewebata YSQL: A PostgreSQL SQL API ekesara maka YugaByte DB", nhọrọ n'etiti SQL ma ọ bụ NoSQL na YugaByte DB dabere kpamkpam na njirimara nke ọrụ dị n'okpuru:

  • Ọ bụrụ na ibu ọrụ gị bụ isi bụ arụmọrụ JOIN multi-key, mgbe ahụ, mgbe ị na-ahọrọ YSQL, ghọta na enwere ike kesaa igodo gị n'ofe ọtụtụ ọnụ, na-ebute latency dị elu na/ma ọ bụ mmepụta dị ala karịa NoSQL.
  • Ma ọ bụghị ya, họrọ nke ọ bụla n'ime API NoSQL abụọ ahụ, na-eburu n'uche na ị ga-enweta arụmọrụ ka mma n'ihi ajụjụ ndị sitere n'otu ọnụ ọnụ n'otu oge. YugaByte DB nwere ike ije ozi dị ka otu nchekwa data arụ ọrụ maka ụwa n'ezie, ngwa mgbagwoju anya nke chọrọ ijikwa ọtụtụ ọrụ n'otu oge.

Ụlọ nyocha ihe ngosi data dị na ngalaba na-esote dabere na ọdụ data data YugaByte DB dakọtara PostgreSQL na Cassandra API, na-emegide ọdụ data ala. Ụzọ a na-emesi ịdị mfe nke imekọrịta ihe na API abụọ dị iche iche (na ọdụ ụgbọ mmiri abụọ) nke otu ụyọkọ nchekwa data, na-emegide iji ụyọkọ nwere onwe zuru oke nke ọdụ data abụọ dị iche iche.
N'akụkụ ndị a, anyị ga-eleba anya na Data Modeling Lab iji gosi ndịiche na ụfọdụ ihe jikọrọ nke ọdụ data kpuchiri.

Data Modeling Laboratory

Ntinye nchekwa data

N'iburu ndoro-ndoro anya na imepụta ụdị data (kama ịwụnye ụlọ ọrụ nchekwa dị mgbagwoju anya), anyị ga-etinye ọdụ data n'ime igbe Docker na igwe mpaghara wee soro ha na-eji shells ahịrị ahịrị na-emekọrịta ihe.

PostgreSQL & Cassandra dakọtara YugaByte DB nchekwa data

mkdir ~/yugabyte && cd ~/yugabyte
wget https://downloads.yugabyte.com/yb-docker-ctl && chmod +x yb-docker-ctl
docker pull yugabytedb/yugabyte
./yb-docker-ctl create --enable_postgres

MongoDB

docker run --name my-mongo -d mongo:latest

Nweta ahịrị iwu

Ka anyị jikọọ na ọdụ data site na iji shei ahịrị iwu maka API ndị kwekọrọ.

PostgreSQL

psql bụ shei ahịrị iwu maka imekọrịta na PostgreSQL. Maka ịdị mfe nke iji, YugaByte DB na-abịa na psql ziri ezi na nchekwa biini.

docker exec -it yb-postgres-n1 /home/yugabyte/postgres/bin/psql -p 5433 -U postgres

Cassandra

cqlsh bụ shei ahịrị iwu maka ịmekọrịta Cassandra yana ọdụ data dakọtara site na CQL (Asụsụ Cassandra Query). Maka ịdị mfe nke ojiji, YugaByte DB na-abịa cqlsh na katalọgụ bin.
Rịba ama na CQL sitere na SQL ma nwee echiche ndị yiri ya nke tebụl, ahịrị, kọlụm na ndeksi. Otú ọ dị, dị ka asụsụ NoSQL, ọ na-agbakwụnye ụfọdụ njedebe, ọtụtụ n'ime ha ga-ekpuchikwa n'isiokwu ndị ọzọ.

docker exec -it yb-tserver-n1 /home/yugabyte/bin/cqlsh

MongoDB

Mongo bụ shei ahịrị iwu maka ịmekọrịta na MongoDB. Enwere ike ịchọta ya na ndekọ ndekọ nke nrụnye MongoDB.

docker exec -it my-mongo bash 
cd bin
mongo

Mepụta tebụl

Ugbu a, anyị nwere ike ịmekọrịta na nchekwa data iji rụọ ọrụ dị iche iche site na iji ahịrị iwu. Ka anyị bido site n'ịmepụta tebụl na-echekwa ozi gbasara egwu nke ndị nka dị iche iche dere. Egwu ndị a nwere ike ịbụ akụkụ nke ọba. Àgwà ọma nhọrọ maka abụ bụ afọ ntọhapụ, ọnụahịa, ụdị na ọkwa. Anyị kwesịrị ịza ajụjụ maka njirimara ndị ọzọ nwere ike ịdị mkpa n'ọdịnihu site na mpaghara "tags". Ọ nwere ike ịchekwa data ahazibere n'ụdị isi ụzọ abụọ bara uru.

PostgreSQL

CREATE TABLE Music (
    Artist VARCHAR(20) NOT NULL, 
    SongTitle VARCHAR(30) NOT NULL,
    AlbumTitle VARCHAR(25),
    Year INT,
    Price FLOAT,
    Genre VARCHAR(10),
    CriticRating FLOAT,
    Tags TEXT,
    PRIMARY KEY(Artist, SongTitle)
);

Cassandra

Ịmepụta tebụl na Cassandra yiri nnọọ PostgreSQL. Otu n'ime isi ihe dị iche bụ enweghị mmachi iguzosi ike n'ezi ihe (dịka ọmụmaatụ, ọ bụghị NULL), mana nke a bụ ọrụ nke ngwa ahụ, ọ bụghị nchekwa data NoSQL.. Isi igodo nwere igodo nkebi (kọlụm ndị nka na ihe atụ dị n'okpuru) yana otu kọlụm nchịkọta (kọlụm SongTitle dị na ọmụmaatụ n'okpuru). Igodo nkebi na-ekpebi nkebi/shard ahịrị kwesịrị itinye n'ime ya, na kọlụm nchịkọta na-egosi ka esi hazie data n'ime shard dị ugbu a.

CREATE KEYSPACE myapp;
USE myapp;
CREATE TABLE Music (
    Artist TEXT, 
    SongTitle TEXT,
    AlbumTitle TEXT,
    Year INT,
    Price FLOAT,
    Genre TEXT,
    CriticRating FLOAT,
    Tags TEXT,
    PRIMARY KEY(Artist, SongTitle)
);

MongoDB

MongoDB na-ahazi data n'ime ọdụ data (Database) (dị ka Keyspace dị na Cassandra), ebe enwere mkpokọta (nke yiri tebụl) nwere akwụkwọ (nke yiri ahịrị na tebụl). Na MongoDB, ọ dịghị mkpa ịkọwapụta atụmatụ mbụ. Otu "jiri nchekwa data", nke egosiri n'okpuru, na-ewepụta nchekwa data na oku nke mbụ wee gbanwee ọnọdụ maka nchekwa data emepụtara ọhụrụ. Ọbụlagodi mkpokọta adịghị mkpa ka emepụta nke ọma; a na-emepụta ya na-akpaghị aka, naanị mgbe ị gbakwunyere akwụkwọ mbụ na mkpokọta ọhụrụ. Rịba ama na MongoDB na-eji nchekwa data ule na ndabara, yabụ ọrụ ọ bụla nchịkọta ọkwa na-akọwapụtaghị otu nchekwa data ga-agba ọsọ na ya na ndabara. 

use myNewDatabase;

Inweta ozi gbasara tebụl
PostgreSQL

d Music
Table "public.music"
    Column    |         Type          | Collation | Nullable | Default 
--------------+-----------------------+-----------+----------+--------
 artist       | character varying(20) |           | not null | 
 songtitle    | character varying(30) |           | not null | 
 albumtitle   | character varying(25) |           |          | 
 year         | integer               |           |          | 
 price        | double precision      |           |          | 
 genre        | character varying(10) |           |          | 
 criticrating | double precision      |           |          | 
 tags         | text                  |           |          | 
Indexes:
    "music_pkey" PRIMARY KEY, btree (artist, songtitle)

Cassandra 

DESCRIBE TABLE MUSIC;
CREATE TABLE myapp.music (
    artist text,
    songtitle text,
    albumtitle text,
    year int,
    price float,
    genre text,
    tags text,
    PRIMARY KEY (artist, songtitle)
) WITH CLUSTERING ORDER BY (songtitle ASC)
    AND default_time_to_live = 0
    AND transactions = {'enabled': 'false'};

MongoDB

use myNewDatabase;
show collections;

Ịbanye data n'ime tebụl
PostgreSQL

INSERT INTO Music 
    (Artist, SongTitle, AlbumTitle, 
    Year, Price, Genre, CriticRating, 
    Tags)
VALUES(
    'No One You Know', 'Call Me Today', 'Somewhat Famous',
    2015, 2.14, 'Country', 7.8,
    '{"Composers": ["Smith", "Jones", "Davis"],"LengthInSeconds": 214}'
);
INSERT INTO Music 
    (Artist, SongTitle, AlbumTitle, 
    Price, Genre, CriticRating)
VALUES(
    'No One You Know', 'My Dog Spot', 'Hey Now',
    1.98, 'Country', 8.4
);
INSERT INTO Music 
    (Artist, SongTitle, AlbumTitle, 
    Price, Genre)
VALUES(
    'The Acme Band', 'Look Out, World', 'The Buck Starts Here',
    0.99, 'Rock'
);
INSERT INTO Music 
    (Artist, SongTitle, AlbumTitle, 
    Price, Genre, 
    Tags)
VALUES(
    'The Acme Band', 'Still In Love', 'The Buck Starts Here',
    2.47, 'Rock', 
    '{"radioStationsPlaying": ["KHCR", "KBQX", "WTNR", "WJJH"], "tourDates": { "Seattle": "20150625", "Cleveland": "20150630"}, "rotation": Heavy}'
);

Cassandra

N'ozuzu okwu INSERT na Cassandra yiri nke ahụ na PostgreSQL. Agbanyeghị, enwere otu nnukwu ọdịiche dị na semantics. Na Cassandra INSERT bụ n'ezie ọrụ UPSERT, ebe a na-agbakwunye ụkpụrụ ikpeazụ na ahịrị ma ọ bụrụ na ahịrị adịlarị.

Ntinye data yiri PostgreSQL INSERT elu

.

MongoDB

Ọ bụ ezie na MongoDB bụ nchekwa data NoSQL dị ka Cassandra, ọrụ ntinye ya enweghị ihe jikọrọ ya na omume semantic nke Cassandra. Na MongoDB fanye () enweghị ohere UPSERT, nke na-eme ka ọ dị ka PostgreSQL. Na-agbakwụnye data ndabara na-enweghị _idspecified ga-eme ka etinye akwụkwọ ọhụrụ na mkpokọta.

db.music.insert( {
artist: "No One You Know",
songTitle: "Call Me Today",
albumTitle: "Somewhat Famous",
year: 2015,
price: 2.14,
genre: "Country",
tags: {
Composers: ["Smith", "Jones", "Davis"],
LengthInSeconds: 214
}
}
);
db.music.insert( {
artist: "No One You Know",
songTitle: "My Dog Spot",
albumTitle: "Hey Now",
price: 1.98,
genre: "Country",
criticRating: 8.4
}
);
db.music.insert( {
artist: "The Acme Band",
songTitle: "Look Out, World",
albumTitle:"The Buck Starts Here",
price: 0.99,
genre: "Rock"
}
);
db.music.insert( {
artist: "The Acme Band",
songTitle: "Still In Love",
albumTitle:"The Buck Starts Here",
price: 2.47,
genre: "Rock",
tags: {
radioStationsPlaying:["KHCR", "KBQX", "WTNR", "WJJH"],
tourDates: {
Seattle: "20150625",
Cleveland: "20150630"
},
rotation: "Heavy"
}
}
);

Ajụjụ tebụl

Ikekwe ihe dị iche n'etiti SQL na NoSQL n'ihe gbasara owuwu ajụjụ bụ asụsụ a na-eji FROM и WHERE. SQL na-enye ohere mgbe okwu FROM họrọ otutu tebụl, na okwu na WHERE nwere ike ịbụ nke mgbagwoju anya ọ bụla (gụnyere arụmọrụ JOIN n'etiti tebụl). Agbanyeghị, NoSQL na-achọ ịmanye oke oke na FROM, ma rụọ ọrụ naanị na otu tebụl akọwapụtara, yana n'ime WHERE, isi igodo ga-abụ kpọmkwem mgbe niile. Nke a na-ejikọ aka na ntinye arụmọrụ NoSQL anyị kwurula na mbụ. Ọchịchọ a na-eduga na mbelata ọ bụla nwere ike ime na mkparịta ụka cross-tabular na cross-key. Ọ nwere ike iwebata nnukwu igbu oge na nkwurịta okwu inter-node mgbe ị na-aza arịrịọ ma ya mere a na-ezere ya nke ọma n'ozuzu ya. Dịka ọmụmaatụ, Cassandra chọrọ ka ọ bụrụ naanị ụfọdụ ndị na-arụ ọrụ (naanị =, IN, <, >, =>, <=) na igodo nkebi, belụsọ mgbe ị na-arịọ index nke abụọ (naanị = onye ọrụ ka anabatara ebe a).

PostgreSQL

N'okpuru bụ ọmụmaatụ ajụjụ atọ nwere ike ịme ngwa ngwa site na nchekwa data SQL.

  • Gosipụta egwu niile nke onye na-ese ihe;
  • Gosipụta egwu niile nke onye na-ese ihe dabara na akụkụ mbụ nke aha ahụ;
  • Gosipụta egwu niile nke onye na-ese ihe nwere otu mkpụrụokwu n'aha ma nwee ọnụ ahịa na-erughị 1.00. 
SELECT * FROM Music
WHERE Artist='No One You Know';
SELECT * FROM Music
WHERE Artist='No One You Know' AND SongTitle LIKE 'Call%';
SELECT * FROM Music
WHERE Artist='No One You Know' AND SongTitle LIKE '%Today%'
AND Price > 1.00;

Cassandra

N'ime ajụjụ PostgreSQL edepụtara n'elu, naanị nke mbụ ga-arụ ọrụ na-agbanweghị agbanwe na Cassandra, ebe ọ bụ na onye ọrụ. LIKE enweghị ike itinye na kọlụm ụyọkọ dị ka SongTitle. N'okwu a, ọ bụ naanị ndị ọrụ ka a na-anabata = и IN.

SELECT * FROM Music
WHERE Artist='No One You Know';
SELECT * FROM Music
WHERE Artist='No One You Know' AND SongTitle IN ('Call Me Today', 'My Dog Spot')
AND Price > 1.00;

MongoDB

Dịka e gosiri na ihe atụ ndị gara aga, usoro bụ isi maka ịmepụta ajụjụ na MongoDB bụ db. mkpokọta. chọta (). Usoro a nwere n'ụzọ doro anya aha nchịkọta (music na ọmụmaatụ n'okpuru), yabụ amachibidoro ịjụ ajụjụ ọtụtụ nchịkọta.

db.music.find( {
  artist: "No One You Know"
 } 
);
db.music.find( {
  artist: "No One You Know",
  songTitle: /Call/
 } 
);

Na-agụ ahịrị niile nke tebụl

Ịgụ ahịrị niile bụ naanị ihe pụrụ iche nke ụkpụrụ ajụjụ anyị lere anya na mbụ.

PostgreSQL

SELECT * 
FROM Music;

Cassandra

Yiri ihe atụ PostgreSQL dị n'elu.

MongoDB

db.music.find( {} );

Na-edezi data na tebụl

PostgreSQL

PostgreSQL na-enye ntuziaka UPDATE ịgbanwe data. O nweghị ohere UPSERT, yabụ nkwupụta a ga-ada ma ọ bụrụ na ahịrị adịghịzi na nchekwa data.

UPDATE Music
SET Genre = 'Disco'
WHERE Artist = 'The Acme Band' AND SongTitle = 'Still In Love';

Cassandra

Cassandra nwere UPDATE dị ka PostgreSQL. UPDATE nwere otu semantics UPSERT, yiri INSERT.

Yiri ihe atụ PostgreSQL dị n'elu.

MongoDB
Ọrụ nwelite () na MongoDB nwere ike imelite akwụkwọ dị adị kpamkpam ma ọ bụ melite naanị mpaghara ụfọdụ. Site na ndabara, ọ na-emelite naanị otu akwụkwọ nwere semantics nwere nkwarụ UPSERT. Na-emelite ọtụtụ akwụkwọ na omume yiri ya UPSERT enwere ike itinye ya n'ọrụ site na ịtọ ọkọlọtọ ndị ọzọ maka ọrụ ahụ. Dịka ọmụmaatụ, na ihe atụ dị n'okpuru, a na-emelite ụdị onye na-ese ihe na-adabere na egwu ya.

db.music.update(
  {"artist": "The Acme Band"},
  { 
    $set: {
      "genre": "Disco"
    }
  },
  {"multi": true, "upsert": true}
);

Na-ewepụ data na tebụl

PostgreSQL

DELETE FROM Music
WHERE Artist = 'The Acme Band' AND SongTitle = 'Look Out, World';

Cassandra

Yiri ihe atụ PostgreSQL dị n'elu.

MongoDB

MongoDB nwere ụdị ọrụ abụọ iji ihichapụ akwụkwọ - deleteOne() /Hichapụ Ọtụtụ() и wepu (). Ụdị abụọ a na-ehichapụ akwụkwọ mana weghachi rịzọlt dị iche iche. 

db.music.deleteMany( {
        artist: "The Acme Band"
    }
);

Ihichapụ tebụl

PostgreSQL

DROP TABLE Music;

Cassandra

Yiri ihe atụ PostgreSQL dị n'elu.

MongoDB

db.music.drop();

nkwubi

Arụmụka banyere ịhọrọ n'etiti SQL na NoSQL anọwo na-eme ihe karịrị afọ 10. Enwere isi ihe abụọ na arụmụka a: nchekwa data engine architecture (monolithic, transactional SQL vs nkesa, NoSQL na-abụghị azụmahịa) na usoro nhazi nchekwa data (ịmepụta data gị na SQL vs ịmegharị ajụjụ gị na NoSQL).

Site na nchekwa data azụmahịa ekesa dị ka YugaByte DB, arụmụka gbasara ụkpụrụ nchekwa data nwere ike ịdobe ngwa ngwa. Ka mpịakọta data na-ebuwanye ibu karịa ihe enwere ike ịdere na otu ọnụ ọnụ, ihe owuwu ekesa nke ọma nke na-akwado scalability ederede na ngbanwe akpaka na-adị mkpa.

E wezụga nke ahụ, dị ka e kwuru n'otu n'ime isiokwu ndị ahụ Google Cloud, Transactional, ike na-agbanwe agbanwe architectures bụ ugbu a karịa ,eji na-enye mma agility na mmepe karịa na-abụghị azụmahịa, , N'ikpeazụ agbanwe agbanwe architectures.

Na-alaghachi na mkparịta ụka imewe nchekwa data, ọ dị mma ịsị na ụzọ imewe abụọ ahụ (SQL na NoSQL) dị mkpa maka ngwa ọ bụla dị mgbagwoju anya nke ụwa. Usoro SQL "data modeling" na-enye ohere ka ndị mmepe nwee ike izute mgbanwe azụmahịa chọrọ n'ụzọ dị mfe, ebe usoro NoSQL "question modeling" na-enye ohere ka otu ndị mmepe ahụ rụọ ọrụ na nnukwu data na obere latency na nnukwu mmepụta. Ọ bụ ya mere YugaByte DB na-enye SQL na NoSQL API n'otu isi, kama ịkwalite otu n'ime ụzọ. Na mgbakwunye, site n'inye ndakọrịta na asụsụ nchekwa data ama ama gụnyere PostgreSQL na Cassandra, YugaByte DB na-eme ka o doo anya na ndị mmepe agaghị amụta asụsụ ọzọ iji jiri igwe nchekwa data ekesa, na-agbanwe agbanwe nke ukwuu.

N'edemede a, anyị lere anya ka ihe ndabere nchekwa data si dị iche n'etiti PostgreSQL, Cassandra, na MongoDB. N'edemede n'ọdịnihu, anyị ga-abanye n'ime echiche imewe dị elu dị ka ndeksi, azụmahịa, JOINs, ntuziaka TTL, na akwụkwọ JSON.

Anyị na-achọ gị ezigbo ezumike nke izu ụka ma na-akpọ gị òkù ka ị bịa webinar efu, nke ga-eme na Mee 14th.

isi: www.habr.com

Tinye a comment