RE: RDMS Database's and/or Record Managers
Euman wrote:
> You all know I wrote the tsunami record manager wrappers and I want to=
=20
> share somethings and get some kind of feedback.
Without spending much time responding I'll reply with the following=20
points.=20=20
I feel like you=92re trying to convince people that record managers=20
are a powerful tool (which is fine) but I don=92t believe you are=20
giving people the full picture of what RDBMS can do.=20
Databases also contain mechanisms for:
* security,=20
* external access to the data through 3rd party tools (like ODBC),
* powerful backup and restore features,
* stores procedures and triggers,=20
* referential integrity,
* transaction support,
* views,
* some provide data replication and distribution,
* and probably more things that I've never used (I'm not a big RDBMS=20
user)
The Pros for RDBMS =85
A good RDBMS is "almost" always required for large and complex=20
projects.=20=20
When you have 500 or 1,000 tables and 20,000 programs it can be=20
difficult to track down how an invoice number got deleted when it=20
shouldn't have.=20=20
Transaction support and good database design ensure data integrity=20
Data Security (from an application view point) can be guaranteed and=20
a misbehaving program can=92t accidentally revel or corrupt data that=20
it shouldn=92t.
Programming complex queries and updates can be done very easily with=20
SQL (saving programmer time and reducing the possibility of errors).
=20
The Cons for RDBMS =85
RDBMS are almost always are more difficult to setup and administer.
RDBMS require more processing power.
Like all things in IT (and life) there are many ways to do achieve=20
the same goal and you should always try and use the best tool for=20
the job.
In general (90% of all generalisations are incorrect!) =85
Smaller applications with fewer users =93can=94 use record managers=20
happily.
Larger more complex applications with more users tend to use RDBMS.
For smaller applications I personally prefer tools like SQLite which act=
=20
as a compromise between the two.=20
Regards,
Ray Smith
http://rays-web.com
|
Not Categorized, Please Help
|
|
