Differences between revisions 7 and 25 (spanning 18 versions)
⇤ ← Revision 7 as of 2005-04-12 22:26:12 →
Size: 4999
Editor: BenjaminWaldron
Comment:
← Revision 25 as of 2009-01-20 11:38:20 → ⇥
Size: 5005
Editor: BenjaminWaldron
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
(Please note: POWER USERS only.)

'''NEW: The LKB/LexDB module now runs under both Linux and M$ Windows (and presumably Solaris also).''' 		NEW: See LkbLexDbSingleUser for SINGLE USER LexDB (lightweight system).
Line 10: Line 8:
 * Ensure the environment variable `PSQL` is set: e.g. [Linux] set `export PSQL=t` in `.bashrc`.
Line 15: Line 12:
   * your `.lkbrc` file contains `(psql-initialize)`
  
Line 20: Line 16:
''LexDB -> Filter'' ''LexDB -> Set Filter''
Line 22: Line 18:
The filter specified will be interpreted as an SQL WHERE clause.

Eg.		 The filter specified is interpreted as an SQL WHERE clause. Examples:
Line 33: Line 27:
(Note: the default is {{{ TRUE }}}. This represents the empty condition and will select all available entries.) (Note: the default is `NULL`. Change this to a non-NULL value to select a subset of the lexical database.)
Line 35: Line 29:
The lexicon as seen by the login user is determined by that user's database filter. Only revision entries matching the conditions in filter can form part of the lexicon. In general multiple revisions for a given entry will be returned; the most recent will become part of the visible lexicon. The filter determines the entries in the lexicon as seen by a particular user. Only revision entries matching the filter conditions in filter can form part of the lexicon (of these, the most recent revision is the one actually used).
Line 43: Line 37:
(This will dump public schema tables to text files -- eg. {{{ lexdb.rev }}}, {{{lexdb.dfn}}}, and {{{lexdb.fld}}})
[[BR]](Note: a TDL dump will be performed also unless you set {{{*lexdb-dump-tdl*}}} to {{{nil}}})
[[BR]](Note: the database dump files are tab-separated with null as {{{\N}}})		 (This will dump public schema tables to text files -- eg. `lexdb.rev`, `lexdb.rev_key`, `lexdb.dfn`, `lexdb.fld`, `lexdb.meta`)
[[BR]](Note: the dump mechanism will also produce a `.tdl` file if `*lexdb-dump-tdl*` is set to `t`)
[[BR]](Note: the database dump files are tab-separated with null as `\N`)
Line 47: Line 41:
2. Run the cvs commit command. E.g. [Linux] 2. Run the cvs commit command. E.g.
Line 49: Line 43:
     {{{cvs commit ~/erg/lexdb.*}}}      `cvs commit ~/erg/lexdb.*`
