Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Automating Reference Data

description
by

Karen Lopez

on 19 January 2011

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Automating Reference Data

Automating Reference Data, Generalized Models and Codes
Tips for Getting it Right
Karen Lopez, ISP
Sr. Project Manager
InfoAdvisors
Codes & Reference Data
Non-transactional
Controling or Informational
Generalizations
"lookup tables"
...is it all really different from other data?
Structure
Content
+
Codes & Reference Data
Anti-patterns
One man's look up table is
another man's strategic data
10 Tips for Managing Reference Data & Codes
1. Know which entities are Codes & Reference Data
2. Manage in a database...with RI turned on...and constraints...and....
3. Version data
4. Monitor modifications - automatically
5. Monitor database configurations
6. Compare Structure and Content
7. Compare what data developers & DBAs are using...& QA, too.
8. Data Architects should monitor data for QA and Production
10. Make it easy for team members to keep in sync
9. Use Issue and Change Management Systems
Karen Lopez
www.infoadvisors.com

@datachick
karenlopez@infoadvisors.com
What to put in Data Model?
Subtype Discriminators
< 7 values
Very stable, simple data
Follow me
on Twitter
Generalizations
Structures become DATA
Using generalized approaches changes where data architecture is applied...but not what needs to be done
www.speakerrate.com/karenlopez
Please ask questions at any time
Full transcript