Researching Distributed DatabaseTopicTermsOracle LiteSybase UltraLiteDB2 EveryplaceJDBCJDBC (cont’d)JDBC (cont’d)Slide 10ChallengesChallenges (cont’d)Conceptual ApplicationSlide 14Overview of the ProjectE-R DiagramDatabase ModelCRUD MatrixQuestions?CS 8630 Database Administration, Dr. GuimaraesResearching Distributed DatabaseJames TollersonCS 8630, Fall 2005Utilizing Conceptual ApplicationCS 8630 Database Administration, Dr. GuimaraesTopic•Research and Analyze 3 different Databases for (PDAs) –Oracle Lite–Sybase UltraLite–DB2 Everyplace•I am going to demonstrate the process transferring data to and from the PDA. •Challenges•Demonstrate the conceptual applicationCS 8630 Database Administration, Dr. GuimaraesTerms•What is distributed database–Database store on many computers or Personal Digital Assistant (PDA)•What is replication–Distributing a database or subset to other devices•What is mirroring–Similar to replicationCS 8630 Database Administration, Dr. GuimaraesOracle Lite•Offline application execution and data access•Oracle Lite has three components–Small footprint (50kb – 750kb)–Java-enable–Modular object-relational database•Web applications shift between online to offline•J-Connect is a set of options for two-way synchronizationCS 8630 Database Administration, Dr. GuimaraesSybase UltraLite•The uses of adaptive server anywhere approach•Adhere to a small footprint on mobile devices•Ultralite usage of SQL operation to achieve data manipulation•MobiLink server (synchronization)CS 8630 Database Administration, Dr. GuimaraesDB2 Everyplace•Advantages in using DB2 Everyplace is low-power, small footprint, and small form-factor•DB2 has it’s SQL version•Two-way data synchronization utilizing DB2 Everyplace Sync Server. •Disadvantages –Does not support sub-queries–Can not create views–Some object/relational feature not available•Triggers, stored procedures, and user-defined functionsCS 8630 Database Administration, Dr. GuimaraesJDBC•JDBC is the industry standard for Java programs•Four Types of JDBC drivers:–JDBC-ODBC Bridge plus ODBC–A native API partly Java technology-enabled–Pure Java Drive for Database Middleware–Direct-to Database Pure Java DriverCS 8630 Database Administration, Dr. GuimaraesJDBC (cont’d)PDAJDBCDriverSynchronization ServerDatabaseServerCS 8630 Database Administration, Dr. GuimaraesJDBC (cont’d)•Sybase Ultralite–What is UltraLite, Java Edition–Written in Java–Java version of UltraLite has three components•UltraLite JDBC driver•Generated database•UltraLite runtime–SynchronizeCS 8630 Database Administration, Dr. GuimaraesJDBC (cont’d)•Oracle Lite Database–Stateless Object Database Access (SODA)•DB2 Everyplace– JDBC and Sync Server use for any data source that is JDBC enableCS 8630 Database Administration, Dr. GuimaraesChallengesChallenges in PDAs and distributed database system•Not a traditional centralized or distributed database system•Limited bandwidth•Recoverability•Consistency•Updates (patches, software updates, and etc..)CS 8630 Database Administration, Dr. GuimaraesChallenges (cont’d)•Problems during synchronization–Outdated information on the Enterprise DBMS or PDA–Large amount of data on the PDA making the data transfer slow.CS 8630 Database Administration, Dr. GuimaraesConceptual Application•The goal of the project is to research and analysis 3 different distributed database suitable for mobile device especially PDAs. •The conceptual application is called Electronic Data Processor Inventory Tracking System. –What–Why–FutureCS 8630 Database Administration, Dr. GuimaraesConceptual Application•Three key components of the project/application–Suitable distributed database–Synchronization of the data–Concept of the application•Conceptual Application database designCS 8630 Database Administration, Dr. GuimaraesOverview of the ProjectCS 8630 Database Administration, Dr. GuimaraesE-R DiagramCS 8630 Database Administration, Dr. GuimaraesDatabase ModelCS 8630 Database Administration, Dr. GuimaraesCRUD Matrix•C = Create or Insert a Record (row)•R = Read/Query or Select a row•U = Update or Modify•D = Delete Tables USER ELECTRONIC LOCATIONForms DATA PROCESSORSSEARCH R R RDEVICES CRUD CRUD CRUDCS 8630 Database Administration, Dr. GuimaraesQuestions? The
View Full Document