Re^2: Computing results through Arrays

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 !!!

Comment on Re^2: Computing results through Arrays

Replies are listed 'Best First'.
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]

Replies are listed 'Best First'.

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]