TLOGFEED (Transaction Log Feed)
HyperScript can access the PROMIS™ Transaction Log, reading records as they are appended to the end of the file. This allows you to detect events as they occur in real time. With this capability you can:
- trigger actions to occur as the result of a real-time event
- feed data to a parallel database, such as lot and equipment status information
- keep track of lot activity data.
- find out when users log in and out
- keep track of scheduled events
- keep track of hot lots
How to Build Your Own Parallel Database (for PROMIS™)
- Create your database schema on ORACLE, MySQL, or SQLSERVER
- Start up ACTLserver (Active Lot Server) to receive lot data and update the database
- Prepopulate your database with ACTLFEED.
- Run TLOGFEED and feed lot transactions to ACTLserver in real time
- Create HyperScript CGI programs to generate reports on your web pages.
How does TLOGFEED work?
Data from every transaction log record is exposed to the TLOGFEED program. Many of these transaction records contains copies of the PROMIS™ database records that have just been applied by the PROMIS fileserver. The TLOGFEED program can select any of these records and expand its contents, to access the complete list of field names and their values within the record.
For example, with the ACTL file, you have access to each data field in the entire record, including the event table array. With a simple programming loop, you can scan for specific events and then perform additional actions from them. Your TLOGFEED program will get almost instant ( ~ 1 second ) response from transactions that are occurring on the factory floor.
When TLOGFEED expands the contents of a TRES record, it also interprets the test data area, discovering the data prompts and data formats for the data, so that the result is not just an array of meaningless bytes, but a completely formatted data structure.
When TLOGFEED expands the contents of a TBLS record, it also interprets the inner table as well, so you get instant notification of PROMIS table changes.
For TLOG records that don't contain PROMIS™ data, such as heartbeat records, TLOGFEED also has access to all the internal fields describing the record.
For multiple update sequences in the TLOGFEED automatically holds back events until the last record in the multiple update has been committed. In the event of a restart, catch-up is automatic, and no transactions are ever missed or duplicated.
TLOGFEED can also read and process any transaction log file, starting and ending at any record number.
Press here to see an example a TLOG feed program.
FEEDING....
20020928:190513:TLOGFEED:BMU TID = '774622012'
20020928:190513:TLOGFEED:Record = schd
20020928:190513:TLOGFEED:Record = schd
20020928:190513:TLOGFEED:Record = actl
20020928:190513:TLOGFEED:Record = actl
20020928:190513:TLOGFEED:EMU TID = '774622012'
20020928:190514:TLOGFEED:Processing actl
20020928:190514:TLOGFEED:BMU TID = '774622012'
20020928:190514:TLOGFEED:Record = schd
20020928:190514:TLOGFEED:BMU TID = '774601585'
20020928:190514:TLOGFEED:Record = schd
20020928:190514:TLOGFEED:Record = hist
20020928:190514:TLOGFEED:Record = actl
20020928:190514:TLOGFEED:Record = hstg
20020928:190514:TLOGFEED:Record = actl
20020928:190514:TLOGFEED:Record = prlv
20020928:190514:TLOGFEED:EMU TID = '774622012'
20020928:190514:TLOGFEED:Processing actl
20020928:190515:TLOGFEED:Record = actl
20020928:190515:TLOGFEED:Record = evst
20020928:190515:TLOGFEED:EMU TID = '774601585'
20020928:190515:TLOGFEED:Processing actl
20020928:190515:TLOGFEED:BMU TID = '774622012'
20020928:190515:TLOGFEED:Record = schd
20020928:190515:TLOGFEED:Record = schd
20020928:190515:TLOGFEED:Record = actl
20020928:190515:TLOGFEED:Record = actl
20020928:190515:TLOGFEED:EMU TID = '774622012'
20020928:190515:TLOGFEED:Processing actl
20020928:190515:TLOGFEED:BMU TID = '774622012'
20020928:190515:TLOGFEED:Record = schd
20020928:190516:TLOGFEED:Record = schd
20020928:190516:TLOGFEED:Record = actl
20020928:190516:TLOGFEED:Record = actl
20020928:190516:TLOGFEED:EMU TID = '774622012'
20020928:190516:TLOGFEED:Processing actl