Database Design and Use

1
Database Design and Use

• Mark Stiegemeier
• Chairman and CEO
• CRISNet by MEGG Associates Inc.

2
Database Design and Use

• Data Centric Web Applications
• Database Instance and Access
• Data Access from Script
• Lessons Learned
• Examples
• QA

3
Data Centric Web Applications

• Structured, Relational Information
• Persistent and Transactional Data
• User Registry and Personalization
• Application Level User Management
• Dynamic Content
• Page components maintained as database items

4
Database Instance and Access

• Legacy and Operational Databases
• Data Warehouses and Data Marts
• Access Methodology and Tools
• Open Database Connectivity - ODBC
• Universal Data Access - UDA
• OLE DB and ADO

5
ADO and Web Applications
?Browser
?HTTP with XML
?IIS (asp), MTX, MSMQ
?SQL 7.0, Oracle 8i, Notes, Exchange, etc.
6
Lessons Learned

• The Web Developer
• Is not a DBA or a Graphic Designer
• Avoid Repetitive Roundtrips
• Dynamic Code Tables for Longevity
• Close/Release Record Sets!
• Get Small with XML
• What Standards? The ones that work
• Forms vs. Documents

7
Examples

• NetRMS
• Police Records and Document Management
• CRISNet Cruiser
• Intelligent Client

8
QA

• Mark Stiegemeier
• CRISNet (MEGG Associates Inc.)
• http//www.crisnet.com
• marks_at_crisnet.com
• [phone] x107