00900045-01_ID_OIS_SIS_14.0_R16-2_DE_EN.pdf - 第9页
ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 9 3 Restrictions The programs implem ented are subje ct to specific lim its and prioriti es based on the hardw are used and the available dat…
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
8
2 Data Interface
All data that can be retrieved from the OIS/SIS 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.
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
9
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 ASM OIS and ASM SIS
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.
Additional Restrictions for OIS
There is a clustered index on the BOARD, EVENT, USEREVENT, PICKUPERROR und
USEDCOMPONENTS tables for the identification of the station and date/time when the event
occured.
This means that queries for one station and one time span are executed very fast.Im Gegensatz
dazu werden Abfragen für ein Zeitintervall für mehrere Stationen langsam abgearbeitet.
But this also means that queries for one time span for any stations are executed slowly.
It is preferred to make station-wise queries.
There is also a normal index on the tables BOARD, EVENT, USEREVENT, PICKUPERROR und
USEDCOMPONENTS tables.
This means that queries for all stations for one time span are executed quickly.
Example for fast and slow queries
Fast query for huge data with dtTime:
FOREACH (station x in line) { SELECT all boards WHERE station = x AND
dtTime = 12.03.2007 }
Fast query reading all stations for huge data with dtCreated:
SELECT all boards AND dtCreated = 12.03.2007
Slow query for huge data with dtTime:
SELECT all boards WHERE (station = line.station1 OR station =
line.station2 …) AND dtTime = 12.03.2007
Slow query for huge data dtCreated:
FOREACH (station x in line) { SELECT all boards WHERE station = x AND
dtCreated = 12.03.2007 }
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
10
4 Database
NOTICE
The Support Media included in the installation package checks the necessary system
requirements of your system and installs these. Amongst others, e.g. Microsoft .NET
Framework, the ASM License Manager, the ASM Error Reporter Service and the ASM
Operation Manager.
The use of the Support Media V2.4 is mandatory.
The system requirements (supported operating systems and database variants) and an
overview of the interoperable products can be found in the ASM
Support Media Software
Version Description, item no. [00900052-xx].
4.1 Name of the Database
OIS: SiplaceOis
SIS: SiplaceSis
4.2 Version of the Database Schema
The Version entry in the DATAMODEL table supplies the version number of the database schema
in the lLong column.
OIS: The current version is 221.
SIS: The current version is 113.
4.3 Users
The following user is needed to access the database:
● 3
rd
-party user
Name: SiplaceMonUser3P
Password: Ois&Sis.1 (see below for versioning issues)
NOTICE
The user SiplaceMonUser3P has been set up globally in the master database and
permits access to all monitoring databases (OIS and SIS).
All database users with SQL Server 2005 need a password.
Due to changes in the password policy, the password for this database user is different
depending on the OIS/SIS version that originally created the database: