Creating a Database of Peonies and Its Use for Teaching IT Courses

DOI 10.7160/aol.2017.090205
No 2/2017, June
pp. 59-66

Havlíček, Z., Lohr, V., Junek, P. and Rajtr, J. (2017) “Creating a Database of Peonies and Its Use for Teaching IT Courses", AGRIS on-line Papers in Economics and Informatics, Vol. 9, No. 2, pp. 59 - 66. ISSN 1804-1930. DOI 10.7160/aol.2017.090205.


The aim of this paper is to describe one of the possible ways of making IT courses more interesting through collecting practical eld data and a subsequent creation of databases. Since the establishment of a specialized peony garden near Prague in 2008, details of the origin of acquired plants and of their cultivation under local conditions have been continuously recorded. The data resulting from the peony research are used as support for our IT courses. They are used in practical modelling of a relational database and in creating student projects focused on responsive web designs. The peonies data make the IT courses more attractive and stimulating for students.Literature survey of the peony research publications and our own data obtained from the peony garden revealed some of the main problems in cultivating and identi cation of peonies. Herbaceous peonies are widespread perennials. Mostly "historical" varieties of Paeonia lacti ora are cultivated. However, these plants have long and weak stems, which are bent down by heavy owers and must therefore be mechanically held up by stakes or support rings. By contrast, the new cultivars have solid stems, such as the hybrid herbaceous peonies and intersectional hybrids (Itoh hybrids) and do not require as much labour but are not commonly cultivated. Our research has discovered that most peony cultivars in home gardens have not been properly identi ed. Great emphasis has, therefore, been placed on the correct identi cation of peony cultivars.


IT, peony, Paeonia, cultivar identi cation, database, responsive web design.


  1. Gilmore, B., Bassil, N., Nyberg, A., Knaus, B., Smith, D., Barney, D. L., and Hummer, K. (2013) “Microsatellite Marker Development in Peony using Next Generation Sequencing”, Journal of the American Society for Horticultural Science, Vol. 138, No. 1, p. 64-74. ISSN: 0003-1062.
  2. Hodgson, L. (2011) “La Bible des Vivaces du jardinier paresseux”, Ottawa: Broquet Inc. ISBN: 978-2-89654-147-8.
  3. Hollingsworth, D. (2016) “Hollingsworth Peonies”. [Online]. Available: http://www. [Accessed: Oct 24, 2016].
  4. Hao, Q., Liu, Z., Shu, Q., Zhang, R., De Rick, J. and Wang L. (2008) “Studies on Paeonia cultivars and hybrids identi cation based on SRAP analysis”, Hereditas. [Online]. Available: [Accessed: Nov 15, 2016]. ISSN 0018-0661. DOI 10.1111/j.0018-0661.2008.2013.x.
  5. Havlíček, Z., Lohr, V. and Benda, P. (2010) “ICT Support for Agritourism”. In: AGRARIAN PERSPECTIVES XIX.. Prague: Czech University of Life Sciences Prague, p. 327-334. ISBN 978-80-213-2123-6.
  6. Jakubowski, R. (2016) “Registry APS Form”. [Online]. Available http://www.americanpeonysociety. org/cultivar-registration/cultivar-registration-info [Accessed: Oct 24, 2016].
  7. Kamenetsky, R. and Dole, J. (2012) “Herbaceous Peony (Paeonia): Genetics, Physiology and Cut Flower Production. Floriculture and Ornamental”. Biotechnology, Vol. 2012, No. 6, p. 62 - 77.
  8. (2016) “ Catalogues, databases and websites about peonies created by students of CULS“, Prague: CULS – PEF. [Online]. Available: http://kitlab.pef.czu. cz/1516zs/ete89e/08/catalog [Accessed: Nov. 24, 2016].
  9. Klehm, R. (2016) “Klehm s Song Sparrow Farm and Nursery”. [Online]. Available online http:// [Accessed: Aug. 16, 2016].
  10. Lagakos, S. (2010) “Recent advances in applied mathematics: proceedings of the American Conference on Applied Mathematics (AMERICAN-MATH ’10), Educational quality systems and new technologies trend“, World Scienti c and Engineering Academy and Society, Harvard University, Cambridge, USA, January 27 - 29, 2010. Athen: WSEAS Press. ISBN 978-960-4741-502.
  11. Mehrabi, M., Zargari, M., Ghanbari, M. and Shayegan, M. A. (2016) “Fast content access and retrieval of JPEG compressed images“, Signal Processing: Image Communication. p. 54-59. [Online]. Available: [Accessed: Nov. 24, 2016]. ISSN 09235965. DOI 10.1016/j.image.2016.05.005.
  12. Örtegren, H. (2012) “The scope of digital image media in art education“, Computers. Vol. 59, No. 2, [Online]. Available: [Accessed: Nov. 2, 2016]. ISSN 03601315. DOI 10.1016/j.compedu.2012.03.021.
  13. Page, M. (2005) “The gardener ́s peony: herbaceous and tree peonies”. Portland: Timber Press. ISBN 0-88192-694-9.
  14. Rivière, J. L. and Nédélec, P. (2009) “Rouge Pivoine”. Paris: Marabout. ISBN 978-2-501-05935-0.
  15. Rivière, M. (1992) “Le monde fabuleux des pivoines”. Massy: Floraprint. ISBN 2-900069-35-1.
  16. Rogers, A. (1995) “Peonies”. Portland: Timber Press. ISBN 978-088192-662-0.
  17. Sekerka, P. (2004) “Pivoňky”. Prague: Grada Publishing. ISBN 80-247-0819-1.
  18. Šimek, P., Stočes, M., Vaněk, J. and Masner, J. (2015) “Mobile accessibility of information sources in the areas of agriculture, forestry, water management, food industry and rural development”. Prague. AGRARIAN PERSPECTIVES XXIV. Prague: Czech University of Life Sciences Prague, 2010, p. 433-439. [Online]. Available [Accessed: Sept. 20, 2016]. ISBN 978-80-213-2581-4. ISSN 2464-4781.
  19. Warmerdam, R. (2016). “Warmerdam Paeonia”. [Online]. Available https://www.paeoniapassion. com/ [Accessed: Aug. 16, 2016].

Full paper

  Full paper (.pdf, 1.79 MB).