1 / 11

Murali Mani

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.

august-curry
Download Presentation

Murali Mani

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. Databases making their data accessible to web applications.

  3. XML Views over Relational DBs Database (Oracle) Xpath/ Xquery mapping XML view

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. Query Query Query Databases Upside Down data static data data Standing queries data Query data data streams of data one-time queries data

  10. 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.

  11. If Questions, email me:rundenst@cs.wpi.eduor visit DSRG at Fuller 319 & 318.

More Related