110 likes | 249 Vues
Murali Mani. Topics projects in databases and web applications and XML. Database Systems Research Lab Email: mmani @cs.wpi.edu Webpages: http://www.cs.wpi.edu/~ mmani http://davis.wpi.edu/dsrg. Databases making their data accessible to web applications.
E N D
Murali Mani Topics projects in databases and web applications and XML Database Systems Research Lab Email: mmani @cs.wpi.edu Webpages: http://www.cs.wpi.edu/~mmani http://davis.wpi.edu/dsrg
XML Views over Relational DBs Database (Oracle) Xpath/ Xquery mapping XML view
Problem 1 • XQuery SQL Query Processing • Translate query • Retrieve data from database • Return result in XML • Task : Produce “minimal” SQL queries that are efficient, especially re its joins
Problem 2 • XQuery SQL Update Processing • is it translatable • If so, how to translate • If no, give error message • Task : Develop techniques for above three issues, implement and evaluate
Elke A. Rundensteiner Topics projects in database and Information systems, such as, web information systems, distributed databases, Etc. Database Systems Research Lab Email: rundenst@cs.wpi.edu Office: Fuller 238 Phone: x – 5815 Webpages: http://www.cs.wpi.edu/~rundenst http://davis.wpi.edu/dsrg
Project Topics in a Nutshell: • Databases and Visualization: • Visualization-Driven Data Caching • Prefetching based on User Access Patterns • Stream Monitoring Systems: • Querying of Data Streams • Monitoring Applications • Distributed Data Sources: • EVE : Data Warehousing over Distributed Data Sources • TOTAL-ETL : Distributed Extract Transform Load Tools • Web Information Systems: • RAINBOW : XML to Relational Database Management • MASS : Native XQuery Processing System
CAPE : Engine for Querying and Monitoring Streaming Data Example of Stream Data Applications: • Market Analysis • Streams of Stock Exchange Data • Critical Care • Streams of Vital Sign Measurements • Physical Plant Monitoring • Streams of Environmental Readings
Query Query Query Databases Upside Down data static data data Standing queries data Query data data streams of data one-time queries data
MQP Projects in CAPE • Work on core engine, such as query processor, scheduler, query approximator, data shedder, distributer, resource allocator, etc. • Develop full example application, e.g.: TRAFFIC, • Load real data streams : traffic simulation • Develop useful queries, like “average density in city region X over last 5 minute window” • Provide GUI to specify query, eg. By drawing a rectangle over city map. • Supply visual results to traffic monitor, e.g., in charts of time trends.
If Questions, email me:rundenst@cs.wpi.eduor visit DSRG at Fuller 319 & 318.