Firebird RDBMS: Ndi chiyani ndipo ndi chiyani chatsopano mu mtundu wake watsopano wa 4.0?

Firebird RDBMS: Ndi chiyani ndipo ndi chiyani chatsopano mu mtundu wake watsopano wa 4.0?

Pafupifupi mwezi wapitawu, "Firebird" RDBMS, wodziwika Chibale kasamalidwe ka database open source, watulutsa fayilo ya mtundu watsopano 4.0 yomwe ili ndi mitundu yatsopano ya data ndikusintha kwambiri.

Ndipo kuti tisaphonye uthengawu, m'buku lino tifufuza pang'ono za zomwe zanenedwa Anayankha (Relational Database Management System) mchingerezi kapena Anayankha (Relational database management system) m'Chisipanishi.

Monga mwachizolowezi, kwa iwo omwe akufuna kuzamitsa nkhaniyi atatha kuwerenga bukuli, nthawi yomweyo tidzasiya pansipa zokhudzana ndi zolemba zam'mbuyomu ndi mutuwo kuti athe kuwapeza mosavuta ndikuwonjezera kuwerenga:

"DBeaver ndi pulogalamu yotseguka yomwe imagwira ntchito ngati chida chosungira zida zonse za omwe amapanga ma database ndi oyang'anira. Ili ndi mawonekedwe ogwiritsa ntchito bwino, ndipo imalola kuti izilembedwe muzowonjezera zingapo, komanso kukhala yogwirizana ndi nkhokwe iliyonse. Chifukwa chake, imathandizira malo onse otchuka monga: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, pakati pa ena." DBeaver: chida chabwino kwambiri choyang'anira ma DB osiyanasiyana

Nkhani yowonjezera:

DBeaver: chida chabwino kwambiri choyang'anira ma DB osiyanasiyana

Firebird RDBMS: Dongosolo lazosamalira zadongosolo

Kodi Firebird ndi chiyani?

Malinga ndi opanga ake mu webusaiti yathu, "Firebird" Zimafotokozedwa motere:

"Ndi RDBMS yamphamvu komanso yathunthu, yomwe imatha kuthana ndi Masamba kuchokera pa KB zochepa kupita ku ma Gigabyte ambiri ogwira ntchito bwino komanso osasamala. Kuphatikiza apo, ili ndi magwiridwe antchito ndipo imasinthika moyenera, kuyambira pamtundu umodzi wosagwiritsa ntchito kupita ku kampani iliyonse yokhala ndi nkhokwe zingapo za 2Tb kapena kupitilira apo, yogwira ndi mazana amakasitomala munthawi yomweyo."

Makhalidwe wamba

Pakati pa zinthu zazikulu de "Firebird" zotsatirazi zitha kutchulidwa:

• Firebird ndi pulogalamu yogwirizana ndi Windows, Linux, MacOS, HP-UX, AIX, Solaris, pakati pa ena. Ponena za Hardware, imagwira ntchito pa x386, x64 ndi PowerPC, Sparc, pakati pama pulatifomu ena azida. Komanso, imathandizira njira yosunthira yosavuta pakati pa nsanja izi.
• Nthawi zambiri imaphatikizidwa m'malo osungira Linux a Zogawa zotsatirazi: Fedora, OpenSuse, CentOS, Mandriva, Ubuntu.
• Ili ndi kapangidwe kosiyanasiyana, kamene kamalola kutukula ndi kuthandizira mitundu ya OLTP ndi OLAP. Izi zimapangitsa kuti database ya Firebird igwire ntchito yofananira nthawi yomweyo, chifukwa owerenga samatseka olemba akamapeza zomwezo nthawi zambiri.
• Imathandizira njira zosungidwa ndi zoyambitsa, ndipo imapereka chithandizo chachikulu kwa SQL92. Izi zikuphatikiza maubwino monga kufanana kwakukulu kwa ANSI SQL, Common Table Expressions (CTE), Flexible Transaction Management, Njira Zosungidwa Zosungidwa, Mafunso a Cross-Database, Concept of Active Tables and Events, and User Defined Functions.
• Zochita zawo ndi zamtundu wa ACID (Chidule cha: Atomic, Consistent, Isolate, Durability), zomwe zikutanthauza kuti ntchitoyo imatsimikizika motetezeka.
• Ndi yaulere pakugwiritsa ntchito malonda ndi maphunziro. Chifukwa chake, sizitengera kugwiritsa ntchito chiphaso, kapena kukhazikitsa kapena zoletsa kuyambitsa. Chilolezo cha Firebird chimakhazikitsidwa ndi Mozilla Public License (MPL).

