Ibhulogi kaJohn Boyer noMike Norris.
Isingeniso
Kubalulekile ukuthi ube namandla weCognos Auditing asebenzayo ukwazi nokuqonda ukuthi amaCognos asetshenziswa kanjani ngumphakathi wakho womsebenzisi futhi usize ukuphendula imibuzo efana nale:
-
- Ngubani osebenzisa uhlelo?
- Yimiphi imibiko abayenzayo?
- Zithini izikhathi zokuqhutshwa kombiko?
- Ngosizo lwamanye amathuluzi, njenge MotioCI, yikuphi okuqukethwe okungasetshenziswanga?
Uma ucabanga ukuthi kubaluleke kangakanani ukugcina izindawo ezinempilo zeCognos Analytics, ngokumangazayo kuncane okulotshwe mayelana nedathabheyisi yayo yokucwaninga ngale kwemibhalo ejwayelekile yomkhiqizo. Mhlawumbe, ithathwa kalula, kepha izinhlangano eziyisebenzisayo ziyazi ukuthi ngokuhamba kwesikhathi ukubuza amatafula e-Audit Database kuzoqala ukwehla - ikakhulukazi uma inhlangano yakho inabasebenzisi abaningi abasebenzisa imibiko eminingi futhi inomlando omningi. Ngaphezu kwalokho ukuthi ukungena ngemvume komsebenzi wokucwaninga ngokwako kungahle kubambezeleke ngoba kuyabekwa kulayini lapho kungenakungezwa ku-database ngokushesha okwanele, ngokwesibonelo. Yilapho uqala ukucabanga ngokusebenza kwedatha njengoba ubungenza nganoma iyiphi i-database esebenza ngezidingo zokubika.
Amatafula amakhulu ngokuvamile ahamba kancane ekusebenzeni kombuzo. Ukukhula kwetafula, kuthatha isikhathi eside ukufaka nombuzo. Khumbula ukuthi lawa amatafula kanye ne-Database Audit ngokuyisisekelo i-database yokusebenza; Kubhala kwenzeka kaningi futhi kusebenza ngokumelene nathi njengoba singeke sikugxile ekusebenzeni kokufunda kuphela njengoba ubungenza nge-data mart.
Ngokufana nesitolo sokuqukethwe, impilo yendawo ye-Cognos nayo kufanele icabangele impilo ye-Database Database. Ukukhula okungenamkhawulo kwe-Database Database kungaba yinkinga ngokuhamba kwesikhathi futhi kungagcina kube nomthelela ekusebenzeni jikelele kwemvelo yeCognos. Ezinhlanganweni eziningi ezinemithetho yangaphandle ebabophezelayo, ukungabi nalo irekhodi eliphelele lokucwaningwa kwamabhuku kungababeka esimweni sokungathobeli imiphumela emibi. Ngakho-ke sisebenzelana kanjani nokuthi sigcine idatha eningi ngezinjongo zomlando wokucwaninga - kwezinye izimo kuze kube yiminyaka eyi-10 - kepha sisathola ukubikwa esikudingayo ukugcina imvelo nokugcina abasebenzisi bejabule ngokusebenza?
Inselele
-
- Ukukhula okungenamkhawulo kwe-Database Database kunomthelela omubi empilweni yemvelo yeCognos
- Ukubika ngeDatabase Lokucwaningwa Kwamabhuku sekuhamba kancane noma akusebenziseki
- Okuhlangenwe nakho kwe-Cognos kubambezeleka kumarekhodi abhalwa ku-Database Database
- I-Database Database iphelelwa isikhala sediski
Konke lokhu kusho ukuthi akuyona nje kuphela imibiko encike kwi-Audit Database ehluphekayo, kepha imvamisa uhlelo lonke. Uma i-Database Database ikusiphakeli esifanayo nesitolo sokuqukethwe seCognos, ukusebenza kwazo zonke izinto amaCognos kuzothinteka kuleyo ndawo.
Isethaphu
Sicabanga ukuthi:
-
- I-Cognos Analytics ifakiwe futhi iyasebenza
- Ama-Cognos amiselwe ukungena ku-Database Audit
-
- Yiba neDatabase Lokucwaningwa kwamabhuku elikhona
- Setha amazinga afanele okugawulwa kwamabhuku ku-Cognos management
- Ukurekhodwa kubhalwa ku-database yiCognos
- I-Database Database isetshenziswe isikhathi esingaphezu konyaka
- Imvelo isebenza kakhulu ngabasebenzisi kanye nokubulawa
- Iphakeji lokucwaningwa kwamabhuku lisetshenziselwa ukwengeza idatha yokusetshenziswa kweCognos
- Sifuna ukwenza ngcono ukubikwa kweDatabase Database
- Ukuqala phansi noma ukususa amarekhodi amadala akuyona inketho ngaso sonke isikhathi
Uma ungakakwenzi, okwamanje, uneCognos Audit efakiwe futhi yamiswa, iLodestar Solutions, a Motio umlingani, unokuhle kakhulu iposi ngokunika amandla ukucwaningwa kwamabhuku ku-Cognos BI / CA.
Ikhambi
Kunezinye izixazululo ezingaziveza ngokushesha:
-
- Yehlisa ivolumu yedatha ngo:
-
- Ukuhambisa enye idatha endala kwenye i-database
- Ukuhambisa enye idatha endala kwelinye itafula ku-database efanayo
- Vele ususe noma i-archive eminye yemininingwane futhi ungakhathazeki ngayo
- Phila nayo. Khahlela ikani phansi road uphinde ucindezele uMlawuli weDatabase ukuze usebenze
ukuthuthuka ngenkathi ubabopha ngesandla ngokungavumeli ushintsho lwe-schema noma
izinkomba
Ngeke sibhekane nenketho 3. Inketho 2, ukususa idatha, akuyona inketho enhle futhi ngincoma ukuthi okungenani ngigcine izinyanga ezingama-18 okungenani. Kepha, uma uthambekele kakhulu, i-IBM inikeza insiza, AuditDBCleanup (ICognos BI) noma a iskripthi (Cognos Analytics) okuzokwenza lokho kanye. Ukusetshenziswa kweCognos BI kususa amarekhodi ngokususelwa kwisitembu sesikhathi ngenkathi imibhalo yeCognos Analytics isusa izinkomba namatafula.
Izincomo esizenze kumakhasimende ngaphambilini kulokhu bekumele zihlukaniswe ngemininingwane emibili:
-
- Ukucwaningwa kwamabhuku - Bukhoma: kuqukethe idatha yesonto lakamuva kakhulu
- Ukucwaningwa kwamabhuku - Okomlando: kuqukethe idatha yomlando (kuze kufike eminyakeni eyi-N)
Ngamafuphi, le nqubo isebenza masonto onke ukuhambisa amarekhodi akamuva kakhulu kusuka ku-Audit Live kuya ku-Audit Historical. I-Audit Live iqala kabusha njengesilayidi esingenalutho ngemuva kokuthi le nqubo iqale.
-
- I-Live DB iyashesha futhi iqinile, ivumela ukufakwa ukuthi kwenzeke ngokushesha okukhulu ngangokunokwenzeka
- Imibuzo yocwaningomabhuku iqondiswe kuphela kwi-Historical DB
Kusetshenziswa le ndlela, akukho “ukuhlanganiswa ndawonye” kwedatha Ebukhoma kanye nedatha Yomlando. Ngingasho ukuthi mhlawumbe ufuna ukuyigcina injalo.
Ku-Cognos Administration, ungangeza ukuxhumana okumbili okuhlukile koMthombo Wedatha Wokucwaningwa Kwamabhuku. Lapho umsebenzisi eqhuba umbiko omelene nephakeji ye-Audit, bayacelwa ukuthi baxhumane naluphi uxhumano abafuna ukulusebenzisa:
Uma kungenzeka ubheke idatha yocwaningomabhuku ebukhoma kunedatha yomlando wokucwaningwa kwamabhuku, umane ukhethe ukuxhumana kwe- "Audit - Live" lapho utshelwa (kufanele kube okuhlukile, hhayi okujwayelekile.)
Uma NGEMPELA futhi ufuna ukunikeza umbono ohlanganisiwe we-Live ne-Historical, ungakwenza lokho, kepha lokho kuzoba nomthelela ekusebenzeni.
Isibonelo, ungakha i-Database yesi-3 ebizwa nge- "Audit - Consolidated View" bese, etafuleni ngalinye ku-Audit schema: dala umbono obizwa ngokufanayo oyinyunyana ye-SQL phakathi kwetafula ku-DB bukhoma netafula umlando DB. Ngokufanayo, lokhu kungatholakala futhi kwimodeli yoMphathi Wezinhlaka, kepha, futhi, ukusebenza kungaba ukucatshangelwa okubalulekile.
Amanye amaklayenti ethu akhe umbono ohlanganisiwe. Kungumbono wethu ukuthi lokhu kungenzeka ngokweqile. Ukusebenza kuzohlala kubi kakhulu kulokhu kubuka okuhlanganisiwe futhi asihlangani namacala amaningi wokusebenzisa asebenzisa amasethi wedatha abukhoma kanye ne-Historical. Okubukhoma kusetshenziselwa ukuxazulula inkinga kanye nomlando wokubika kwethrendi.
Kusukela ngeCognos Analytics 11.1.7, i-Audit Database isikhule yaba ngamatafula angama-21. Ungathola eminye imininingwane kwenye indawo ku-Database Database, imibiko yokuhlolwa kwamasampula kanye nemodeli ye-Framework Manager. Izinga lokungena ngemvume elizenzakalelayo lincane, kepha ungahle uthande ukusebenzisa ileveli elandelayo, eyisisekelo, ukuthatha izicelo zokusebenzisa, ukuphathwa kwe-akhawunti yomsebenzisi nokusetshenziswa kwesikhathi sokusebenza. Enye indlela ongakugcina ngayo ukusebenza kohlelo ngokugcina ileveli yokugawula ibe sezingeni eliphansi kakhulu elidingekayo. Ngokusobala, ukungena ngemvume okwenziwa yiseva, ukusebenza kweseva jikelele kungathinteka.
Amatafula angukhiye abaphathi abaningi abazoba nentshisekelo kuwo amathebula ayi-6 afaka umsebenzi womsebenzisi nomsebenzi wokubika ohlelweni.
- COGIPF_USERLOGON: Igcina imininingwane ye-logon yomsebenzisi (kufaka phakathi ukungena ngemvume) imininingwane
- COGIPF_RUNREPORT: Igcina imininingwane emayelana nokubulawa kwabantu
- COGIPF_VIEWREPORT: Igcina imininingwane mayelana nezicelo zokubukwa kombiko
- COGIPF_EDITQUERY: Igcina imininingwane mayelana nokugijima kombuzo
- COGIPF_RUNJOB: Igcina imininingwane mayelana nezicelo zomsebenzi
- COGIPF_ACTION: Irekhoda izenzo zomsebenzisi kuma-Cognos (leli thebula lingakhula ngokushesha okukhulu kunamanye)
Ukucushwa kwangaphandle kwebhokisi kubukeka kanjena:
Ukumiswa okunconyiwe:
I-Cognos Audit Database - Live iqukethe isonto eli-1 lemininingwane yokuhlolwa. Idatha engaphezulu kwesonto eli-1 iyiswa ku-Cognos Audit Database - Historical.
Ulayini osuka kuDatabase Lama-Cognos Audit - Live to Cognos Audit Database - Umlando kulo mdwebo ubhekele lokhu:
- Ikopisha idatha kusuka ku-Live Audit kuya ku-Historical Audit
- Susa yonke imigqa ku-Live Audit endala kuneviki elingu-1
- Susa yonke imigqa ku-Historical Audit endala kuneminyaka engu-x
- Susa yonke imigqa ku-COGIPF_ACTION endala kunezinyanga eziyi-6
izinkomba
Izinhlobo ezihlukile zemininingwane zinezinhlobo zokukhomba ezihlukile. Inkomba yedathabhesi iyisakhiwo sedatha, esihlotshaniswa neThebula (noma i-View), esisetshenziselwa ukuthuthukisa isikhathi sokwenza imibuzo lapho kubuyiswa idatha kulelo tafula (noma i-View). Sebenza ne-DBA yakho ukudala isu elilungile. Bazofuna ukwazi izimpendulo zemibuzo enjengalena ukwenza izinqumo ezinhle kakhulu ukuthi yimaphi amakholamu okufanele abhekiswe kuwo. Ngokusobala, umphathi wedatha angathola izimpendulo zeminye noma yonke le mibuzo ngaphandle kosizo lwakho, kepha kungathatha ucwaningo nesikhathi esithile:
- Mangaki amarekhodi anawo amatafula futhi ulindele ukuthi akhule kangakanani? (Ukufaka inkomba etafuleni ngeke kusize ngaphandle kokuthi itafula linezinombolo eziningi zamarekhodi.)
- Uyazi ukuthi yimaphi amakholomu ahlukile? Ngabe bayawavumela amanani we-NULL? Yimaphi amakholomu anehlobo ledatha lenombolo ephelele noma inani elikhulu? (Amakholomu anezinhlobo zedatha yezinombolo futhi ahlukile futhi HHAYI NULL angabalingani abaqinile ababambe iqhaza kukhiye wenkomba.)
- Ziphi izinkinga zakho eziyinhloko zokusebenza namuhla? Ngabe bakulanda idatha? Ingabe kukhona imibuzo ethile noma imibiko okuyinkinga enkulu? (Lokhu kungaholela kumlawuli wedatha kwamanye amakholamu athile angenziwa kahle.)
- Yiziphi izinkambu ezisetshenziselwa ukujoyina amatafula wokubika?
- Yiziphi izinkambu ezisetshenziselwa ukuhlunga, ukuhlunga, ukwenza iqembu nokuhlanganisa?
Akumangalisi ukuthi le yimibuzo efanayo ezodinga ukuphendulwa ukuze kuthuthukiswe ukusebenza kwanoma yimaphi amatafula wedatha.
Ukusekelwa kwe-IBM uncoma kwakha inkomba kumakholomu “COGIPF_REQUESTID”, “COGIPF_SUBREQUESTID”, kanye ne- “COGIPF_STEPID” yamathebula alandelayo ukuthuthukisa ukusebenza:
- COGIPF_NATIVEQUERY
- COGIPF_RUNJOB
- COGIPF_RUNJOBSTEP
- COGIPF_RUNREPORT
- COGIPF_EDITQUERY
Futhi kwamanye amatafula angasetshenziswanga:
- COGIPF_POWERPLAY
- COGIPF_HUMANTASKSERVICE
- COGIPF_HUMANTASKSERVICE_DETAIL
Ungakusebenzisa njengesiqalo, kepha ngizozivocavoca ngokuphendula imibuzo engenhla ukuze ngithole impendulo enhle yenhlangano yakho.
Okunye yezakhi
- Ukucwaninga FM Model. Khumbula ukuthi imodeli ye-Framework Manager enikezwa yi-IBM imodeliswa kumatafula nezinkambu ezizenzakalelayo. Noma yiluphi ushintsho olwenzayo kumatafula wokubika luzodinga ukuboniswa kumodeli. Ubulula noma ubunzima balezi zinguquko - noma amandla akho enhlangano okwenza lezi zinguquko - kungathinta isixazululo osikhethayo.
- Izinkambu ezingeziwe. Uma uzokwenza, manje isikhathi sokungeza izinkambu ezingeziwe zomongo noma idatha yesethenjwa ukuthuthukisa ukubikwa kokuhlolwa.
- Amathebula okufingqa. Esikhundleni sokukopisha idatha etafuleni lakho lomlando, yicindezele. Ungahlanganisa idatha ezingeni losuku ukuyenza isebenze kangcono ekubikeni.
- Ukubukwa esikhundleni samatafula. Abanye bathi, “Ngakho-ke, esikhundleni sokuba ne-database 'yamanje' kanye ne-database 'yomlando', kufanele ube ne-database eyodwa kuphela, futhi wonke amatafula akuyo kufanele afakwe kuqala 'umlando'. Ngemuva kwalokho, kufanele wakhe isethi yemibono, eyodwa yetafula ngalinye ofuna ukuyibona 'njengamanje', futhi umbono ngamunye uhlunge imigqa yomlando ongafuni ukuyibona bese uvumela kuphela eyamanje. ”
https://softwareengineering.stackexchange.com/questions/276395/two-database-architecture-operational-and-historical/276419#276419
Isiphetho
Okusemqoka ukuthi ngolwazi olunikezwe lapha kufanele uzilungiselele kahle ukuba nengxoxo ekhiqizayo ne-DBA yakho. Amathuba amahle ukuthi uxazulule izinkinga ezifanayo phambilini.
Izinguquko ezihlongozwayo ekwakhiweni kwedathabheyisi ye-Cognos Audit zizothuthukisa ukusebenza ekubikeni okuqondile kanye nasezinsizeni ezivela eceleni ezithembele kuyo, njenge Motioka- ReportCard kanye ne-Inventory.
Ngendlela, uma uke waba naleyo ngxoxo ne-DBA yakho, singathanda ukuzwa ngayo. Singathanda futhi ukuzwa ukuthi ngabe usuxazulule yini udaba lweDatabase Lokucwaningwa Kwamabhuku elingenzi kahle nokuthi ukwenze kanjani lokho.
