Muva nje kwavela izindaba zokuthi i-Amazon inqume ukukhipha ikhodi yomthombo ye- "Babelfish ye-PostgreSQL", iphakamisa ukunwetshwa kusizindalwazi se-PostgreSQL ngokuqaliswa kwamakhono athile wesizindalwazi se-Microsoft SQL Server.
Umgomo oyinhloko wephrojekthi ukunikeza amandla okusebenzisa izinhlelo zokusebenza ezibhalelwe i-SQL Server kumaseva asebenzisa i-PostgreSQL. Ikhodi yephrojekthi ivuliwe ngaphansi kwamalayisensi e-Apache 2.0 kanye nelayisensi ye-PostgreSQL.
Kulabo abangayijwayele i-Babelfish, kufanele ukwazi ukuthi lokhu isekela iphrothokholi yenethiwekhi esetshenziselwa ukuxhuma amaklayenti ku-SQL Server, T-SQL, kanye nezandiso zolimi zombuzo othize we-SQL Server, ikuvumela ukuthi uhumushe izinhlelo zokusebenza ezisebenzayo ukusuka ku-Microsoft SQL Server kuya ku-PostgreSQL ngaphandle kokushintsha ikhodi yakho noma ngoshintsho oluncane futhi ngaphandle kokufaka abashayeli esikhundleni se-DBMS. Kuzinhlelo zokusebenza, i-Babelfish ibukeka njengeseva evamile ye-SQL. Iphrojekthi isivele isetshenziswa e-Amazon Aurora.
Namuhla, senza i-Babelfish itholakale ku-Aurora PostgreSQL. I-Babelfish inika amandla i-Amazon Aurora PostgreSQL-Compatible Edition ukuthi iqonde iphrothokholi yokuxhumana ye-SQL Server. Ikuvumela ukuthi uthuthe izinhlelo zakho zokusebenza zisuka ku-SQL Server ziye ku-PostgreSQL ezishibhile, ngokushesha, futhi ezinobungozi obuncane obuhambisana noshintsho olunjalo.
Kuthiwa iphrojekthi I-Babelfish ilandela imodeli yokuthuthukisa evulekile lokho kwenza abanikeli bomphakathi bakwazi ukwenza ushintsho futhi babe nomthelela ekuthuthukisweni. Kubasebenzisi, ushintsho kokuthi I-Babelfish izokuvumela ukuthi ugweme izinzuzo ezibalulekile ngokusebenzisa i-SQL Server, imikhawulo yelayisense yokudlula futhi ayincikile ekushintsheni kwenqubomgomo yokugcinwa komkhiqizo wobunikazi (ukukhanselwa kwezinzuzo, ukuqedwa kosekelo lwenkundla, ukukhuphuka kwentengo).
Le phrojekthi ihlanganisa isethi yezandiso ze-PostgreSQL, isethi yamapeshi e-PostgreSQL, kanye nekhithi yamathuluzi yekhampasi:
Izandiso zihlinzeka ngosekelo lwe-PostgreSQL lwe-syntax eyengeziwe, izinhlobo zedatha, nemisebenzi edingekayo ukuze kuthuthwe isuka ku-SQL Server. Izandiso ezi-4 seziphelele ziyahlongozwa:
- babelfishpg_tsql: okuyisandiso sokwenza ukusetshenziswa kolimi lwe-T-SQL (Transact-SQL) elengeza i-SQL ngohlelo lwenqubo, ukusekelwa kokuguquguqukayo kwendawo kanye nemisebenzi ethuthukisiwe yokusingatha iyunithi yezinhlamvu, amadethi nezinkulumo zezibalo. Iningi lemisebenzi ye-T-SQL eceliwe iqalisiwe, okuhlanganisa amaphuzu okulondoloza, izinqubo ezigciniwe, kanye nokwenziwe okufakwe esidlekeni. Nokho, ingxenye ebalulekile ye-syntax nemisebenzi ihlala ingakafinyelelwa (njengomthetho, lezi izici ezingavamile ukusetshenziswa ezinhlelweni zangempela, ithebula lokuhambisana). Isibonelo, abakhi "ENGEZA ISIGNATURE", "DALA ISIQINISEKISO", "DALA / ALTERA / YEHLISA INDIMA YOKUFAKA ISICELO | UMHLANGANO | UKHIYE WE-ASYMMETRIC", "QALA ISIKHATHI SENXOXO", "QEDA / THUTHA INGXOXO", nokunye. abakatholakali.
- babelfishpg_tds: isandiso sokuqaliswa kwephrothokholi ye-TDS (Tabular Data Stream) esetshenziswa ku-SQL Server ukuze kuxhunywe inethiwekhi phakathi kwe-DBMS neklayenti. I-TDS protocol version 7.1 nangaphezulu iyasekelwa.
- i-babelfishpg_evamile: isandiso sokusetshenziswa kwezinhlobo ezithile zedatha Yeseva ye-SQL.
babelfishpg_money: kuwukusetshenziswa kohlobo lwemali okusekelwe kukhodi yesandiso ye-FixedDecimal.
Amapeshi afaka izinguquko enjinini ye-PostgreSQL edingekayo ukuze kuhlinzekwe ukusebenza okwengeziwe kuzandiso ze-Babelfish. Njengamanje, kanye nabathuthukisi be-PostgreSQL, kwenziwa umsebenzi wokufaka iziqephu ezilungisiwe ekuqanjweni okukhulu kwe-PostgreSQL. Iziqephu ezilungiselelwe i-PostgreSQL 13.
Insiza yekhampasi yakhelwe ukuncozulula imibhalo ye-T-SQL DDL kanye nekhodi ye-SQL ukuze ihambisane ne-Babelfish. Kokukhiphayo, kukhiqizwa umbiko ukuthi yimuphi umsebenzi odingekayo ukuze kuqalwe uhlelo lokusebenza ongakasekelwa yi-Babelfish.
Amalabhulali amaklayenti alandelayo okuxhuma ku-MS SQL Server asekelwa ngokusemthethweni:
- OLEDB / MSOLEDBSQL umhlinzeki
- OLEDB / SQLEDB umshayeli
- Uhlaka lwebhizinisi lwe-Ado.NET
- I-SQL Server 11.0 Iklayenti Lomdabu
- I-ODBC (Open Database Connectivity)
I-JDBC (I-Java Database Connectivity)
Okokugcina uma unesifiso sokwazi okwengeziwe ngakho, ungabheka imininingwane yenothi Kulesi sixhumanisi esilandelayo. Ngokuqondene nalabo abanentshisekelo yokukwazi ukubona ikhodi yomthombo, bangakwenza lokho kusuka kulesi sixhumanisi.