🍿 2022-09-16 15:34:00 - Paris/France.
UGoogle uthi inkonzo entsha Ukusasaza iya kunceda abaphuhlisi bafumane idatha kwindawo yayo yokugcina idatha yeBigQuery ukusuka kwiinkqubo zentengiselwano ezikufutshane.
Ifumaneka kwi-preview, i-Datastream ye-BigQuery yenzelwe ukunika abaphuhlisi amandla okuphindaphinda kwimithombo yedatha yokusebenza efana ne-AlloyDB ye-PostgreSQL, i-PostgreSQL, i-MySQL kunye ne-Oracle, ngokuthe ngqo kwi-BigQuery, ifu yenkqubo yokugcina idatha esekelwe kwi-Google ye-Colossus inkqubo yefayile esasazwayo.
UGoogle uthe ubona "ilifu ledatha elidibeneyo, elidibanisa i-database, i-analytics kunye nokufunda koomatshini kwiqonga elinye elihambisa isikali, isantya, ukhuseleko kunye nokulula okufunwa ngamashishini," ngokutsho kwebhlog ebhengeza inkonzo entsha.
I-Datastream isebenzisa i-auto-scaling, i-architecture engena-server evumela abasebenzisi ukuba baqulunqe umbhobho we-Extract, Load, Transform (ELT) ukuphindaphinda idatha esuka kumthombo we-OLTP inkqubo kwi-BigQuery kwixesha elingaphezulu okanye elingaphantsi kwexesha langempela. Uhlalutyo oluphumayo lwenzelwe ukwazisa abasebenzisi beemeko zoshishino kunye nokunceda ukuqikelela okunokwenzeka okulandelayo.
Inkonzo engenamncedisi iphinda isebenzise inqaku likaGoogle loTshintsho lweDatha (CDC) kunye neSitoreji sokuBhala i-API's UPSERT isici sokuphindaphinda uhlaziyo ngokuthe ngqo ukusuka kwiinkqubo zomthombo ukuya kwiitafile zeBigQuery, ngoko ke iinjineli kunye nabaphuhlisi beDatha akufuneki benze kwaye balawule imibhobho yedatha entsonkothileyo, iitafile zestaging, ukudityaniswa okusengqiqweni okanye uguqulelo ngesandla logcino-lwazi olungqale kwiintlobo zedatha yeBigQuery.
"Misa nje isiseko sedatha yakho yomthombo, uhlobo loqhagamshelo, kunye nendawo oya kuyo kwiBigQuery kwaye ulungele ukuhamba," utshilo u-Andi Gutmans, umphathi wobunjineli bedatha, kwibhlog. "Idatha yeBigQuery iya kuzala idatha yembali kwaye ngokuqhubekayo iphindaphinda utshintsho olutsha njengoko lusenzeka. Kwaye njengoko i-schemas yedatha iguquka, i-Datastream iphatha ngokucacileyo utshintsho lwe-schema kwaye yongeza ngokuzenzekelayo iitheyibhile ezintsha kunye neekholamu kwi-BigQuery. »
Imibutho eqokelela kwaye ihlalutye idatha yayo kwiLifu likaGoogle inokubona ingqiqo ekunikezelweni, kodwa abanye abathengisi baya kuzama ukucenga abaphuhlisi ukuba baqhekeze le nati ngenye indlela. I-Snowflake, umzekelo, inomsebenzi wayo we-Snowpipe, owaqala ukuqala ngo-2017. I-Amazon inento ebizwa ngokuba yi-AWS Glue. Abanye babuza ukuba kutheni ukuhambisa idatha kwaye bakhuthaze abasebenzisi ukuba benze uhlalutyo kwiinkqubo zokuthengiselana, njengoko i-Oracle isenza nge-MySQL HeatWave, ngoku ekhoyo kwi-AWS, kwaye njengoko Irejista kuxoxwe apha.
Ezinye izinto ezintsha ezisuka kwicandelo lelifu lomenzi wetshokolethi ziquka ulawulo lofikelelo olusekwe kwindima kwinkonzo kaGoogle ye-OLTP yedatha, iSpanner.
"Ngeempawu ezinjengomzila wophicotho owakhelwe ngaphakathi kunye nokufikelela kolwazi ngomxholo, isazisi kunye noLawulo lokuFikelela kwenza kube lula ukunika umzekelo- kunye neemvume zenqanaba ledatha kubasebenzisi beSpanner," utshilo umphathi wemveliso uMark Donsky kwiposti yebhlog.
UGoogle ukwabonelela ngeemeko zovavanyo lwasimahla lweSpanner. ®
SOURCE: Uphonononga Iindaba
Ungalibazisi ukwabelana ngenqaku lethu kwiinethiwekhi zentlalo ukusinika ukomelela okuqinileyo. 👓