《DatabaseTheoryanditsimplementationwithPostgreSQLat》.ppt

Database Theory and its implementation with PostgreSQL at an academic environment Toshiyuki ISHIKAWA Japan PostgreSQL Users Group ishikawa@postgresql.jp Thin edge of the Wedge As a consultant to switchover the existing information processing system for renewal at an institute Included college operation and educational software materials Database course had been foresighted since opening the faculty of the Department of Manufacturing Database course would be lectured with Oracle Budget problem PostgreSQL appeared on the scene Then, who will teach? Institute of Technologists Historically, Japan, influenced by China, Korea, and the other countries more than ten thousand years in production technology Blossoming Japan specific production technologies Inheritance of the technology in every field Technologists must be equipped in both theory and practice Students to gain highly realistic experiences Collaboration with industries Institute of Technologists How to balance at an university education Theory vs. Implementation Principle vs. Product Relational algebra vs. SQL Not a SQL language course Composition of the syllabus How PostgreSQL tolerate against principles of database? Will it be neutral in education? Blend in PostgreSQL world Silently imprinting PostgreSQL as OSS Oracle in the real world Matlab vs. Scilab (by INRIA ENPC) Theory and Implementation (continued) Teaching in balance Parallel For example Projection SQL SELECT target list FROM table_name; 3 years experience in teaching PostgreSQL affords in the educational environment without doubt Alert to RDBMS controlled world Stage to lead students to DBA But Could not share enough time for backup storage security performance tuning etc. Any help! *7.11.2009 PGDay.eu technologists (My view at the Institute) The professional person who is specialized in creating something new in the fields of industrial arts of the production sector, making us