Oracle Database: te āhuatanga matua o te Oracle

Ko te whanaketanga tere o te Information Society hua i roto i te whanaketanga o ngā hangarau hangaia mō ngā mahi motuhake. He kaupapa matua ko te hiahia o te hoahoa ara hou o te rokiroki me te tukatuka nui o ngā raraunga mā te whakamahi i pūmārō.

Otinga o te raruraru, ko te hanganga o te pātengi raraunga (DB) rite te tikanga o te rokiroki raraunga me ngā pūnaha whakahaere turanga raraunga (DBMS) rite te tikanga tukatuka.

He aha te mea he DBMS

pūnaha pātengi raraunga whakahaere - he huinga o ngā taputapu pūmanawa e kua whakamahia ki te hanga i te pātengi raraunga, me te tirotiro, rapu, a ka whakahou ratou mōhiohio penapena. whakahaeretia huinga raraunga e te huinga o reo, me te pūmanawa. I roto i te mahi, kei te nuinga o whakamahia te pātengi raraunga i roto i te hanga o ngā pūnaha mōhiohio.

I teie mahana i reira e rave rahi kōwhiringa mō ngā pūnaha whakahaere pātengi raraunga e te wehe rua taumahinga me ngā whakaritenga ki te rorohiko. Ka rite ki tauira o DBMS hou taea meinga Oracle Pātengi Raraunga, ka e kia kōrero atu, MySQL, Access, Tūmau SQL, Fox Pro.

Ahakoa te kanorau o te pātengi raraunga, kua wehea ratou ki e rua ngā momo: maha-kaiwhakamahi, me te whaiaro.

pūnaha Maha-Kaiwhakamahi

E hangaia ēnei tüäpapa ki te mahi i ngā mahi matatini i runga i rorohiko kaha. mahi maha iwi i roto i te whakarara i roto i te pūnaha taua, na ngā reira o te maha āhuatanga, me te ake āta:

• karihi i roto i te mahara;
• tūmau;
• here i te maha o ngā hōtaka kiritaki e mahi i ngā mahi i whakaritea e ngā kaiwhakamahi.

I roto i te pūnaha taua whakamahi kotahi rorohiko matua whakamahia e te rite te tūmau me te pupuru ana nga raraunga me te pata. whakarato i tētahi otinga taua wāhi whakamarie ki te pātengi raraunga kiritaki. I roto i te tua, he pātengi raraunga taua nui e ohie te ako o ngā hapa. hanga High tere tuku raraunga te mahi tōtika. Ka taea e kiritaki kōrero ki te pūnaha mā tetahi whatunga. Ko tika enei etahi o nga painga o te pātengi raraunga maha-kaiwhakamahi, ki nei te Pātengi Oracle.

pūnaha whaiaro

Kei te hangaia tēnei momo mō ngā tono iti-tauine. E whakanohoia ēnei pūnaha i runga i ngā rorohiko whaiaro, me te taunekeneke ki te kaiwhakamahi. Kei te rongoa te pātengi raraunga, me te ake te hōtaka i roto i te kōpae kotahi.

Ki te rā, te ngā o enei pūnaha kua tapiritia te kaha ki te mahi i roto i te taiao raumata. Heoi, i roto i tenei take ko reira āhuatanga tino nui o ia wāhi mahi. E kei ēnei i runga i te tūmau; E hiahiatia ana kiritaki katoa ki te tāuta i te tono, me te kape o te pūnaha iho. Ko tenei otinga ai raruraru ka te huringa raraunga. Kei te faingataa hoki Access ki te turanga i roto i tenei take. mahi wehe ia kaiwhakamahi, me i roto i tona hōtaka e kore e kitea ki ētahi atu kiritaki hapa. Ki te kore ratou e aukati, ka ka kia raruraru uru tukutahi.

Mō ētahi atu pārongo e pā ana ki Oracle

He aha te mea te Pātengi Oracle? No te tau maha, pātengi i Oracle whakarato kaiwhakamahi ki te whakamarie mōrahi, haumaru, te mahi nui, me te tika. E whakaatu ana maitai te pūnaha iho me he nui hoki te kiritaki ia o tona āhuatanga. e kore e taea te mahi i te nuinga o ngā pūnaha mōhiohio nui-tauine waho te whakamahi o tenei pātengi raraunga.

rawa hohoro Hangarau hou, a ka he tonu hua rite tono hou. Storage me taunekeneke ki te raraunga i te taumata tika whakarato e rave rahi ngā pūnaha. Ko tonu te pātengi raraunga Oracle i te mata, te whakawhetai ki te whakapai ake tamau.

āhuatanga matua o te pūnaha

Tenei pātengi raraunga ko te kohinga o ngā wāhanga pūmanawa, he rawaka hoki te whakahaere o te kaupapa o tetahi whīwhiwhi te mana o e. tikanga ka tika te whakawhanake-topa e taea te rokiroki e koe te here i te maha o pātengi raraunga mōhiohio. Ko te mahi whānui whakarato te kaha ki te taunekeneke ki te raraunga ki tetahi maha o kiritaki. kia Rāhuitanga tika nga rauemi pūmārō. Kua whakaheia e te ngā i roto i te pūnaha te hangarau tūmau pai katoa, hanga i te mahi i roto i te pai Ipurangi.

tautoko hoki i te āhuatanga nui o Oracle tüäpapa maha. Linux, Windows ranei tetahi atu pūnaha whakahaere e tukua te pātengi raraunga ki te whakarite tōtika. Ko reira utu te whakahua, me ngā kaupapa here hekenga. Ko te whakawhiti ki ngā putanga whakahoutia whakaritea tino watea, ka whakawhiti i te hōtaka motuhake raraunga mai i ētahi atu pūnaha.

