One day, my coleauge and I had a simple debate about a database termilogogy, 'live'. I said that a live database is the original one, not the backup. But he wants to add that it must be used by everyone to be live.
As a background, our company got lots of databases stored and handled by MySQL Server. They usually use VB 6 to process them. But I, being their intranet programmer, set-up a MySQL to locally to their intranet server, to store transactions that is of the site's use, such as guestbooks, birthdays, and techical support. I backup this db twice a week.
In view of all these, I insists that my MySQL database is live. Am i correct? or he is?
It's alive!
Moderator: General Moderators
- harrisonad
- Forum Contributor
- Posts: 288
- Joined: Fri Oct 15, 2004 4:58 am
- Location: Philippines
- Contact:
I consider a live database to be the one that is used by the target audience. If I've got a development database that is a duplicate of a database used to run a website, then I would consider the database running the website to be the 'live' copy.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Live
My definition of a Live DB is one which gets used by the users….
Directly or indirectly (via web interface, etc)
It does have to be in use, and must not be the backup,
but it does not have to be used bay all the users
(think of a distributed environment).
The data that is stored in the DB may help determine this…
Is the data test data or data duplicated exactly from another DB?
If so then it is not live!
It seems that the actual site in use, stores info into your DB directly.
If this is the case, then yours is a Live DB. Else, it is a backup DB.
Hope that helped
Directly or indirectly (via web interface, etc)
It does have to be in use, and must not be the backup,
but it does not have to be used bay all the users
(think of a distributed environment).
Is the data test data or data duplicated exactly from another DB?
If so then it is not live!
It seems that the actual site in use, stores info into your DB directly.
If this is the case, then yours is a Live DB. Else, it is a backup DB.
Hope that helped
- harrisonad
- Forum Contributor
- Posts: 288
- Joined: Fri Oct 15, 2004 4:58 am
- Location: Philippines
- Contact: