RTXPS
Reference &
User Manual
    RTXPS  On-line Reference Manual

      Release Level 2.0
      Release Date 2012 06
      Revision Level 1.0
    Document was last modified on:   Sunday, 12-Aug-12 18:37 CEST

    RTXPS files and data base tables

    RTXPS uses several data bases and table for

    • basic configuration data
    • Descriptors (shared between forward and backward chaining branches)
    • forward chaining RULES,
    • backward chaining RULES
    • dynamic knowledge base, log files.

    The following Data Bases and TABLES are used:

    • DESCRIPTORS

      • Descriptors, definition

        mysql> describe descriptors;
        FieldTypeNull Key Default Description
        id int(11)NO PRINULLauto_increment
        name varchar(255)YES NULL internal name, must not be changed once referenced
        display_name varchar(64) YES NULL arbitrary name for display e.g., in different languages
        type varchar(255) YES NULL S = symbolic, H = hybrid, V = variable (free text)
        unit varchar(255) YES NULL unit of measurement where applicable
        def_value varchar(255) YES NULL default value
        desc textYES NULL description text for the header meta field
        owner varchar(32) YES NULL
        createddatetime YES 0000-00-00 00:00:00
        modified datetime YES 0000-00-00 00:00:00 timestamp of the last modification, see change log table below
        url varchar(255) YES NULL
        format varchar(16) YES NULL display format for numerical values, C syntax
        sort varchar(20) YES NULL sorting of the symbolic values by numerical ranges, ascending or descending

      • Descriptors: ranges, questions

        mysql> describe desc_range;
        FieldTypeNullKey DefaultDescription
        id int(11) YES MUL NULL
        desc_from float YES NULL lower value for the range
        desc_to float YES NULL upper value for the range
        desc_median float YES NULL explicit median, used as default for the symbolic reference; if unspecified the arithmetic mean of the desc_from - desc_to values is used
        seq int(11) YES NULL drives explicit sequencing of symbols/ranges
        desc_range varchar(255) YES NULL symbolic label for a range

        mysql> describe desc_questions;
        FieldTypeNullKey DefaultDescription
        id int(11) YES MUL NULL
        question varchar(255) YES NULL text (htlm) of the explanatory questions shown in the editor
        seq int(11) YES NULL

      • Descriptor values

        The current descriptor value is saved in a standard triple column table like:

        FieldTypeNullKey DefaultDescription
        ID int(10) unsigned NO PRI 0
        DESCRIPTOR varchar(32) NO PRI
        VALUE varchar(255) NO depending on the display function used, value is shown as string (symbolic) or float

      • Descriptor change log

        mysql> describe desc_log;
        FieldTypeNullKey DefaultDescription
        id int(11) YES MUL NULL
        name varchar(255)YES NULL internal name, must not be changed once referenced
        user varchar(255) YES NULL user responsible for the change, if interactive
        dt datetime YES NULL timestamp of the change
        rule int(11) YES NULL rule that made the change (if changed by inference)
        value varchar(255) YES NULL

    • RULES: RTXPS, and XPS (subset)

      • RULES, condition part

        mysql> describe rule_cond; function
        FieldTypeNull Key Default Description
        id int(11) NO PRI 0
        seq int(11) NO PRI 0
        ifandor varchar(255) YES NULL AND or OR clause
        parup int(11) YES NULL open parenthesis
        varchar(255) YES NULL
        descriptor varchar(255) YES NULL
        operator varchar(255) YES NULL
        operand varchar(255) YES NULL
        pardown int(11) YES NULL close parenthesis

      • RULES, action part

        mysql> describe rule_act;
        FieldTypeNull Key Default Description
        id int(11) NO PRI 0
        seq int(11) NO PRI 0
        function varchar(255) YES NULL
        descriptor varchar(255) YES NULL
        operator varchar(255) YES NULL
        operand varchar(255) YES NULL

    • Dynamic Knowledge Base

        mysql> describe dynamic_KB_act;
        FieldTypeNull Key Default Description
        id int(11) NO PRI NULLautoincrement
        namevarchar(255) YES NULL of the descriptor, links to its definition and related data, TABLE: descriptors
        modified datetime YES NULL timestamp of the change
        newvalue varchar(255) YES NULL new value set
        oldvalue varchar(255) YES NULL redundant luxury, but useful for performance
        method varchar(255) YES NULL one of user or model, sensor, etc.


© Copyright 1995-2016 by:   ESS   Environmental Software and Services GmbH AUSTRIA | print page