dbTalk Databases Forums  

SQL or SAS or Neither?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss SQL or SAS or Neither? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robert
 
Posts: n/a

Default SQL or SAS or Neither? - 11-20-2007 , 12:41 PM







The technical and logical challenges of data preparation and data
transformation can differ greatly from project to project. Also, data
transformation is quite a separate challenge from database management.

A pragmatic approach requires more than one data manipulation
programming language.

If the logical complexity of the required data transformations is not
too high, a GUI-oriented application may be best. However, for complex
data transformations, a graphical user interface can be inflexible and
can get in the way.

SQL works quite well with some data transformations, and can be
cumbersome for others. The SAS datastep is a better choice for many
types of transformations, but for a many-to-many join, for example,
SQL is a better fit. A software development language choice ( Perl,
C ) usually requires more development time and maintenance than a
specialized tool.

Reply With Quote
  #2  
Old   
Mark D Powell
 
Posts: n/a

Default Re: SQL or SAS or Neither? - 11-20-2007 , 03:51 PM






On Nov 20, 1:41 pm, Robert <irishhac... (AT) gmail (DOT) com> wrote:
Quote:
The technical and logical challenges of data preparation and data
transformation can differ greatly from project to project. Also, data
transformation is quite a separate challenge from database management.

A pragmatic approach requires more than one data manipulation
programming language.

If the logical complexity of the required data transformations is not
too high, a GUI-oriented application may be best. However, for complex
data transformations, a graphical user interface can be inflexible and
can get in the way.

SQL works quite well with some data transformations, and can be
cumbersome for others. The SAS datastep is a better choice for many
types of transformations, but for a many-to-many join, for example,
SQL is a better fit. A software development language choice ( Perl,
C ) usually requires more development time and maintenance than a
specialized tool.
Should this post have been attached to
http://groups.google.com/group/comp....9c1c5c7b0bb947
?

-- Mark D Powell --


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.