4

4

Microsoft SQL Server

Microsoft SQL Server

Microsoft SQL Server Microsoft SQL Server DataBase Management System

Microsoft SQL Server

LAN WAN RDBMS RDBMS

Relational

IndustrialSQL Server

Microsoft SQL Server Windows NT Microsoft SQL Server Performance Monitor event log

Windows NT Event Viewer

IndustrialSQL Server IndustrialSQL Server

Microsoft SQL Server

MS SQL Server

On-Line Transaction Processing SQL Server

OLTP EIS

Windows NT

32 Wonderware InSQL Server 8.0

65

4

Microsoft SQL Server

SQL Server

Windows NT Windows NT -

SQL Server SQL Server

, IndustrialSQL Server

Itel RISC Windows NT

Microsoft SQL Server SQL

InTouch

IndustrialSQL Server Wonderware Wonderware I/O Servers

FactorySuite

Microsoft SQL Server Microsoft SQL Server

SQL Server Enterprise Manager Microsoft SQL Server Runtime

database Microsoft SQL Server

SQL Server Enterprise Manager Microsoft SQL Server Server SQL Server Enterprise Manager

SQL Server Enterprise Manager IndustrialSQL Server Microsoft SQL

l l l l l l

66

Wonderware InSQL Server 8.0

4

Microsoft SQL Server

l l l l

SQL

SQL Server Enterprise Manager Windows Microsoft SQL Server SQL Server Enterprise Manager

Start

SQL Server Enterprise Manager SQL Server Enterprise Manager SQL Server Enterprise Manager Enterprise Manager

1. 2. 3. 4.

SQL Server Microsoft SQL Server

SQL Server Enterprise Manager Action New SQL Server Registration Register SQL Server Wizard

Wonderware InSQL Server 8.0

67

4

Microsoft SQL Server Microsoft

SQL Server Enterprise Manager SQL Enterprise Manager Windows

SQL Service Manager Microsoft SQL Server SQL Server Service Manager Microsoft SQL Server IndustrialSQL Server InSQL Console Microsoft SQL Server

Microsoft SQL Server 1. Start SQL Service Manager 2. Server 3. Start/Continue

68

Microsoft SQL Server

SQL Service Manager

Microsoft SQL Server

Wonderware InSQL Server 8.0

5

5

Wonderware InSQL

Wonderware InSQL

1

- IndustrialSQL Server

2

- Transact SQL

1

- IndustrialSQL Server

IndustrialSQL Server IndustrialSQL Server

IndustrialSQL Server

IndustrialSQL Server

IndustrialSQL

"

Microsoft SQL Server

" IndustrialSQL Server

Microsoft SQL Server

SQL

Wonderware I/O Server

500 IndustrialSQL

Server IndustrialSQL Server

Wonderware InSQL Server 8.0

69

5

Wonderware InSQL Wonderware I/O Server

SuiteLink(tm)

SuiteLink

I/O Server

IndustrialSQL Server SQL SQL

SQL

Microsoft SQL Server Server Transact-SQL

SQL

Transact-SQL

IndustrialSQL

Microsoft SQL Server

Runtime database Microsoft SQL Server IndustrialSQL Server SQL Server InSQL Console Configuration Editor Microsoft SQL Server IndustrialSQL Server SQL Server Microsoft SQL Server IndustrialSQL Server Microsoft SQL Server

OLE DB

Microsoft SQL Server

SQL IndustrialSQL Server

70

/

client/server /

Wonderware InSQL Server 8.0

5 IndustrialSQL Server Microsoft SQL Server IndustrialSQL Server l

Microsoft SQL Server IndustrialSQL Server

IndustrialSQL Server

Wonderware IndustrialSQL Server l

Wonderware InSQL

SQL

Microsoft SQL Server

WonderTools SQL

ODBC ODBC

SQL IndustrialSQL Server

IndustrialSQL Server IndustrialSQL Server l l l l l

IndustrialSQL Server

Wonderware InSQL Server 8.0

71

5

72

Wonderware InSQL

Wonderware InSQL Server 8.0

5

Enterprise Manager

Wonderware InSQL

(Linked Server) IndustrialSQL Server

