This patch moves towards in-database indexed value normalization. The eventual
goal of this is to move to pure database ingest handled by triggers. This will
free us from the grip of the Ingest server, speed up ingest altogether, and
cause ingest to occur entirely within the same database transaction as the
INSERT or UPDATE to the MARC that is the cause of the ingest. This means
no more potential for race conditions on ingest, and simpler data import.
In this first step, we add some normalization routines for dealing with basic
string data. NACO normalization and the like. With these functions we can
do everything that the Ingest server can do with regard to munging indexed
strings.
You can register these normalizers with specific indexed fields, and define the
order in which they are to be applied.
Next up: work on the scaffolding to actually apply the functions, define the
IDL entries, and create MARC-handling functions to do the xpath dances.
This functionallity will require either:
* a custom (I have a patch) pgxml contrib module or
* Postgresql 8.3+ XML/XPath support
git-svn-id: svn://svn.open-ils.org/ILS/trunk@14375
dcc99617-32d9-48b4-a31d-
7c20da2025e4