Re: Computing results through Arrays

Replies are listed 'Best First'.
Re^2: Computing results through Arrays by aaron_baugher (Curate) on Jun 05, 2015 at 13:18 UTC
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.	[reply]
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.	[reply]
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	[reply]
Re^4: Computing results through Arrays by aaron_baugher (Curate) on Jun 05, 2015 at 14:17 UTC
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.	[reply]
Re^2: Computing results through Arrays by yasser8@gmail.com (Novice) on Jun 05, 2015 at 17:39 UTC
Actually I am working DBA for more than 12 Years, I can meet this requirement in no time if this was in SQL. But unfortunately these data are pulled from Oracle Exadata Storage servers and I don't want to store it in Production databases which are purely meant for storing Customer Data. This is why I am striving very hard to learn perl from experts like you guys...one good thing I notice in perl world is, perl experts are very helpful in nature. Thanks a lot for helping beginners like me !!!	[reply]
Re^3: Computing results through Arrays by afoken (Chancellor) on Jun 06, 2015 at 10:40 UTC
these data are pulled from Oracle Exadata Storage servers and I don't want to store it in Production databases which are purely meant for storing Customer Data. Use SQLite or a local PostgreSQL. Both are free as in speech and free as in beer, and both are supported by DBI: DBD::SQLite, DBD::Pg. Note that DBD::SQLite already includes the database engine (SQLite), so after `cpan DBD::SQLite`, you can start using SQLite without installing anything else. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply] [d/l]