PBB MANAGED SOFTWARE SERVICES HIGH LEVEL ARCHITECTURE

(1)

MBC

Workflow

PIX

Review and Approval Turnovers and Shot

Tracking EAGL Marketing Assets DBB Production and Marketing Assets

PBB MANAGED SOFTWARE SERVICES

SECURITY SERVICES Authentication Authorization Access Control User Management OTHER SERVICES Status Management Reporting Billing DAM SERVICES (DMR) Asset Management Search Download Upload Edit Metadata Folder Management Revisions Check-in Check-out INTEGRATION SPECS & TEMPLATES Content Library Other Storage PBB Cache GPMS PRISM GOLD 5th Kind Shotgun EAGL PBB Production Assets UI SERVICES CONTENT PROCESSING SERVICES Transcoding Visible WM Forensic WM Image Transform FILE DELIVERY SERVICES Aspera SFTP UNC CORE SERVICES Logging Event Management Exception Management Notification Governance Policy Enforcement SLA Monitoring Guaranteed Delivery Analytics Resource Mgt (MBC) DEPT - DAM UI Production Assets

PBB MANAGED SOFTWARE SERVICES – HIGH LEVEL ARCHITECTURE

DATA SERVICES WORKFLOW SERVICES MBC / Web Methods Business Rules Distributed Services Content Processing Other Cloud Services

(2)

MBC

Workflow

PIX

Review and Approval Turnovers and Shot

Tracking EAGL Marketing Assets DBB Production and Marketing Assets SECURITY SERVICES Authentication Authorization Access Control User Management OTHER SERVICES Status Management Reporting Billing DAM SERVICES (DMR) Asset Management Search Download Upload Edit Metadata Folder Management Revisions Check-in Check-out INTEGRATION SPECS & TEMPLATES Content Library Other Storage PBB Cache EAGL PBB Production Assets UI SERVICES CONTENT PROCESSING SERVICES Transcoding Visible WM Forensic WM Image Transform FILE DELIVERY SERVICES Aspera SFTP UNC DEPT - DAM UI Production Assets

PBB MANAGED SOFTWARE SERVICES – HIGH LEVEL ARCHITECTURE - PHASES

DATA SERVICES WORKFLOW SERVICES MBC / Web Methods Business Rules Phase 3 Phase 1 Phase 2 Governance Policy Enforcement SLA Monitoring Guaranteed Delivery Analytics Resource Mgt (MBC) CORE SERVICES Logging Event Management Exception Management Notification Distributed Services Content Processing Other Cloud Services GPMS PRISM GOLD 5th Kind Shotgun

(3)

Content Library

PBB CACHE

DAM SERVICES (DMR) Asset Management Search Download Upload Edit Metadata Folder Management Revisions Check-in Check-out MBC Workflow PIX

Review and Approval

EAGL Marketing Assets UI SERVICES DBB Production and Marketing Assets

PBB MANAGED SOFTWARE SERVICES – DAILIES DATA FLOW

1. Ingest Picture, Sound, Dailies Take Proxies 4. Initiate a workflow 2. Sync assets with PBB DAM 5. Distribute to Picture Editorial 3. Sync to PIX CW DI 6. Request DPX Frames 8. Push Frames 7. Export request EAGL PBB Production Assets DATA SERVICES PICTURE EDITORIA L SOUND EXTERNA L DI VFX

(4)

PICTURE EDITORIA L SOUND EXTERNA L DI VFX

DAM SERVICES (DMR) Asset Management Search Download Upload Edit Metadata Folder Management Revisions Check-in Check-out Content Library PIX

PBB MANAGED SOFTWARE SERVICES – WORK IN PROGRESS DATA FLOW

DATA SERVICES PBB CACHE 1. WIP iteration s 4. Submit Ingest Request

6. Sync select clips to PIX 2. Selects posted to hot folder 3. Request for Ingest

Data outside of PBB Managed Software Services

Data within PBB Managed Software Services

CW DI MBC Workflow EAGL PBB Production Assets 5. Sync assets with PBB DAM

(5)

PBB MANAGED SOFTWARE SERVICES DAM SERVICES (DMR) Asset Management Search Download Upload Edit Metadata Folder Management Revisions Check-in Check-out Content Library PIX

PBB MANAGED SOFTWARE SERVICES – DI DATA FLOW

DATA SERVICES PBB CACHE 1. Clip Approved 2. Sync Status PICTURE EDITORIA L SOUND EXTERNA L DI 5. Push Frames CW DI 3. Notify Status Update 4. Request Frames MBC Workflow EAGL PBB Production Assets 6. Request DPX Frames 8. Push Frames 7. Export request VFX

