[NLUUG]   Welcome to ftp.nluug.nl
Current directory: /pub/ftp/os/Linux/doc/linux-doc-project/linuxfocus/common/db/
Current bandwidth utilization 1210.69 Mbit/s
Bandwidth utilization bar
Contents of README:
Last update:
Sun Dec 30 11:39:41 CET 2001

This directory contains a simple and lightweight database system
for LinuxFocus. 

The principe is that all files can be compiled from
a single XML file (xmldb_en.xml). This master database
file is maintained and checked manually. Normally this means
just that you copy new entries from resdb_newarticles.xml
to xmldb_en.xml and then execute xmlupdateall_sh
to compile all files.

To maintain the database you need:
- perl
- nsgmls (http://www.jclark.com/sp/nsgmls.htm) for xml validation
- Sablotron (http://www.gingerall.com/) as a XSLT processor

You can query this database system via

New article numbers can be allocated via
getticket will write to resdb_newarticles.xml

The architecture
The master files for this database system are xml files.
However xml is only good to transform xml into another document
without changing much the structure. It becomes very slow and
inefficent if you need to do more complex changes.

The system consists therefore of structured text files that
can be read very efficently with perl.
It's a 2 layer system. XML as a master file for easy maintenance
and perl parsible text files which are really used
by the various programs such as (lfthemes, lftaklback, getticket, qdb...)

The files in are:

downloaddb -- a script to download the latest db files from
              linuxfocus.org to the current directory
xmldb_en.xml -- the master DB file. 
resdb_newarticles.xml -- new articles allocated via
               getticket are written into this file. You need
               to check the entries and copy them over to xmldb_en.xml
resdb.txt -- all articles allocated via getticket are as well listed here
             Do not manually change this file it is updated by 

The generated files are:
textdb.txt -- all articles with title, abstract etc....
textdb_person.txt -- all authors
issuedb.txt -- issue numbers
talkback.txt -- used by lftalkback

Scripts and other files:
maindb.txt -- the old DB system file (before XML was introduced), no longer
linkus.txt -- Hist here the current article numbers. This will then
              periodically be used to automatically update 
renumber.txt -- end of 2000 the old articles where renumbered to
              get new numbers which are unique. This file explains
              what was done.
olddb2xml -- script, transforms the old maindb.txt file into xmldb_en.xml
qdb_sh -- shell script to query the linuxfocus db (you need to be
          online to use this).
querydb_pl -- a perl script to query the linuxfocus db

The scripts to update the low level text files, the
stylesheets and xml helper files are:

Regular maintenance
Every second month (when a new issue comes out). The main editor
has to move the entries from resdb_newarticles.xml to xmldb_en.xml and
check them. Change the <issueref href="none"/> to the directory name of the
new issue and add a new issue entry under <issues>.
Next run the program xmlupdateall_sh and upload the files:

The file linkus.txt (which is as such not related to the DB system but
used for the http://linuxfocus.org/common/linkus/ pages) needs to be
updated with the new articles of the current issue.


Icon  Name                                                       Last modified      Size  
[DIR] Parent Directory - [DIR] lftalkback/ 21-Nov-2006 10:28 - [DIR] old/ 05-May-2003 21:57 - [   ] LFlanguages.pm 12-Jan-2005 11:47 1.1K [TXT] README 30-Dec-2001 12:12 3.7K [   ] downloaddb 04-Sep-2003 04:40 427 [TXT] index.html 24-Feb-2002 18:03 40 [TXT] issuedb.txt 29-Sep-2005 21:09 8.1K [TXT] issuedbshort.txt 29-Sep-2005 21:09 1.0K [   ] lfupd_artch.log 29-Sep-2005 21:09 20K [TXT] pubdb.txt 29-Sep-2005 21:09 19K [TXT] pubdb.xslt 28-Oct-2004 22:46 1.3K [TXT] qdb_sh 25-Nov-2001 23:27 361 [TXT] querydb_pl 25-Nov-2001 23:27 3.0K [TXT] renumber.txt 25-Nov-2001 23:27 4.8K [TXT] resdb.txt 03-Sep-2005 22:24 81K [TXT] resdb_newarticles.xml 29-Sep-2005 21:09 0 [TXT] talkback.txt 29-Sep-2005 21:09 21K [TXT] talkback.xslt 13-Oct-2002 13:33 702 [TXT] talkbacknew.txt 29-Sep-2005 21:09 20K [TXT] talkbacknew.xslt 13-Oct-2002 13:33 718 [TXT] textdb.txt 29-Sep-2005 21:09 100K [TXT] textdb.xslt 03-Oct-2002 20:21 1.6K [TXT] textdb2issue_pl 04-Sep-2003 04:40 1.5K [TXT] textdb_person.txt 29-Sep-2005 21:09 9.5K [TXT] textdb_person.xslt 03-Oct-2002 20:21 720 [   ] validate_sh 04-Sep-2003 04:40 88 [TXT] xhtml-lat1.ent 02-Dec-2001 21:11 12K [TXT] xml.dcl 02-Dec-2001 21:11 6.8K [   ] xml2pubdb_sh 28-Oct-2004 22:46 301 [   ] xml2talkback_sh 04-Sep-2003 04:40 452 [   ] xml2textdb_person_sh 04-Sep-2003 04:40 325 [   ] xml2textdb_sh 04-Sep-2003 04:40 304 [TXT] xmldb.dtd 02-Dec-2001 21:11 2.4K [TXT] xmldb_en.xml 29-Sep-2005 21:09 167K [TXT] xmlupdateall_sh 04-Sep-2003 04:40 659

NLUUG - Open Systems. Open Standards
Become a member and get discounts on conferences and more, see the NLUUG website!