00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE.pdf - 第9页

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 9 3 Restrictions The program s implemented are subject to specific lim its and priorities based on the hardwar e used and the available dat a …

ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition

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 16.0 (R18-2) / Interface Description 11/2018 Edition

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

-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

-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, and PICKUPERROR 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.

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 16.0 (R18-2) / Interface Description 11/2018 Edition

4 Database

NOTICE

The Support Media 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 2.8 (R18-2) 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 Predefined 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 226.

SIS: The current version is 114.

4.3 Users

The following user is needed to access the database:

● 3

-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:

● If the database was created in old versions (prior to 5.0 i.e. without support of SQL

Server 2005), the password is an empty string.

● If the database was created with versions 5.0 or 5.1, the password is

SiplaceUser3P+.