Ndipo pakati pa ena ambiri, zotsatirazi zitha kuwonjezeredwa mwachidule: Ili ndi mowa zochepa, amafunikira zochepa kapena zosafunikira ma DBA apadera, pafupifupi palibe kasinthidwe kofunikira (kukhazikitsa ndikugwiritsa ntchito pafupifupi), ndipo has gulu lalikulu ndi masamba ambiri komwe titha kupeza chithandizo chabwino chaulere.

Zambiri zambiri za "Firebird" ndi awo makhalidwe ndi mapindu itha kupezeka pamalumikizidwe otsatirawa:

1. Mawonekedwe: M'Chingerezi
2. Kumanani ndi Firebird mumphindi 2!: M'Chisipanishi

Zatsopano mu mtundu wa 4.0

"Firebird" 4.0 Onetsani mitundu yatsopano ya data ndi maere kusintha popanda kusintha kwakukulu zomangamanga kapena ntchito. Pakati pa 10 chofunikira kwambiri Kuti tiwonetsedwe, zotsatirazi zitha kutchulidwa:

1. Kubwereza komveka bwino;
2. Kutalika kwazidziwitso zazidziwitso (mpaka zilembo 63);
3. Mitundu yatsopano ya INT128 ndi DECFLOAT, yolondola kwambiri pamitundu yamtundu wa NUMERIC / DECIMAL;
4. Chithandizo chazigawo zapadziko lonse lapansi;
5. Nthawi zosintha zolumikizirana ndi ziganizo;
6. Kuphatikizira kulumikizana kwakunja;
7. Ntchito zamagulu mu API;
8. Ntchito zophatikizika;
9. New ODS (mtundu 13) wokhala ndi machitidwe atsopano ndi matebulo owunikira;
10. Kuwonjezeka kukula kwa tsamba mpaka 32 KB.

Kuti mumuwone mndandanda wathunthu wazosintha mutha kudina zotsatirazi kulumikizana.

"Firebird imachokera ku nambala yaku Borland's InterBase 6.0. Ili lotseguka ndipo ilibe ziphaso ziwiri. Kaya mumagwiritsa ntchito ngati malonda kapena osatsegula, ndi UFULU kwathunthu! Ukadaulo wa Firebird wakhala ukugwiritsidwa ntchito kwa zaka 20, ndikupangitsa kuti ukhale chinthu chokhazikika komanso chokhwima." Kumanani ndi Firebird mumphindi 2!

Chidule

Tikukhulupirira izi "positi yaying'ono yothandiza" za «Firebird RDBMS», yomwe ndi Chibale kasamalidwe ka database pulogalamu yotseguka kwambiri, yomwe yangotulutsa kumene mtundu watsopano 4.0 kuti ili ndi mitundu yatsopano yazidziwitso ndikusintha kambiri; ndichofunika kwambiri komanso chothandiza, chonsecho «Comunidad de Software Libre y Código Abierto» ndikuthandizira pakufalitsa zachilengedwe, zazikulu komanso zokula zomwe zikugwiritsidwa ntchito «GNU/Linux».

Pakadali pano, ngati mumakonda izi publicación, Osayima gawani ndi ena, mumawebusayiti omwe mumawakonda, mayendedwe, magulu kapena magulu azamawebusayiti kapena makina amtokoma, makamaka aulere, otseguka komanso / kapena otetezeka monga uthengawo, Chizindikiro, Matimoni kapena ina ya Kusintha, makamaka.

Ndipo kumbukirani kuchezera tsamba lathu kunyumba «KuchokeraLinux» kuti muwone zambiri, komanso kujowina njira yathu yovomerezeka ya Telegalamu yochokera ku DesdeLinux. Pomwe, kuti mumve zambiri, mutha kuchezera aliyense Laibulale ya pa intaneti Como OpenLibra y kodi, kupeza ndi kuwerenga mabuku a digito (ma PDF) pamutuwu kapena ena.