Ukuvula Ubuhle Bedatha: I-Nithin Gadicharla's Insights ku-SQL Server Innovation

Emhlabeni wanamuhla oqhutshwa idatha, izinhlangano azisakhawulelwe kudatha ehleliwe iyodwa. Ngokukhula kwezindlela zesimanje zokuqoqwa kwedatha, idatha enesakhiwo esincane nengahlelekile iye yavela njengempahla eyigugu, edinga ubuchwepheshe obuphambili ukuze iphathe ngempumelelo. Amafomethi anesakhiwo esincane njenge-JSON ne-XML avala igebe phakathi kwamamodeli edatha aqinile nedatha yefomu yamahhala, okuvumela ukuguquguquka kwezinhlelo zokusebenza eziguqukayo. Ngesikhathi esifanayo, idatha yendawo, egxile olwazini lwendawo, ibaluleke kakhulu ezimbonini ezithembele ekwenziweni kwemephu nokuhlaziya kwesikhathi sangempela.

Ukuphatha lezi zinhlobo zedatha ezihlukene kudinga amakhono akhethekile, futhi ochwepheshe abambalwa abanekhono kulokhu njengo-Nithin Gadicharla, Umlawuli Wedathabheyisi Yeseva ye-SQL onesipiliyoni esikhulu. Cishe iminyaka eyishumi yokuhlangenwe nakho kuzo zonke izimboni ezifana nezamabhange, umshwalense, nokwakhiwa kwenethiwekhi, uNithin ufakazele ikhono lakhe lokubhekana nezinselele zedatha eziyinkimbinkimbi. Ubuchwepheshe bakhe buhlanganisa izixazululo zokutholakala okuphezulu, ukulungiswa kokusebenza, kanye nokuklama nokusekelwa kolwazi olukhulu, oluyinkimbinkimbi.

Ngale kwedatha ehleliwe, i-Nithin ikwazile amakhono e-SQL Server okuphatha i-JSON, i-XML, nedatha yendawo. Kusukela ekwenzeni ngcono ukuhlanganiswa kwe-API ne-JSON kuya ekuqinisekiseni imibuzo ephumelelayo kanye nenkomba ye-XML nokuthuthukisa idatha yendawo ngemisebenzi ethuthukisiwe ye-geospatial, inhlawulo yakhe yobuchwepheshe ibanzi futhi ijulile. Ngokuhambisana nekhono lakhe ezinsizeni ze-Azure njenge-Azure Data Factory kanye ne-Azure Data Lake Store, i-Nithin iletha indlela yesimanjemanje, eyingozi ekuphathweni kwedatha.

Ibhekana ne-JSON, i-XML, nedatha yendawo

Ukusebenza ne-JSON, i-XML, nedatha yendawo ku-SQL Server kuveza izinselele ezihlukile, ezidinga amasu aqondiwe ukuze kusingathwe ubunzima bazo. I-JSON, enemvelo yayo eguquguqukayo kodwa engena-schema, idinga ukuphathwa ngokucophelela. U-Nithin uyachaza, "Ukukhipha kanye nokubuza ngezinto ezibekwe esidlekeni kudinga amathuluzi nezindlela ezithile." Ukuze abhekane nalokhu, ugcina idatha ye-JSON kumakholomu e-NVARCHAR futhi usebenzisa imisebenzi efana ne-JSON_VALUE kumanani esikali, i-JSON_QUERY yedatha efakwe esidlekeni, kanye ne-OPENJSON ukuze iguqule amalungu afanayo abe amathebula ahlobene. Uphinde agcizelele ukuqinisekiswa nge-ISJSON nezibuyekezo ezingabhubhi kusetshenziswa i-JSON_MODIFY, okuqinisekisa ubuqotho bedatha kuyilapho kuthuthukisa ukusebenza ngamakholomu ekhompuyutha anenkomba.

