Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Need some help for some perl homework....

Thread Tools

Need some help for some perl homework....

Posts: n/a
I have this question for homework in an intro perl class, I was hoping for some quick help on this is the question

Using the Perl programming language, please prepare the following script:

Given a table 'mailer' that has a column:
emailaddr varchar(255)

Create a new table to hold a count of email addresses by their domain name limited to those domains that have at least 100 addresses in the list and add a set of rows on a daily basis

Then report on this table for the last 4 months the top 25 domains showing their counts.

do not use the database for processing only use Perl for this ( ie, group by )
a table is to be generated, not a report. There is no date field provided in the initial mailing table.

there are 5,000,000 "email addresses" and 200,000 domains. Please make the script as efficient as possible with this in mind.
the adding of new rows on a daily basis means going through the mailing table which is also updated daily and updating the count or adding new rows for a domain that now has 100 or more count. The purpose is this to trend analysis of domain growth.

Reply With Quote

Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
need help in perl arrays (New to perl but know TCL well) Anil A Kumar Perl Misc 2 08-03-2011 12:40 PM
FAQ 1.4 What are Perl 4, Perl 5, or Perl 6? PerlFAQ Server Perl Misc 0 02-27-2011 11:00 PM
FAQ 2.17 What is Perl Mongers? PerlFAQ Server Perl Misc 0 02-03-2011 11:00 AM
FAQ 1.4 What are Perl 4, Perl 5, or Perl 6? PerlFAQ Server Perl Misc 0 01-23-2011 05:00 AM
Perl Help - Windows Perl script accessing a Unix perl Script dpackwood Perl 3 09-30-2003 02:56 AM