Chimodzi mwazosankha zofunika kwambiri zomwe wopanga mapulogalamu amapanga ndizomwe mungagwiritse ntchito. Kwa zaka zambiri, zosankha zinali zochepa pazosankha zosiyanasiyana za database zomwe zimathandizira Structured Query Language (SQL). Izi zikuphatikizapo MS SQL Server, Oracle, MySQL, PostgreSQL, DB2 ndi zina zambiri.
Pazaka 15 zapitazi, nkhokwe zambiri zatsopano zalowa pamsika pansi pa njira ya No-SQL. Izi zikuphatikiza masitolo amtengo wapatali monga Redis ndi Amazon DynamoDB, nkhokwe zotakata ngati Cassandra ndi HBase, masitolo osungiramo zolemba ngati MongoDB ndi Couchbase, ndi nkhokwe zama graph ndi injini zosakira monga Elasticsearch ndi Solr.
M'nkhaniyi, tiyesa kumvetsetsa SQL ndi NoSQL popanda kulowa muzochita zawo.
Komanso, tidzakhala ndi zosangalatsa m'njira.
Kufotokozera SQL kwa Agogo
Agogo taganizani kuti sindine mdzukulu wanu yekhayo. M'malo mwake, amayi ndi abambo ankakondana ngati akalulu, anali ndi ana 100, kenako anatengera ena 50.
Chifukwa chake, mumatikonda tonsefe ndipo simukufuna kuiwala mayina athu, masiku obadwa, zokometsera za ayisikilimu zomwe timakonda, kukula kwa zovala, zokonda, mayina aakazi, mayina a ana ndi mfundo zina zofunika kwambiri. Komabe, tiyeni tivomereze. Ndinu zaka 85 zakubadwa ndipo mukukumbukira bwino lomwe simungakwanitse.
Mwamwayi, pokhala wochenjera kwambiri pa zidzukulu zanu, ndikhoza kukuthandizani. Ndiye ndimabwera kunyumba kwanu, ndikutulutsa mapepala ndikukupemphani kuti muphike makeke tisanayambe.
Pa pepala limodzi, timapanga mndandanda wotchedwa "Adzukulu". Aliyense mdzukulu yolembedwa ndi chidziŵitso chofunika kwambiri chokhudza iye, kuphatikizapo nambala yapadera imene isonyeza mmene achitira mdzukulu iye ali. Ndiponso, pofuna kulinganiza zinthu, timalemba mikhalidwe yotchulidwa pamwamba pa ndandandayo kuti nthaŵi zonse tidziŵe zimene ndandandayo ili nayo.
id
dzina
tsiku lobadwa
ulendo womaliza
kukula kwa zovala
ayisikilimu wokondedwa
adalandira
1
Jimmy
09-22-1992
09-01-2019
L
chokoleti chakuda
zabodza
2
Jessica
07-21-1992
02-22-2018
M
Mwala msewu
koona
…tikupitiriza mndandanda!
Mndandanda wa zidzukulu
Patapita kanthawi, mumamvetsa zonse ndipo tatsala pang'ono kumaliza mndandanda! Komabe, mumatembenukira kwa ine ndi kunena kuti: “Tinayiwala kuwonjezera malo kwa okwatirana, zosangalatsa, zidzukulu!” Koma ayi, sitinaiwale! Izi zikutsatiranso ndipo zimafuna pepala latsopano.
Chifukwa chake ndimatulutsa pepala lina ndipo pamenepo timatcha mndandanda Amuna ndi akazi. Timawonjezeranso makhalidwe omwe ali ofunika kwa ife pamwamba pa mndandanda ndikuyamba kuwonjezera mizere.
id
mdzukulu_id
dzina
tsiku lobadwa
1
2
John
06-01-1988
2
9
Fernanda
03-05-1985
…akazi ambiri!
Mndandanda wa okwatirana
Panthawiyi, ndikuwafotokozera agogo anga kuti ngati akufuna kudziwa kuti ndi ndani, ndiye kuti akuyenera kufanana. id m'ndandanda adzukulu с mdzukulu_id pa mndandanda wa okwatirana.
Pambuyo pa ma cookies angapo, ndiyenera kugona. "Kodi mungapitilize agogo?" Ndikupita kukagona.
Ndikubwerera m'maola ochepa. Ndinu abwino, agogo! Chilichonse chikuwoneka bwino kupatula mndandanda zosangalatsa. Pali zokonda pafupifupi 1000 pamndandanda. Ambiri aiwo amabwerezedwa; Zomwe zachitika?
mdzukulu_id
Zosangalatsa
1
kupalasa
4
kupalasa
3
kupalasa
7
athamanga
11
kupalasa
…tikupitiriza!
Pepani, ndinayiwalatu kunena! Pogwiritsa ntchito mndandanda umodzi, mutha kutsatira zosangalatsa. Ndiye mu mndandanda wina tiyenera kutsatira adzukuluamene akuchita izi zosangalatsa. Ife tizitcha izo "Common List". Powona kuti simukuzikonda, ndimakhala ndi nkhawa ndikubwerera ku mndandanda.
id
Zosangalatsa
1
kupalasa
2
athamanga
3
kusambira
…zokonda zambiri!
Mndandanda wa zokonda
Tikakhala ndi mndandanda wathu wazokonda, timapanga mndandanda wathu wachiwiri ndikuwutcha "Zokonda za adzukulu".
mdzukulu_id
hobby_id
4
1
3
1
7
2
…Zambiri!
Mndandanda wazinthu zokonda zidzukulu
Pambuyo pa ntchito yonseyi, agogo aakazi tsopano ali ndi makina abwino okumbukira kuti azitha kuyang'anira banja lawo lonse lalikulu modabwitsa. Ndiyeno - kuti andisunge motalika - akufunsa funso lamatsenga: "Kodi munaphunzira kuti kuchita zonsezi?"
Zogwirizana ndi database
Dongosolo lachiyanjano ndi gulu la matebulo ofotokozedwa bwino (muchitsanzo chathu, awa ndi masamba) omwe mungapezeko. zoperekedwa kapena kuwasonkhanitsa m'njira zosiyanasiyana popanda kukonzanso matebulo Nawonsomba. Pali mitundu yambiri yosiyanasiyana ya nkhokwe zaubale, koma mwatsoka mndandanda wa pepala siumodzi mwa iwo.
Chizindikiro cha nkhokwe zodziwika bwino zaubale ndi chilankhulo cha SQL (Structured Query Language). Chifukwa cha iye, ngati Agogo atumiza makina awo okumbukira zinthu ku kompyuta, angapeze mayankho mwamsanga ku mafunso onga akuti: “Ndani sanandichezere chaka chatha, ali wokwatira ndipo alibe zokonda?”
Chimodzi mwazinthu zodziwika bwino za kasamalidwe ka database ya SQL ndi gwero lotseguka la MySQL. Imakhazikitsidwa makamaka ngati relational database management system (RDBMS) pamapulogalamu apakompyuta.
Zina mwazofunikira za MySQL:
- Ndiwodziwika bwino, wogwiritsidwa ntchito kwambiri komanso woyesedwa kwambiri.
- Pali otukula ambiri aluso omwe ali ndi chidziwitso ndi SQL komanso nkhokwe zaubale.
- Deta imasungidwa m'matebulo osiyanasiyana, zomwe zimapangitsa kuti zikhale zosavuta kukhazikitsa maubwenzi pogwiritsa ntchito makiyi oyambirira ndi akunja (zozindikiritsa).
- Ndiosavuta kugwiritsa ntchito komanso yothandiza, ndikupangitsa kuti ikhale yabwino kwa mabizinesi akuluakulu ndi ang'onoang'ono.
- Khodi yoyambira ili pansi pa GNU General Public License.
Tsopano iwalani ZONSE.
Kufotokozera NoSQL kwa agogo
Agogo, tili ndi banja lalikulu. Ali ndi zidzukulu 150! Ambiri a iwo ndi okwatira, ali ndi ana, amakonda chinachake ndi zina zotero. Pa msinkhu wanu, n'zosatheka kukumbukira zonse za tonsefe. Zomwe mukufunikira ndi kukumbukira!
Mwamwayi, ine osati ndikufuna kuti muiwale kubadwa kwanga ndi ankakonda kukoma ayisikilimu, ine ndikhoza kuthandiza. Chifukwa chake ndimathamangira kusitolo yapafupi, ndikutenga kabuku ndikubwerera kunyumba kwako.
Chinthu choyamba chimene ndikuchita ndi kulemba “Adzukulu” m’zilembo zazikulu zakuda kwambiri pachikuto cha kope langa. Kenako ndikutembenukira patsamba loyamba ndikuyamba kulemba zonse zomwe muyenera kukumbukira za ine. Mphindi zochepa pambuyo pake, tsambalo likuwoneka motere.
{
"_id":"dkdigiye82gd87gd99dg87gd",
"name":"Cody",
"birthday":"09-12-2006",
"last_visit":"09-02-2019",
"clothing_size":"XL",
"favorite_ice_cream":"Fudge caramel",
"adopted":false,
"hobbies":[
"video games",
"computers",
"cooking"
],
"spouse":null,
"kids":[
],
"favorite_picture":"file://scrapbook-103/christmas-2010.jpg",
"misc_notes":"Prefers ice-cream cake on birthday instead of chocolate cake!"
}
Я: "Zikuwoneka kuti zonse zakonzeka!"
Agogo: “Tadikirani, nanga adzukulu ena onse?”
Я: "Inde ndendende. Kenako perekani tsamba limodzi pagawo lililonse.”
Agogo: “Kodi ndiyenera kulemba zonse zofanana kwa aliyense, monga ndinachitira kwa inu?”
Я: “Ayi, pokhapokha ngati mukufuna. Ndiloleni ndikuwonetseni."
Nditatenga cholembera cha agogo anga, ndikutsegula tsambalo ndikulemba mwachangu za msuweni wanga yemwe sindimakonda kwambiri.
{
"_id":"dh97dhs9b39397ss001",
"name":"Tanner",
"birthday":"09-12-2008",
"clothing_size":"S",
"friend_count":0,
"favorite_picture":null,
"remember":"Born on same day as Cody but not as important"
}Nthawi zonse agogo akafuna kukumbukira zina za mdzukulu wake, amangofunika kupita patsamba loyenera m'kabuku ka adzukulu ake. Zonse zokhudza iwo zidzasungidwa pomwepo pa tsamba lawo, zomwe angathe kusintha ndikusintha mwamsanga.
Zonse zikachitika, amafunsa funso lamatsenga: "Munaphunzira kuti kuchita zonsezi?"
Zolemba za NoSQL
Pali ambiri Zolemba za NoSQL ("osati SQL yokha"). Mu zitsanzo zathu, tasonyeza Document database. Ma data amtundu wa NoSQL m'njira zomwe sizimapatula maubwenzi atebulo omwe amagwiritsidwa ntchito pazosungidwa zamaubale. Ma database awa adadziwika koyambirira kwa zaka za m'ma 2000 ndi makampani omwe amafunikira kusakatula kochokera pamtambo chifukwa cha zomwe amafunikira pakukweza (monga Facebook). M'mapulogalamu oterowo, kusasinthika kwa data kunali kocheperako kuposa magwiridwe antchito komanso kuwerengeka.
Poyambirira, nkhokwe za NoSQL nthawi zambiri zinkagwiritsidwa ntchito poyang'anira deta. Kwenikweni, zikafika pakugwiritsa ntchito intaneti ndi mitambo, ma database a NoSQL adakonza ndikugawa zambiri. Mainjiniya a NoSQL adakondanso schema yosinthika ya data (kapena kusowa kwake) kotero kuti kusintha kwachangu kunali kotheka pamapulogalamu omwe adasinthidwa.
Zofunikira za NoSQL:
- Njira yosinthika kwambiri yosungira deta
- Kukula kopingasa mpaka magulu
- Kutsatizana kotheka pakulimbikira/kufalikira
- Zolemba zomwe zimadziwika pogwiritsa ntchito makiyi apadera
Kuyerekeza mwatsatanetsatane
MySQL imafuna schema yofotokozedwa komanso yokonzedwa.
NoSQL imakulolani kuti musunge deta iliyonse mu "document".
MySQL ili ndi gulu lalikulu.
NoSQL ili ndi gulu laling'ono komanso lomwe likukula mwachangu.
NoSQL ndiyosavuta kukulitsa.
MySQL ikufunika kuwongolera kwambiri.
MySQL imagwiritsa ntchito SQL, yomwe imagwiritsidwa ntchito mumitundu yambiri yama database.
NoSQL ndi mapangidwe opangidwa ndi database omwe ali ndi machitidwe otchuka.
MySQL imagwiritsa ntchito chilankhulo chodziwika bwino (SQL).
NoSQL sagwiritsa ntchito chilankhulo chodziwika bwino.
MySQL ili ndi zida zambiri zofotokozera.
NoSQL ili ndi zida zingapo zofotokozera zomwe ndizovuta kuziyika.
MySQL ikhoza kuwonetsa zovuta zogwirira ntchito pa data yayikulu.
NoSQL imapereka magwiridwe antchito pazida zazikulu.
Maganizo 8base
Mu kampani kumene ndimagwira ntchito, timapereka malo ogwirira ntchito pulojekiti iliyonse yokhala ndi database ya Aurora MySQL yosungidwa pa AWS. Ngakhale NoSQL ndi chisankho chomveka pamene ntchito yanu ikufuna kuchita bwino komanso kusinthasintha, timakhulupirira kuti kusasinthika kwa data komwe kumaperekedwa ndi DBMS ndikofunikira pomanga mapulogalamu a SaaS ndi mapulogalamu ena abizinesi.
Kwa oyambitsa ndi opanga kupanga mabizinesi omwe amafunikira malipoti, kukhulupirika kwamakampani, ndi mitundu yodziwika bwino ya data, kuyika ndalama pazosunga zolumikizana, m'malingaliro athu, ndiye chisankho choyenera.
Dziwani zambiri za kupanga ndi Aurora, Serverless ndi GraphQL pa 8base.com .
Source: www.habr.com