120 likes | 541 Views
Self Checkout Shopping Cart. CSC 335: Database System Concepts Term Project. Aaron Klor and Dan Matz Missouri State University. Functionality Recap. Transacting Administrating Product add/edit/remove User add/edit/remove Transaction view/delete/output. Database. Object database
E N D
Self Checkout Shopping Cart CSC 335: Database System Concepts Term Project Aaron Klor and Dan Matz Missouri State University
Functionality Recap • Transacting • Administrating • Product add/edit/remove • User add/edit/remove • Transaction view/delete/output
Database • Object database • NOT Relational database • NO SQL • Entirely object based • Just “store” objects • Well suited for high-order, object-oriented languages
DB4O • Database 4 Objects • Single-file database • Similar to SQLite • Can be configured for client/server • Available for Java and .NET languages • GPL license model
DB4O Usage • Import library • Database access methods/classes
Objects • Product, Transaction, User • All extend DatabaseObject • Database Object • Provided by us • Abstract class • Provides super type • ID • ImageLocation
Not Relational, But • Some terms still apply: • ER Diagramming still useful • Specialization important – “IS A” • Schema diagrams still useful • Constraints • Foreign keys • Functional dependencies • Others do not • Normal forms • Used for column normalization – No columns!
Technologies • Java – Language • http://java.sun.com/ • Eclipse – IDE • http://www.eclipse.org/ • Eclipse SWT - Cross-Platform Frontend Library • http://www.eclipse.org/swt/ • DB4O – Database • http://www.db4o.com/ • Google Project Hosting • http://code.google.com/p/databaseprojectcsc335fa09/ • Mercurial