Each time a document (message, request, payload) arrives in the application, its meta data (type, name, size, encryption, link to its body, encoding, … ) is stored in this table. Check TRANS_DATA SQL queries.ĭOCUMENT: This table is one of the important tables in the schema.
TRANS_DATA: contains the physical payload files, mailbox messages, documents, status reports… stored as blobs (or points to the physical file on filesystem if storage is FS). WORKFLOW_CONTEXT: One of the largest tables that contains the execution steps of business processes, node information, service name, link to status report and primary document (stored in trans_data table as binary object blobs or in filesystem)… Example SQL queries. I will describe some important database tables: I explained how the B2B Integrator Housekeeping works in another post. The housekeeping processes need to be watched carefully to prevent the Database from growing. There are also other DB cleanup processes, listed above in the fifth box in red. For example: WORKFLOW_CONTEXT will contain the BP execution steps.įinally when the BP completes, it will be indexed or moved to the next step so it can be either archived or purged.
The fourth box lists some of the important transactional tables affected when a BP runs. Alternatively, a BP schedule (like the Evaluate Mailbox) will start the needed inbound and outbound operations. When the document is in the system it will either trigger or bootstrap a Business Process (BP) as soon it arrives. Other Database tables are also impacted when a document arrive, like MBX_MESSAGE, ACT_SESSION, DATA_FLOW, CORRELATION_SET etc (shown in the blues boxes above). It has references to other tables like TRANS_DATA which either stores the physical document as a DB blob (binary object) if the storage is database or will store a pointer to the filesystem. The DOCUMENT table is one of the most important tables in the schema.
The picture below, summarizes the document/BP lifecycle and the tables involved: Transaction log (redo logs) are crucial.Ī document or a message can come to the application in different ways such as mailboxing, webservices, SFTP, FTP, HTTP, REST … etc.OLTP (transactional processing) write centric database.Let’s start with some key facts about the Sterling B2B Integrator Database schema:
0 kommentar(er)