Ku-XML, i-Nithin isebenzisa imvelo yayo ye-hierarchical ngokusebenzisa uhlobo lwedatha ye-XML ukuze igcinwe kahle futhi isetshenziswe ngokuqondile. Ukuze akhiphe idatha, usebenzisa izindlela ezifana nokuthi .value() amanani e-scalar, .query() yezingcezu, kanye .nodes() ukuze ahlukanise i-XML ibe ifomu lethebula. Ugqamisa ukubaluleka kwezinkomba ze-XML eziyinhloko nezesibili ukuze kuthuthukiswe imibuzo nokuqinisekiswa kwe-schema ngamaqoqo e-XML Schema ukuze kuphoqelelwe ubuqotho besakhiwo. Ngokufanayo, idatha yendawo idinga izindlela ezikhethekile, ikakhulukazi ezinhlotsheni ezingezona zethebula njenge-GEOMETRY kanye ne-GEOGRAPHY. U-Nithin uyaphawula, “Dala izinkomba zendawo ukuze uthuthukise ukusebenza kwemibuzo yendawo,” futhi isebenzisa imisebenzi efana ne-.STDistance(), .STIntersects(), kanye ne-.STContains() ngemisebenzi ehilela ukukalwa kwebanga, ukugqagqana, nokuqukatha. Ngokuhlanganisa idatha yendawo namathuluzi e-GIS, uqinisekisa ukunemba kwemephu nokuboniswa, okwenza ukuhlaziya okuphumelelayo kokusebenza kwe-geospatial eyinkimbinkimbi.

I-Evolution yeseva ye-SQL Yedatha Yesimanje

I-SQL Server ithuthuke kakhulu ukuze isekele amafomethi edatha anesakhiwo esincane njenge-JSON ne-XML, enikeza amathuluzi aqinile alinganisela ukuguquguquka nokusebenza. I-Nithin igqamisa ukwethulwa kosekelo lwe-JSON ku-SQL Server 2016 njengentuthuko enkulu, ichaza ukuthi imisebenzi efana ne-JSON_VALUE kanye ne-JSON_QUERY yenza kanjani ukukhishwa kwedatha kube lula, kuyilapho i-OPENJSON iguqula amalungu afanayo e-JSON abe amathebula ahlobene ukuze ahlaziyeke kalula. Uyanezela, “I-ISJSON iqinisekisa ukwakheka kwedatha ye-JSON, iqinisekisa ubuqotho bayo, futhi i-JSON_MODIFY ivumela izibuyekezo ngaphandle kokubhala phezu kwayo yonke into,” okwenza lezi zici zibe yigugu ezinhlelweni zokusebenza zesikhathi sangempela nokuhlanganiswa kwe-API.

Ku-XML, eye yasekelwa kusukela ku-SQL Server 2005, i-Nithin isebenzisa amathuluzi ayo anamandla okuphathwa kwedatha ye-hierarchical. Uhlobo lwedatha ye-XML lunika amandla ukugcinwa nokukhwabanisa okuphumelelayo, kuyilapho izindlela ezifana ne-.value(), .query(), kanye .nodes() zinikeza ukulawula okuyimbudumbudu phezu kokukhipha idatha nokuguqulwa. Uphinde agcizelele ukubaluleka kokuqinisekiswa kwe-schema ngamaqoqo e-XML Schema kanye nokusetshenziswa kwezinkomba ze-XML ukuze kuthuthukiswe ukusebenza kwemibuzo eyinkimbinkimbi kumadathasethi amakhulu. Ndawonye, lokhu kuthuthukiswa kuvumela izinhlangano ukuthi zihlanganise kalula idatha enesakhiwo esincane, ziqondise ukusebenzisana nezinhlelo zangaphandle, futhi zigcine ubuqotho bedatha ngaphandle kokudela ukusebenza. Njengoba uNithin ephawula, "Amakhono aguqukayo e-SQL Server ayenza inkundla eguquguqukayo yokuphathwa kwedatha yesimanje."

Izixazululo Zomhlaba Wangempela Nokuthuthukisa

