...

View Full Version : How do they do it?



rr299
03-29-2007, 12:25 PM
Hi, just wanted someone to explain this to me. I am pretty new to php and mysql so excuse me if it's a silly question.
Ok well i know how to set up a database using php and mysql so a user can look at a variety of products. At the moment I only do this with a few products so it is quite simple. What is i had 1000s of products? Do i have to sit and enter all this data into a database?! How do big websites (such as amazon) go about keeping there stock levels up to date?
Thanks

Acid
03-29-2007, 01:28 PM
Keep in mind that while MySQL is a very good database system, professional companies that store client data tend to go with more corporate solutions like Oracle, Access or perhaps MSSQL and probably do database integration with other hardware devices.

For example think of online banking, you go to an ATM and withdraw some cash, you check your online banking to see that money has left your account because the client data will either be accessed by multiple devices or they'll have some form of synchronisation going on.

Although even if they updated these manully through an admin interface keep in mind that Amazon probably employs a lot of people for this task.

ronaldb66
03-29-2007, 01:35 PM
Do i have to sit and enter all this data into a database?!
Er... basically, yes. Any data that is to be pulled from a table to be shown dynamically on a page has to be present in that table in the first place.

As Acid indictated, large companies that have numerous entries in their databases employ lots of people to maintain the data, likely supported by applications to make their lives a bit easier.

CFMaBiSmAd
03-29-2007, 02:31 PM
How do big websites (such as amazon) go about keeping there stock levels up to date?When stock is received, it is scanned (barcode/RFID) into the database and when items are pulled to be shipped, they are scanned again to subtract the quantity from the database. However, as we all know humans are not perfect and you also need to regularly (frequency dependent on how critical an absolute accurate count is) perform an inventory count to reconcile actual stock on hand with the quantity indicated in the database.

oracleguy
03-29-2007, 10:28 PM
Keep in mind that while MySQL is a very good database system, professional companies that store client data tend to go with more corporate solutions like Oracle, Access or perhaps MSSQL and probably do database integration with other hardware devices.

I wouldn't quite put Access in the same regards as the other two because compared to those products, its substantially inferior. And while MySQL can be used by anyone for free, it is still an enterprise product. Just look at all the big organizations that use it: http://www.mysql.com/customers/

Acid
03-30-2007, 12:07 PM
Oh yeah granted, I just used Access as another example because ive noticed it being used for corporate solutions whereas MySQL doesn't seem to be quite as common even though IMO it was way better than Access.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum