Hopewell: Database and Natural Language Development

1
Hopewell Database and Natural Language
Development

• Stacy Brasol
• The College of New Jersey
• Department of Computer Science
• Brasol2_at_tcnj.edu

2
Hopewell Archive Project

• Introduction/Background
• Database Anomalies
• Natural Language / Queries
• Query Interface Users
• Query Interface Developers
• Future Goals

3
(No Transcript)
4
Data Anomalies

• Redundant Storage?
• Update Anomalies?
• Insertion Anomalies?
• Deletion Anomalies?
• Data riddled with redundancies inconsistencies

5
(No Transcript)
6
Natural Language Queries

• Teacher submits natural language query
• Developer translates query into MySQL
• Record of both query response maintained
• Results returned to query originator

7
Query Interface User

• Prototyped using Annotation table
• Annotations maintain pertinent information
  associated with particular curriculum area
• Multi-purpose prototype
• Teachers view annotations from multiple
  perspectives
• Enhance teacher desire to annotate and create
  queries

8
User Interface Prototype
9
Sample Query Results
10
Query Interface Developers

• Secondary Interface
• Deliberate trade-off between automation and
  flexibility
• Primary goal is to save future developers time

11
Developer Interface Prototype
12
Sample Query Results
13
Future Goals

• Establish query log
• Develop patterns based on query log
• Additional automation
• Data edit influenced by queries

14
Conclusion

• Technology to connect users
• User/Developer relationship is iterative