SQL and Islamic Geometric Design

  • Brian WichmannEmail author
Geometer’s Angle


SQL is used as the principle software engineering tool to aid the production of a database of Islamic patterns. These patterns can be found by searching facilities using geometric properties, such the symmetry. The SQL is used to automatically generate HTML for the web site ( The database also covers aspects of the internal documentation which includes the mathematical analysis of the patterns, and photos, if available. Checks are also performed using SQL to verify aspects of the system. The open source implementation of SQL is used to allow the entire system to be run on any computer. Currently, there is no SQL server on the web site, but a simple set of options is used to aid searching.


SQL Islamic geometry Symmetry Web site design Mathematical analysis 



David Wichmann for expertise on SQL and to Tony Lee for expertise on Islamic art. The MySql system has made this work possible with assistance from Welldata Ltd.


  1. S. J. Abas and A. S. Salman. Symmetries of Islamic Geometrical Patterns. World Scientific, Singapore. 1993.zbMATHGoogle Scholar
  2. Mahmood Maher al-Naqsh. Design and execution of drawing in Iranian tilework, Islamic period, Reza Abbasi Museum, 1983.Google Scholar
  3. Catherine Balmelle. Le décor géométrique de la mosaique romaine. Paris, Picard. 2002.Google Scholar
  4. Jay Bonner, Islamic Geometric Patterns. Springer, Berlin. 2016. ISBN 9781441902160zbMATHGoogle Scholar
  5. Jules Bourgoin, Les Eléments de l’art arabe: le trait des entrelacs, Paris 1879. (Patterns available as a Dover reprint,)Google Scholar
  6. Jean-Marc Castéra. Arabesques: Decorative Art in Morocco. ACR Edition, Paris. 1999.Google Scholar
  7. J. H. Conway, H. Burgiel and C. Goodman-Strauss. The symmetries of things. A K Peters Ltd, Natick. 2008.zbMATHGoogle Scholar
  8. B. Grünbaum and G. C. Shephard, Tilings and Patterns, W. H. Freeman & Co., New York, NY, 1987.zbMATHGoogle Scholar
  9. E Herzfeld. Die Ausgrabungen von Sammarra I.. Der Wandschmuck der Bauten von Samarra und seine Ornamentik, Berlin. 1923.Google Scholar
  10. Will Jagy. What Islamic tiling patterns are constructible?
  11. A. J. Lee. Islamic star patterns. Muqarnas vol. 4. pp182-197, 1987.CrossRefGoogle Scholar
  12. Basilio Pavón Maldonado. El arte hispanomusulman en su decoración geométrica. Madrid : Ministerio de Asuntos Exteriores, Instituto Hispano-Arabe de Cultura. 1975. ISBN 8460068811Google Scholar
  13. Gülru Necipoğlu. The Topkapı scroll: geometry and ornament in Islamic architecture. The Getty Center for the History of Art and the Humanities. 1995.Google Scholar
  14. Ögel Semra. Anadolu Selçuklulari’nin taÿs tezyinati. Ankara: Türk Tarih Kurumu Basimevi. 1966.Google Scholar
  15. Javad Shafai. On decoration in Persian architecture and wood carving, Tehran, 1977.Google Scholar
  16. Tiling search web site. Data references to a specific site URL, e,g,. data175/B168 refers to
  17. Victoria and Albert Museum collections website. Individual items are referenced by means of an object number. For object \(n\), see:
  18. David Wade. Pattern in Islamic Art. Studio Vista, London. 1976.Google Scholar
  19. David Wade. Patterns in Islamic Art. The web site: Photos reference in the format EGY 0512.
  20. Hasan ‘Abd-al-Wahhab. Tarikh al-masajid al-athariyah. Cairo, 2 vols in Arabic. 1946.Google Scholar
  21. B. A. Wichmann. The World of Patterns, World Scientific, Singapore. 2001. ISBN 981024619CrossRefzbMATHGoogle Scholar
  22. Brian Wichmann and David Wade. Islamic Design: A mathematical approach. Birkhäuser, Cham, Switzerland. 2017.CrossRefzbMATHGoogle Scholar

Copyright information

© Kim Williams Books, Turin 2019

Authors and Affiliations

  1. 1.WokingUK

Personalised recommendations