Dismiss Notice
You are browsing this site as a guest. It takes 2 minutes to CREATE AN ACCOUNT and less than 1 minute to LOGIN

Oracle

Discussion in 'Tech, Gadgets & Science Forum' started by Yo Yo, Jul 26, 2011.

  1. Yo Yo

    Yo Yo JF-Expert Member

    #1
    Jul 26, 2011
    Joined: May 31, 2008
    Messages: 11,245
    Likes Received: 39
    Trophy Points: 0
    Ijulikane kuwa hii ndio the best Database kwa sasa hivi.Kama umetumia Oracle utakubaliana na mimi.
    Je watanzania tuna watu wenye ujuzi wa administration,developing kwenye Oracle? Siku za karibuni tumeshuhudia baadhi ya makampuni wakiitaji watanzania wenye sifa hizo lakini wamekosa(sina uhakika) na badala yake lundo la wageni wakichukua kazi za DB kwa kisa tu hatujui Oracle.

    Tufanyeje? Nafahamu kuna watanzania wenye uwelewa na Oracle tupo humu,tushirikiane tutajadili mengi toka kwenye Administration,developing forms and reports na mengineyo.
    .
     
  2. Zing

    Zing JF-Expert Member

    #2
    Jul 26, 2011
    Joined: Jun 24, 2009
    Messages: 1,780
    Likes Received: 15
    Trophy Points: 0
    Kabla ya tufanyeje je unaweza kufafanua hayo mambo mawili niliyoweka rangi

    • Unasema siku za karibuni tumeshuhudia je ambao hatukushuhudia unaweza kutuhabarisha ni makampuni gani hayo na job speccs zilizotoka. Je zaidi ya hiyo kampuni hapa bongo kampuni gani nyingine DB zao zinatumia oracle?
    • Unasema Oracle ni best DB. Je ni kivipi. ?
     
  3. Yo Yo

    Yo Yo JF-Expert Member

    #3
    Jul 26, 2011
    Joined: May 31, 2008
    Messages: 11,245
    Likes Received: 39
    Trophy Points: 0
    Makampuni mengi sana mkuu,siwezi kuyataja hapa ila nina list ya makampuni ambayo mpaka sasa hivi wanachukua expertriates toka nje kuja ku fine tune Oracle DB.
    Samahani nime copy na ku paste article hii

    Oracle takes a lead role because of some of the following reasons:

    Oracle is used for almost all large application and one of the main applications in which oracle takes its major presence is banking. In fact ten of the worldÂ’s top 10 banks run Oracle applications this is because oracle offers a powerful combination of technology and comprehensive, pre-integrated business applications, including key functionality built specifically for banks.

    Some similar databases like Sybase, SQL-Server one have facilities for using loops, conditions, arrays and so on in a program and also facilities like cursors and temp tables but all this would be used in a convoluted fashion which are very slow and resource consuming operations. The operations are not implemented as in Oracle which is efficient enough.

    Also with the features available in oracle with the earlier versions in market the oracle company keeps upgrading and releasing new products into market, new versions releases which serves better than the earlier versions and thus the performance is improved much in later versions and thereby retaining the market growth and thus proves greater satisfaction to the customers using this technology. Thus the advantage of a higher version is that one would have more features and better capabilities.



    For instance oracle 8i version has many new features which helped users namely like with oracle 8i one could run Java in the database, had features like new features on partitioning to support large database and so on. With the next version 9i oracle had these facilities maintained and had more new facilities added to it namely like new features added to help the DBA to handle change database configuration and so on.

    Oracle is a database that responds very well with excellent performance in demanding environments. Oracle is a major database which along with its added features passes the ACID test, which is important in insuring the integrity of data. This is very important because data is the heart of any system in organization. A reliable and adequate database system has the following properties:


    Atomicity:
    That is Results of a transaction's execution are either all committed or all rolled back.


    Consistency:
    The database is transformed from one valid state to another valid state. Illegal transactions aren't allowed and, if an integrity constraint can't be satisfied then the transaction is rolled back.


    Isolation:
    The results of a transaction are invisible to other transactions until the transaction is complete thus increasing the security on data.

    Durability:
    Once committed (completed), the results of a transaction are permanent and survive future system and media failures and thus ensuring maintenance and protection of data.


    All the above are well maintained by Oracle database.

    The latest version oracle 10g has many features and one new feature is the introduction of recycle bin. This option when enabled could be used by users just like Windows recycle bin or Mac Trash. Dropped tables go "into" the recycle bin, and can be restored from the recycle bin.

    One of the main advantage of oracle over other databases is in its recent version oracle has the concept of Flashback technology. That is we all know that data is the heart of any application or organization and thus this requires careful maintenance. But sometimes application outage can occur and mostly DBA claim the reasons for this as hardware failure and apart from this the reason would be human errors like accidental deletion of valuable data, deleting the wrong data, or dropping the wrong table. So it is very essential to take care of such situation and this is done in oracle's latest technology called flash introduced in its latest version. By Flash technology it helps in recovery by working just on the changed data. Thus Flashback provides an

    Efficient recovery from human errors
    Faster database recovery
    Helps in simplifying the management and administration processes

    and so on.
    Advantages of Using Oracle
     
  4. Zing

    Zing JF-Expert Member

    #4
    Jul 26, 2011
    Joined: Jun 24, 2009
    Messages: 1,780
    Likes Received: 15
    Trophy Points: 0
    Duh mkuu hata usalama wa taifa, FBI, zinatajwa tu au hio kampuni zinatumia oracle kwenye DB ya madawa ya kulevaya. teh teh teh teh . Why not mention just three four institution using oracle.


    oracle mi naona kidogo iko complicated. Sijui version mpya maana nisiku nyingi maana hata installition yake ni kazi. Inahitaji more resource kuliko Mysql na hata MSQL server.




    Mkuu ACID ni sifa ya any database engine kwa hiyo Atomicity, Consistency, Isolation, Durability sio sifa za oracle tu ni sifa za any Relational Database engine na hata Mysql na MSQL server zina sifa hizo.

    Anyway huo ni mtazamo tu
     
Loading...