00194923-01_OIS_DB.pdf - 第5页
OIS Datenbank Version 4.1 Schnittstellenbeschreibung OIS Database Version 4.1 Interface Description 5 von 47 4.6.6 View V_PICK UPERRO R3 ...................................................................................…
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
4 von 47
4.7.5 V_USEREVENTANDTEXT2 view.............................................................................................. 13
4.7.6 V_PICKUPERROR2 view.......................................................................................................... 13
4.7.7 V_USEDCOMPONENTS2 view................................................................................................. 13
4.7.8 V_STATION2 view..................................................................................................................... 14
4.7.9 V_STATE2 view......................................................................................................................... 14
4.7.10 V_STATESHARE2 view............................................................................................................. 14
4.7.11 V_DATAMODEL2 view.............................................................................................................. 14
4.8 Views of Version 1............................................................................................................................. 14
5 State machines......................................................................................................................................... 15
5.1 Machines with one processing area.................................................................................................. 15
5.2 Machines with two processing areas (HS-50, HS60, HF)................................................................. 17
6 Appendix................................................................................................................................................... 18
6.1 Time slices ........................................................................................................................................ 18
6.2 OIS relevant machine error messages.............................................................................................. 19
1 Allgemeines.............................................................................................................................................. 25
2 Datenschnittstelle..................................................................................................................................... 25
3 Einschränkungen...................................................................................................................................... 26
4 Datenbank ................................................................................................................................................ 27
4.1 Name der Datenbank........................................................................................................................ 27
4.2 Version des Datenbank-Schemas..................................................................................................... 27
4.3 Benutzer............................................................................................................................................ 27
4.4 Tabellen............................................................................................................................................. 27
4.4.1 Tabelle BOARD.......................................................................................................................... 28
4.4.2 Tabelle EVENT .......................................................................................................................... 28
4.4.3 Tabelle USEREVENT ................................................................................................................ 28
4.4.4 Tabelle PICKUPERROR............................................................................................................ 29
4.4.5 Tabelle USEDCOMPONENTS .................................................................................................. 29
4.4.6 Tabelle STATION....................................................................................................................... 30
4.4.7 Tabelle STATE........................................................................................................................... 30
4.4.8 Tabelle STATESHARE ..............................................................................................................30
4.4.9 Tabelle DATAMODEL................................................................................................................ 30
4.4.10 Tabelle SHIFTWORK................................................................................................................. 31
4.4.11 Tabelle EVENTTEXT................................................................................................................. 31
4.5 Views der Version 4 .......................................................................................................................... 31
4.5.1 View V_STATION4 .................................................................................................................... 31
4.6 Views der Version 3 .......................................................................................................................... 31
4.6.1 View V_BOARD3....................................................................................................................... 31
4.6.2 View V_EVENT3........................................................................................................................ 31
4.6.3 View V_EVENTANDTEXT3....................................................................................................... 31
4.6.4 View V_USEREVENT3.............................................................................................................. 32
4.6.5 View V_USEREVENTANDTEXT3............................................................................................. 32
OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
5 von 47
4.6.6 View V_PICKUPERROR3..........................................................................................................32
4.6.7 View V_USEDCOMPONENTS3.................................................................................................32
4.6.8 View V_STATION3.....................................................................................................................32
4.6.9 View V_STATE3.........................................................................................................................32
4.6.10 View V_STATESHARE3.............................................................................................................32
4.6.11 View V_DATAMODEL3..............................................................................................................32
4.7 Views der Version 2...........................................................................................................................33
4.7.1 View V_BOARD2........................................................................................................................33
4.7.2 View V_EVENT2.........................................................................................................................33
4.7.3 View V_EVENTANDTEXT2........................................................................................................33
4.7.4 View V_USEREVENT2...............................................................................................................33
4.7.5 View V_USEREVENTANDTEXT2..............................................................................................33
4.7.6 View V_PICKUPERROR2..........................................................................................................33
4.7.7 View V_USEDCOMPONENTS2.................................................................................................33
4.7.8 View V_STATION2.....................................................................................................................34
4.7.9 View V_STATE2.........................................................................................................................34
4.7.10 View V_STATESHARE2.............................................................................................................34
4.7.11 View V_DATAMODEL2..............................................................................................................34
4.8 Views der Version 1...........................................................................................................................34
5 Zustandsautomaten...................................................................................................................................35
5.1 Maschinen mit einem Bearbeitungsbereich.......................................................................................35
5.2 Maschinen mit zwei Bearbeitungsbereichen(HS-50, HS-60, HF)......................................................37
6 Anhang......................................................................................................................................................38
6.1 Zeitanteile...........................................................................................................................................38
6.2 OIS relevante Maschinen Fehlermeldungen .....................................................................................39
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
6 von 47
1 General
The OIS software (Operator Information System) handles production data acquisition for the SIPLACE
placement machines. The data is saved in a database. In order that third-party users/applications can
retrieve and process this data, this document provides a description of the functionality of the OIS software
and the database format for the data supplied.
2 Data interface
All data that can be retrieved from the OIS database is supplied in the form of database views. This ensures
that the database format is not (forcibly) modified even if changes are made to the database format. All
views are read-only; write access is not possible. When strings are transferred, no length restriction is
applied. This means that the transferred values always correspond to the actual format in the database,
because the ODBC interface permits variable access. If string lengths are changed within the database, the
data is thus always forwarded correctly via ODBC.
3 Restrictions
The programs implemented are subject to specific limits and priorities based on the hardware used and the
available data storage. To ensure an unrestricted placement sequence, the SIPLACE Pro software must
always be assigned highest priority, followed by the SIPLACE OIS software and only then the 3
rd
-party
products used. It may be necessary to impose this type of restriction by means of appropriate configuration
within Windows. In addition, the size of a 3
rd
-party database schema must not overstretch the limits of the
existing system configuration, i.e. it may be necessary to impose a restriction on the maximum size
proportional to the available data storage.
There is a clustered index on the tables BOARD, EVENT, USEREVENT, PICKUPERROR and
USEDCOMPONENTS, for the identification of the station and date/time when the event occured. This means
that queries for a station and a timespan are executed fast. This also meanss that timespan queries for a
group of stations are executed slowly. It is preferred to make station-wise queries.
Example for fast and slow queries:
Fast query for huge data:
FOREACH (station x in line) { SELECT all boards WHERE station = x AND day = 17.08.2006 }
Slow query for huge data:
SELECT all boards WHERE (station = line.station1 OR station = line.station2 …) AND day = 17.08.2006