From a72e66db913de3a2e508080c8b1fc8d1342a899b Mon Sep 17 00:00:00 2001 From: Ralph Amissah Date: Tue, 25 Sep 2007 23:23:03 +0100 Subject: remove generated output from main package --- .../sisu_manual/sisu_search/search_sql.html | 639 --------------------- 1 file changed, 639 deletions(-) delete mode 100644 data/doc/manuals_generated/sisu_manual/sisu_search/search_sql.html (limited to 'data/doc/manuals_generated/sisu_manual/sisu_search/search_sql.html') diff --git a/data/doc/manuals_generated/sisu_manual/sisu_search/search_sql.html b/data/doc/manuals_generated/sisu_manual/sisu_search/search_sql.html deleted file mode 100644 index d745e71f..00000000 --- a/data/doc/manuals_generated/sisu_manual/sisu_search/search_sql.html +++ /dev/null @@ -1,639 +0,0 @@ - - - - - - search_sql - - SiSU - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - -
- -
SiSU -->
-
- - - - - - - - - - - - - - - - - -
- - - TOC linked  toc  - - - - - - Full Text  scroll  - - - - - - PDF portrait -   pdf  - - - - - - PDF landscape -   pdf  - - - - - - ODF/ODT  odt  - - - - - - -   A-Z  - - - - - - Document Manifest  - - - - - @ -
-
- - - - - - -
- - << previous - - - - TOC - - - - next >> - - -
-
- - - - -
- - < - - - - ^ - - - - > - -

- SiSU -

-

- Search -

-

- Ralph Amissah - -

-

- copy @ - - SiSU - -

- - -
-

- SiSU - Search,
Ralph Amissah -

-
  -

-   1 -

-
- - -
- -   -

-   2 -

-
- - -
- -   -
- - -
-

- - 2. SQL -

-
-

-   7 -

-
- - 2.1 populating SQL type databases - -
- - -
- -

- 2.1 populating SQL type databases -

-
-

-   8 -

-
- - -
-

- SiSU feeds sisu markupd documents into sql type databases PostgreSQL  1  and/or SQLite  2  database together with information related to document structure. -

-
-

-   9 -

-
- - -
-

- This is one of the more interesting output forms, as all the structural data of the documents are retained (though can be ignored by the user of the database should they so choose). All site texts/documents are (currently) streamed to four tables: -

-
-

-   10 -

-
- - -
-
  • - one containing semantic (and other) headers, including, title, author, subject, (the Dublin Core...); -
  • -
    -

    -   11 -

    -
    - - -
    -
  • - another the substantive texts by individual "paragraph" (or object) - along with structural information, each paragraph being identifiable by its paragraph number (if it has one which almost all of them do), and the substantive text of each paragraph quite naturally being searchable (both in formatted and clean text versions for searching); and -
  • -
    -

    -   12 -

    -
    - - -
    -
  • - a third containing endnotes cross-referenced back to the paragraph from which they are referenced (both in formatted and clean text versions for searching). -
  • -
    -

    -   13 -

    -
    - - -
    -
  • - a fourth table with a one to one relation with the headers table contains full text versions of output, eg. pdf, html, xml, and ascii. -
  • -
    -

    -   14 -

    -
    - - -
    -

    - There is of course the possibility to add further structures. -

    -
    -

    -   15 -

    -
    - - -
    -

    - At this level SiSU loads a relational database with documents chunked into objects, their smallest logical structurally constituent parts, as text objects, with their object citation number and all other structural information needed to construct the document. Text is stored (at this text object level) with and without elementary markup tagging, the stripped version being so as to facilitate ease of searching. -

    -
    -

    -   16 -

    -
    - - -
    -

    - Being able to search a relational database at an object level with the SiSU citation system is an effective way of locating content generated by SiSU. As individual text objects of a document stored (and indexed) together with object numbers, and all versions of the document have the same numbering, complex searches can be tailored to return just the locations of the search results relevant for all available output formats, with live links to the precise locations in the database or in html/xml documents; or, the structural information provided makes it possible to search the full contents of the database and have headings in which search content appears, or to search only headings etc. (as the Dublin Core is incorporated it is easy to make use of that as well). -

    -
    -

    -   17 -

    -

    -^

    - - -
    -

    -  1. <http://www.postgresql.org/> -

    -
      -
    - - -
    -

    - <http://advocacy.postgresql.org/> -

    -
      -
    - - -
    -

    - <http://en.wikipedia.org/wiki/Postgresql> -

    -
      -
    - - -
    -

    -  2. <http://www.hwaci.com/sw/sqlite/> -

    -
      -
    - - -
    -

    - <http://en.wikipedia.org/wiki/Sqlite> -

    -
      -
     
    - - - -
    - -
    SiSU -->
    -
    - - - - - - - - - - - - - - - - - -
    - - - TOC linked  toc  - - - - - - Full Text  scroll  - - - - - - PDF portrait -   pdf  - - - - - - PDF landscape -   pdf  - - - - - - ODF/ODT  odt  - - - - - - -   A-Z  - - - - - - Document Manifest  - - - - - @ -
    -
    - - - - - - -
    - - << previous - - - - TOC - - - - next >> - - -
    -
    - - - - -
    - - < - - - - ^ - - - - > - -

    - - - - - - - - -
    - -
    -

    - - SiSU - -

    -
    - -

    - Output generated by - - SiSU - - 0.59.1 2007-09-25 (2007w39/2) -
    - - SiSU - - Copyright © Ralph Amissah - 1997, current 2007. - All Rights Reserved. -
    - - SiSU - - is software for document structuring, publishing and search, -
    - - www.jus.uio.no/sisu - - and - - www.sisudoc.org - -
    - w3 since October 3 1993 - - ralph@amissah.com - -

    -
    -

    - SiSU using: -
    Standard SiSU markup syntax, -
    Standard SiSU meta-markup syntax, and the -
    Standard SiSU object citation numbering and system, (object/text positioning system) -
    - Copyright © Ralph Amissah 1997, current 2007. - All Rights Reserved. -

    -
    -

    - - GPLv3 - -

    -
    -

    - - SiSU - - is released under - GPLv3 - or later, - <http://www.gnu.org/licenses/gpl.html> -

    -
    -

    - SiSU, developed using - - Ruby - - on - - Debian/Gnu/Linux - - software infrastructure, - with the usual GPL (or OSS) suspects. -
    - Better - "performance, reliability, scalability, security & total cost of ownership" - [not to mention flexibility & choice] use of and adherence to open standards (where practical and fair) and it is software libre. -
    - Get With the Future - - Way Better! - -

    -
    - - - - - -
    -
    - - -
    - - -
    - - - - idx - txt - - -
    -
    - -
    -

    - - -SiSU manual - -

    - - - - - - - - - - - -
    -

    - - -SiSU - -

    - - - - - - - - - - - - - - - - -
    - \ No newline at end of file -- cgit v1.2.3