Re: just say NO to inline SQL

frebe wrote:
external forces. But there are not really any need for putting simple
inserts and updates inside procedures because some DBA expert should
be able to modify them without having to recompile your application.

If an application's insert, select, update, and delete (ISUD) statements are actually very simple (especially the I, U and D) then the database hasn't been elevated over anything more valuable than a simple data store. If there are no smarts given to the database then beyond its tables it has no semantic value to the application. If thought of as little more than a structure composed of ordered collections then that's all it can ever be, and in place of get()ters and set()ters programmers use SQL for get()ting and set()ting.

In this approach all the business logic, except its data model, exists outside the database requiring every logic change to necessarily change the application.

If instead the database is more than just the data model and actually knows how to checkout a book, increase inventory, move collateral, or validate and edit-check other actions, then it becomes more valuable to its customers (programmers and applications). The /how/ of state changes can be modified independently of their /why/. This is how one service/object can _tell_ another service/object to do something without knowing _how_ to do it.

--
Visit <http://blogs.instreamfinancial.com/anything.php> to read my rants on technology and the finance industry.
.

Relevant Pages

  • Re: 3vl 2vl and NULL
    ... reporting, MV end-users were either churning out reports and ad hoc ... MV-database-independent applications as often as they do in the SQL ... where I cannot leave MV behind unless I can find a better data model. ... screen to be identical to the logical data model of the database. ...
    (comp.databases.theory)
  • Re: Value ...
    ... I actually use Pick-Like ... > quicker than others because my data model is better. ... What i need is the posibility to use any of them with my database. ... hey Uncle Bossman can even swipe his mouse and import it into Excel!!! ...
    (comp.databases.pick)
  • some ideas about db rheory
    ... The database records not only the ... What I have done is a data model, in which time is not in a “record ... Above mentioned technical solutions can have troubles in real world ... identifier of a state. ...
    (comp.databases.theory)
  • Re: Guidelines to a decent support of surrogate key implementation
    ... totally unrelated to the logical data model. ... A surrogate key is system generated to replace the actual key ... with a quote from Dr. Codd: ... Extending the database relational model to capture more meaning. ...
    (comp.databases.theory)
  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)