Award Abstract # 0741620
SGER: An Exploration of the Presentation Data Model

NSF Org: IIS
Division of Information & Intelligent Systems
Recipient: REGENTS OF THE UNIVERSITY OF MICHIGAN
Initial Amendment Date: September 11, 2007
Latest Amendment Date: July 24, 2009
Award Number: 0741620
Award Instrument: Standard Grant
Program Manager: Gia-Loi Le Gruenwald
IIS
 Division of Information & Intelligent Systems
CSE
 Directorate for Computer and Information Science and Engineering
Start Date: September 15, 2007
End Date: February 28, 2010 (Estimated)
Total Intended Award Amount: $0.00
Total Awarded Amount to Date: $149,998.00
Funds Obligated to Date: FY 2007 = $149,998.00
History of Investigator:
  • Hosagrahar Jagadish (Principal Investigator)
    jag@umich.edu
Recipient Sponsored Research Office: Regents of the University of Michigan - Ann Arbor
1109 GEDDES AVE STE 3300
ANN ARBOR
MI  US  48109-1015
(734)763-6438
Sponsor Congressional District: 06
Primary Place of Performance: Regents of the University of Michigan - Ann Arbor
1109 GEDDES AVE STE 3300
ANN ARBOR
MI  US  48109-1015
Primary Place of Performance
Congressional District:
06
Unique Entity Identifier (UEI): GNJ7BBP73WE9
Parent UEI:
NSF Program(s): Info Integration & Informatics
Primary Program Source: app-0107 
Program Reference Code(s): 7364, 9216, 9237, HPCC
Program Element Code(s): 736400
Award Agency Code: 4900
Fund Agency Code: 4900
Assistance Listing Number(s): 47.070

ABSTRACT

This high-risk, high-payoff project seeks to make database management systems much more usable than they are today, through the introduction of a new presentation data model. Traditionally, database management systems have had two conceptual layers -- a physical layer comprising the actual implementation and a logical layer comprising a formal decomposition of a database into tables, rows, constraints, etc. The user interacts with the logical layer, and is shielded from physical layer implementation details. This project introduces a new presentation layer above the traditional logical layer. The user interacts with this presentation layer, and is shielded from logical layer details such as relational decomposition and joins. Through this means the root cause underlying much of the complexity of interacting with traditional database systems is eliminated. This project includes work both to develop the theoretical underpinnings of the presentation data model as well as to construct a prototype system representing a vertical slice through the three layers.

The broader impact of this project is in the potential for this project to greatly improve the way databases are used, not just by computer scientists but also by researchers in other disciplines and by the public at large. The project directly supports the training of one doctoral student, and indirectly impacts the education and training of several additional students, both graduate and undergraduate, through their participation in directed projects. The project web-site is http://www.eecs.umich.edu/db/usable

PUBLICATIONS PRODUCED AS A RESULT OF THIS RESEARCH

Note:  When clicking on a Digital Object Identifier (DOI) number, you will be taken to an external site maintained by the publisher. Some full text articles may not yet be available without a charge during the embargo (administrative interval).

Some links on this page may take you to non-federal websites. Their policies may differ from this site.

Arnab Nandi and H. V. Jagadish "Qunits: queried units in database search" Proc. CIDR , 2009
Bin Liu, H. V. Jagadish "A Spreadsheet Algebra for a Direct Data Manipulation Query Interface" ICDE , 2009 , p.417
Bin Liu, H. V. Jagadish "DataLens: making a good first impression" SIGMOD Conference , 2009 1115

Please report errors in award information by writing to: awardsearch@nsf.gov.

Print this page

Back to Top of page