Explore BrainMass
Share

Ebay database

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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?

© BrainMass Inc. brainmass.com December 19, 2018, 11:31 pm ad1c9bdddf
https://brainmass.com/computer-science/data-clustering/ebay-database-122387

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