| Author |
Need some help for some perl homework....
|
|
|
| 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.
| |
| Matt Garrish 2004-03-18, 6:46 pm |
|
<shlomois@hotmail.com> wrote in message
news:l7T_b.8270$Qg7.5359@news04.bloor.is.net.cable.rogers.com...
> 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
>
Okay, but where's your code and what are you having difficulty with?
Matt
| |
|
| <shlomois@hotmail.com> wrote in message
news:l7T_b.8270$Qg7.5359@news04.bloor.is.net.cable.rogers.com...
> 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
>
[snipped crappy assignement]
find another course
gnari
| |
|
| Xref: kermit alt.perl:26528
We were not given any code, just instructions.
Please HELP ME!!!! Any Ideas where to start?
| |
| Carsten Aulbert 2004-03-18, 6:46 pm |
|
shlomois@hotmail.com wrote:
> We were not given any code, just instructions.
>
> Please HELP ME!!!! Any Ideas where to start?
>
Easy, start at looking at a matching Database module on your computer or
alternatively on cpan.org (modules, section DB)
Then start to write a brief script which simply fetches all available
email addresses and domains and output them to disc/screen.
Well after that start tying them into variables and do what the
assignment asks of you.
When you have a sample code ready and run into problems, come back here
and the might be s/o who is willing to offer you help - but without
seeing any work from your side it is pretty likely that you will fail
the homework and/or the course.
Cheers
CA
| |
| Tintin 2004-03-18, 6:46 pm |
|
<shlomois@hotmail.com> wrote in message
news:AiU_b.9307$Qg7.3407@news04.bloor.is.net.cable.rogers.com...
> We were not given any code, just instructions.
>
> Please HELP ME!!!! Any Ideas where to start?
Start by helping yourself and not expecting other people to do your homework
for you.
| |
| Joe Smith 2004-03-18, 6:46 pm |
| shlomois@hotmail.com wrote:
> I have this question for homework in an intro perl class...
The problem you described is _not_ suitable for an intro to Perl class.
Tell the teacher that professional Perl programmers say that he/she
should to back to the basics, not jump into a hairy DB program.
-Joe
|
|
|
|