Database Efficiency?

All off topic discussions go here. Everything from the funny thing your cat did to your favorite tv shows. Non-programming computer questions are ok too.
Post Reply
pcmattman
Member
Member
Posts: 2566
Joined: Sun Jan 14, 2007 9:15 pm
Libera.chat IRC: miselin
Location: Sydney, Australia (I come from a land down under!)
Contact:

Database Efficiency?

Post by pcmattman »

Does anyone here remember the equation for database efficiency? I know it's something like Efficiency = Data / Time or something like that.
Tyler
Member
Member
Posts: 514
Joined: Tue Nov 07, 2006 7:37 am
Location: York, England

Post by Tyler »

Depends what action your talking about it really?
pcmattman
Member
Member
Posts: 2566
Joined: Sun Jan 14, 2007 9:15 pm
Libera.chat IRC: miselin
Location: Sydney, Australia (I come from a land down under!)
Contact:

Post by pcmattman »

Well for a database system where the user is searching the database for data...

It's a project for school, we're doing expert systems and I want to throw in the database efficiency equation to justify several (seemingly pointless) parts of the system's design.
Tyler
Member
Member
Posts: 514
Joined: Tue Nov 07, 2006 7:37 am
Location: York, England

Post by Tyler »

Then yeah Search Efficiency can be expressed as such. If you are testing numerous algorithms against each other i would use a system where by all data in the system is searched for and average times per search are correlated.
User avatar
Solar
Member
Member
Posts: 7615
Joined: Thu Nov 16, 2006 12:01 pm
Location: Germany
Contact:

Post by Solar »

Efficiency is in the eye of the beholder. Or: Database efficiency is whatever the marketing department claims it to be. 8)

Perhaps, for a given application, absolute search-time is crucial. Another app might require that search time scales well for huge databases. Another app might require that search time scales well for concurrency. Another app might require all three.

And that is not taking into account storage efficiency, reliability etc...
Every good solution is obvious once you've found it.
Post Reply