Toshiyuki ISHIKAWA
Download
Report
Transcript Toshiyuki ISHIKAWA
Database
Theory and its implementation
with PostgreSQL
at an academic environment
Toshiyuki ISHIKAWA
Japan PostgreSQL Users Group
[email protected]
7.11.2009 PGDay.eu
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?
7.11.2009 PGDay.eu
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
7.11.2009 PGDay.eu
Institute of Technologists
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
use of individual wisdom, skills,
and techniques, to attain to be a
maestro.
7.11.2009 PGDay.eu
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)
7.11.2009 PGDay.eu
Theory and Implementation
(continued)
Teaching in balance
Parallel
For example
Projection
SQL
SELECT target list FROM table_name;
7.11.2009 PGDay.eu
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