Transcript 490phase1Presentation

Database Data Generator
Presented by: Christopher Jestice
Project Specifications
 The goal of this project is to create a program that quickly and efficiently
generates large amount of data for use in testing and debugging a database.
 The data should be unique when uniqueness is a constraint of the database
 Program should be robust and support more than one RDBMS specification
 While the program is platform specific the platforms the data is built for
should not.
 Object oriented techniques should be utilized.
 User interface should be designed for a programmer with powerful features
but minimize amount of interaction required
Project Specifications
Development Tools
 Microsoft Visual Studio 2010
 Chosen for ease of development.
 Intellisense
 Integrated database tools
 Oracle 10g
 One of the major DBMS available
 Oracle complexity outweighs that of other DBMS
 Microsoft SQL Server
 Major DBMS
 Integrates well with Microsoft products
 Fulfills spectrum of Microsoft vs. Open-Source operating systems
Platform
 Windows 7 x64 (my Computer)
 Solaris 5.8 (Helios)
 Microsoft Windows Server 2008 R2 (my other computer)
Devices

HP Pavilion DV6000




Used for low end computing test
Development Machine/ Power User

AMD Athlon 2 x4 640

MSI 870A-G54 Motherboard

4GB DDR3 1600 Memory
Microsoft Based Server

2 AMD Opteron 2210 Dual Core Server Processors (socket 1207F)

ASUS KFN5-D SLI Motherboard

4 GB DDR2 667 ECC Registered Server Memory
UNIX Based Server

Helios

Utilizing the database developed by winter 2011 CMPS 440 class for testing
Milestones

Investigate Methods for AI development(week 2)

Revise initial design (week 3)

Develop functions to generate specific types of data: (week 4)


Date, currency, timestamp, names, imbalanced types (like gender)
Make DBMS specific protocols (week 6)

Include connection, retrieval, and insertion

Implement Website specific web crawler (week 7)

Design AI protocols (week 9)


Design User Interface (week 9)


Must correlate desired types with minimal errors
Incorporate standard interface functions with symmetrical design layout considerations
Complete final documentation and fine-tuning (week 10)
Important Features
 Use of threading
 Automatic file generation
 Cross DBMS functionality
 AI for string comparison