decoration decoration
Stories

GROKLAW
When you want to know more...
decoration
For layout only
Home
Archives
Site Map
Search
About Groklaw
Awards
Legal Research
Timelines
ApplevSamsung
ApplevSamsung p.2
ArchiveExplorer
Autozone
Bilski
Cases
Cast: Lawyers
Comes v. MS
Contracts/Documents
Courts
DRM
Gordon v MS
GPL
Grokdoc
HTML How To
IPI v RH
IV v. Google
Legal Docs
Lodsys
MS Litigations
MSvB&N
News Picks
Novell v. MS
Novell-MS Deal
ODF/OOXML
OOXML Appeals
OraclevGoogle
Patents
ProjectMonterey
Psystar
Quote Database
Red Hat v SCO
Salus Book
SCEA v Hotz
SCO Appeals
SCO Bankruptcy
SCO Financials
SCO Overview
SCO v IBM
SCO v Novell
SCO:Soup2Nuts
SCOsource
Sean Daly
Software Patents
Switch to Linux
Transcripts
Unix Books
Your contributions keep Groklaw going.
To donate to Groklaw 2.0:

Groklaw Gear

Click here to send an email to the editor of this weblog.


Contact PJ

Click here to email PJ. You won't find me on Facebook Donate Paypal


User Functions

Username:

Password:

Don't have an account yet? Sign up as a New User

No Legal Advice

The information on Groklaw is not intended to constitute legal advice. While Mark is a lawyer and he has asked other lawyers and law students to contribute articles, all of these articles are offered to help educate, not to provide specific legal advice. They are not your lawyers.

Here's Groklaw's comments policy.


What's New

STORIES
No new stories

COMMENTS last 48 hrs
No new comments


Sponsors

Hosting:
hosted by ibiblio

On servers donated to ibiblio by AMD.

Webmaster
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)


  


Are You a Database Guru? -- A Request for Volunteers | 175 comments | Create New Account
Comments belong to whoever posts them. Please notify us of inappropriate comments.
Corrections Here
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 | # ]

Off Topic
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 | # ]

[NP] Groklaw News Picks discussion
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 | # ]

Overall connectivity...
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

Please post candidate platforms here
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

Use Martus
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 | # ]

Postgresql and phpPgAdmin
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

Just a Suggestion...
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

This screams for GIS
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

Sahana
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 | # ]

Existing systems: Sahana ?
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

Backup
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
Are You a Database Guru? -- A Request for Volunteers
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 | # ]

Choosing the ideal platform is the wrong approach
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 | # ]

OT: Before the Game
Authored by: webster on Sunday, February 03 2008 @ 11:47 AM EST

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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 | # ]

Windows_Yahoo code for future Service Packs and OS releases
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 | # ]

ok this is an odd question
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 | # ]

What About Epiinfo
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 | # ]

Who do we contact?
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 | # ]

Random thought
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
Authored by: bloggsie on Tuesday, February 05 2008 @ 07:28 AM EST
Have you found your Guru?

[ Reply to This | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

What do you still need?
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

Are You a Database Guru? -- A Request for Volunteers
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 | # ]

Groklaw © Copyright 2003-2013 Pamela Jones.
All trademarks and copyrights on this page are owned by their respective owners.
Comments are owned by the individual posters.

PJ's articles are licensed under a Creative Commons License. ( Details )