UNIX sql options | Unix Linux Forums | UNIX for Dummies Questions & Answers

  Go Back    


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

UNIX sql options

UNIX for Dummies Questions & Answers


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 08-13-2013
sas sas is offline
Registered User
 
Join Date: Aug 2013
Last Activity: 29 December 2013, 8:21 AM EST
Posts: 30
Thanks: 3
Thanked 0 Times in 0 Posts
UNIX sql options

New to the unix experience and sure love it.

I do all my big sql queries using unix sas, it's great, can't complain. Also have isql on the box to work with Sybase db's if need be.

Just wondering if there's any large-amt-of-data-folks round here that might suggest some other sql/data tools you use on unix? I know really vague question. I'm taking a liking to using unix sas and python to solve lots'a large-data-initiatives. Just wondering if there is some kind'a magic-unix-bin that I've never heard of that you'd be stunned I'm not leveraging. Solaris fyi....

Have a great one
Sponsored Links
    #2  
Old 08-14-2013
vbe's Avatar
vbe vbe is offline Forum Staff  
Moderator
 
Join Date: Sep 2005
Last Activity: 23 October 2014, 4:40 AM EDT
Location: Switzerland - GE
Posts: 5,834
Thanks: 162
Thanked 414 Times in 389 Posts
well SAS is not standard unix tools but a powerfull $$ software, I happen to use it in cases where other unix tools fail... (e.g. mainrame files in impossible format containing binary and photos in the file... with file size around 40GB...) I suppose all people using oracle are happy with SQLplus and plSQL..., I suppose you could have a look at what mysql and postgress offer...
Sponsored Links
    #3  
Old 08-16-2013
sas sas is offline
Registered User
 
Join Date: Aug 2013
Last Activity: 29 December 2013, 8:21 AM EST
Posts: 30
Thanks: 3
Thanked 0 Times in 0 Posts
Thanks vbe! Yeah I've the db side covered and can use native tools on the db side (isql, sqlplus, etc to write tsql or pl/sql).

Just looking for thinking-outside-of-the-box when it comes to all these millions of records, analytics, patterns, unatructured text mining, etc

Seems python is a good oop to handle some of this. Finally got my book from the library re python and the day off to read it

SAS Unix handles most of what I need but I just want to make sure I'm not missing something in unix that I've never considered that might be as magic as sas and python. They seem like peas and carrots together!

Happy Friday all!
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Format options while Redirecting output of sql to a file in shell qwertyu Shell Programming and Scripting 7 12-17-2012 01:40 AM
What are the career options in unix apart from unix system administration? thulasidharan2k UNIX for Dummies Questions & Answers 2 06-09-2011 07:53 PM
How to use sql data file in unix csv file as input to an sql query from shell Nareshp Shell Programming and Scripting 2 11-09-2009 01:15 AM
Execute PL/SQL function from Unix script (.sql file) reptile UNIX for Dummies Questions & Answers 1 05-14-2009 07:40 AM
unix variables from sql / pl/sql djehres Shell Programming and Scripting 2 05-07-2009 10:38 AM



All times are GMT -4. The time now is 11:48 AM.