Nws yog lub sij hawm mus yuav ib qho kev txhim kho database rau koj lub tsev lossis lag luam, tab sis koj txiav txim siab li cas? Ua ntej, txiav txim siab seb yam twg koj xav tau kom koj xaiv tau cov khoom uas ua tau raws li koj xav tau thiab tsis ua rau mob ntau dhau hauv koj lub hnab ntawv.
Duab Databases
Tej zaum koj yuav paub nrog tsawg kawg ib qho khoom database . Cov lag luam yog dominated ntawm cov npe xws li Microsoft Access , FileMaker Pro, thiab OpenOffice Base. Cov khoom no tseem pheej yig thiab zoo rau cov tib neeg siv lossis cov ntawv tsis sib tham hauv web. Cia wb mus ze saib lawv:
- Microsoft Access : Access yog ib feem ntawm Microsoft Office suite thiab tej zaum twb yuav nkag mus rau koj. Yog tias koj muaj Chaw Ua Haujlwm, Kev Nkag Mus yuav muaj ib qho kev paub zoo rau koj, yog li yuav yooj yim dua kev kawm dua dlaws teeb meem ntau. Tag nrho cov qauv database yooj yim txaus siab, nrog rau txoj kev queries, ntau tus neeg siv, cov ntaub ntawv nkag teb chaws, thiab kev tshaj qhia. Web-based functionality tau ntxiv nrog rau kev tshaj tawm xyoo 2010, tso cai rau cov neeg siv nkag mus rau hauv cov ntaub ntawv uas tsis muaj Access ntsia rau lawv lub cev. Hmoov tsis, Access txhawb ntau qhov loj me me ntawm 2 gigabytes, limiting nws rau cov lag luam me thiab cov neeg. Kev nkag yog muaj nyob rau ntawm ob lub qhov rais thiab Mac.
- FileMaker Pro : Thawj zaug muaj nyob rau ntawm Mac, FileMaker Pro tau los ntawm kev muaj zog nyob rau hauv xyoo tas los thiab yog ib qho muaj txiaj ntsig lwm txoj kev mus rau. Nws ceev thiab luv nqi thiab muab ib chav suite los txhawb cov kev daws teeb meem mobile. FileMaker Pro yog ib feem ntawm FileMaker Platform uas muaj xws li FileMaker Mus rau mobile platforms thiab FileMaker huab thiab FileMaker tus neeg siv rau hosting apps hauv huab.
- OpenOffice Base : No cov ntaub ntawv pub dawb uas muaj los ntawm Apache muab ntau ntau cov kev teev database, tab sis kev pub dawb tsis txwv nws txoj kev teeb. Nws txoj kev siv nws yog tej zaum tus neeg siv khoom hauv tsev, thiab nws muaj xws li ntawm cov neeg paub txog kev lag luam los pab kev teeb tsa. Nws ua li, txawm li cas los, muab ib txheej drives mus txuas rau lwm cov ntaub ntawv database multiuser xws li MySQL thiab PostgreSQL.
Neeg rau zaub mov Databases
Yog tias koj tab tom npaj ib daim ntawv thov kev lag luam xws li lub chaw xa khoom e-commerce lossis cov ntaub ntawv database, koj yuav tsum tau hu rau ib qho ntawm cov phom loj. Databases databases zoo li MySQL, Microsoft SQL neeg rau zaub mov, IBM DB2 thiab Oracle muab cov firepower tiag tab sis nqa ib tus nqi hnyav hnyav.
- Oracle : Oracle yog tus vaj ntxwv ntawm databases thiab yog thawj qhov kev qhia database system (RDBMS) tsim. Nws cov teeb txheej yog sab thiab sib sib zog nqus, tab sis yog li nws txoj kev kawm nkhaus. Yog tias koj tswj cov ntaub ntawv ntau nyob hauv ntau qhov chaw thiab koj muaj qee cov kev pabcuam thiab tob ntaws, qhov no yog qhov kev xaiv zoo tshaj plaws.
- Microsoft SQL neeg rau zaub mov : SQL neeg rau zaub mov yog tus xaiv zoo yog tias koj lub koom haum twb siv Microsoft cov kev siv. Nws yog ib qho yooj yim siv thiab sib koom nruj nrug nrog lwm cov khoom siv Microsoft.
- MySQL : MySQL twb yog Sun Microsystems tab sis ua ib feem ntawm Oracle thaum Oracle yuav muag Sun rau xyoo 2009. Nws nyiam rau kev siv web-based.
- IBM DB2 : IBM lub lag luam database DB2 yog Oracle qhov ncaj ncaj competitor thiab yeej qhov sib ntaus sib tua tshaj tus nqi, dhau lawm.
Cov plaub tsis yog tib tug neeg nyob hauv cov ntaub ntawv tso cai rau database, tab sis lawv yog cov poj koob yawm txwv. Lwm tus xav txog yog Teradata, PostgreSQL thiab SAP Sybase. Qee cov tuam txhab kev lag luam muab "cov ntaub ntawv" cov khoom siv dawb los yog them tus nqi tsawg, yog li kos cov neeg tawm ua ib lub sijhawm los tuav cov qauv rau lub kiv puag ncig.
Web-Enabled Databases
Niaj hnub no, yuav luag txhua daim ntawv thov database hu rau qee qhov kev sib tham ntawm lub web. Ntau tus neeg xav tias yog tias koj xav tau txais los yog muab cov ntaub ntawv hauv Internet, koj yuav tsum siv cov database server. Tias 's tsis tas muaj tseeb - lub database database yuav (pheej yig!) Raws li koj xav tau. Piv txwv, Microsoft Access ntxiv kev them nyiaj yug rau lub web daim ntawv sau npe nrog nws cov lus tshaj tawm 2010. Yog tias koj xav tau qhov no, nco ntsoov nyeem tag nrho cov ntawv nplua nuj ntawm txhua tus database uas koj tab tom xav yuav khoom.