Mushure memakore maviri nehafu ebudiriro, kuburitswa kwehukama DBMS Firebird 5.0 kwakaunzwa. Firebird inoenderera mberi nekuvandudzwa kweiyo InterBase 6.0 DBMS kodhi, yakavhurwa muna 2000 neBorland. Firebird ine rezinesi pasi peMPL yemahara uye inotsigira ANSI SQL zviyero, zvinosanganisira zvinhu zvakaita sezvinokonzeresa, maitiro akachengetwa, uye kudzokorora. Binary magungano akagadzirirwa Linux, Windows, macOS uye Android.
Zvitsva zvakakosha:
- Iko kugona kuita maoparesheni mu-multi-threaded mode yakaitwa. Kufananidza mushinda dzakawanda kunoshanda pakugadzira indexes, kuunganidza marara (otomatiki uye manyorero ekutsvaira mashandiro), kugadzira mabhapu uye kudzoreredza kubva kwavari. gfix -sweep -parallel 4 dbname gbak -b -par 4 -user username -pass password dbname backupname
- Yakawedzerwa tsigiro yezvikamu zvidiki izvo zvinosanganisira zvinyorwa zvakasarudzwa chete zvinosangana nemamiriro akatsanangurwa pakuumba index. GADZIRA INDEX IT1_COL PAT1 (COL) PANE COL <100;
- Iyo SARUDZA NELOCK, UPDATE, uye DELETE zvirevo shandisa iyo "SKIP LOCKED" syntax, iyo inokutendera kuti usabatanidze marekodhi ane kiyi panguva iyo chikumbiro chatumirwa (semuenzaniso, kuti usamirire kukiya kuburitswa. pakupindana neimwe transaction).
- Yakawedzera kugona kugadzirisa dhatabhesi kune yazvino yepakati vhezheni yekuchengetedza (ODS - On-Disk-Structure) panhunzi (inline update) pasina kugadzira uye kudzoreredza kubva kune backup. Semuenzaniso, unogona ikozvino kushandura dhatabhesi muFirebird 4.0 (ODS 13.0) fomati kuenda kuFirebird 5.0 (ODS 13.1) fomati panhunzi.
- Kumisikidza cache yezvakaunganidzwa SQL zvirevo zvinochengetwa zvoga (stale zvinyorwa zvinocheneswa sezvinodiwa). Saizi yecache yakaiswa kuburikidza neMaxStatementCacheSize parameter mu firebird.conf.
- Iyo interface yakawedzerwa yekunyora SQL nePSQL, ichikubvumidza kuti ufungidzire nguva yekuitwa yemubvunzo wega wega, kuunganidza manhamba ehuwandu hwemibvunzo, uye kuona matambudziko ekuita.
- Yakawedzera tsigiro kune MERGE kutaura kweiyo "KANA ISINGAfananidzirwe NE SOURCE" conditional block, iyo inopfuta kana iyo sosi rekodhi isingaenderane chero marekodhi mune yakatarwa seti. BAIDZAI MUvatengi c KUSHANDISA new_customers nc PARIRA (c.id = nc.id) KANA WAKUFANISA WOZOSHANDURA SET zita = nc.zita KANA ZVISINGABVISWA NEZVINHU WOZOBVISA
- Ikozvino zvave kuita kudzosa mitsetse yakawanda uchishandisa RETURNING kutaura kana yakapihwa DML matauriro achitambanudzira mitsetse yakawanda (kare, kukanganisa "mitsetse yakawanda mu singleton sarudza" yairatidzwa mumamiriro ezvinhu akadaro).
- Mashandiro matsva akavakirwa-mukati awedzerwa: UNICODE_CHAR kudzosa mavara eunicode anoenderana nekodhi yakapihwa, uye UNICODE_VAL kudzosera kodhi yemavara akapihwa. Iyo QUARTER parameter yawedzerwa kune EXTRACT, FIRST_DAY uye LAST_DAY mabasa kuti tione nhamba yekota.
- Iyo itsva system package RDB$BLOB_UTIL yawedzerwa nesarudzo yeBLOB mashandiro ePSQL module.
- Iyo rekodhi yekumanikidza algorithm yakagadziridzwa kuti ishandise iyo inosiyana kureba counter kuti inyatso kurongedza inodzokorora data sequences. Iko optimization yakavandudza zvakanyanya kuwanda kwekumanikidza kweiyo isina kuzara refu VARCHAR minda ine UTF-8 encoded data.
- Yakawedzera kugona kushanda nebidirectional cursors (inotenderedzwa) kana uchiwana dhatabhesi kure netiweki.
- Kuita kwekukopa blob kwakagadziridzwa.
- Yakawedzera rutsigiro rwakazara rweiyo tambo tsananguro syntax inotsanangurwa muSQL standard. Semuenzaniso, mitsetse inogona kutyorwa nekutaura kana nzvimbo: sarudza 'ab' /* comment */ 'cd' kubva kuRDB $DATABASE; sarudza 'ab' 'cd' kubva kuRDB $DATABASE;
Source: opennet.ru
