Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^2: Computing results through Arrays

by aaron_baugher (Curate)
on Jun 05, 2015 at 13:18 UTC ( #1129199=note: print w/replies, xml ) Need Help??


in reply to Re: Computing results through Arrays
in thread Computing results through Arrays

I agree that a database could be a good way to store this data, especially if it's going to be mined in various ways. However, if I'm given this file as-is and told to produce the reports specified by the OP, I'm not going to go to the trouble to put it in a database so that I can run SQL statements on it. I can write a script to get it directly in far less time, so a database will only become an advantage if I need to pull reports from it in several different ways. (And I already know SQL; the newbie would have to learn a second language first.)

Aaron B.
Available for small or large Perl jobs and *nix system administration; see my home node.

Replies are listed 'Best First'.
Re^3: Computing results through Arrays
by Laurent_R (Canon) on Jun 05, 2015 at 13:41 UTC
    aaron_baugher:
    I agree that a database could be a good way to store this data, especially if it's going to be mined in various ways. However, if I'm given this file as-is and told to produce the reports specified by the OP, I'm not going to go to the trouble to put it in a database so that I can run SQL statements on it. I can write a script to get it directly in far less time, so a database will only become an advantage if I need to pull reports from it in several different ways.
    I agree with every single word of what you say, Aaron.

    To me, using a database is overkill for such a simple problem. I would certainly not do that unless there are some other very good reasons to do it.

Re^3: Computing results through Arrays
by GotToBTru (Prior) on Jun 05, 2015 at 13:24 UTC

    Yeah. That's why my reply is a good third reply. As long as the scope of the problem stays this small and this specific, no need to bring out the big guns. In case it won't ... the sooner he learns databases and SQL, the better.

    Dum Spiro Spero

      Fair enough, DBI/SQL is certainly a good extra skill for a Perl programmer to have. I just don't want to overwhelm a guy who hasn't shown any Perl skills yet. This wouldn't exactly be trivial SQL, either, since it would require a combination of SUM, SUBSTR, and GROUP BY, at least.

      Aaron B.
      Available for small or large Perl jobs and *nix system administration; see my home node.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1129199]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (6)
As of 2020-06-04 18:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you really want to know if there is extraterrestrial life?



    Results (35 votes). Check out past polls.

    Notices?