|
Are You a Database Guru? -- A Request for Volunteers |
|
Saturday, February 02 2008 @ 08:40 AM EST
|
Here's something a little different for us, but although unusual, I thought it was worth telling you about. We are, after all, a community here, and a Groklaw member, arnotsmith, wrote to me because he is urgently looking for a volunteer or volunteers to help him with quickly setting up a database. He's been unable to find anything to suit, and he wondered if you guys might be able to help him. I said I didn't know for sure, but I thought probably you brainiacs could probably steer him in the right direction at least. Some of you may know of a solution that already exists, and if not, maybe someone will want to lend a hand and code up a solution.
It's for a project the Kenya National Commission for Human Rights in Nairobi is doing to document and analyze the current post-election violence there. But I'll let him tell you about it himself.
Here is his request, and because of the time frame, I'm putting it up as he sends it:
I have an urgent problem which is more-or-less On Topic for Groklaw, and I wonder if there are people out there who can help us.
As you probably know, following the Kenyan presidential elections last December, there has been widespread violence in the country, after the announcement that President Kibaki had won the election, despite numerous reports of election irregularities, primarily related to the tallying of votes.
This violence has resulted in the reported killings of hundreds and displacement of thousands of people, who have apparently been targeted for belonging to ethnic communities perceived to be affiliated with specific political parties, and in the reported shooting to death of unarmed demonstrators by security forces. The violence seems to be characterised in four broad categories: organised militia activity in various locations; disorganised protest and violence; disproportionate use of force by the Kenya security forces; and retributive communal actions.
I have been called in by a NGO called "No Peace Without Justice" who themselves have been called in by the Kenya National Commission for Human Rights here in Nairobi to assist them in analysing the current post-election violence.
The aim is to go into the field and collect witness reports and to analyse these along with open source documents (newspapers, etc.). My task is to select a database and set it up for our requirements.
Unfortunately, we have been unable to find anything that is reasonably user friendly and which is focussed on the data patterns we are interested in.
We have a good idea of what tables, queries and forms we need, but there is no way that we can get a proper working system going in the time available with our current resources. I would be working (reluctantly) in Microsoft Access, but if there are people out there who could use our preferred Open Office Base and MySQL, so much the better.
Time scale? Well, people are going into the field next week, and the Commission has committed to a preliminary report in two months.
The bravery, committment and expertise of the Commission and their staff are humbling. They are a fiercly independent public body, and they find themselves between two fires: both the opposition and the government do not particularly like them, and this work - looking at the political violence of both sides of the divide - is not making them any friends. In addition, as a public body, they are having difficulties raising new funds for their work, as international donors have frozen contribution to state (public) bodies so things are really tight.
Are there any database experts in the Groklaw diaspora would be able to help us? Yes, he knows it's asking a lot. If you can lend a hand, let me know and I'll forward your email to him. No pressure though. Only if you want to. To evaluate what he needs, here's what he says he envisons it as being like:
********************************
This would be a list of tables and their fields, and a description of
user interactions. Anyway, here goes - all
written as for MS Access:
Firstly, the data tables:
Table tblReport (for the initial input of the witness interview report)
Field ReportID - AutoNumber
Field Source - Number (identifying whether a witness or an open
source document)
Field Reliability - Number (selecting from a table Low/Medium/High etc)
Field InterviewerID - Number (link to interviewer's Person record)
Field CollatorID - Number (link to collator's record)
Field DateReported - Date/Time (when the interview took place)
Field StartDate - Date/Time (start of period covered by the interview)
Field EndDate - Date/Time (end of period covered by the interview)
Field Transcript - Memo (full text of the interview)
Field DocumentRef - Number (link to the scanned document)
Table tblPerson (listing all persons or groups referred to)
Field PersonID - AutoNumber
Field PerTypID - Number (link to table of "person" types -
individual, group, etc.)
Field FamilyName - Text
Field OtherNames - Text
Field EthnicityID - Number (link to ethnicity table)
Field SexID - Number (link to gender table)
Field MemberOf - Number (link to a relevant group in tblPerson)
Field Age - Number
Field CurrentLocation - Number (link to a location table)
Field CurrentAddress - Text
Field HomeLocation - Number (link to location table)
Field HomeAddress - Text
Table tblEvent (a record for each event extracted from the reports -
multiple reports may refer to one event)
Field EventID - AutoNumber
Field TypeID - Number (link to table of event types)
Field ReliabilityID - Number (link to reliability table)
Field StartDate - Date/Time
Field EndDate - Date/Time
Field Location - Number (link to location table)
Field Comments - Memo
Table tblDocuments (index of all scanned documents)
Field DocumentID - AutoNumber
Field Reliability - Number (link to reliability table)
Field Reference - Text (title or description of document)
Field ScanURL - Text (pointer to the scan file)
Now for the lookup tables:
Table tlkpActs (list of acts a perpetrator may commit)
Field ActID - AutoNumber
Field ActName - Text
Table tlkpDistrict (list of administrative Districts in Kenya)
Field DistID - AutoNumber
Field ProvID - Number (link to administrative Province)
Field District - Text
Table tlkpDivision (list of administrative Divisions in Kenya)
Field DivID - AutoNumber
Field DistID - Number (link to administrative District)
Field Division - Text
Table tlkpEthnicity (list of ethnic groups)
Field EthID - AutoNumber
Field EthnicGroup - Text
Table tlkpEventType (list of types of events)
Field TypeID - AutoNumber
Field EventType - Text
Table tlkpLocation (list of locations (towns and villages) in Kenya)
Field LocID - AutoNumber
Field DivID - Number (link to administrative Division)
Field Location - Text
Table tlkpPersonType (list of "person" types)
Field PerTypID - AutoNumber
Field PersonType - Text
Table tlkpProvince (list of Provinces in Kenya)
Field ProvID - AutoNumber
Field Province - Text
Table tlkpSource (list of source types)
Field SourceID - AutoNumber
Field SourceType - Text
Table tlkpSubLocation (list of sub-locations) (this may not be necessary)
Field SubLID - AutoNumber
Field LocID - Number (link to location)
Field SubLocation - Text
Table tlkpWeapons (list of weapon type)
Field WeapID - AutoNumber
Field Weapon - Text
Now the link tables:
Table tlnkEventPerp (link between an event and a perpetrator "person")
Field EP-ID - AutoNumber
Field EventID - Number (link to an event record)
Field PersonID - Number (link to a person record)
Table tlnkEventVictim (link between an event and a victim "person")
Field EV-ID - AutoNumber
Field EventID - Number (link to an event record)
Field PersonID - Number (link to a person record)
Table tlnkEventDocs (link between an event and a document)
Field ED-ID - AutoNumber
Field EventID - Number (link to an event record)
Field DocID - Number (link to a document record)
Table tlnkEventReport (link between an event and a report)
Field ER-ID - AutoNumber
Field EventID - Number (link to an event record)
Field ReportID - Number (link to a report record)
Table tlnkEventWeapons (link between an event and a weapon)
Field EW-ID - AutoNumber
Field EventID - Number (link to an event record)
Field WeaponID - Number (link to a weapon type)
Table tlnkReportDocs (link between a report and a document)
Field RD-ID - AutoNumber
Field ReportID - Number (link to an event record)
Field DocumentID - Number (link to a person record)
Table tlnkRepRep (link between a report and another report)
Field RR-ID - AutoNumber
Field ReportID - Number (link to an report record)
Field OtherID - Number (link to a related report record)
Now for a functional description of the system:
The home page should display buttons to access each of the four primary data tables and the KNCHR logo.
The input form for each of the four primary tables should open in separate pages - simultaneously if required. They should allow for viewing or editing existing records, or the entry of new records. I don't believe that more fields are needed - at least initially - as the look-up tables can be loaded manually.
The Report page should have provision to create links between the currently open report and a document. A scrollable window should display existing linked documents, and a drop-down box will display all documents for addition to the linked set. This will create a new record in the tlnkReportDocs table. There needs to be provision for removing a link. There needs to be a button to bring up the document entry form if the required document turns out to be not present.
Similar requirements apply to all the other links: Event-Perpetrator Person, Event-Victim Person, Event-Report, Event-Document, Report-Document, Event-Weapons, Report-Report, and Person-Group (now there's a link table I missed out on).
Table tlnkPersonGroup (link between a person and a group "person")
Field PP-ID - AutoNumber
Field PersonID - Number (link to a person record)
Field GroupID - Number (link to a person record for a group)
All fields using look-up tables should display a drop-down box. The last entry in each look-up table will be "Other" for when the required entry is not present, with the operator noting the required entry on a clip-board and making a note in the text field for the record - unless someone can dream up a tidy way of adding the missing entry to the look-up table and flagging it for review.
I think that covers the data-entry side - the next episode covers the search and analysis phase.
Now for the search and analysis functions:
After discussions about analysis, we find there are some bits missing:
An extra field (ActID) is required in tblEvent:
Table tblEvent (a record for each event extracted from the reports - multiple reports may refer to one event)
Field EventID - AutoNumber
Field TypeID - Number (link to table of event types)
Field ActID - Number (link to table of event actions)
Field ReliabilityID - Number (link to reliability table)
Field StartDate - Date/Time
Field EndDate - Date/Time
Field Location - Number (link to location table)
Field Comments - Memo
Two new look-up tables are needed:
Table tlkpComms (list of communications type)
Field CommsID - AutoNumber
Field Communication - Text
Table tlkpVehicles (list of vehicle type)
Field VehID - AutoNumber
Field Vehicle - Text
Three new links are required from the Event table:
Table tlnkIntevenor (link between an event and an intervening "person")
Field EV-ID - AutoNumber
Field EventID - Number (link to an event record)
Field PersonID - Number (link to a person record)
Table tlnkEventVehicle (link between an event and a vehicle)
Field EVh-ID - AutoNumber
Field EventID - Number (link to an event record)
Field VehicleID - Number (link to a vehicle record)
Table tlnkEventComms (link between an event and a document)
Field EC-ID - AutoNumber
Field EventID - Number (link to an event record)
Field CommsID - Number (link to a communications record)
|
|
Authored by: feldegast on Saturday, February 02 2008 @ 08:45 AM EST |
So they can be fixed
---
IANAL
My posts are ©2004-2008 and released under the Creative Commons License
Attribution-Noncommercial 2.0
P.J. has permission for commercial use.[ Reply to This | # ]
|
|
Authored by: bbaston on Saturday, February 02 2008 @ 09:21 AM EST |
with HTML links would be nice. --- IMBW, IANAL2, IMHO, IAVO
imaybewrong, iamnotalawyertoo, inmyhumbleopinion, iamveryold [ Reply to This | # ]
|
|
Authored by: Aladdin Sane on Saturday, February 02 2008 @ 09:23 AM EST |
Discuss Groklaw's News Picks here.
Please say which News Pick you are
commenting on.
--- Form follows function [ Reply to This | # ]
|
- SCO Shutting Down New Jersey, Layoffs? - Authored by: Anonymous on Saturday, February 02 2008 @ 10:24 AM EST
- SCO Shutting Down New Jersey, Layoffs? - Authored by: Anonymous on Saturday, February 02 2008 @ 10:36 AM EST
- SCO Shutting Down New Jersey, Layoffs? - Authored by: John Hasler on Saturday, February 02 2008 @ 11:29 AM EST
- SCO Shutting Down New Jersey, Layoffs? - Authored by: Anonymous on Saturday, February 02 2008 @ 03:29 PM EST
- SCO Shutting Down New Jersey, Layoffs? - Authored by: JamesK on Saturday, February 02 2008 @ 03:54 PM EST
- SCO Shutting Down New Jersey, Layoffs? - Authored by: Peter H. Salus on Sunday, February 03 2008 @ 10:11 AM EST
- If you don't like it, fork it - Authored by: oro_meister on Saturday, February 02 2008 @ 11:46 AM EST
- The XO Laptop: It's the Software, Stupid - Authored by: Aladdin Sane on Sunday, February 03 2008 @ 07:16 PM EST
|
Authored by: drakaan on Saturday, February 02 2008 @ 09:31 AM EST |
It wasn't specified...should we assume that this is a client-server application,
with people in the field using a web interface to the input forms that place
data in a central database? You mentioned MS Access and Open Office Base
before, so it was unclear whether each investigator had a separate copy of the
database (to be merged later), or whether there was a single database.
I'd imagine mobile network connectivity will be difficult, so I was guessing the
second option applied, but that would make a difference as far as design goes.
---
'Murphy was an optimist'
-O'Toole's Commentary on Murphy's Law[ Reply to This | # ]
|
|
Authored by: Anonymous on Saturday, February 02 2008 @ 09:45 AM EST |
I'll volunteer ...
Experienced in production commercial environments using Oracle, Sybase,
Informix, DB2, PostgreSQL.
Experienced in production commercial environments using PHP, PERL, C/C++, Java,
HTML, JSP.
Experienced in production commercial environments using Apache and Tomcat.
Experienced in production commercial environments using bash, ksh and csh.
Experienced in production commercial environments using OpenOfffice.org (write,
impress, draw, calc, and base.)
----
I have much more experience than what I've listed here, such as MS-Access and
SQL*Server, but this is what I would prefer to work with.
email me at: shotgun1635 at yahoo period com.[ Reply to This | # ]
|
|
Authored by: ThrPilgrim on Saturday, February 02 2008 @ 09:49 AM EST |
I'm wondering if any Catalyst gurus are out there.
I'll forward this on to various Perl programmers I know[ Reply to This | # ]
|
|
Authored by: aiban on Saturday, February 02 2008 @ 10:17 AM EST |
Please include the reason you think it would be a good platform. Perhaps there
are already existing projects that can be leveraged?
Some general requirements to remember in your proposals (please correct me if I
am wrong):
1) Paper field reports will come into one central office and be transcribed by
multiple individuals at that office
2) Already entered records must be easily editable
Maybe at some point someone should open up a Sourceforge project?[ Reply to This | # ]
|
|
Authored by: schnuffle on Saturday, February 02 2008 @ 11:30 AM EST |
Sorry for the double post but the first went to the wrong place :-).
his request sounds like it is the optimal scenario for one of the new
Web-Frameworks.
I personally just program a database driven app in Django and most of the
requested features just are available by only defining the data model.
Of course there needs to be done some template hacking and other adjusting but
a
prototype could be deployed quite fast.
My time is more than scheduled already so I can't volunnteer myself but my
impression of the django community is quite good and maybe you should forward
the request to the community.
Have fun
Marc[ Reply to This | # ]
|
|
Authored by: Anonymous on Saturday, February 02 2008 @ 11:35 AM EST |
http://www.martus.org/
The problem is not just a database, but security, protection, etc.
So use Martus, which is a human rights abuse tracking database which is
specifically designed to address these problems.
[ Reply to This | # ]
|
|
Authored by: Anonymous on Saturday, February 02 2008 @ 11:39 AM EST |
It appears your application is well suited for use with PostgreSQL and phpPgAdmin and Postgres Forms. You will
obviously need a working computer, either Linux or Microsoft Windows will do,
and a webserver and so forth. Given your time constrains you will also need
help. Fortunately, at least if you use Linux, administration can easily be
performed over the Internet so people everywhere could help.
One
advantage of this sort of solution is that it's network accessible
(client/server), operating system neutral (on both the client and server side),
and it scales.
There are similar tools for MySQL, but I tend to prefer
PostgreSQL for its reliability and its history of support for data
integrity.
Karl O. Pinc <kop@meme.com> [ Reply to This | # ]
|
|
Authored by: perezda on Saturday, February 02 2008 @ 12:54 PM EST |
I know a bit about databases, and dabble in Perl, PHP, Python, Ruby, Linux, and
I'm a fan of everything Open Source (well almost...)
I can lend a hand, but not this weekend. You can reach me at perezda 'at' yahoo
. com.
Also, I think we definitely need to know more about the machines on the ground,
and the connectivity before throwing designs around...
A 5 second look at Martus makes me think that might be promising... no need to
re-invent the wheel if we can adapt it to the purpose. Might be other options
out there as well.
Dan[ Reply to This | # ]
|
|
Authored by: proceng on Saturday, February 02 2008 @ 01:14 PM EST |
Perhaps you should start out with the data coming in and the resultant output
desired. With a cursory check of the information given, I see multiple tables
that could/should(?) be combined (ie: victim/perpetrator should be one table
with a field defining which - this would ease reporting as to all involved with
a particular incident).
The relationships of information should also be
established (direct witness/"as reported to"/anecdotal, etc).
The database
tables should be set up in such a way that a one to many relationship can easily
be established (ie: victim(s) records can only be entered against an existing
incident report).
Perhaps others (in addition to myself) with experience
with law enforcement data capture can provide information.
PJ - feel free to
pass on my email --- And ye shall know the truth, and the truth shall make
you free.
John 8:32(King James Version) [ Reply to This | # ]
|
|
Authored by: Anonymous on Saturday, February 02 2008 @ 01:50 PM EST |
Two suggestions.
-
Could they just use a wiki like wikidot.com to
collect data?
wikidot.com allows setting up areas with authorization-required
(login). It's not clear whether the interviews should be publicly accessible or
not
Copy-and-paste a template.
That should allow collection. Analysis would be
a separate step.
- Look at dabbledb.com
[ Reply to This | # ]
|
|
Authored by: Anonymous on Saturday, February 02 2008 @ 02:06 PM EST |
Some of the key questions (e.g. was the violence concentrated in particular
areas that correlate with paticular ethnic populations? or did the violence
produce systematic movement of people of particular ethnic groups from
particular areas?) that you undoubtedly want to address are essentially
Geographic Information System questions. You can probably do some sophisticated
analysis with GRASS (or the spatial tools in R) or good visualizations of
patterns in the data with QGIS if you can compile a gazeteer linking all the
entries in Table tlkpLocation (list of locations (towns and villages) in Kenya)
with a latitude and longitude for the town/village. A simple map of where each
reported incident of violence occured linked with a line to the place where the
report was compiled (with a red dot for the violence, and a blue dot for the
report) could very quickly show systematic patterns of displacement of people,
color the lines by their ethnic group and you may have a very compelling image.
This can be done easily if you have latitude/longitude for each tlkpLocation,
run a query, export the results to a text file, and import it into QGIS.
Finding other GIS layers for Kenya might take some work, but NASA composite
satelite images like the BlueMarble can work well for producing pretty maps for
people.[ Reply to This | # ]
|
|
Authored by: Jey on Saturday, February 02 2008 @ 02:39 PM EST |
I am very willing to give a hand here.
I have around 10 years experience of web development and I have managed a number
of projects involving MySQL. I have experience with Access and Base. It is
trivial to interface Access or Base to a MySQL backend.
I agree with the others who have said that Django is a good way forward for a
web frontend.
You can contact me at davis.jey at gmail dot com.
Jey
---
"I believe in everything; nothing is sacred. I believe in nothing; everything is
sacred"
- Tom Robbins
[ Reply to This | # ]
|
|
Authored by: ak on Saturday, February 02 2008 @ 02:51 PM EST |
"Sahana is a Free and Open Source Disaster
Management system. It is a web based collaboration tool that addresses the
common coordination problems during a disaster from finding missing people,
managing aid, managing volunteers, tracking camps effectively between Government
groups, the civil society (NGOs) and the victims themselves."
[ Reply to This | # ]
|
|
Authored by: akStan on Saturday, February 02 2008 @ 03:49 PM EST |
Are parts of the Sahana FOSS Disaster Management System workable at this
time?
Sahana Wikipidia page.
generic
disaster management tool PDF brochure
SourceForge
PostGIS and/or other offsite GIS efforts fall in line after the data assembly
starts. [ Reply to This | # ]
|
|
Authored by: Anonymous on Saturday, February 02 2008 @ 04:42 PM EST |
As does MySQL, and spatial support is very good in Postgres with the Postgis
extension. The hard part will probably be obtaining latitude and longitude data
to populate the database. [ Reply to This | # ]
|
|
Authored by: Anonymous on Saturday, February 02 2008 @ 07:28 PM EST |
My experience with Kenya is some 20 years ago but sounds little different to
what is going on today. The locals were apt to steal anything not welded to the
floor or quite happy to smash something that might produce an inconvenient
truth.
Put into the design a simple way to get off-site or international backups of the
data. It is essential there.
Tufty
[ Reply to This | # ]
|
- Backup - Authored by: Anonymous on Saturday, February 02 2008 @ 08:00 PM EST
- Backup - Authored by: Anonymous on Wednesday, February 06 2008 @ 08:12 AM EST
|
Authored by: billposer on Sunday, February 03 2008 @ 01:07 AM EST |
I would check out Martus, a project
that aims to provide security for human rights workers via encryption, an
on-screen virtual keyboard (so as to defeat keyboard monitors, and so forth.
They have some sort of database but I am not familiar with the details. Even if
their software doesn't solve the problem, they may have suggestions, and you may
well want to make use of their other software.
[ Reply to This | # ]
|
|
Authored by: emmenjay on Sunday, February 03 2008 @ 07:38 AM EST |
Modern developers are spoilt for choice. There are many platforms that will do
an admirable job of hosting your data.
The hardest thing is to find capable people who can build and support your
database.
If you get one or more volunteers, let them choose the platform -- so long as it
meets your requirements. They will be much more productive with tools they know
than with tools that you might choose.
Good luck with the project.
It has been a while since I did hands-on database work and there are probably
many here who would do a better job than I would. However if there should be
areas where you need help, I'd be happy to do my best.
To get my email, take my Groklaw user name, at zip dot com dot au.
Regards
Michael J Smith
[ Reply to This | # ]
|
|
Authored by: webster on Sunday, February 03 2008 @ 11:47 AM EST |
- Every one will be watching to see what happens. Remember years ago
after the SCO suit, IBM advertised Linux during the super bowl. What will Apple
advertise? Pods, books, phones, all three? It is hard to believe that they got
BG to appear in their ads. Will they dump on their main competitor? Speaking
of which, will the Monopoly indoctrinate us further about innovation and the
wonders of Blista. No doubt whatever it is doing for them is a wonder. They are
too ashamed to tell us. The Monopoly will tell the world all they are doing to
get one laptop per child. Expect surprises.
- There is not going
to be so much working and shopping today. A look at today's paper --the "paper"
paper, not the online paper, revealed the current realities to this bifocular,
jaundiced eye. The Monopoly remains strong. There is no mention of any other
operating system, not even Apple's. Every machine has an italicized Monopoly
Edition of one sort or another. This must be the result of a contractual
bind enforced by the Monopoly. No machine is advertised with another operating
system. Yet it is clear that inexpensive machines like the Asus eee, and the
Walmart gOS machine are immensely popular and out of stock. Their promotion and
supply must be limited either at the manufacturing or retail
level.
- But let us face the harsh truth. The retailers and
manufactures like the Monopoly. The Monopoly spurs cyclical turnover: everyone
has to buy new hardware too keep up with the Monopoly BloatVare. Everyone gets
to sell a new, updated version of their software to run on the new BloatVare.
The Monopoly spurs all to make more money from the consumers who are frustrated,
but trained to "buy-grade" their way out of frustration. Then there is the
antivirus and maintenance... The industry is used to the Monopoly. Long live
the Monopoly.
- Monopoly "group-think" is quite successful. A
friend who had been raving about her Asus eee in her law practice recenly
allowed as she had changed her eee to Monopoly PX. She did this for the cost of
the OS and the services of the member of the Nerd Squad who told her that her
old-format Word Documents won't work on the Asus eee. One would have thought he
would have shown her how to do it. But no, he was more satisfied to charge her
more than the machine was worth to change the OS.
- Back to the
"paper" paper. There are five ad inserts: Staples, Office Depot, Circuit City,
Best Buy, and InkStop. Four of them have low-priced Monopoly (of course)
laptops on the cover. Staples has a $500 14" Acer on the second page.
Circuit city has the same for $479, Office Depot has a "15 Lenovo for
$529. Then at the magic $399 eee level is Best Buy with a 15" Toshiba
with only Basic Monopoly CrippleWare, and finally InkStop with a 14"
refurbished Dell running Monopoly PX, 90-day hardware warranty, possibly the
best deal of all. Who is suffering the discounts on these machines? The
hardware or software? Clearly the OLPC has cast a long shadow. MacBooks are
thriving. The Air might too. The high end goes to Mac. The Monopoly tries to
keep out Linux on price and vendor/manufacturer lock-in. Imagine if Dell could
put their Ubuntu's in the Suday paper. Or imagine a showroom with every
computer running a different version of Linux, all compatible. People could get
used to that quickly.
- There is some competitive pressure in the
air. One can get a 15" Zonbu for $279 if you add a $200 subscription
for 30 gigs online for 2 years. It runs some kind of Linux. But everyone is
waiting to see what OLPC and Mary Lou do with their screen and power patents
toward their goal of $75 computers. That promises to be a lot more than a
typewriter with a screen.
- Let's hope they all play fair and it's
not a blowout by the third quarter.
~
webster~
Tyrants live
their delusions.
Beware the PIPE
Fairy. [ Reply to This | # ]
|
|
Authored by: SirHumphrey on Sunday, February 03 2008 @ 05:44 PM EST |
#Module HijackSearch
#define SearchEngine Yahoo
if exists (Google.browser)
then
{
SearchEngine.URL = URL;
warning("The search engine you have selected has performed an error. Now
starting bundled uninstallable search engine");
load_spyware();
invoke SearchEngine(URL);
Bank_Money();
}
else
{
load_spyware();
invoke SearchEngine(URL);
Bank_Money();
}
end if
[ Reply to This | # ]
|
|
Authored by: Anonymous on Sunday, February 03 2008 @ 05:49 PM EST |
you mean with the african union, the United nations etc. Your coming here for
help. Interesting.
has anyone taught these guys phpMyAdmin, and how easy it is to make the actual
database?
A) what i also htink they really want is a way to enter and look at the data
correct. Making a dbase is easy as beans.
B) OS specifics please, need ot know all types a machines you will use it on and
if any differ need ot get a cross OS dbase, so things can migrate around
C) external and internal security for the Dbase like arkea has that been thought
of or are you leaving such a thing insecure.
D) will it have a webpresence and what network security have you in place that
has to interact with the dbase.
E) simple creation is not issue as i can see above, and to the one guy that
shooted off credentials , i'd like to call proof and see examples before i GIVE
ANYONE trust.
chronoss2008@hush.com
you'd kill to see my resume, it however doesn't include a spellchecker ROFL[ Reply to This | # ]
|
|
Authored by: Anonymous on Monday, February 04 2008 @ 03:21 AM EST |
If :
- The interviewer use offline laptop.
- The only avalaible IT person can only write document, doesn't have programming
experience
If all the above requirement is satisfied, I recommend epiinfo from
http://www.cdc.gov/EpiInfo. They only need to write a questionaire with a few
placeholder to enter input data.
[ Reply to This | # ]
|
|
Authored by: Anonymous on Monday, February 04 2008 @ 11:16 AM EST |
Who should be contacted to help here?
In my experience, https://www.quickbase.com/would be the
fastest way to get this thing up and running.
I've authored an online
database for keeping track of child sponsorships for a charity that works with
disabled children in Kenya: Kupenda for the
Children
I could leverage this codebase for the creation of this KHCHR
database, but I'd like to speak to some of the stakeholders first. You can
contact me at "jacob" (at the charity website mentioned above)[ Reply to This | # ]
|
|
Authored by: Anonymous on Monday, February 04 2008 @ 12:55 PM EST |
Once this is all together and working, it deserves a project page somewhere.
This is the sort of thing that may have application elsewhere. It will be good
to have a writeup of the final project so that others can follow.
Tufty
[ Reply to This | # ]
|
|
Authored by: bloggsie on Tuesday, February 05 2008 @ 07:28 AM EST |
Have you found your Guru?
[ Reply to This | # ]
|
|
Authored by: Anonymous on Tuesday, February 05 2008 @ 10:21 AM EST |
You're trying to do too much given the speed at which things are evolving. Just
use WinEvsys for the meantime (see huridocs.org). Get the incidents into a
standard format, with an incident number (use the eventid)and make use of the
current chain of evidence systems currently used. [ Reply to This | # ]
|
|
Authored by: joh3 on Wednesday, February 06 2008 @ 02:03 PM EST |
I was wondering what solutions had been decided upon and what assistance was
needed at this point?
perhaps if their are specifics then more people can get involved and help out?
which i for one would be happy to do.
[ Reply to This | # ]
|
|
Authored by: Anonymous on Friday, February 08 2008 @ 01:24 PM EST |
Just a suggestion since I have not seen it mentioned, but the database server
should not be in the country but in some other country. It would be a shame to
collect all that data and have it destroyed or hijacked by some local entity.[ Reply to This | # ]
|
|
Authored by: Anonymous on Friday, February 08 2008 @ 01:29 PM EST |
Just another note, I did see somebody recommend backups out of country, and that
is essential, putting the server out of country would help prevent downtime,
just in case.[ Reply to This | # ]
|
|
|
|
|