DBTech
DBTech Pro Leonardo da Vinci
English



 In Finnish . In German . In Greece . In Spanish 
DBTechNet is an initiative of European database lecturers.
DBTech Pro is a development project, running from December 2002 to May 2005. The project is funded by the EU Commission, Leonardo da Vinci programme.

A recorded presentation (Flash file, duration 13 min).

The Need


"Databases today are essential to every business. They are used to maintain internal records, to present data to customers and clients on the World-Wide-Web, and to support many other commercial processes. Databases are likewise found at the core of many scientific investigations. They represent the data gathered by astronomers, by investigators of the human genome, and by biochemists exploring the medicinal properties of proteins, along with many other scientists.

The power of databases comes from a body of knowledge and technology that has developed over several decades and is embodied in specialized software called a database management system, or DBMS, or more colloquially a "database system". A DBMS is a powerful tool for creating and managing large amounts of data efficiently and allowing it to persist over long periods of time, safely. These systems are among the most complex types of software available."

page 1, Database Systems: The Complete Book by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom, Prentice Hall 2001

Databases are everywhere. They provide functionality for client-server applications, for legacy organizational applications, and for both business-to-customer and business-to-business e-commerce applications. They are also used on millions of desktops. Because of this popularity, database processing has become the most important topic in the information systems curriculum. Knowledge of database design, development, administration and access technology is critical for the success of every information systems graduate.

Unfortunately, increased popularity has not meant increased competency. Many students (as well as professionals) have been deceived by the simplicity of creating small databases using products such as Microsoft access. With this background, they believe they know sufficient database technology to create databases that have more complicated structure and greater processing complexity. The result is often a mess: databases are hard to use, barely meet system requirements, and are difficult to redesign."

page xi, Database Processing: Fundamentals, Design, and Implementation by David Kroenke,  Prentice Hall 2003

Reutlingen

Aims and The Mission

Database technology is the corner stone of modern information systems, from small client-server applications up to large enterprise level systems, business-to-business e-commerce applications, etc.   The basic tools providing simple methods for rapid application development are commonly available, which may be useful for small applications, but can be hazardous for building modern, complicated, but reliable enterprise level systems.  Students and aspiring professionals are required to possess more thorough knowledge on database design, application development, database administration, database standards, major DBMS products, as well as on the new trends in an increasing number of technologies that gradually get amalgamated into the modern DBMS environment, extending its functionality and broadening its applicability and use.

DBTech Pro project will determine the essential knowledge area of database technology covering the related standards, specifications, technology trends and understanding of the mainstream DBMS products. The project will plan, develop and pilot test course modules, methods and laboratory exercises to be used on advanced courses in schools and in further training for professionals.

The project will also investigate possibilities to develop a vendor-independent European certificate of Database Professional.

Meeting

For The Companies

For the companies in the long term:
  • Highly skilled work force
  • Professional ability
  • Competitiveness
  • Recognized European certificate for staff


Objectives for The Project

All learning material will be available for students and lecturers in the partner polytechnics and universities.  It will also be possible to give Web-based courses on the Internet.  The course modules and exams will provide equal learning opportunities for professionals working anywhere in Europe to update their knowledge and skills.

Concrete results of the project include:

  • Course descriptions covering all the major areas of expertise in the database technology
  • Study labs together with required documentation in English to be used over the Internet (documentation also available in Finnish, German, Greek, and Spanish if necessary)
  • Specification of examinations and tests
  • Project evaluation reports to be collected from the partner companies according to application area knowledge and results
  • Pedagogic evaluation report on the results

The partner enterprises in the DBTech Pro project have an important role in specifying the expertise area and evaluating the content of study modules and lab exercises. Special attention will be paid to the pedagogic evaluation of the course modules and workshops.


Malaga
Helsinki

Workshops

Beside the pilot tests there will be 4 major pedagogically monitored workshops in different countries consisting of presentations on selected topics and laboratory exercises for students and local industry representatives.  The themes for the workshops are the following:

  • Concurrency control and recovery technologies (Thessaloniki, Greece, Nov 2003)
  • Database Design Methodologies (Malaga, Spain, May 2004)
  • Data Warehousing and Data Mining (Reutlingen, Germany, Nov 2004)
  • XML and Databases (Helsinki, Finland, April 2005)
Paneeli


Work Packages of The Project

The DBTech Pro project has been divided into nine work packages with named WP leader

WP1    Management

Helia, Tiina Junkkari:

Project management, financial administration

WP2    Knowledge Areas

University of Paisley, Thomas Connolly: 

Specification of skills needed for an European DBTech professional
Final Report of WP2 (PDF file)

WP3    Teaching Practices and Labs, Tests

Häme Polytechnic, Jaakko Rantanen:

Analysis of teaching methods and testing in different modules, specifying, setting up and documenting laboratories, and pilot testing together with pedagogues
Combined Final Reports of WP3, WP5 and WP9 (a PDF file)
Appendices to the WP3 Final Report (PDF file)
 

WP4    Content planning and tests

T.E.I. of Thessaloniki, Dimitris Dervos:

Develop the skills specificity in WP2 to learning tasks and contents, course syllabuses, Co-operation with the pedagogic evaluator
WP4 Final Report (a PDF file)


WP5    Pilots

Reutlingen University, Fritz Laux:

Pilot runs of training in partner organisations in three semesters, follow-up and documentation control
Combined Final Reports of WP3, WP5 and WP9 (a PDF file)

WP6    Assemble of the DBTech Pro Certificate

University of Macedonia, Georgios Evangelidis:

Gathering the experiences from WP2, WP3 and WP4, determination of levels of aspiration, checking the pilot runs and defining the need for further development work.  Survey for the need of a vendor-independent certificate of database professional
WP6 Final Report (a PDF file)

WP7    Evaluation

University of Malaga, José F. Aldana-Montes:

Documentation and control of assessment activities both internal and external, Pedagogic evaluation both of the learning process and the results. This work package will collect all previous evaluation reports.
WP7 Final Report (a PDF file)

WP8    Dissemination

Helia, Martti Laiho:

Meetings with companies, seminars, articles.  Documentation and control of dissemination activities during the whole project period

WP9    Workshops

Helia, Kari Silpiö:

Specification of the DBTech Pro Workshop concept and format, follow up of the workshops.
Combined Final Reports of WP3, WP5 and WP9 (a PDF file)



Lab exercise

DBTech Pro Project Partner Organizations

Contractor and coordinator:
•    Helia (Helsinki Business Polytechnic), Helsinki, Finland

Partners:
•    ALTEC S.A., Greece
•   
University of Reutlingen, Germany
•    HAMK, Häme Polytechnic, Hämeenlinna, Finland
•    Solid EMEA North,
Finland
•    T.E.I.  Thessaloniki,
Greece
•    TietoEnator Public Sector, Finland
•    University of Macedonia,  Thessaloniki,
Greece
•    Universidad de Málaga, Spain
•    University of Paisley, United Kingdom

Reutlingen Malaga

www.DBTechNet.org