Murali Mani

1
Murali Mani
Topics projects in databases and web
applications and XML
Database Systems Research Lab Email mmani
_at_cs.wpi.edu Webpages
http//www.cs.wpi.edu/mmani http//davi
s.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
Area 1 ER-2-XML

• Convert ER Schemas to XML Schemas
• Ideas
• Extend ER Model to capture more semantics
• Map extended ER Model into an XML schema
• Retrieve data from database
• Return result in XML
• Status initial tool implemented by prior MQP
  team and available for download.
• Paper published in XSym04.

5
Area 2 Updating XML Views of Relational Databases

• CoT defines a specific XML View over RDB
• Tasks
• Study how to translate updates specified over
  such views
• Develop simple translations for insert, delete
  and modify\
• Status Prior MQP team has worked on this, more
  cases can be added.

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

• 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

• Databases and Visualization
• Visualization-Driven Data Caching
• Prefetching based on User Access Patterns
• Stream Monitoring Systems
• Query Engine of Data Streams
• Monitoring Applications Motion

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

• Develop new services for core engine
• Scheduler of query flow graphs
• Data shedder under fluctuating loads
• Distributed query processing
• Develop stream applications
• e.g. TRAFFIC, SENSORS, HEALTH,
• Load real data streams traffic simulation
• Develop useful queries, like average density in
  city region X over last 5 minute window
• Provide usable GUI and visual result for
  monitoring

11
TotalETL MQP Projects

• General Data warehousing and collaboration
  workflow management tool suites
• Current MQP Project Developed a collaboration
  server, complete with session manager, project
  manager, job scheduler, and project repository.
• Proposed MQP Projects
• Extend collaboration server to support scalable
  project execution by utilizing cluster of
  machines, java concurrent thread libraries for
  parallel project flows, better scheduling.
• Develop client (GUI) that enables users to
  collaborative develop projects, as well as
  administrator GUI to monitor status of project
  executions.

12
If Questions, email merundenst_at_cs.wpi.eduor
visit DSRG at Fuller 319 318.