From: | Paul Ganainm <paulsnewsgroups(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Database of electoral results? |
Date: | 2003-11-07 11:39:14 |
Message-ID: | MPG.1a159468bb537f0e98969b@news.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
This is not so much a question specific to PostgreSQL, but rather a
general "application of theory" type of problem!
I did post this on comp.databases.theory but received no replies there.
If anyone here is interested and this is a suitable forum in the
PostgreSQL hierarchy, that would be great! If this is not a good group,
please point me in the right direction.
The actual election being discussed is neither here nor there, but I
mention it so that people might get a flavour for the issues - I often
find that this can help to get a discussion/flame-war/whatever going!
I am planning a database of the results for the NoI (North of Ireland)
assembly elections.
Background information can be found here
http://www.ark.ac.uk/elections/
For those not used to the STV (Single Transferrable Vote) PR
(Proportional Representation) method used in elections in Ireland or the
NoI (still part of the United Kingdom), all I can suggest is to search
for STV PR on your favourite search engine.
Basically constituencies are multi-seats and voters vote for their
choice in order of preference (1,2,3,4... &c.) and when a person is
elected, their surplus is transferred to still unelected candidates.
It's quite a complex system, and makes for great amateur psephology.
This will be a proper SQL database that will allow for sophisticated
queries about the results.
What I would like to know from this group is:
"Does anybody know of logical and/or data models that have been used in
the past to model election data?" - i.e. Candidate, Constituency,
Party, Election &c. (Sample tables and fields would be nice! 8-);
And,
"Particularly in the case of STV PR elections?":
BTW, I did search in the library of free datamodels here
http://www.databaseanswers.com/data_models/index.htm
and found nothing.
Any URL's, references, discussions, texts, ideas &c. welcome.
Paul...
I did look at
http://bolson.org/voting/essay.html
and
http://www.logicaldatastructures.com/elections.htm
and I don't see much there that I can apply to my particular problem.
--
plinehan__AT__yahoo__DOT__com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-11-07 12:09:00 | Re: SET AUTOCOMMIT OFF |
Previous Message | btober | 2003-11-07 08:49:56 | Re: on connect trigger? |