🍿 2022-09-16 15:34:00 - Paris/France.
Google ikuti ntchito yatsopano akukhamukira idzathandiza omanga kupeza deta mu malo ake osungiramo data a BigQuery kuchokera ku machitidwe oyandikana nawo.
Zopezeka powoneratu, Datastream for BigQuery idapangidwa kuti ipatse omanga kuthekera kobwereza kuchokera ku ma database ogwirira ntchito monga AlloyDB ya PostgreSQL, PostgreSQL, MySQL, ndi Oracle molunjika ku BigQuery, mtambo wosungira deta wotengera Google's Colossus Distributed File System.
Google idati ikuwona "mtambo wolumikizana wa data, kuphatikiza nkhokwe, kusanthula, ndi kuphunzira pamakina papulatifomu imodzi yomwe imapereka kuchuluka, liwiro, chitetezo, komanso kuphweka komwe mabizinesi amafunikira." utumiki.
Datastream imagwiritsa ntchito zomangamanga zopanda seva zomwe zimalola ogwiritsa ntchito kukhazikitsa payipi ya Extract, Load, Transform (ELT) kuti abwereze deta kuchokera ku gwero la OLTP kupita ku BigQuery mu nthawi yeniyeni kapena yochepa. Zotsatira zake zimapangidwira kudziwitsa ogwiritsa ntchito zabizinesi ndikuthandizira kulosera zomwe zingachitike kenako.
Ntchito yopanda seva imagwiritsanso ntchito gawo la Google la Change Data Capture (CDC) ndi gawo la Storage Write API's UPSERT kuti libwereze zosintha kuchokera kumakina kupita ku BigQuery matebulo, kotero mainjiniya ndi opanga Data safunika kupanga ndi kuyang'anira mapaipi ovuta a data, ma tebulo , kuphatikiza, kutembenuza mwanzeru kapena pamanja kwa mitundu ya data yachinsinsi kukhala mitundu ya data ya BigQuery.
"Ingokonzani nkhokwe yanu, mtundu wolumikizira, ndi komwe mukupita ku BigQuery ndipo mwakonzeka," Andi Gutmans, woyang'anira uinjiniya wa database, adatero mu positi. "Datastream ya BigQuery idzadzaza mbiri yakale ndikusintha mosalekeza zosintha zatsopano zikachitika. Ndipo pamene ma schema a database akusintha, Datastream imayendetsa mowonekera kusintha kwa schema ndikuwonjezera matebulo ndi mizati yatsopano ku BigQuery. »
Mabungwe omwe amasonkhanitsa ndikusanthula deta yawo mu Google Cloud atha kuwona tanthauzo la zomwe amapereka, koma ogulitsa ena amayesa kunyengerera opanga kuti awononge mtedzawo mwanjira ina. Mwachitsanzo, Snowflake ili ndi mawonekedwe ake a Snowpipe, omwe adayambitsa koyamba mu 2017. Amazon ili ndi chinthu chotchedwa AWS Glue. Ena amafunsa chifukwa chake amasuntha deta ndikulimbikitsa ogwiritsa ntchito kusanthula machitidwe opangira, monga Oracle akuchitira ndi MySQL HeatWave, yomwe tsopano ikupezeka mu AWS, komanso monga Kulembetsa kutsutsana apa.
Zina zatsopano kuchokera kugulu lamtambo la fakitale ya chokoleti zikuphatikiza kuwongolera kotengera gawo la Google's OLTP database service, Spanner.
"Pokhala ndi mawonekedwe ngati njira yowerengera yokhazikika komanso mwayi wodziwa zomwe zikuchitika, Identity ndi Access Management zimapangitsa kuti zikhale zosavuta kupereka zilolezo zapaintaneti kwa ogwiritsa ntchito a Spanner," woyang'anira malonda a Mark Donsky adatero mu positi.
Google imaperekanso zitsanzo zaulere za Spanner. ®
SOURCE: Ndemanga za News
Osazengereza kugawana nawo nkhani yathu pamasamba ochezera kuti atilimbikitse. 👓