Publikálás dátuma 2015.03.10. 5:30
One of the objectives of the KNOWGATE project is to share information resources among CSIR laboratries. One way to achieve this objective is to create integrated library system (ILS). MySQL is (as of July 2013) the world's second most widely used relational database management system (RDBMS) and most widely used open-source RDBMS. Koha for backend with cataloguing data stored in MARC, preferred SQL database MySQL. For better understanding of SQL and using RDBMS prepared MySQL database presentation with example text file. SQL knowledge help in generating report in KOHA, which directly intract with KOHA MySQL database. For more detail see
KOHA reporting and
SQL example for reporting purpose.
The following presentation are prepared by KNOWGATE Team for training on Open Source ILS using KOHA. Download KOHA presentation files from below Related Assets For more information:
http://en.wikipedia.org/wiki/MySQL
http://www.mysql.com
http://manual.koha-community.org/3.12/en/reports.html
http://wiki.koha-community.org/wiki/SQL_Reports_Library