He aha e nga kōwhiringa mo te pātengi raraunga?

Ko te ngā whakarato ngā kaiwhakamahi ki kōwhiringa wha mo te pūnaha:

• Edition Paerewa;
• Lite;
• Enterprise Edition;
• Edition Whaiaro.

kitea ana tēnei whakarōpūtanga te kore anake i roto i te Oracle Database. He nui ake rite ki tahi e te tahi Putanga. Ko nga rerekētanga matua i roto i te wahi mahi, mō ia kōwhiringa reira he kōwhiringa ahurei.

Paerewa Edition

Tino putanga rongonui, ko ahua iti te taumahinga. Nuinga o ngā wā kei te whakamahia i te reira ki te hanga i ngā pūnaha mō te maha iti o kiritaki. he pai hoki rōpūmahi, pakihi iti, a na i runga i. D. tenei Otiia i roto i te whakahaere nui ano hoki, he wāhi mō te Paerewa Edition, ina tae mai te reira ki wāhi mamao. Kei te iti te utu o tenei putanga o Oracle Pātengi Raraunga, ia e kia nui ki te mahi tōtika te kaha ngā.

Oracle Lite

Ko te putanga tino māmā, me te ono tekau o te pūnaha. He pai ki te whakamahi i te reira i runga i ngā pūrere pūkoro, rorohiko, a na i runga i. tutuki D. Easy tukutahitanga o ngā mōhiohio kei te roto i te whakamahi o atanga noa. kawea whanaketanga Taupānga te roto e te tikanga tikanga.

Enterprise Edition

Ko te putanga pai o te pātengi raraunga Oracle me taea ngā katoa. He ana tēnei pūnaha taea mutunga, me te taea ki a koe te whakarite tino tetahi kaupapa. I roto i tenei take, tei reira anake i runga i pūmārō kaha. kua kohia putanga te hangarau rokiroki pai me te taunekeneke ki te mōhiohio. Ka taea ki te mahi hua kahore hoki e mutu, te whakawhetai ki te scalability rahi te tūmau pātengi raraunga. Whānui whānuitanga o ngā mea āwhina ki te pūrua o koutou raraunga, me te whakahoki ratou ina hiahiatia. e kore te ngaro tino mōhiohio.

Edition whaiaro

Ko te kiritaki Database Oracle he tino tika hoki te whakamahi whaiaro ranei whakangungu. ka kia ranea ki te waihanga hōtaka me ratou whakamahi atu i runga i putanga maha o Windows taumahinga. tākaro rātou i te wāhi nui, ie. A. I roto i te NT ranei "2000" e wātea ana ki te taea katoa, a ka kua iti 95/98 / AU kōwhiringa e tika ana ki te āhua o te pūnaha whakahaere.

Āhuatanga o te putanga 11g

Kaua pinepine i raruraru ki te tāutanga o te pātengi raraunga kaiwhakamahi, me te i roto i te putanga 11g, kua nui raweketia tenei tukanga. I tua atu, kua riro te reira atu watea ki te taketake e kore anake, engari ano hoki i te tautuhinga motuhake. Ka waiho i te pūnaha whai hua ake ki te te papaitia reira mo te mahi e hiahiatia ana, a i roto i Oracle Database 11g, tenei āhuatanga hangaia tika.

pai ake hoki whakatauine tikanga. Mā te tāpiri i kōpuku hou i roto i te tautau e taea te whakatutuki i mahi whakaponohia i roto i te tere, me te hua o te tūmau. Kahore he hiahia ki te aukati i te hōtaka ranei ki te tuhituhi anō rawa ratou. e kore te pūmautanga o te tono waimaero ara, ki te te kore o ngā kōpuku takitahi.

Me pēhea te ki te tiki i te pātengi raraunga?

I runga i te paetukutuku e pā ana ka taea e koe te tiki i te putanga e tika ana o te pūnaha, a ka tonu hei reira te otinga tino mātau. I te whārangi download, ka hiahia koe anake ki te titiro me te whakau i te whakaaetanga raihana, a ka tīpako i te pūnaha whakahaere.

Ko te taahiraa whakamutunga ko whakamanatanga i runga i te pae. Ki te kahore he kōtaha, ngāwari koutou e taea e te waihanga i te reira, ka takiuru roto. Ko te aroaro o te pūkete, ko te kore e whakahauanga anake, engari ano hoki pai. I tua atu ki te pātengi raraunga whārangi download, ka riro kaiwhakamahi uru ki ētahi atu taea ngā.

Tāuta 11g Oracle

Me pēhea te ki te tāuta Oracle Database 11g i runga i Windows 7? tākai DBMS te i roto i te pūranga hiahiatia e te ki whewhera i muri i te tikiake.

Next, me mahi koutou te whai ake:

1. I roto i te kōpaki DISK1 ki te whakatuwhera i te kōnae tāutanga huaina Setup.exe.
2. Haere i te mata Nau.
3. Whakaae ki te raihana.
4. Tīpakohia te wahi ki te tāuta i te hōtaka (engari ko te reira pai ki te waiho i te ara o te paerewa).
5. Waihanga i tētahi kaiwhakahaere pūkete.
6. Tirohia enei kōrero, me te whakaū i ratou.

Ko te tino māmā Tāuta, a he pūmanawa nga mahi katoa. E tano ia tapao e kore anake i runga i Windows kia ngāwari ki te whakaturia ake te pātengi raraunga i Oracle. Linux me ētahi atu pūnaha whakahaere katoa e kore hoki e meinga raruraru, rite atu tukanga whakamahinga ko te taua.