InSQL Microsoft SQL Server Enterprise Manager

OLE DB

Enterprise Manager Start/Programs/Microsoft SQL Server /Enterprise Manager

Enterprise Manager SQL Server Group/ Server Name / Security / Linked Servers / INSQL / INSQLD INSQLD

INSQL

OLE DB

InSQL OLE DB

INSQL Runtime

l l l

dbo

AnalogHistory AnalogWideHistory DiscreteHistory

Wonderware InSQL Server 8.0

73

5

Wonderware InSQL l l l l l

DiscreteWideHistory HistoryBlock AnalogLive DiscreteLive StringLive InSQL Runtime SQL Server

OLE DB

Four-Part Queries

INSQL.Runtime.dbo.TableName.

AnalogHistory SELECT SELECT * from INSQL.Runtime.dbo.AnalogHistory WHERE TAGNAME = 'ReactTemp'

OLE-DB Improvements The following SQL improvements are readily visible to users, since these queries required workarounds in InSQL 7.1. l GetDate()-type datetime functions work without the need for a parameterised query. For example, the following works correctly: SELECT TagName, DateTime, Value from INSQL.Runtime.dbo.History where TagName = 'ReactTemp' and DateTime > DateAdd(mi, -2, GetDate()) and DateTime < GetDate() l

74

GROUP BY works, when the query uses four-part naming or one of the v_ views.

Wonderware InSQL Server 8.0

5 l

Wonderware InSQL

Count(*) now works without the need for OpenQuery.

These improvements are mainly due to Microsoft enhancements to the SQL Server query processor.

2

- Transact-SQL Transact-SQL

IndustrialSQL Server .

Query Analyzer Execute Query

l l l

Query Analyzer SQL Query

Query Analyzer 1.

Query Analyzer

Start / Run / Programs / Microsoft SQL Server / Query Analyzer 2.

MS SQL Server

Wonderware InSQL Server 8.0

75

5

Wonderware InSQL 3.

SQL Server

4.a

Login Name

5.b

Password

wwUser

OK SQL Server Query Analyzer

4. SELECT * FROM ANALOGHISTORY

5.

Execute Query

IndustrialSQL Server

SQL Query ----SELECT FROM 76

1 +++++++++++++++++++++++++++++++++++++++++++

* Tag Wonderware InSQL Server 8.0

5 ----SELECT FROM

2 +++++++++++++++++++++++++++++++++++++++++++

Tagname Tag -----

SELECT FROM

Wonderware InSQL

3 +++++++++++++++++++++++++++++++++++++++++++ '

' SQL

database.owner.table.column

Runtime.dbo.Tag.Tagname, Runtime.dbo.Tag.Description Runtime.dbo.Tag -----

4 +++++++++++++++++++++++++++++++++++++++++++ 'WHERE'

SELECT Tagname, Description FROM Tag WHERE Tagname = 'SysTimeSec' ------

5 +++++++++++++++++++++++++++++++++++++++++++

- AnalogLive

SELECT Datetime, Tagname, Value FROM AnalogLive WHERE Tagname = 'SysTimeSec'

Wonderware InSQL Server 8.0

77

5

Wonderware InSQL

---

4 Server.Database.Owner.Table

SELECT Datetime, Tagname, Value FROM InSQL.Runtime.dbo.AnalogLive WHERE Tagname = 'SysTimeSec' --

6

SELECT Datetime, Tagname, Value FROM v_AnalogLive WHERE Tagname = 'SysTimeSec' --

'Live'

'History'

SELECT Datetime, Tagname, Value FROM v_AnalogHistory WHERE Tagname = 'ReactTemp' --

4

---1. -1 --2. ' ' -100 / -7 -+++++++++++++++++++++++++++++++++++++++++++ 'getdate()' -MSSQL MSSQL

78

Wonderware InSQL Server 8.0

5 --

Wonderware InSQL

InSQL

InSQL

---

InSQL

SQL Server

OpenQuery() -SELECT * from OpenQuery(InSQL, 'SELECT FROM AnalogHistory WHERE Tagname = "SysMinutesRun" AND Datetime > "Oct 15, 1999 11:00" AND Datetime "Oct 15, 1999 11:00" AND Datetime