Desktop vs. Server Database Systems
Oracle, SQL Server, Microsoft Access, MySQL, DB2 kana PostgreSQL? Iko kune zvakasiyana-siyana zvezvigadzirwa zvemadhora mumusika nhasi, zvichiita kusarudzwa kwepurati yekusungirirwa kwesangano rako basa rinotyisa.
Tsanangura Zvaunoda
Database management systems (kana DBMSs) inogona kugoverwa mumapoka maviri: desktop databases uye server database. Kazhinji kutaura, desktop database yakarongeka kune maitiro evanhu vasina kushandiswa uye inogara pamakombiyuta evanhu chaiwo (saka iyo inonzi desktop ).
Server database yakagadziridza nzira dzekuvimbisa kuvimbika uye kusagadzikana kwematare uye zvinotarisirwa kumashandisirwo evanhu vakawanda. Iyi nheyo dzakagadzirirwa kuti dzishandise pamashandisi epamusoro uye dzinotakura mutengo wakafanana wepamusoro.
Zvakakosha kuongorora nekutsvaga kwezvinodiwa usati wapinda mukati uye uzviisa kune imwe sarudzo yezvinyorwa. Iwe unowanzoona kuti database yekodhidhi yakakodzera yebhizimisi rako zvaunoda apo iwe pakutanga wakaronga kutenga yakadhura server-based solution. Iwe unogonawo kuzarura zvido zvakavanzika izvo zvinoita kuti kuendeswa kwezvinyorwa, se-database-based database.
Kuongorora kudiwa kwechiso kuchave kwakananga kune sangano rako asi, zvishoma, inofanira kupindura mibvunzo inotevera:
- Ndiani achange achishandisa database uye mabasa avo achaitei?
- Inguva yakawanda sei data ichachinjwa? Ndiani achaita izvi kuchinja?
- Ndiani achange achipa Tutsi kutsigirwa kwe database?
- Ndeipi hardware iripo? Pane bhajeti yekutenga hardware yakawedzerwa here?
- Ndiani achave ane kodzero yokuchengeta deta?
- Ko kuwanikwa kwepa data kuchapiwa paIndaneti here? Kana zvakadaro, ndeapi nhanho yekuwana inofanira kutsigirwa?
Kana uchinge waunganidza mhinduro dzemibvunzo iyi, iwe uchagadzirira kutanga chirongwa chekuongorora hutachiona hwehutano hwemashoko. Iwe unogona kuona kuti unyanzvi hwakawanda-shandisi server sepuraneti (saSQL Server kana Oracle) inodiwa kuti utsigire zvinetso zvako zvakaoma. Kune rumwe rutivi, database ye database yakadai seMicrosoft Access inogona kunge yakakwanisa kukwanisa zvido zvako (uye zviri nyore kudzidza, pamwe nekudzidzira pamapokisi yako!)
Desktop Databases
Desktop databases inopa sarudzo shoma, iri nyore kune dzakawanda zvisinganyanyi kuoma zvakachengetedzwa zvekuchengetedza uye kushandiswa kwezvinhu zvinodiwa. Vanowana zita ravo kuburikidza nekuti ivo vakagadzirirwa kuti vashandise pa "desktop" (kana munhu oga) makombiyuta. Iwe unogona kunge uchiziva nezvezvishoma zvemishonga iyi ikozvino - Microsoft Access, FileMaker uye OpenOffice / Free Office Base (vakasununguka) ndivo vatambi vakuru. Ngatimboongororai zvishoma zvezvikomborero zvakawanikwa nekushandisa database yedesktop:
- Desktop databases haina mari. Iwe uchaona kuti mahofisi akawanda ezvekombiyuta anowanikwa kune madhora anosvika $ 100 (achienzaniswa nezviuru zvemadhora nokuda kwevana vavo vakagadzikana). Zvechokwadi, kana iwe uine kopi yeMicrosoft Office, iwe watova nemvumo yeMicrosoft Access.
- Desktop databases inoshandiswa nevashandi. Kunyatsonzwisiswa kweSQL hazvidikanwi kana uchishandisa maitiro aya (kunyange zvazvo vazhinji vanotsigira SQL nokuda kwenyu geeks kunze uko). Desktop DBMSs inowanzopa nyore nyore kufamba-famba mufananidzo wekushandisa.
- Desktop databases inopa web solutions. Mazuva ano akawanda mabhuku ezvinyorwa anopa ma webhutsetse anoita kuti iwe ubudise dheedhi yako pawebhu mumutambo wakasimba kana wakasimba.
Server Database
Server database, yakadai seMicrosoft SQL Server , Oracle, PostgreSQL yakasununguka, uye IBM DB2, inopa masangano kukwanisa kutakura zvakawanda zvematare nenzira inoita kuti vashandi vakawanda vauye uye vadzosere data panguva imwe chete. Kana iwe uchikwanisa kutakura mutengo wemari, ine server-based database ingakwanisa kukupa yakazara yekugadzirisa dambudziko remhinduro.
Zvikomborero zvakawanikwa kuburikidza nekushandiswa kwe-server-based system zvakasiyana. Ngatitarisei zvimwe zvishoma zvinowanikwa zvakawanikwa:
- Flexibility. Server-based databases inogona kubata chero chero dambudziko rekushandisa kwedambudziko raunokwanisa kuakanda kwavari. Vanokurudzira vanoda masangano aya nokuti vane programmer-friendly friendly programmer interfaces (kana APIs) iyo inopa kukurumidza kukurudzirwa kwezvidzidzo zvekodhi-tsika yakatangwa. Purogiramu yeOracle inowanikwa kune maitiro akawanda ekushandura, kupa Linun junkies neanhare kutamba munda apo pairi pairi paMicrosoft.
- Simba rinoshanda. Server-based database yakasimba seunoda kuti vave. Vatambi vakakurumbira vanogona kushandisa zvakanyatsoshandisa chero chero ipi zvayo yakakodzera hardware platform iyo iwe unokwanisa kuvakira. Mazuva ano databases inogona kutarisa yakawanda, yakakura-speed processors, mavhareji akabatanidzwa, high bandwidth kuwirirana uye kukanganiswa kwekuchengetedza teknolojia yekuchengetedza.
- Kubudirira. Ichi chirevo chinopinda maoko-pamwe-nechokutanga. Kana iwe uchida kugovera zvigadziridzo zvehurongware zvakakodzera, database yevashumiri inokwanisa kushandira zvakanaka nekuwedzera kwekuwedzera kwevashandi uye / kana data.
NoSQL Database Alternatives
Nekuwedzera kwekuda kwemasangano kushandura zvikwata zvakakura zve data yakaoma - mamwe acho asina chimiro chetsika - "NoSQL" databases yakave yakawanda kwazvo. A NoSQL database haisi yakarongeka pamatombo akazara / murongwa wekugadzirwa kwemashoko ezvizvarwa zvezvekodzero, asi zvinoshandisa imwe nzira yakawanda ye data. Muenzaniso wacho unofanana, zvichienderana nedhesiyo: vamwe vanoronga dhigirii kuburikidza nheyo / kukosha mbiri, mairafu kana mapuranga akareba.
Kana sangano rako richida kukanganisa deta yakawandisa, funga nezvenzvimbo iyi ye database, iyo inowanzoita nyore kugadzirisa pane dzimwe RDBM uye yakawanda yakawanda. Vanopikisana zvikuru vanosanganisira MongoDB, Cassandra, CouchDB, uye Redis.