On Sun, 19 Oct 2003, Maxim K. wrote:
> Abstract:
> the db will contain information about real estates (flats/houses etc.)
> i thought in OOD terms, and came to:
> address, person, estate- data "objects" or - tables.using these
> terms, there will be relations between these tables.
>
> i understand there's solution of "simply" putting it all into 1 huge
> table.and search by simple or/and matches. what i don't unserstand is:
> how do i decide how much to go down with the most basic tables, vs. one
> huge table.
> as someone pointed this out to be the "normalization" question.
>
> Q1: where do i read about it ?
At home I have a book about practical issues of database design. I don't
remember the author name, but the book explains about normalization,
about mistaken notions about relational databases in general, etc.
> Q2: which platform shall i use for the GUI frontend of this DB, given
> that i chose the DBMS to be PostgreSQL.
> i have written in: C, C++, Java
> (i see C isn't much of a help in GUI...except maybeGTK frontend)
> i think i also can handle Python.
> which tools are there ? what you suggest ?
> need Hebrew support, of course .. so if GUI supports - good for it.
You may want to design your system as a 3-part system:
- Database backend
- Web site (running on your own PC): server, CGI scripts and Web pages
- The GUI will be provided by your browser (Mozilla, if you have the
freedom to choose a platform).
BiDi/Hebrew support is good out of the box.
If you prefer to do without Web server, you can develop your application
as a Mozilla chrome, and then you'll have database backend and browser
frontend. Refer to the O'Reilly book "Developing applications with
Mozilla".
--- Omer
My opinions, as expressed in this E-mail message, are mine alone.
They do not represent the official policy of any organization with which
I may be affiliated in any way.
WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
