System Profile
System Full Name | Video Logging Database |
Business Administrator | |
Business Owner | Doug Hickey |
Director | |
Subject Matter Expert | WeiGuang Xiao, Caroline Gignac |
Division | |
NTARS Code | CA39 |
Source Location | Source code , data and documentation backed up to : \ncras22\CSSG Release\CSSG Staging\VLD\PROD[C254374] |
Source Code Location |
Technology Assessment
Platform Type | Web (Internal) |
|---|---|
Database Platform and Version | Oracle 11g |
Development Language and Framework | .NET |
Operating System and Version | Windows Server 2016 |
Additional Dependencies | |
Authentication |
...
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV | TTSD_11G | |||
PREACC | ||||
ACC | http://tcappstest/Saf-Sec-Sur/2/vld-bdv/ <INACTIVE> | TTSA_11G | ||
PROD | http://tcapps.tc.gc.ca/saf-sec-sur/2/vld-bdv/ <INACTIVE> | TTSP | ||
TRAINING |
System Overview
<--->
Good To Know
<--->Decommissioning completed May-2022 ( C254374 ) (PBI- 132519 )
all source code , data and documentation backed up to :
\ncras22\CSSG Release\CSSG Staging\VLD\PROD[C254374]
The Video Logging Database (VLD) uses Microsoft Access to log and catalogue information from original camera videotapes.
MPS maintains the TC Camera Original and Raw Footage Video Library. Currently, the Video Library contains an estimated 1000 Camera Original and Raw Footage video tapes. Most of these tapes belong to Civil Aviation but other modes are starting the transfer of their video assets to MPS. The video footage contained on these tapes was originally shot as part of video productions undertaken by MPS or an outside video production company.
Camera Original and Raw Footage videos exist invarious Standard Definition formats (e.g. BetacamSP, S-VHS, DVCPRO, DVCam and MiniDV) As well as various High Definition formats. These tapes are held at the MPS office location, MOT Level.
Each Camera Original and Raw Footage Video tape consists of a variety of shots. Each shot can be described as; for example: Shot Type, Shot description, location etc.
Each tape contains a control track or Time code, which would indicate the location of a particular shot on a tape. For Example 01:03:24:12. These series of numbers refer to Hours:Minutes:Seconds:Frames
MPS has a requirement for capturing the shot type, tape number, shot description etc for quick retrieval to use in future productions. MPS would be the sole user of this application. MPS Has begun the logging process
Purpose of website (or application):
To help Multimedia Publishing Services manage the approximately 1000 tapes of shots owned by the group. Each tape is 30 to 60 minutes in length and the database will identify which shots are on each tape. This will simplify retrieval when requests for shots are made.
Good To Know
from RDIMS #8046685 (Date: December 11, 2012) Decommissioning Request (C254374 May-2022)
Multi-Media Product and Services (AARA_MPS) has recently declared surplus a large amount of raw stock tape footage. These tapes had been associated with the Video Logging Database. There is no business need to continue to maintain the Video Logging System Database at this point as we no longer have the associated tapes in our possession. There will be no replacement database for this business need.
Decommission and remove all data from servers.
Note:There are no infrastructure items such as workflow, firewall rules, DNS, IP addressing, etc. and/or support processes that were associated with the application and/or database that need to be adjusted and/or decommissioned
Application will not be replaced because function is no longer needed. |
Requested Decommission Date: February 1st 2013
SEE ATTACHMENTS :
RDIMS-#1032961-v1-VIDEO_LOGGING_CCB_SUBMISSION
RDIMS-#1301407-v1-VIDEOTAPE_LOGGING_DATABASE_(VLD)_-_CLF_COMPLIANCE
RDIMS-#2525860-v1-VIDEO_LOGGING_DATABASE_PRESENTATION
RDIMS-#8046685-v1-VIDEO_LOGGING_DECOMMISSION_APPLICATION
How-To and Fixes
<Sub-sections should describe how to address known support request, including any scripts, instructions / steps, etc… >