Database Research and Application Activities at NPAC Major Database Application Areas: 1. Telemedicine - CareWeb, Patient Record Database 2. Education - ThinkQuest, NewsBank tec. 3. Manufacturing and Electronic Commerce - Carrier 4. Document Publishing - NPAC Internal Technical Report Database 5. Chemistry - AskNPAC Chemistry Data Repository 6. Multimedia - Image Databases, VOD 7. Geographic Information System - 3D Terrain Rendering with Illustra Database Backend Database Infrastruacture at NPAC: 1. Illustra server on a SGI 2. Oracle 7.3 RDBMS (parallel server and parallel query options) on IBM SP2 and nCUBE2 3. Two Oracle 7 RDBMS production servers on an IBM RS/6000 and a SUN Solaris 4. One Oracle 7 RDBMS development server on a SUN10 5. One Oracle 7 RDBMS server for educational classes 6. DB2 Parallel Edition software on IBM SP2 (for benchmarking only) 7. > 160 GB disk space for database projects Research & development of core database technology: 1. Integration of Relational Database Technology in World Wide Web and Internet . AskNPAC: Email-based Messaging and Conferencing Systems and Data Repository for Internet collaboration and Search . Searchable USENET Newsgroup and Mailing List Archive (http://asknpac.npac.syr.edu) . Online WWW-based Chat system . AskNPAC Chemistry --- Chemistry Domain Specific Information Repository . Mailing List Archives for NPAC Projects (http://kayak.npac.syr.edu:1963/cgi-bin/admcode/asknpac) . RDBMS-based WebMail --- Email Repository and Search Engine for Personal Mailbox Management . RDBMS Support for Video-on-demand (http://kayak.npac.syr.edu:6578/index.html) . indexing of close-caption in video clips . Video server mangement . Search in digital video clips . New York State Image Database for Education and Tourism (http://kayak.npac.syr.edu:1963/cgi-bin/NYSJ/wow/JOURNEY.showcategory('all')) . A large collection and catalog of NYS images . Annotated text description of images for navigation and search . Web search and navigation interface for easy access and viewing . Other educational databases . K-12 WhaleNet and EnviroNet Database . BirdWatch Database . News Source Database in Living Schoolbook . Patient Record Database (http://kayak.npac.syr.edu:1200/db/Main.html) 2. Evaluation of Parallel Database Technology and its applications in large-scale information systems . Benchmarking of Parallel Relational Database Management Systems on High-performance Distributed and Parallel Machines . TPCD (Decision Support System) Benchmarking of Parallel Oracle 7 and DB2 on a nCUBE2 and an IBM SP2 . Benchmarking of Parallel Data Mining Software on an IBM SP2 . Use of High-Performance RDBMS-based Servers in Web Applications . Multiple compute nodes to access the same database . support large number of concurrent database users and very large database volume . Web interface for global access, linking high-performance server technology into pervasive Internet applications 3. Full-text Search in WWW information space . ThinkQuest Search System . ThinkQuest is an annual contest for students in grades 7-12 to use the Internet as a collaborative, interactive teaching and learning tool . NPAC provides a Web search service to the ThinkQuest program (http://www.npac.syr.edu/thinkquest/pub) . NewsBank Search . Full-text context-based search in newspaper articles . An educational resource for teachers and students to seek educational information and materials for classroom use . Text Materials from CD Rom Distribution into Web/Database Client-Server System . Web-based search interface (http://naos.npac.syr.edu:1972/search/search.html) . Customized Web Site Search (http://kayak.npac.syr.edu:1963/search/index.html) . NPAC Web server . Online Books . Online Presentations and Foils 4. Database Support in Web-based Information and Collaborative Systems . CareWeb Project (http://www.npac.syr.edu/projects/careweb/) . offer interactive and current health-education database resources for school nurses, nurse practitioners, nursing students, school children, and parents . Components include a community database, student health record database, and other Web-based educational resources . assesment data, medical diagnosis, and treatment plan are recorded in a central database . Uses pervasive revolutionary Web Technologies, including video conferencing, shared database access, and interactive collaboation via Internet. . . Collaborative Interaction and Visualization for Command and Control Application . Access to a RDBMS from Java Programs (JDBC) . A central database for user management and session control in a collaborative system . All Collaboration Events can be recorded in the central database for playback and simulation 5. Object-Oriented Database and Visualization . Illustra Object-Oriented Relational Database backend for managing and generating GIS data objects . VRML front-end for 3D interactive data visualization and navigation . Real time navigation and construction of terrain images . Annotation of 3D objects linking to Web pages 6. Web-based Enterpreise Intranet Information Systems . Carrier project for external catalog and internal databases . Electronic commerice over Intranet and Internet Tango - A Java/WWW Based Collaborative Framework for Internet distance education and remote collaboration . An Integration software infrastracture for conducting interactive collaboration over Internet . Communication backbone for User management, Session Control, message passing, event routing and server management . Monitoring and storage of actions and event . Simple Java API allows modification and addition of porting standalone applications into collaborative mode . Key components technology: Java, Web Browser, RDBMS. . easy distribution and installation, multiple platforms (UNIX,PC) and easy to use . http://www.npac.syr.edu/tango