|
Openness
Thomas Kyte suffers from peoples prejudice against database.
Since devoloppers avoid using databse features even stored
procudures
and sequences.Their reason is They don't want to locking into database.
They (devoloppers) called this technique as openness.
But there is interesting point (by the way i made the same mistake
in my software engineering project) your query may cause deadlock in
one database and work properly in other database(Most probably oracle)
He offers that use database effectively since you pay money for this
and this product has many built in features(exploit them). And he says
you store your data inside your database and you put all your application
data and your security outside of the database.Let's say Your application
logic is on the JSPs or inside Java Beans but newest technology of today
will be tomorrow's old technology.
Fine Grained Access Control (FGAC) ie: it allows the devolopper to embed
procuderes in the database that can modify queries as they are submitted to
the database.This query modification resctrict the rows which are received or
modified by the client.Security controls,answers of the questions who,where
,when running the query are
also good utilities of FGAC.
Shortly he says "You have gold in your bag, please use it.".
|
