Database Management Systems & DBMSs

UPS ndiyo inotungamira pasi rose mukutakurwa kwepasuru.

Pazasi pane tsananguro yekubatanidzwa pakati pezvakasiyana zvinhu (kubatana / sangano / masisitimu).

Izvo zvinofanirwa kucherechedzwa kuti, zvichipihwa saizi yekambani, chimiro chebhizinesi rayo uye huwandu hwehunyanzvi hwaanotora, tsananguro yakakwana ingadai yakapfuura zvakanyanya miganhu yakaiswa pamushumo uyu; naizvozvo tichaedza kupa mhedziso yezvinhu zvikuru.

Kubatanidzwa

Kubatanidzwa kwekutanga pakati pezvikamu zvinogona kutaurwa nezvazvo ndezvekuti pakati pehurongwa nehurongwa. UPS ikambani hombe, asi yaive nefanoona yekugadzira yayo kubva pakutanga data base sepakati uye monolithic entity. Iyo New Jersey nzvimbo - senge mapatya ayo eGeorgia, hongu - inotambira akati wandei Database izvo zvine (pakati pemamwe ruzivo):

i dati kuhutungamiri hwevashandi;

i dati, yakagadziridzwa munguva chaiyo, pamatura uye nzira dzekufambisa dziri kushandiswa, dzakagoverwa muintermodal transport network;

ruzivo pamusoro pemakambani anodyidzana ei vatengi (iyo yekupedzisira zvakare yakagadziridza chaiyo-nguva, zvichibva paruzivo rwunouya kubva kuDIAD terminals uye saiti Indaneti);

i dati yekugadzira zvinyorwa zvemari (balance sheet, mari yekuwana, nezvimwewo).

Sezvo kambani dhanzi kunyange kunze kweUnited States, mamwe mativi akagoverwawo kunze kwenyika. Muenzaniso ndewe data base manejimendi evashandi, nemasikirwo ayo akabatanidzwa nehupfumi hwekuongorora masisitimu: vashandi uye mari yekushandisa inochengetwa mukati Database yenyika, asi ruzivo rwunopota ruchiunganidzwa uye rwunoshandurwa kumari yeUS; chero mabasa anopesana nekugadzirwa anoonekwa uye anogadziriswa munguva pfupi. Iko kudiwa kwekuita otomatiki kutevedzera mutengo kwagonesa UPS kuti iite otomatiki mamwe maitiro, kusanganisira kugadzirwa kwemubhadharo.

Iyo manejimendi yekuchinja uye nguva yekuzorora yakave zvakare semi-otomatiki: vashandi vakaiswa muchikamu. Database zvichibva parudzi rwebasa, kosi uye dunhu renzvimbo (tichaona mundima inotevera kuti izvi zvinomiririra sei zvinhu.

yeOntology); chikumbiro chezororo - icho chinofanirwa kuitwa pachine nguva - chinopinzwa musoftware inoendesa kubvumidzwa kwechirongwa kune vakuru vechikamu. Iyi nzira, inoshanda zvakanyanya pamapepa, yakakonzera kutangwa kwekirasi-chiito chekutonga kuUPS nevashandi, nekuti yanga isiri nzira "inochinjika" kune vanhu vanongoerekana vakanganisa kana kuremara).

I dati zvine chekuita nedzimba dzekuchengetera zvinhu uye zvekufambisa ndiwo musimboti wekuita kweUPS, iyo inorarama nekugona kwemabasa ayo nekusagadzira zvinhu. Yese software yakagadzirwa nekambani pachayo mumakumi maviri emakore apfuura uye yakanyatsobatanidzwa: ivo vese vanoreva zvakafanana data base uye kune kuenderera mberi kweruzivo kuenda nekubva kune maapplication.

Semuenzaniso, kana mutengi achikumbira pasuru kuti itumirwe, ruzivo rwake rwunopinzwa - kubva pakutanga kana sekuvandudzwa - (kunyanya mareferensi ekubhadhara, anosimbiswa kuburikidza neinterfacing masevhisi ane interbank system). dati yepasuru (yekunhonga uye yekuendesa nzvimbo, inogoneka imwe nzvimbo kana isiri yekuunganidza, mutengo wekutumira unoverengerwa otomatiki uye unogamuchirwa nemutengi, nezvimwewo). Chikwereti chinogadzirwa ipapo ipapo kana chatambirwa neiyo sisitimu yekusimbisa yekutumira (yakasvika kubva kuDIAD terminal).

Chizvarwa chekuraira chinokonzeresawo kusikwa kwerekodhi muhurongwa hwekutungamira kwekutakura, iyo inosanganisira chiziviso kune vashandisi vanobatanidzwa. Iyo UPS Logistic support system inotarisira kukwenenzvera kutumirwa kwepakeji, zvese maererano neiyo nzira shoma inotorwa nemavan uye mapakeji anotakurwa navo, zvakare ichifunga nezvevashandisi varipo pahwaro hwezororo rambotaurwa uye kuronga kwekuzorora. Iyi yese mienzaniso yehupamhi hwekubatanidza hunowanikwa nehurongwa hwekambani.

