integrating hypermedia functionality into database applications
Download
Skip this Video
Download Presentation
Integrating Hypermedia Functionality into Database Applications

Loading in 2 Seconds...

play fullscreen
1 / 39

Integrating Hypermedia Functionality into Database Applications - PowerPoint PPT Presentation


  • 133 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Integrating Hypermedia Functionality into Database Applications' - keon


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
integrating hypermedia functionality into database applications

Integrating 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

outline research agenda
Outline (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

motivation
Motivation
  • 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
dynamic hypermedia engine
Dynamic Hypermedia Engine
  • Automatically generate links and other “hypermedia” services for applications:
      • comments, guided tours, etc.
  • Automatically integrate applications through external linking
slide5
Main Application Frame

List of Links

Menus

Metadata

dynamic hypermedia engine9
1997 Sales

1997 Expenses

$127,322.12

$85,101.99

Dynamic 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 Sales[1997]
dhe contributions
DHE 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
slide23
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
slide24
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

slide25
Main Application Frame

Menus

Metadata

List of Links

database element types
Database Element Types

Any instance of these types can be uniquely identified, have metadata, and relationships.

database element types27
Database Element Types

Any instance of these types can be uniquely identified, have metadata, and relationships.

Each type has its own set of generic database relationship links. For example, an element will be related to a column, its tuple’s key field & foreign keys, a table, etc.

The DB Wrapper generates these links automatically.

slide28
Schema Manager

Automatically generates

DB-specific links from a machine-readable E-R schema

(e.g., courses taught by a professor)

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

outline research agenda33
Outline (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

slide34
DHE can integrate

multiple database applications

Each wrapper handles its own application.

Research questions in specifying related objects across applications in mapping rules...

slide35
Data Warehousing

The DB Wrapper could also

load data into and

give other applications access to

a data warehouse

slide36
Data 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?

database design relationship analysis ra
Database Design:Relationship 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
database design relationship analysis ra38
Database Design:Relationship Analysis (RA)

Research Questions:

  • How does RA contrast with standard database analysis?
  • Can RA supplement standard database analysis
outline research agenda39
Outline (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

ad