SBIR-STTR Award

Development of a Prototype Local Area Network Schema Server
Award last edited on: 12/23/2014

Sponsored Program
SBIR
Awarding Agency
DOD : AF
Total Award Amount
$528,971
Award Phase
2
Solicitation Topic Code
AF87-062
Principal Investigator
Henry C Lefkovits

Company Information

AOG Systems Corporation

18 Harvard Depot Road
Harvard, MA 01451
   (978) 486-9466
   N/A
   N/A
Location: Single
Congr. District: 03
County: Worcester

Phase I

Contract Number: 30602-88-C-0114
Start Date: 00/00/00    Completed: 00/00/00
Phase I year
1987
Phase I Amount
$49,950
The processing of user queries in local area networks (LANs) where multiple database management systems (DBMS) are being used is addressed in this proposal. The need exists for a LAN facility which accepts query input from any node in the network and performs accesses against each applicable DBMS in the network to retrieve the desired data. In addition to the definition of a common network query language, such as facility requires features to support the de composition of network queries into "subqueries", the distribution of subqueries to each of the resident DBMSS which contain applicable data, the collection of subquery responses, and aggregation of sub query responses into a composite query response. To support these requirements, a "schema server" must be maintained on the LAN which provides a representation of the network schemes, which is a aggregate of all LAN-resident database schemas. Proposed herein is an implementation study for a LAN schema server (LANSS) hardware/software capability which is based on past research by AOG systems corporation Into an integrated data network (IDN) for Rome air development center, and the draft proposed American national standard (DPANS) information resource dictionary system (IRDS).

Phase II

Contract Number: N/A
Start Date: 00/00/00    Completed: 00/00/00
Phase II year
1988
Phase II Amount
$479,021
This proposal addresses the development of a prototype Local Area Network Schema Server (LANSS) which enables the processing of user queries against multiple databases residing in the lan. Heterogeneous DBMSS residing on different kinds of computers are to be supported, and administrator commands will be provided that allow the network schema and network views to be maintained. DBMSS supported in the prototype will be the relational DBMSS Ingers and Oracle, and DBMS, a Codasyl System. Additionally, the user will be allowed to access a text database using keywords that have been assigned to the text. The queries will be decomposed into-subqueries based on meta-data residing in an Information Resource Dictionary System (IRDS), these subqueries are dispatched to the resident DBMSS which contain applicable data, and the subquery responses are aggregated into a composite query response which is returned to the user. The prototype will provide a natural language interface for the user. The work done in Phase I was based on previous work done by aog systems corporation for rome air development center on the design of database utilities and the specification of the standard IRDS.