Need some help for some perl homework....

Discussion in 'Perl' started by Guest, Feb 25, 2004.

  1. Guest

    Guest Guest

    I have this question for homework in an intro perl class, I was hoping for some quick help on this please...here is the question


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

    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.

    Constraints
    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.

    Assumptions
    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.
     
    Guest, Feb 25, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Rhino

    need help with homework

    Rhino, Nov 16, 2003, in forum: Java
    Replies:
    1
    Views:
    321
    Roedy Green
    Nov 16, 2003
  2. Allens Mail

    Need Help On Homework

    Allens Mail, Jul 13, 2003, in forum: C++
    Replies:
    1
    Views:
    387
    Aggro
    Jul 14, 2003
  3. gpdus24
    Replies:
    5
    Views:
    913
    divanshu
    Oct 6, 2006
  4. Mike
    Replies:
    1
    Views:
    342
    Phlip
    Nov 23, 2004
  5. Replies:
    31
    Views:
    334
    David Hutto
    Feb 3, 2014
Loading...

Share This Page