(6)

The process of storing, retrieving and

distributing digital assets (files) in a

centralized and systematically

organized system, allowing for the quick

and efficient storage, retrieval, and

reuse of the digital files that are

essential to all businesses

(7)

Asset Centric Approach

(DAM is the centerpiece for the Digital Media Eco-System)

DAM SERVICES Asset Management Search Download Upload Edit Metadata Folder Management Revisions Check-in Check-out CONTENT PROCESSING SERVICES Transcoding Visible WM Forensic WM Image Transform Distributed Services

DAM (Asset Repository) Media Production &

Processing

Content & Transaction Management

Workflows

Reporting & Dashboard

(8)

Digital Asset Management – DMR Ability

Requirement

DMR

Stability

In production 3 years with 1675 worldwide internal and

external users

Performance

Performance tests run in 2009 (complete results

appended)

• Number of asset records = 1,500,000

• All mean SQL response times were less than 328

milliseconds.

Security

Asset based security

Scalability

Yes, based on .NET & Oracle

Openness – Ability to integrate with other

systems

Integrated with many LOB systems and Tools.

Systems: GPMS, PRISM, DBB, MP Publicity, CRB,

Lightroom (MP Photo), SPT B2B, SPT Japan, Non

Theatrical Sales, Magic (Sound)

Tools: Flip Factory, FFMPEG, AVI Synth, Civolution,

FMS, ImageMagick, Media Rich, Photoshop, Open Office

Flexible

Services based – SOA Architecture

Experience in Integration with internal and external

applications & tools

(9)

DMR Performance Testing – Test Setup

Database Records

•Number of asset records = 1,500,000 •Number of user records = 6,156 •Number of asset filter records = 7,151

•Average number of asset filters per user = 19 •Average number of assets per asset filter = 862

Features Hit During Each Iteration

•Login and Logout (only for the first iteration by a vuser), Search, Pagination •Changing thumbnails displayed from the default 10 to 50 and 100

•Navigating to the asset details page for the first asset in the search results (only every 5 iterations by a vuser) •Navigating to the cart landing page with 100 assets already in the cart

Backend Processes Running

•20 AssetIDs were processed minutely throughout the duration of the test to simulate 20 new asset uploads or metadata edits which would require…

o_{an incremental sync of the asset filter to asset work tables.} o_{an incremental sync of the full-text search index.}

Other Test Configuration Notes

• 1 new vuser was added to the test minutely until 50 vusers were running concurrently, then the test persisted for another 30 minutes with a constant load of 50 vusers (total test duration = 1 hour, 20 minutes).

(10)

DMR Performance Testing – Test Results

SQL Response Times

• All mean SQL response times were less than 328 milliseconds.

• The max SQL response time overall was 2.2 seconds (this was from the stored procedure that executes a search).

• SQL response times remained relatively constant throughout the test. They did not increase noticeably as more and more vusers were added.

• The graph below shows each of the SQL response times.

o_{The x-axis is time of day, and the y-axis is response time in milliseconds.}

o _{The test started at 11:48 AM with 1 vuser. At 12:37 PM, the 50th vuser was added. Then the test persisted for another} 30 minutes with those 50 vusers.

o _{Each data point on the graph represents the average response time in a 90 second interval, which explains why you} don't see the max overall response time of 2.3 seconds (it was averaged with other response times in some arbitrary 90 second interval).

o _{The 2 response times which seem to be generally higher than the rest (the teal circle and the black square) represent} the response times of the stored procedure that executes a search. 1 of the them is from DMIQCULWH03 and the other is from DMIQCULWH04 (the 2 DMR web servers), but they're both representing the response time of the same stored procedure.

(11)

DMR Performance Testing – Test Results (continued)

User-Perceived Transaction Response Times

• All mean transaction response times were less than 2.6 seconds.

• The max transaction response time overall was 3.5 seconds (this was from navigating to the asset details page on one particular occasion).

• Transaction response times grew very slightly throughout the test. The transaction response times with 50 vusers are not much higher than with 1 vuser.

• The graph below shows each of the average transaction response times.

o _{The test started with 1 vuser. At the 49th minute, the 50th vuser was added. Then the test persisted for another 30} minutes with those 50 vusers.

o _{The 4 response times which seem to be generally higher than the rest represent navigating to the details page, login,} search, and navigating to the cart landing page.