Intelligent EnvironmentsDatabases for Intelligent EnvironmentsSlide 3Database RequirementsData Storage RequirementsSlide 6Slide 7Slide 8Database TechnologiesDB2EmpressInformixOracleMS AccessMS SQLSybaseBerkeley DBMySQLPostgreSQLSlide 20Database BenchmarkingTPC-C BenchmarkTPC-H BenchmarkTPC-R BenchmarkTPC-W BenchmarkTPC ResultsSlide 27Other BenchmarksAnalysisSlide 30Database ArchitectureSensor Database SystemsSiemens NetabaseSlide 34SmartHome Database ArchitectureSlide 36UTA MavHome Smart HomeIntelligent Environments 1Intelligent EnvironmentsComputer Science and EngineeringUniversity of Texas at ArlingtonIntelligent Environments 2Databases for Intelligent EnvironmentsRequirementsTechnologiesEvaluationArchitectureIntelligent Environments 3Intelligent EnvironmentsDatabase RequirementsIntelligent Environments 4Database RequirementsIntelligent Environments 5Data Storage RequirementsSensor dataTemperature (15 @ 8 Kbps)Humidity (15 @ 8 Kbps)Gas (15 @ 8 Kbps)Light (15 @ 8 Kbps)Motion (15 @ 8 Kbps)Pressure (100 @ 8 Kbps)Microphone (15 @ 500 Kbps)Camera (15 @ 10 Mbps)Intelligent Environments 6Data Storage RequirementsUser dataMultimediaPhone messages/conversations (500 Kbps – 10 Mbps)Music (500 Kbps)TV/Radio broadcasts (500 Kbps – 10 Mbps)Home movies (10 Mbps)ImagesComputerProgramsData filesOperating systemsIntelligent Environments 7Data Storage RequirementsIssuesQuery frequency and typeSampling/recording rates205 sensors (158,900 Kbps)Multimedia recordingsSimultaneous playbackAnalysis, prediction, decision-making queriesTransaction granularityHistorical data, decaySecurity and privacyCentralized vs. distributedIntelligent Environments 8Intelligent EnvironmentsDatabase TechnologiesIntelligent Environments 9Database TechnologiesCommercialDB2EmpressInformixOracleMS AccessMS SQLSybaseFreeBerkeley DBPostgreSQLMySQLIntelligent Environments 10DB2Vendor: IBMAvailability: Commercial ($300)www.ibm.com/software/data/db2FeaturesComprehensiveIntelligent Environments 11EmpressVendor: EmpressAvailability: Commercial ($ call)www.empress.com FeaturesDesigned for embedded, real-time applicationsIntelligent Environments 12InformixVendor: IBM (acquired from Informix)Availability: Commercial ($ call)www.ibm.com/software/data/informix FeaturesParallel databasesObject relationalIntelligent Environments 13OracleVendor: OracleAvailability: Commercial ($300)www.oracle.comFeaturesComprehensiveIntelligent Environments 14MS AccessVendor: MicrosoftAvailability: Commerical ($329 with Office Professional)www.microsoft.com/office/accessGeneral purposeDesigned for individual usersIntelligent Environments 15MS SQLVendor: MicrosoftAvailability: Commercial ($5,000)www.microsoft.com/sqlFeaturesGeneral purposeDesigned for enterprise usersIntelligent Environments 16SybaseVendor: SybaseAvailability: Commercial ($1,000)www.sybase.comFeaturesGeneral purposeIntelligent Environments 17Berkeley DBVendor: UC BerkeleyAvailability: Freewww.sleepycat.comFeaturesDesigned for embedded systems applicationsIntelligent Environments 18MySQLVendor: MySQLAvailability: Freewww.mysql.comFeaturesGeneral purposeIntelligent Environments 19PostgreSQLVendor: Open source effortAvailability: Freewww.postgresql.orgFeaturesGeneral purposeIntelligent Environments 20Intelligent EnvironmentsDatabase EvaluationIntelligent Environments 21Database BenchmarkingTransaction Processing Performance Council (TPC)www.tpc.orgRigorously-defined benchmarksIndependent regulatory bodyTPC benchmarksTPC-C, TPC-H, TPC-R, TPC-WIntelligent Environments 22TPC-C BenchmarkSimulates complete computing environmentMultiple users executing transactions against a databaseOrder-entry scenarioEntering and delivering ordersRecording paymentsChecking order statusInventory monitoringMetricsTransactions per minute (tpmC)Price per transaction ($/tpmC)Intelligent Environments 23TPC-H BenchmarkDecision support benchmarkExamine large volumes of dataAnswers to critical business questionsComplex queriesData modificationsMetricsComposite Query-per-Hour Performance Metric (QphH@Size, $/QphH@Size)Size of databaseSingle-stream query processing powerConcurrent query throughputIntelligent Environments 24TPC-R BenchmarkDecision support benchmarkSimilar to TPC-HAdvanced knowledge of queriesAllows optimizationMetricsComposite Query-per-Hour Performance Metric (QphR@Size, $/QphR@Size)Intelligent Environments 25TPC-W BenchmarkWeb transactions benchmarkE-commerce scenarioMultiple browser sessionsDynamic page generation with database access and updateSimultaneous transaction executionHeterogeneous database tables (sizes, attributes, relationships)MetricsWeb interactions processed per second (WIPS, $/WIPS)Intelligent Environments 26TPC ResultsBestTPC-C709,220 tpmC (MS SQL)TPC-H100GB: 5578 QphH (Oracle)300GB: 5976 QphH (Oracle)1000GB: 25,805 QphH (Oracle)3000GB: 79,528 QphH (Teradata)10,000GB: 81,501 QphH (Teradata)Intelligent Environments 27TPC ResultsBestTPC-R100GB: 4442 QphR (Oracle)TPC-W10,000 items: 21,139 WIPS (MS SQL)100,000 items: 10,439 WIPS (MS SQL)More results at www.tpc.orgIntelligent Environments 28Other BenchmarksWisconsinRelational queriesAS3APANSI SQL Scalable and Portable benchmarkMix of transactions, relational queries, and utility functionsOpen Source Database Benchmark (OSDB)Based on AS3APIntelligent Environments 29AnalysisHigh-end database transaction processing power600,000 tpm = 10,000 tpsSensor recording transactions15 temp/hum/gas/light/motion, 100 pres175 tps15 cameras (30 fps) / 15 microphones (64 Kbps)465 tps, or 120,450 tps (one-byte mic transactions)Multimedia recording transactionsPrediction and decision-making queriesSystem informationIntelligent Environments 30Intelligent EnvironmentsDatabase ArchitectureIntelligent Environments 31Database ArchitectureIssues (again)Query frequency and typeSensorsMultimedia recording and playbackAnalysis, prediction, decision-making queriesUser dataSystem informationTransaction granularityHistorical data,