{"id":112886,"date":"2024-01-13T11:28:03","date_gmt":"2024-01-13T09:28:03","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-firebird-5-0"},"modified":"2024-01-13T11:28:03","modified_gmt":"2024-01-13T09:28:03","slug":"vypusk-subd-firebird-5-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-subd-firebird-5-0","title":{"rendered":"Publikimi i SGBD Firebird 5.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Pas dy vjet e gjysm\u00eb zhvillimi, u prezantua l\u00ebshimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave relacionale Firebird 5.0. Firebird vazhdon zhvillimin e kodit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave InterBase 6.0, e hapur n\u00eb vitin 2000 nga kompania Borland. Firebird shp\u00ebrndahet n\u00ebn licenc\u00ebn e lir\u00eb MPL dhe mb\u00ebshtet standardet ANSI SQL, duke p\u00ebrfshir\u00eb mund\u00ebsit\u00eb si trigger-at, procedurat e ruajtura dhe replikimin. Nd\u00ebrtime t\u00eb binar\u00ebve jan\u00eb p\u00ebrgatitur p\u00ebr Linux, Windows, macOS dhe Android. <\/p>\n
Novitetet kryesore: <\/p>\n
\n
\u00cbsht\u00eb realizuar mund\u00ebsia e kryerjes s\u00eb operacioneve n\u00eb modin shum\u00ebfizik. Paralelizimi n\u00eb disa procese \u00ebsht\u00eb i aplikuesh\u00ebm gjat\u00eb krijimit t\u00eb indekseve, grumbullimit t\u00eb plehrave (operacione automatik\u00eb dhe manual\u00eb sweep), krijimit t\u00eb kopjeve rezerv\u00eb dhe rikuperimit nga to. gfix -sweep -parallel 4 dbname gbak -b -par 4 -user username -pass password dbname backupname\n
\u00cbsht\u00eb shtuar mb\u00ebshtetje p\u00ebr indekset e pjesshme, t\u00eb cilat p\u00ebrfshijn\u00eb vet\u00ebm regjistrat e zgjedhur q\u00eb p\u00ebrputhen me kushtet e caktuara n\u00eb momentin e krijimit t\u00eb indeksit. CREATE INDEX IT1_COL ON T1 (COL) WHERE COL < 100;\n
N\u00eb shprehjet SELECT ME LOCK, UPDATE dhe DELETE \u00ebsht\u00eb realizuar sintaksa \u00abSKIP LOCKED\u00bb, q\u00eb lejon p\u00ebrjashtimin e regjistrimeve p\u00ebr t\u00eb cilat n\u00eb momentin e d\u00ebrgimit t\u00eb k\u00ebrkes\u00ebs \u00ebsht\u00eb vendosur nj\u00eb bllokim (p\u00ebr shembull, p\u00ebr t\u00eb mos pritur \u00e7lirimin e bllokimit gjat\u00eb p\u00ebrputhjes me nj\u00eb transaksion tjet\u00ebr).\n
Shtohet mund\u00ebsia e p\u00ebrdit\u00ebsimit t\u00eb DB n\u00eb versionin p\u00ebrkoh\u00ebsisht m\u00eb t\u00eb fundit t\u00eb struktur\u00ebs s\u00eb ruajtjes (ODS \u2014 On-Disk-Structure) n\u00eb fluks (p\u00ebrdit\u00ebsim inline) pa krijuar dhe rikuperuar nga nj\u00eb kopje rezerv\u00eb. P\u00ebr shembull, tani \u00ebsht\u00eb e mundur q\u00eb n\u00eb fluks t\u00eb konvertohet DB me format Firebird 4.0 (ODS 13.0) n\u00eb formatin Firebird 5.0 (ODS 13.1).\n
\u00cbsht\u00eb realizuar nj\u00eb cache i shprehjeve SQL t\u00eb kompiluara, e cila administrohet automatikisht (regjistrat e vjetra pastrohen sipas nevoj\u00ebs). Madh\u00ebsia e cache-it p\u00ebrcaktohet p\u00ebrmes parametrin MaxStatementCacheSize n\u00eb firebird.conf.\n
\u00cbsht\u00eb shtuar nj\u00eb nd\u00ebrfaqe p\u00ebr profilimin e SQL dhe PSQL, e cila lejon vler\u00ebsimin e koh\u00ebs s\u00eb ekzekutimit t\u00eb \u00e7do k\u00ebrkese, akumulimin e statistikave mbi numrin e k\u00ebrkesave dhe identifikimin e problemeve me performanc\u00ebn.\n
N\u00eb shprehjen MERGE \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr bllokun kushtor \u00abWHEN NOT MATCHED BY SOURCE\u00bb, i cili aktivizohet kur regjistri burimor nuk p\u00ebrputhet me asnj\u00eb regjist\u00ebr n\u00eb grupin e synuar. MERGE INTO customers c USING new_customers nc ON (c.id = nc.id) \tWHEN MATCHED THEN \t\tUPDATE SET name = nc.name \tWHEN NOT MATCHED BY SOURCE THEN \t\tDELETE\n
Sigurohet mund\u00ebsia e kthimit t\u00eb disa rreshtave me shprehjen RETURNING, n\u00ebse shprehja DML e dh\u00ebn\u00eb mbulon disa rreshta (m\u00eb par\u00eb n\u00eb situata t\u00eb tilla shfaqej gabimi \u00abmultiple rows in singleton select\u00bb.\n
Funksione t\u00eb reja t\u00eb integruara jan\u00eb shtuar: UNICODE_CHAR p\u00ebr kthimin e simbolit unicode q\u00eb p\u00ebrputhet me kodin e caktuar dhe UNICODE_VAL p\u00ebr kthimin e kodit p\u00ebr simbolin e caktuar. Parametri QUARTER p\u00ebr p\u00ebrcaktimin e numrit t\u00eb tremujorit \u00ebsht\u00eb shtuar n\u00eb funksionet EXTRACT, FIRST_DAY dhe LAST_DAY.\n
Nj\u00eb paket\u00eb e re sistemore RDB$BLOB_UTIL \u00ebsht\u00eb shtuar me nj\u00eb koleksion operacionesh mbi BLOB-t\u00eb p\u00ebr modulet PSQL.\n
Algoritmi i kompresimit t\u00eb regjistrimeve \u00ebsht\u00eb p\u00ebrmir\u00ebsuar, tani duke aplikuar nj\u00eb num\u00ebrator me gjat\u00ebsi variabel p\u00ebr paketimin m\u00eb efikas t\u00eb sekuencave t\u00eb t\u00eb dh\u00ebnave t\u00eb p\u00ebrs\u00ebritura. Optimizimi ka lejuar rritjen e ndjeshme t\u00eb shkall\u00ebs s\u00eb kompresimit t\u00eb fushave VARCHAR me gjat\u00ebsi t\u00eb gjat\u00eb q\u00eb nuk jan\u00eb plot\u00ebsisht t\u00eb mbushura me t\u00eb dh\u00ebna n\u00eb kodimin UTF-8.\n
\u00cbsht\u00eb shtuar mund\u00ebsia e pun\u00ebs me pamjet dyansh\u00ebm (scrollable) gjat\u00eb qasjes n\u00eb distanc\u00eb n\u00eb DB.\n
Optimizohet performanca e kopjimit t\u00eb BLOB-eve.\n
Shtohet mb\u00ebshtetje e plot\u00eb p\u00ebr sintaks\u00ebn e shpalljes s\u00eb rreshtave, t\u00eb p\u00ebrshkruar n\u00eb standardin SQL. P\u00ebr shembull, rreshtat tani mund t\u00eb ndahen me komente ose hap\u00ebsira: select \u2018ab\u2019 \/* comment *\/ \u2018cd\u2019 from RDB$DATABASE; select \u2018ab\u2019 \u2018cd\u2019 from RDB$DATABASE; <\/ul>\n