Digital Memories Software

1
Digital Memories Software

• Jim Gemmell
• Digital Memories (Memex) Workshop 7/19/2006

2
Whats in the kit

• SenseCam
• SenseCam software upload wizard, (non-database)
  viewer inc. movie creation.
• sc-qa_at_microsoft.com for support

• Digital Memories Software
• Includes a (database-based) SenseCam viewer

3
Connect Site

• Latest version of Digital Memories software.
• Updated version of SenseCam upload/viewer.
• SenseCam demo data (photos, sensor date GPS).
• Sample code for extending the Digital Memories
  software.
• Tips, e.g. upgrade problems
• Uninstall a previous release
• Remove any Digital Memories services

4
Running in the background

• NTFS file system promotion service (fswatch.exe)
• Local Web Service" (mlbwww.exe)
• PersonalVibe (in startup group)
• Outlook toolbar watching your email, contacts
  etc.
• IE toolbar capturing web pages

5
dmInfo
6
NTFS Sync Controller

• Dont need to run SenseCam import if you are
  watching the folder tree

7
VIBE log viewer
8
DEMO did you know you can?

• IE common pages, next/prev in history
• Outlook click for log, pause button, launch
  shell
• SenseCam Viewer
• Trip Replay
• Shell drag drop photos onto map, sort web
  pages by time spent

9
Creating new item types

• Award for first new item type goes to Michael
  Shoffner from UNC Inserted context items show
  up in the shell and work with full text search!

-- SQL to add a new type to Digital Memories for
context snapshots from CAF -- These items are
inserted by a trigger on the _Items table
whenever a modification or creation of an item
occurs. -- Create a table to hold context
data create table Context_Snapshots (item_id
uniqueidentifier NOT NULL, Snapshot
varchar(max)) GO -- add a primary key
constraint ALTER TABLE dbo.Context_Snapshots
ADD CONSTRAINT PK_Context_Snapshots PRIMARY
KEY NONCLUSTERED (item_id) GO -- add a foreign
key reference to enforce that no Snapshot can
exist without a corresponding _Item ALTER TABLE
dbo.Context_Snapshots ADD CONSTRAINT
FK_ContextSnapshot_Items FOREIGN KEY
(item_id) REFERENCES dbo._Items
(item_id) GO exec _Init_CreateSubType
'CEC5651C-AE0E-494E-9959-97B6654C9441',
'Context_Snapshots' GO -- sp to delete a context
item create procedure Context_Snapshots_DeleteProc
edure _at_item_id uniqueidentifier AS delete from
Context_Snapshots where item_id _at_item_id
10
My questions for you

• Is anyone planning on extending the shell with a
  new visualization?
• We want to hold a workshop for the final results
  of your workshop
• When should it be?
• How long should it be? (is one day enough?)
• What is the most important feature missing from
  the software right now?

11
Questions?