How the Databases are for Large Companies

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

Whats the problem guys?
No Reply ?
At least any links or some references.

Amol

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.

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

Quote:

---

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

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.

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.

Quote:

---

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.

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

Hi

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

Amol

Quote:

---

Originally posted by amolik
Hi

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

Amol

---

Check Metalink 13229.1.

Quote:

---

Originally posted by julian

Quote:

---

Originally posted by amolik
Hi

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

Amol

---

Check Metalink 13229.1.

---

no kidding.
In the time it took you to post this 5 times, you could have researched it on OTN or Metalink with ease. This is not counting just going out and buying an Oracle Admin book which would tell you everything you need to know. Also, I am sure there are threads here on this site that you can search for. search --> parallel server

- Magnus

Thanks Magnus, I ll do that

Just to tell you.. I am accessing this from netcafe. I dont have access to metalinks. Anyway I am serching for it..

Thanks again

Amol

Quote:

---

Originally posted by julian

Quote:

---

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.

---

Well, since we're talking about world wide affiliated banks here, any banks that don't have world wide affiliation is considered small banks. Now, it's all for you now to identify where your bank belongs.

But if you're going to quote everything that I've said in previous post, you can clearly comprehend that though ORACLE is widely used world wide, BANKING sector is not its forte. That's all what I meant.

To give you a vivid reason why it is not, its implementation of sending and receiving data out from the network is far to slow and bulky compare to the languages that were really design to do such job such as TAL(Transaction Application Language).
It's like a comparison of sending a TEXT messages(Short Messages Services) and sending an e-mail with 1 page which is practically the same message. :-)

TAL uses binary codes to identify and designate kind of transaction, bank were transaction happens, and the transaction itself. In turn it will only form a few bytes to be send to the hosts after it passes its security accessories such as ATALLA. So usually transaction is done in one pass. It will only re-send the transaction back if it fails with its data validation,parity checking(such like).

Now, thus Oracle has this specialization? Please tell me that it has, then I will agree to you that Oracle can also dominate in BANKING sector.
:-)