1 / 8

Archive Data to ORACLE

Archive Data to ORACLE. The Prototype PEPII model. Goals of this project. Perform timing tests to see how much data ORACLE can handle. Determine if using ORACLE for archiving is a viable option for the NLC. Allow more data to be archived faster than our current capability allows.

vernal
Download Presentation

Archive Data to ORACLE

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Archive Data to ORACLE The Prototype PEPII model Lee Ann Yasukawa

  2. Goals of this project • Perform timing tests to see how much data ORACLE can handle. • Determine if using ORACLE for archiving is a viable option for the NLC. • Allow more data to be archived faster than our current capability allows. • Provide more insight into problems/trouble areas that the NLC might encounter. Lee Ann Yasukawa

  3. Why Use ORACLE? • ORACLE has been optimizing their database for many years and will continue to do so • There are new features which tailor the database to data warehouses (i.e. partitioning) • ORACLE supports many tools to access and maintain the database (i.e. ORACLE reports, database views, SQL, etc…) • ORACLE supports built-in functions which can be accessed to perform calculations on the data (i.e. mean, standard deviation, min, max, etc.) • SLAC/Stanford has experience with ORACLE and have licenses for it. Lee Ann Yasukawa

  4. The Ultimate Model Java Application Web Browser Web Server Running Corba ORACLE Archive Database Data Collector Data Collector Lee Ann Yasukawa

  5. PEPII Data Archive Path ORACLE Database Public Network NFS Mounted Disk Gateway Gateway PEPII Network IOC IOC IOC Lee Ann Yasukawa

  6. PEPII Archive Data Display Web Browser Web Browser Java Application Local Web Server ORACLE Database Lee Ann Yasukawa

  7. Status of Archive Retrieval Project • Created ORACLE tables to store data • Completed PERL scripts to take data from the Archive Data Manager output and put it into ORACLE • Created a JAVA form to collect archive request data • Working on the path between the archive data request to gathering the actual data and displaying it • Working on making the connection from our local web server to the ORACLE database from a JAVA applet Lee Ann Yasukawa

  8. Status of Archive Request Project • ORACLE request table is created • Need to create script to verify request and insert into ORACLE tables (another project is creating an ORACLE database to hold all device definitions) • Need to modify Archiver to monitor ORACLE request table for archiving changes Lee Ann Yasukawa

More Related