How the Databases are for Large Companies
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: How the Databases are for Large Companies

  1. #1
    Join Date
    Dec 2000
    Posts
    255
    Hi All

    I don't know where I am posting it at correct place or not
    but I think all of you have done work on this can help me out.

    I would like to know that how in a big organizations the databases are implemented. This especially I am talking about huge bans who has ATMs world wide. Also where can I get info. on these databases.
    i ll also give cases which I would like to know. Is it possible just by using distributed databases or Oracle parallel server is needed for implementation

    Case 1. I have a account and I am withdrawing some amount from it from U.S . and simulataneously same time my father who also has access to that account is withdrawing money from India. Now the physical datafile for this table is located in Germany; Is my transaction directly going to delete data from my table data which is stored in germany or it will change first in local replicated datafile and then change it ?

    Also then if my transactions removes
    all amount from my account and at next second itself my father's transaction for withdrawal takes place in ATM in India then How this integrity will be maintained ? will my fatherimmediatly get a message for no balance. (Almost at same time my and my father's transactions are requested.)

    Also the above scenario is implemented using Parallel Server or Can it be implemented using just Distributed databases concepts i.e. Creating Links to remote databases and creating synonyms for tables at various locations?

    I ll be glad if anyone can guide me properly on this issue?

    Amol

  2. #2
    Join Date
    Dec 2000
    Posts
    255
    Whats the problem guys?
    No Reply ?
    At least any links or some references.

    Amol

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    With my own views,
    I haven't heard Oracle alone is being used to implement such wide range of scope of that kind of project. Some small banks uses Oracle for Banking, but never heard Oracle being used alone with affiliation world wide.
    I know BASE24 was widely used during late 1990s together with IBMs DB2/AS400,etc.
    Its got alot to do with the whole infrastructure not just the software but also the hardware aspect.
    Kind of transactions such as ON-US transaction- your banking transaction is with the same bank in which your account belong. And the other one is your banking transaction is made from a bank affiliated with organization of different banks where your bank is a member, such as BANCNET,etc. Where in your initial transaction info such as balance is immediately forwarded by BANCNET to your bank and later-on there will be a CLEARING in a certain time.

    I hope this helps you somehow.

  4. #4
    Join Date
    Dec 2000
    Posts
    255
    Thanks

    your info. was really helpful . However suppose we are talkin like compay called yahoo.com where it maintains users database of all over the world, how the database is designed and implemented.

    Amol

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by amolik
    Whats the problem guys?
    No Reply ?
    At least any links or some references.

    Amol
    gees gime a break, this is a forum not a classroom

  6. #6
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    Actually, there are too many factors for a clean answer. Too much depends on the specific hardware, software and application configuration.

    If the bank in your case is using replication, there is a delay between your's and your father's transactions and balance since multiple databases are involved. Whether this is a problem or what happens when the negative balance from is determined (at synchronization time for the replication) is an application issue.

    If the bank is using one database, then your father will be prevented from withdrawing because your balance will be immediately reflected. (There is a small risk if both your transactions occur at EXACTLY the same time, but that is vanishingly small.)

    With modern communications, both scenarios are possible, assuming 1 bank company.

    With multiple banks, you have various systems and *************s involved. Anything is possible.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  7. #7
    Join Date
    Nov 2001
    Posts
    11
    Just try to add some more:

    If you are using one central database, no risk for two concurrent transactions. Oracle has those basic stuff ( row level locking, read consistent etc...) as a commercial RDBMS, of course.
    If you are implementing replication, you have your choice to have the replicated data read-only, or have the applications themselves to resolve any transaction/data conflict. It's not the database to resovle this.

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Some small anks uses Oracle for Banking, but never heard Oracle being used alone with affiliation world wide.
    We, an investment bank in Scandinavia, run Oracle Parallel Server in a distributed enviroment.

    What is small bank? Define small.


  9. #9
    Join Date
    Dec 2000
    Posts
    255
    Hi

    I am not asking for small bank..in fact big banks. If you have Oracle parallel server implemented on distributed environment, can you tell me how it is implemented and how it supports the transactions from world wide. I ll be very much thankful if you can tell me or even guide me as I am still hanging on reserch.

    Amol


  10. #10
    Join Date
    Dec 2000
    Posts
    255
    Hi

    Can anyone at least tell how the distributed databases are implemented using Oracle Parallel Server

    Amol

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width