Kwa-Elan Technologies, u-Nithin wasebenzisa ubuchwepheshe bakhe kudatha yendawo ukuze akhe uhlelo lokukhokhisa olushintshashintshayo oluthuthukisa ukuhamba kwethrafikhi futhi lwathuthukisa izibalo zama-toll ngesikhathi sangempela. Esebenzisa uhlobo lwedatha ye-SQL Server's GEOGRAPHY, uphathe idatha ye-geospatial eyinkimbinkimbi, ehlanganisa izindawo ze-toll booth, amanethiwekhi emigwaqo, nezindawo zethrafikhi. Ukuze asheshise imibuzo yokuhlaziywa kwendlela yezimoto kanye nokuhlonzwa kwendawo ekhokhelwayo, wasebenzisa ukukhonjwa kwendawo, eqinisekisa ukuthi uhlelo lungakwazi ukuphatha kahle idatha enkulu yedatha yesikhathi sangempela. U-Nithin uchaza ukuthi imisebenzi yendawo ye-SQL Server idlale kanjani indima ebalulekile: “.

Ngale kokuhlaziywa, izindawo zebhafa ezisetshenziswayo ze-Nithin zidalwe ngomsebenzi we-.STBuffer() ukuze kulungiswe izindawo ezikhokhelwayo ngokusekelwe esiminyaminyeni sethrafikhi namahora aphakeme. Leli zinga lokuzivumelanisa nezimo liqinisekise izibalo ezinembile ze-toll. Uthi, "Inhlanganisela yedatha yendawo kanye nedatha yokwenziwayo yenze ukubalwa kwe-toll yesikhathi sangempela ngokusekelwe ebangeni elihanjwe phakathi kwezindawo ezishiwo," kanye nokuphakelayo kwe-GPS okuhlinzeka ngokulandelelwa okunembile kokunyakaza kwezimoto. Ngokuhlanganisa uhlelo namathuluzi e-GIS, ababambiqhaza bathole ulwazi olubalulekile olubonakalayo mayelana nokuminyana kwezimoto kanye nokusebenza okukhokhelwayo, okubanikeza amandla okwenza izinqumo ezinolwazi mayelana nokuphathwa kwethrafikhi kanye nokulungiswa kwamanani entengo.

Ukuze kuqhutshekwe nokwandisa ukusebenza kwemibuzo yendawo, i-Nithin ithembele emikhubeni engcono kakhulu, okuhlanganisa ukuhlukaniswa kwenkomba yokuqapha kanye nezinhlelo zokwenza imibuzo. Ngokusebenzisa izinhlobo zedatha ye-GEOMETRY ne-GEOGRAPHY kanye nokuthuthukisa ukusebenza kahle ngezinkomba zendawo, waqinisekisa ukuthi uhlelo lugcina ukusebenza okuphezulu ngisho nemithwalo yedatha eyinkimbinkimbi. Indlela yakhe emisha ihlanganisa ukunemba nokulinganisa, ebonisa indlela idatha yendawo engaletha ngayo umthelela, izixazululo zomhlaba wangempela ezimbonini ezidinga ukuhlaziywa okunembile kwe-geospatial kanye nokwenza kahle.

Ukuphula Izithiyo Ekuhlanganiseni Kwedatha

Ukuhlanganisa idatha ye-JSON kanye ne-XML kumasistimu ngokuvamile kuletha izinselele ezifana nokungafani kwe-schema, izingqinamba zokusebenza, nezinkinga zokusebenzisana. I-Nithin ibhekane ngempumelelo nalezi zingqinamba isebenzisa inhlanganisela yamathuluzi namasu okuthuthukisa. Ugqamisa ukubaluleka kwe-OPENJSON ye-SQL Server yokuguqula idatha ye-JSON ibe amathebula ahlobene futhi isebenzise ukuqinisekiswa kwe-schema se-XML ukuze kuphoqelelwe ukwakheka nokuqinisekisa ubuqotho bedatha. Ngokulungiselela izinkomba nokulinganisa amafomethi wedatha, i-Nithin inike amandla ukusebenzisana okungenazihibe kanye nemibuzo ephumelelayo kuwo wonke amasistimu ahlukahlukene. Lezi zindlela ziqondise izinqubo zokushintshisana kwedatha futhi zaxazulula izithiyo ezivamile eziphakama lapho kusetshenzwa ngamafomethi wedatha akhiwe kancane.

