Introducing 

Prezi AI.

Your new presentation assistant.

Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.

Loading…
Transcript

Questions?

What are Remote Objects?

Answer: Remote Objects are refer to Objects/Tables located in OLTP Database. Records in these objects are prepared to ship into ODS database.

Remote Objects are:-

DataStoreInserts1Mast

DataStoreInserts1

DataStoreInserts2Mast

DataStoreInserts2

DataStoreUpdatesMast

DataStoreUpdates

OLTP & ODS Structure

Camstar OLTP Database

Insert directly into Camstar Application Objects such as below Objects:

Container

HistoryMainline

Employee

Factory

Enterprise

Holdreason

Containerdetails

ContainerGroup

ContainerLevel

CollectDataHistory

Do you know?

Camstar 5.5 have more than >1200 tables!

DATASTORE

PRESENT?

What additional jobs will done from Camstar Web Server site if found out DataStore is presents?

Answer: Camstar Web Server will perform additional job in generating records in OLTP Remote Objects.

Example

Creating a new factory will have Web Server generate the following DML statements.

Insert into factory (factoryid, factoryname, changecount) values('4000000fd23','SGP', 1)

Insert into ChangeStatus (changestatusid) values ('48000000ds31') and etc

Addition insertion into Camstar Remote Objects listed as below:

An Addtional records will be generate into Remote Objects, such as below.

Insert into Remote_DataStoreInserts1Mast (ID,TXNID,Status,RecordDate,Server,CDOID,ERROR) values (1,'400000ds01', 'P', '20150208','MyPC',...)

Insert into Remote_DataStoreInserts1 (TXNID,Sequence,TXNType, SQLSTMT)

Values ('400000ds01',1,'P',' All DML Statement in Normal Transaction within 8KB');

DataStoreInserts1Master

DataStoreInserts1

DataStoreInserts2Master

DataStoreInserts2

DataStoreUpdatesMaster

DataStoreUpdates

End Of OLTP Jobs

Things to Remember:

Not every tables records will be propagate to ODS servers.

Verify Camstar Datastore Availability

INSITESITEINFO.TVALUE = 'Y'

Camstar Application Server

Camstar ODS Database

How Camstar know which objects should propagate to ODS?

Camstar Management Studio

Answer: In Camstar Insite Designer, User can configure which tables records shall be propagate to ODS.

OLTP & ODS Architecture

Upon Datastore database being created and assigned.

Single click on

[Create New Database Tables...]

or

[Update Database...]

in Camstar Management Studio will automatically populate necessary Database objects into OLTP and ODS.

Is Camstar Datastore Enable?

Scheduled Jobs in ODS

Moved OLTP Remote Object into ODS Local objects.

DataStoreInserts1Mast

DataStoreInserts1

DataStoreInserts2Mast

DataStoreInserts2

DataStoreUpdatesMast

DataStoreUpdates

Shall periodically search availabile records in OLTP Remote tables.

DataStoreInserts1Master

DataStoreInserts1

DataStoreInserts2Master

DataStoreInserts2

DataStoreUpdatesMaster

DataStoreUpdates

YES Action:

Perform Normal Transaction and Create ODS Transactions into Remote Objects.

Executed SQLSTMT in ODS

Camstar ODS Database

Camstar OLTP Database

Camstar Platform Application

Camstar Application Server

Examples of sqlstmt

No Action:

Perform Normal

Transactions into

Camstar Objects.

NOTE: Datastore Master table do not have sqlstmt (Datatype:Clob).

If the set of statements is larger than 8KB in size, there will be multiple detail rows for a given transactions.

Camstar Web Application & Portal Connect to

Web Application Server

Camstar Platform Application

Web Applications

Portal Applications

Learn more about creating dynamic, engaging presentations with Prezi