Line 53: Line 47:
1. Run the cvs update command to retrieve the latest dump file. E.g. [Linux] 1. Run the cvs update command to retrieve the latest dump file. E.g.
Line 57: Line 51:
2. ''LexDB -> Merge new entries'' 2. ''LexDB -> Load ('rev' entries)''
Line 59: Line 53:
These steps update the LexDB (public schema) to include all new revisions stored in a CVS dump file. The new entries will be copied to the table public.revision_new. Any changes made to your copy of the LexDB since the last update will be preserved. These steps update the LexDB (public schema) to include all new revisions stored in a CVS dump file. The new entries will be copied to the table public.rev_new. Any changes made to your copy of the LexDB since the last update will be preserved.
Line 61: Line 55:
== HOW TO dump LexDB as TDL file == == HOW TO export LexDB to TDL file ==
Line 63: Line 57:
''LexDB -> Dump (TDL format)'' ''LexDB -> Export (TDL file)''
Line 65: Line 59:
Dumps active LexDB entries (see filter) to {{{.tdl}}} file. Dumps active LexDB entries (determined by filter) to `.tdl` file.
Line 69: Line 63:
The LexDB-Emacs interface allows editing of lexical entries from within an Emacs environment (with browsing functionality, field completion, etc.). New revision entries are first stored in the users private schema, and hence are visible only to the particular user. To commit the entries to the public table (public.revision): The LexDB-Emacs interface allows editing of lexical entries from within an Emacs environment (with browsing functionality, field completion, etc.). New revision entries are first stored in the users private schema, and hence are visible only to the particular user.
Line 71: Line 65:
0. Add the following line to your {{{.emacs}}} file: 0. Add the following (path adjusted for your setup) to your `.emacs` file:
Line 73: Line 67:
{{{(load "pg-interface")}}}
 {{{
(add-to-list 'load-path "/path/to/delphin/lkb/lexdb")
(load "pg-interface")
}}}
Line 81: Line 77:
''C-c'' : commit (edited/new revision of) lexical entry into LexDB ''C-c C-c'' : commit (edited/new revision of) lexical entry into LexDB
Line 85: Line 81:
''M-TAB'' : get (ring of) (active) entries in LexDB where value of current field matches that in buffer ''M-TAB l'' : get (ring of) entries in table lex where value of current field matches that in buffer

''M-TAB r'' : get (ring of) entries in union of rev tables where value of current field matches that in buffer
Line 93: Line 91:
''M-vs'' : view entries in user's scratch space ''M-vs'' : view entries in user's privat rev
Line 95: Line 93:
Note: To remove a lexical entry from the active grammar, create a (head) revision where the {{{flags}}} field is set to `0` (rather than `1`). This is necessary as in order to preserve revision history entry. No revision entry should ever be deleted from the lexical database itself.) To remove a lexical entry from the current lexicon ''lex'', create a (head) revision where the `dead` field is set to `t` (true) rather than `f` (false). In this manner we keep a revision history even for entries which are no longer used (and such entries can be reactivated if necessary). No revision entry should ever be deleted from the lexical database itself.
Line 97: Line 95:
== HOW TO load TDL entries into private schema == == HOW TO import TDL entries from a file ==
Line 99: Line 97:
To add a small number of new (revision) entries from a `.tdl` file: ''LexDB -> Load TDL entries''. The grammatical fields of the LexDB will be obtained from the TDL code; you will be queried to provide values for other necessary fields. To add a small number of new (revision) entries from a `.tdl` file: ''LexDB -> Import (TDL file)''. You will be queried to provide values for other certain non-grammar fields. The entries will go into the private ''rev'' table.
Line 101: Line 99:
== HOW TO commit entries to public schema == == HOW TO commit entries to public rev ==
Line 103: Line 101:
The LexDB consists of a single public schema and a set of private schemas, one per user. New (revision) entries are placed initially in your private schema. To commit (all) entries in your private schema to the public table: ''LexDB -> Commit scratch'' The LexDB consists of a single public schema and a set of private schemas, one per user. New (revision) entries are placed initially in your private schema. To commit (all) entries in your private schema to the public table: ''LexDB -> Commit private 'rev' ''
Line 106: Line 104:
== HOW TO list entries in private schema == == HOW TO list entries in private rev ==
Line 108: Line 106:
From LKB: ''LexDB -> View scratch'' From LKB: ''LexDB -> Display private 'rev' ''
Line 114: Line 112:
== HOW TO clear entries in private schema == == HOW TO clear entries in private rev ==
Line 116: Line 114:
''LexDB -> Clear scratch'' ''LexDB -> Clear private 'rev'''

== Troubleshooting

 * If M-x lexdb results in "no connection to LexDb", make sure that a working grammar is loaded.
