00900045-01_ID_OIS_SIS_14.0_R16-2_DE_EN - 第10页

ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 10 4 Database NOTICE The Support Media in cluded in the instal lation package ch ecks the necessa ry system requirements of your system and i…

100%1 / 144
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
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
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)
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:
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
11
● 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+.
● If the database was created with version 5.2 (or later), the password is Ois&Sis.1.
● If the database has been created by a previous version of OIS/SIS and is now
upgraded to version 14.0, the password is not modified, even if the new version
would configure a new password in case of creating a new database.
This procedure has been chosen to provide an unchanged interface to 3
rd
-
applications that are allowed to access the upgraded database as before. 3
rd
-party
client applications must adapt to the new password only if accessing a newly-
The passwords for the needed internal users have the following characteristics:
● The password does not contain all or part of the account name of the user. Part of an account
name is defined as three or more consecutive alphanumeric characters delimited on both ends
by a white space such as space, tab and return, or any of the following characters: comma (,),
period (.), hyphen (-), underscore (_) or number sign (#).
● The password is at least 8 characters long.
● The password contains characters from 3 of the following 4 categories:
– Latin uppercase letters (A through Z)
– Latin lowercase letters (a through z)
– Base 10 digits (0 through 9)
– Non-alphanumeric characters such as: exclamation point (!), dollar sign ($), number sign
(#) or percent (%).
4.4 Database Maintenance
4.4.1 "DB remove old data"
The OIS database has a stored procedure ESP_REMOVEOLDDATA that removes old data from
the OIS database. The stored procedure is called regularly to remove OIS data older than 40 days
(default value). Allowed values are 40 days to 400 days. As of OIS 5.0 the SQL statement EXEC
SiplaceOIS..ESP_REMOVEOLDDATA 40 is executed every two hours from the OisServerDb
service process for all SQL Server versions. OIS 4.1 and earlier versions had installed a job for the
SQL Server-Agent that executed the same remove old data SQL statement once a day.
The SIS database has a stored procedure ESP_REMOVEOLDDATA that removes old data from
the SIS database. The stored procedure is called regularly to remove SIS data older than 400
days. As of SIS 5.0 the SQL statement EXEC SiplaceSIS..ESP_REMOVEOLDDATA 400 is
executed every 24 hours from the SisServer service process, for all SQL Server versions. SIS 4.1
and earlier versions had installed a job for the SQL Server-Agent that executed the same remove
old data SQL statement once a day.