Title: Integrating Hypermedia Functionality into Database Applications
1Integrating Hypermedia Functionality into
Database Applications
- Anirban Bhaumik,
- Deepti Dixit, Roberto Galnares, Manolis
Tzagarakis, Michalis Vaitis, - Michael Bieber, Vincent Oria, Aparna Krishna,
- Qiang Lu/, Firas Aljallad, Li Zhang
- Collaborative Hypermedia Laboratory, CIS
Department, NJIT, USA - Computer Technology Institute, University of
Patras, Greece Suzhou University, Peoples
Republic of China
2Outline (research agenda)
- Motivation
- DHE - Dynamic Hypermedia Engine
- Basic DB query interface
- Schema support
- DB application support
- Integrating multiple database applications
- Data warehousing
- Data mining
- Database Design Relationship Analysis
current
future
3Motivation
- Most database applications have few links
- Each element could have multiple links
(relationships) - Each element is a potential starting point for
exploring - Research Goal automatically adding links and
services to database applications
4Dynamic Hypermedia Engine
- Automatically generate links and other
hypermedia services for applications - comments, guided tours, etc.
- Automatically integrate applications through
external linking
5Main Application Frame
Metadata
Menus
6(No Transcript)
7(No Transcript)
8(No Transcript)
9Dynamic Hypermedia Engine
- Links generated based on application structure,
not search or lexical analysis - You cannot do a search on the display text
127,322.12 to find related information - But you can find relationships for the element
Sales1997
10Dynamic HypermediaEngine Architecture
11(No Transcript)
12Dynamic HypermediaEngine Architecture
13Relationship Manager
14Dynamic HypermediaEngine Architecture
15(No Transcript)
16Dynamic HypermediaEngine Architecture
17Dynamic HypermediaEngine Architecture
18(No Transcript)
19Dynamic HypermediaEngine Architecture
20Dynamic HypermediaEngine Architecture
21Dynamic HypermediaEngine Architecture
22DHE Contributions
- Only tool that providing automated linking,
metadata, and hypermedia services - based on the application structure (not lexical
analysis) - without altering applications
- for analytical and technical applications that
generate display contents dynamically
23- Basic DB Wrapper
- Provides a simple query interface
- Allows users to make SQL queries directly to a
database - Parses the results
- Passes results to the Relationship Manager to
automatically add links
24- Basic DB Wrapper
- Provides a simple query interface
- Allows users to make SQL queries directly to a
database - Parses the results
- Passes results to the Relationship Manager to
automatically add links
Uses a persistent pool of JDBC Connection Objects
to execute SQL statements and retrieve
metadata. Currently uses physical schema for
metadata Future dedicated metadata repositories,
data dictionaries
25Main Application Frame
Menus
Metadata
List of Links
26Database Element Types
Any instance of these types can be uniquely
identified, have metadata, and relationships.
27Database Element Types
Any instance of these types can be uniquely
identified, have metadata, and relationships. Eac
h type has its own set of generic database
relationship links. For example, an element will
be related to a column, its tuples key field
foreign keys, a table, etc. The DB Wrapper
generates these links automatically.
28Schema Manager Automatically generates
DB-specific links from a machine-readable E-R
schema (e.g., courses taught by a professor)
29(No Transcript)
30(No Transcript)
31(No Transcript)
32DB Application Wrapper identifies elements in
application screens Links DB Wrapper basic
links DB Access Schema Manager E-R links Appl
Wrapper appl-specific links
Existing applications can access database
directly as before New applications could let
the DB wrapper provide all database access
33Outline (research agenda)
- Motivation
- DHE - Dynamic Hypermedia Engine
- Basic DB query interface
- Schema support
- DB application support
- Integrating multiple database applications
- Data warehousing
- Data mining
- Database Design Relationship Analysis
current
future
34DHE can integrate multiple database
applications Each wrapper handles its own
application. Research questions in specifying
related objects across applications in mapping
rules...
35Data Warehousing The DB Wrapper could also load
data into and give other applications access to
a data warehouse
36Data Mining DHE relationships are pre-specified
in mapping rules in the Relationship Manager and
dynamically generated A data mining tool could
dynamically mine relationships for DB application
elements. But how?
37Database DesignRelationship Analysis (RA)
- A systematic approach to finding the implicit or
hidden relationships in an information domain - Relationships can be implemented as links
- RA is a brainstorming technique for domain
experts based on a taxonomy of relationship types
38Database DesignRelationship Analysis (RA)
- Research Questions
- How does RA contrast with standard database
analysis? - Can RA supplement standard database analysis
39Outline (research agenda)
- Motivation
- DHE - Dynamic Hypermedia Engine
- Basic DB query interface
- Schema support
- DB application support
- Integrating multiple database applications
- Data warehousing
- Data mining
- Database Design Relationship Analysis
current
future