Line 120: Line 122:
LexDbInternals
[[BR]]["MWEs and Idiomatic Expressions"]
[[BR]] [http://www.cl.cam.ac.uk/~bmw20/DT/Papers/ Papers]		  * [http://www.cl.cam.ac.uk/~bmw20/Papers/ Papers]
 * LexDbEmacsInterface

LexDB Usage Instructions

NEW: See LkbLexDbSingleUser for SINGLE USER LexDB (lightweight system).

If running the LKB runtime binary:

  • Download and install (LkbInstallation) the latest LKB, taking care to install/extract the lkb_data.tgz archive into the lkb installation directory (henceforth [Linux] ~/lkb).

If running the LKB from source:

  • Download and compile (LkbCompilation) the LKB, ensuring that

    • your .clinit.cl file contains (pushnew :psql *features*)

Now initialize the database server (LexDbPsqlInitialize) and the lexical database itself (LexDbInitialize).

HOW TO set the filter

LexDB -> Set Filter

The filter specified is interpreted as an SQL WHERE clause. Examples: 

     userid = 'danf'
     userid = 'danf' AND dialect = 'my_dialect'
     userid IN ('danf', 'aac')
     confidence > 0.5

(Note: the default is NULL. Change this to a non-NULL value to select a subset of the lexical database.)

The filter determines the entries in the lexicon as seen by a particular user. Only revision entries matching the filter conditions in filter can form part of the lexicon (of these, the most recent revision is the one actually used).

HOW TO store LexDB in CVS

The LexDB may be dumped to text files which can then be uploaded to storage in CVS.

1. LexDB -> Dump

(This will dump public schema tables to text files -- eg. lexdb.rev, lexdb.rev_key, lexdb.dfn, lexdb.fld, lexdb.meta) BR(Note: the dump mechanism will also produce a .tdl file if *lexdb-dump-tdl* is set to t) BR(Note: the database dump files are tab-separated with null as \N)

2. Run the cvs commit command. E.g.

  • cvs commit ~/erg/lexdb.*

HOW TO retrieve LexDB from CVS

1. Run the cvs update command to retrieve the latest dump file. E.g.

  • cvs update ~/erg/lexdb.*

2. LexDB -> Load ('rev' entries)

These steps update the LexDB (public schema) to include all new revisions stored in a CVS dump file. The new entries will be copied to the table public.rev_new. Any changes made to your copy of the LexDB since the last update will be preserved.

HOW TO export LexDB to TDL file

LexDB -> Export (TDL file)

Dumps active LexDB entries (determined by filter) to .tdl file.

HOW TO edit entries in the LexDB

The LexDB-Emacs interface allows editing of lexical entries from within an Emacs environment (with browsing functionality, field completion, etc.). New revision entries are first stored in the users private schema, and hence are visible only to the particular user.

0. Add the following (path adjusted for your setup) to your .emacs file: 

(add-to-list 'load-path "/path/to/delphin/lkb/lexdb")
(load "pg-interface")

1. In [http://www.gnu.org/software/emacs/emacs.html GNU Emacs]: M-x lexdb to enter LexDB major mode. Then see the PG menu.

Available commands in LexDB major mode are:

C-l : load (active revision of lexical entry) into Emacs

C-c C-c : commit (edited/new revision of) lexical entry into LexDB

TAB : field completion

M-TAB l : get (ring of) entries in table lex where value of current field matches that in buffer

M-TAB r : get (ring of) entries in union of rev tables where value of current field matches that in buffer

M-n : cycle through ring of entries obtained above

M-s : as M-TAB, but explicitly specify field value

M-va : view entries added in merge operation from dump file

M-vs : view entries in user's privat rev

To remove a lexical entry from the current lexicon lex, create a (head) revision where the dead field is set to t (true) rather than f (false). In this manner we keep a revision history even for entries which are no longer used (and such entries can be reactivated if necessary). No revision entry should ever be deleted from the lexical database itself.

HOW TO import TDL entries from a file

To add a small number of new (revision) entries from a .tdl file: LexDB -> Import (TDL file). You will be queried to provide values for other certain non-grammar fields. The entries will go into the private rev table.

HOW TO commit entries to public rev

The LexDB consists of a single public schema and a set of private schemas, one per user. New (revision) entries are placed initially in your private schema. To commit (all) entries in your private schema to the public table: LexDB -> Commit private 'rev'

HOW TO list entries in private rev

From LKB: LexDB -> Display private 'rev'

or

from Emacs LexDB major mode: M-vs

HOW TO clear entries in private rev

LexDB -> Clear private 'rev

== Troubleshooting

  • If M-x lexdb results in "no connection to LexDb", make sure that a working grammar is loaded.

Further Topics

LkbLexDb (last edited 2011-10-08 21:12:12 by localhost)

(The DELPH-IN infrastructure is hosted at the University of Oslo)