Sezvakatojekeswa mugwaro rapfuura, uye sekubuda kubva pane zvataurwa kusvika zvino pakuyerera kwe dati kubva kune dzimwe nyika kuenda kune Database pakati, basa guru rekuchengetedza zvinhu rinoitika. UPS ine a Database yeanoverengeka terabytes inogara iyo oparesheni ruzivo raibhurari (OIL), muunganidzwa wakakura we dati, yakarongeka pamatanho akasiyana e granularity, inopfupikisa mabasa eboka. OIL yakatanga kuberekwa kuitira kuvandudza sangano remukati pavhu reAmerica uye kuronga mazano munguva pfupi, asi kutanga kubva ku1999 inobatanidza ruzivo rwese pamusoro pekushanda kwepuraneti uye chete kubva pakutanga kwe2000s inoshandiswa pakubatanidzwa kwesoftware hungwaru uye online analytical processing.

I dati aggregates anogona kubvunzurudzwa nevatungamiriri vesangano; sezvakataurwa mune rimwe gwaro, akawanda dati ye granularity yakanaka kwazvo inoitwa kuti iwanikwe kuburikidza neAPI na vatengi, semuenzaniso ruzivo rwechimiro chechinhu chimwe chete chakatumirwa. THE vatengi ivo pachavo vanogona kubatanidza ruzivo urwu mumasisitimu avo zviri nyore nekuda kweiyo UPS yakarongeka yekugashira yakavhurika zviyero.

Sezvinotsanangurwa mune rimwe gwaro, UPS ine komisheni inoita hunyanzvi hwetekinoroji, kuunganidza mazano kubva kuvashandi. Mazano anotumirwa kuburikidza newebhu application, iyo inogona kushandiswa kuburikidza nekambani intranet.

Ontology yekubatanidza

Mukufungidzira ontology kuseri kwekubatanidzwa kweUPS, munhu anogona zvechokwadi kutanga kubva kuvatambi vanobatanidzwa mubhizinesi rayo rekutanga: parcel transport. Saka, isu tine kirasi Package, inotakurwa kubva kune imwe Nzvimbo kuenda kune imwe; kutakura kunogona kufungidzirwa nehukama huviri "transportFrom" uye "transportTo", kana imwe isingabatanidzi kubva

modelling transnational uye multimodal delivery. Parcel inogona kunge iine akati wandei madiki madiki - zvichienderana nehunhu hwayo - uye inofanirwa kuve neNzvimbo yekukurumidza, ichitevera geolocation.

Iyo package inowanzotumirwa nemutengi; tichitarisa hukuru hwemhando dzemasevhisi eUPS - ayo asingasanganisi chete kutakurwa kwemapasuru - kutarisisa kukuru kunofanirwa kubhadharwa kune tsananguro yemakirasi akatorwa uye hunhu. Chero sevhisi inopihwa, yechero hunhu, inosanganisira "kuita" kweOrder yemhando dzakasiyana, seShipi.

Zvinogona kuitika kuti mutengi zvakare Mutengesi. Iyo ontology inogona kutsanangura yepamusoro-kirasi yekuunganidza CompanyPartner kana ichiziva kuti iri panguva imwe chete kambani yerudzi Mutengi uye Mutengesi, kana kana yakaita kamwechete kugovera uye kanenge odha imwe.

Big Brown, sekudanwa kwainodanwa muUPS jargon, inonyanya kuumbwa neVashandi masangano akarongwa mune yakakura uye yakasiyana-siyana hierarchical chimiro (Organization Chart). Pano zvakare, kurongeka kunofanirwa kuve kwakaringana, nekusimbisa zvakanyanya pazvinhu zvine chekuita nenzvimbo / nguva: mushandi anozoshanda muNzvimbo chaiyo, kana kuti kuunganidzwa kwenzvimbo padandemutande repasi rose, achavhara chaiyo Timetable panguva yake yeKushanda Vhiki. zvichingodaro. Ontology yerudzi urwu yaizoita kuti zvive nyore kuita otomatiki inferences muchizvarwa chekuzorora mashifiti. Nekuenzanisira zvakakwana humwe hunhu hwakadai sezvikwaniriso, mazita, marekodhi ebasa uye makore ebasa, manejimendi anopiwa mukana wehuwandu - pamwe nehunhu - kuongorora mashandiro evashandi.

Zvizhinji zveizvi dati vatovepo muUPS's legacy system, yakachengetwa mukati me Database yakatangwa mumakumi maviri emakore apfuura. Vamwe vanogona kubuda kubva pa "maonero" akakodzera pane dhatabhesi kana kuburikidza nezviitiko zvekuchera data.

arun CEO

👍Online Web Agency | Webhu Agency nyanzvi muDigital Marketing uye SEO. Webhu Agency Pamhepo iWebhu Agency. YeAgenzia Web Online kubudirira mukushandurwa kwedhijitari kunobva panheyo dzeIron SEO vhezheni 3. Hunyanzvi: Kubatanidzwa kweSystem, Enterprise Application Integration, Service Oriented Architecture, Cloud Computing, Dhata warehouse, njere dzebhizinesi, Big Data, portals, intranets, Web Application. Dhizaini uye manejimendi ehukama uye multidimensional dhatabhesi Kugadzira nzvimbo dzekupindirana dzedhijitari midhiya: usability uye Graphics. Online Web Agency inopa makambani masevhisi anotevera: -SEO paGoogle, Amazon, Bing, Yandex; -Web Analytics: Google Analytics, Google Tag Manager, Yandex Metrica; -Kushandura kwemushandisi: Google Analytics, Microsoft Clarity, Yandex Metrica; -SEM paGoogle, Bing, Amazon Ads; -Social Media Marketing (Facebook, Linkedin, Youtube, Instagram).

Ona Yakazara Bio

Digital Marketing Database DBMS Dhata Warehouse Data Science Kushambadzira Pamhepo Information Technology Webhusaiti Webhu Advertising Agency Marketing