Kuphrojekthi eyodwa ephawulekayo, i-Nithin yasebenzisa i-OPENJSON ukuze iguqule ngokuzenzakalelayo ukudluliswa nokuguqulwa kwamadathasethi amakhulu empendulo ye-API ibe amathebula ahlobene. Le ndlela ithatha indawo yokwenza imephu yedatha eyenziwa ngesandla, ebidla isikhathi futhi ijwayele ukuba namaphutha. "Lokhu kuzenzakalela kunciphise isikhathi sokucubungula ngo-70%, kuqinisekisa izibuyekezo zesikhathi sangempela futhi kuthuthukisa ukukala kwesistimu ukuze kusingathwe amavolumu edatha akhulayo ngaphandle kokuwohloka kokusebenza," uyachaza. Ngokubhekana ngqo nalezi zinselele, i-Nithin ayizange nje ithuthukise ukusebenza kahle kwesistimu kodwa futhi yaqinisekisa ukuthi isisombululo singakhula ngokuzikhandla njengoba izimfuno zedatha zanda. Umsebenzi wakhe ubonisa ukuthi ukuhlanganiswa okucatshangelwe kahle kanye nokwenza kahle kwe-JSON kanye ne-XML kungaba nomthelela oguquguqukayo ekusebenzeni nasekulondolozeni.

Amathrendi Ajabulisayo kuseva ye-SQL

I-Nithin ibona amathuba ajabulisayo emandleni avelayo e-SQL Server, ikakhulukazi ekuphatheni kwayo i-JSON, i-XML, nedatha yendawo. Ugqamisa intuthuko efana nemisebenzi ethuthukisiwe yokubuza ye-JSON, efana ne-JSON_MODIFY kanye ne-OPENJSON, evumela ukugcinwa kwedatha okusebenza kahle kakhudlwana nokuthuthukiswa kokusebenza kwedatha enesakhiwo esilinganiselwe. Lezi zithuthukisi zibaluleke kakhulu njengoba amabhizinisi ngokuya ngokuya ethembela ekuhlanganisweni kwedatha okuguquguqukayo, kwesikhathi sangempela kwezinhlelo zokusebenza zesimanje.

Ngedatha yendawo, i-Nithin igcizelela ukubaluleka kwemisebenzi ye-geospatial ethuthukisiwe kanye nezindlela zokukhomba zendawo, ezibalulekile ezimbonini ezifana nokuhlela nokubhala amamephu okuncike ekuhlaziyeni kwesikhathi sangempela. Uyachaza, "Amandla akhulayo kudatha yendawo, njengemisebenzi ethuthukisiwe ye-geospatial nezindlela zokukhomba, abalulekile ekuhlaziyweni kwesikhathi sangempela ezimbonini ezifana nezokuhlela nokubhala amamephu." Lokhu kuthuthukiswa akuthuthukisi ukusebenza kuphela kodwa futhi kuthembisa izixazululo ezingaka kakhulu zokuphatha umthwalo onzima wedatha. Ngokuqhubeka nokuthuthukisa ukusekela kwayo idatha engahlelekile neyakheke kancane, i-SQL Server izibeka njengenkundla eqinile ekwazi ukuhlangabezana nezidingo zezinhlangano zesimanje eziqhutshwa idatha.

Njengoba izinhlangano ziya ngokuya zithembela ezinhlotsheni zedatha ezihlukene, ochwepheshe abafana ne-Nithin babonisa ubuchwepheshe obudingekayo ukuze kuguqulwe izinselele zedatha eziyinkimbinkimbi zibe izixazululo ezisebenzayo. Ngokufunda kahle i-JSON, i-XML, kanye nedatha yendawo ngaphakathi kweseva ye-SQL, ukuhlanganiswa kwe-Nithin kwenza kube lula ukusebenza, futhi kuxazulule izinkinga zomhlaba wangempela ezifana nokuhlaziya kwesikhathi sangempela kanye nokwenza kahle kwe-geospatial. Umsebenzi wakhe ugqamisa amandla okuthuthukisa okucatshangelwayo kanye nokunemba kwezobuchwepheshe, okuvumela amabhizinisi ukuthi akhule kahle ngenkathi ebhekana nezidingo zedatha yesimanje. Ngamakhono aguqukayo e-SQL Server, imininingwane ye-Nithin isebenza njengepulani lokuvula amandla aphelele wesistimu yedatha yanamuhla.