Re: Parallel multi-relational collections

On 11 Apr 2005 20:50:52 -0700, "frebe"
<fredrik_bertilsson@xxxxxxxxxxx> wrote:

>Are you never using datasets in any other way but assigning them to GUI
>components?

Assigning them to report generators, for instance.

>Every applications that do something else but map the tables to the
>user interface is a badly designed application?

Every application that enforces business logic is a badly designed
application.

> Maybe you should
>actually do some application development for a change...

I develop applications everyday, and often I am forced to create badly
designed applications.

>> Business logic should be enforced by the DBMS.
>
>A DBMS can't enforce every kind of business logic, unless a programming
>language is built-in the database.

Every DBMS has a programming language. Oracle has PL/SQL, SQL Server
has Transact SQL, etc.

> Are every applications that uses an
>external programming language a bad designed application?

What is an external programming language?

> I think you
>have to accept that there are reasons for not using stored procedures
>for all your application.

Do you mean to not using the DBMS for enforcing business logic?

What reasons?

>
>> With PL-SQL or SQLJ you can manage tables with type safety.
>
>Data-aware compilers decreases the the need for generated table
>classes, because such classes/structures exists by default. In PL/SQL
>for example, you have the rowtype concept, that is a structure type
>corresponding to one table record.

Tables and records are not the same thing.

> In the case of embedded SQL you
>would still need generated record classes. Otherwise the programmer
>would have to declare host variables for every column in a select
>statmenent, with the correct type.

No, you have the column names and the column types stored in the
ResultSetMetaData object.

> If you look in the data division in
>a COBOL program, it is full of record structures.

COBOL!, what an example! :)


Regards
.

Relevant Pages

  • Re: OOP - a question about database access
    ... I meant the DBMS server. ... > It is really practical for presentation applications. ... I consider them only a part of a single database. ... > He consideres SQL DBMSes, OODBMSes, XML file managers and OS file ...
    (comp.object)
  • Re: OOP - a question about database access
    ... a dbms is a system. ... > GUI applications can be viewed as user friendly replacements for the ... >> Only the developer providing the persistence access subsystem or layer ... Everyone knows that abstraction is the key to effective software ...
    (comp.object)
  • Re: choices regarding where to place code - in the database or middle tier
    ... enterprises with worldwide distributed applications in successful service, ... > DBMS, this data needs to appear in the middleware cache at some point, so ... Why cache what is already cached in the DBMS? ...
    (comp.lang.java.databases)
  • Re: choices regarding where to place code - in the database or middle tier
    ... enterprises with worldwide distributed applications in successful service, ... > DBMS, this data needs to appear in the middleware cache at some point, so ... Why cache what is already cached in the DBMS? ...
    (comp.lang.java.programmer)
  • Re: OOP - a question about database access
    ... > application, a DBMS is another application, a data management ... application is an application that handles persistence through a DBMS. ... RAD, as it is currently applied, is only used for pipeline applications ... > The persistence subsystem is a part of the DBMS. ...
    (comp.object)