Share
Explore BrainMass

Ebay database

Though there is great risk in implementing a database in this fashion Ebay gained an extreme performance boost because the database didn't have to work as hard to ensure that the data "conformed."

So my question is, if the database does not have referential integrity to keep the data clean, how does Ebay ensure that the data is accurately stored? Do you think that most companies would need this type of implementation? Why?

Solution Preview

Ebay database does not have referential integrity.
--------------------------------------------------------------------------------
Though there is great risk in implementing a database in this fashion Ebay gained an extreme performance boost because the database didn't have to work as hard to ensure that the data "conformed."

So my question is, if the database does not have referential integrity to keep the data clean, how does Ebay ensure that the data is accurately stored? Do you think that most companies would need this type of implementation? Why?

Answer:
So my question is, if the database does not have referential integrity to keep the data clean, how does Ebay ensure that the data is accurately stored?

Basically eBay uses massive Oracle Database. They demonstrate their divide-and conquer approach for a system with over 20 billion transactions per day:
EBay does not employ referential integrity because ...

Solution Summary

Ebay database is discussed.

$2.19