80 likes | 182 Views
Academic and Industrial Interactions: Models and Experiences Some Long-term Observations on Successful Industry Projects. Theo Härder haerder@cs.uni-kl.de. The Ancient Times: 1977 - 1994. 5 consecutive research projects DBMS Measurement Techniques
E N D
Academic and Industrial Interactions:Models and ExperiencesSome Long-term Observations on Successful Industry Projects Theo Härder haerder@cs.uni-kl.de
The Ancient Times: 1977 - 1994 • 5 consecutive research projects • DBMS Measurement Techniques • Fault Tolerance and Recovery Issues in DB/DC Systems • Multiprocessor Database Systems • High Performance Transaction Systems • Integrity Control in Relational DBMS • Model • Generous funding: 2 scientific staff members and several student researchers (70% from BMFT, later larger share from Siemens) • Long-term research problems (5 years ahead of development) • Loosely coupled cooperation • Distant partner (Munich 400 km away) • 2 workshops/year in Munich/KL • Donation for AG DBIS: a mid-range computer
UDS The First Project: 1977 - 1981 Research project: DBMS measurement techniques Start conditions: little/no experience, knowledge, competence on both sides Funding:generous funding Overall goals: no specific wishes: do something that is useful for us Partner support: system documentation, internals, page reference strings Tool development: analysis tools, identification of bottlenecks, measurements Own experience: understanding of principles, development of algorithms, proof of concepts, … freedom and time to explore own ideas! Partner:little interest, resources, capacity to implement our concepts Research results: The ACID principle, Buffer Mgmt Algorithms, … Härder T., Reuter, A.: Principles of Transaction-Oriented Database Recovery, in:Comp. Surveys 15: 4, 287-317, 1983. Effelsberg, W., Härder, T.: Principles of Database Buffer Management, in: ACM TODS 9: 4, 560-595, 1984. Missing bilateral involvement prohibits transfer of knowledge, experience, … 3
The Middle Ages • Ph. D. projects • Isolated topics, oriented towards the demand of the funding party • Distant advising – no group integration (bi-monthly visits) • Needs self-reliant and active students • Only works, if students have discussion partners in their home environment • Success 6 x, failure ? (cannot be done on weekends) Not overly attractive, because they do not boost the long-term research of the group • Short-term opportunities • Run specific subprojects for Fraunhofer, DFKI, SAP, etc. • Not very attractive from a research point of view • It does not bring forward running Ph. D. work • But some extra money is always welcome! The definitely better options are DFG-funded research opportunities!
Nowadays • Attractive research opportunities? • Always conflicting: publishing vs. patent applications • Before start, you should haveexperiencewith the company! • Reluctant funding • Short-term contracts with thight and specific research tasks • Research cooperation with Google? • Challenging application • Specific topics, not focused to DBIS • Recommendable for post-docs But general sponsoring programmes
The Ideal Project with Industry Partners • Where do you find the best research environment? • If you want do know the next great DB wave (coming up in ~3 years), go to a research group of a (key) university (Don Haderle, ~1990) • Today: If you want to discover hot topics of the near future, go to the research labs of the DBMS vendors • Ideal Project (quality counts!) • Long-term funding (aligned to a Ph. D. duration) • Focus on systematic research / deep understanding • No pressing deadlines / milestones • Concept-related work, but proof of concepts • Enthusiasm / momentum of game-changing technology EU funding hardly fulfills any of these aspects, but Collaborative Research Centers approximate some of these “ideal properties”.
A New Approach: 2009 Research under conflicting interests University Industry Start conditions: comparable interests, knowledge (?), competence (?) fresh Ph. D. students experienced system architects Overall goals: relevant and novel quality research concepts, visibility system optimizations, intellect. property Funding:? no research money Application parameters: Example: energy efficiency Model: single-flash config multi-device configs (RAID ) Environment: single/dual processors processor complex Data volume: < 10GB 1 PB Concurrency: 10K TPM > 1M TPM Optimization: energy-aware budget-aware Expectations: prototypes applicable results
A New Approach (2) • Loose coupling – only support of knowledge, tools, and data • Enhance/generalize the project results • Quality research money from independent source (DFG) • Benefits of the cooperation • Refinement/extension of our XML research • Application of DB2 page reference strings from various applications • Comparison of XTC with major DBMS products (DB2) • Use of standard benchmarks • TPoX for OLTP • Upcoming variations of TPoX for decision support • Reveal energy efficiency of DB2 components and compare it to XTC • Distant flash-aware reimplementation and evaluation of DB2 components in DB2 (Buffer Mgr) • Future • Specific project support by IBM Center of Advanced Studies (CAS)