古兰经数据库架构 [英] Quran database schema

问题描述

我需要一些帮助来为MySQL中的quran数据库构建表。我不确定如何将这些信息放在桌子上。



我想要我的数据库alquran，可以播放音频并且可以翻译古兰经

b

I need some help building tables for a quran database in MySQL. I am unsure on how to lay this information out in a table.

I want my database alquran , can play the audio and can translate a quran
b

b
asically anything that has to do with organizing quran. I'm new to databases and I have some ideas. But if I'm going to learn I might as well learn the right way of doing it.

Any thoughts on how to design my table(s) would be awesome.

什么我试过了：



table ayah

table juz

table surah

表的意思

table languange

What I have tried:

table ayah
table juz
table surah
table meaning
table languange

推荐答案

正如@BillWoodruff建议的那样，确实存在学术性文章。



这一个 - http://www.sciencepub.net/report/ report0607 / 001_24497report060714_1_6.pdf [ ^ ]有一些建议的表格布局。 （虽然 http://www.lifesciencesite.com/lsj/life1101/025_20725life1101_160_171，但可能已从本报告中获取。 pdf [ ^ ]） />


Drupal在古兰经中有一个完整的项目。 Drupal.org [ ^ ]



此资源也可能有用 - SemanticQuran - 数据集 - Datahub [ ^ ]



你可能通过观察基督教圣经如何被数字化来获得一些洞察力，因为结构是相似的，例如 GitHub - scrollmapper / bible_databases：圣经版本和交叉引用数据库。 [ ^ ]



如你所说，你是数据库的新手，那么你应该做确定你理解规范化的基础知识 [ ^ ]。

As suggested by @BillWoodruff there are indeed scholarly articles around.

This one - http://www.sciencepub.net/report/report0607/001_24497report060714_1_6.pdf[^] has some suggested table layouts. (It may have been taken from this report though http://www.lifesciencesite.com/lsj/life1101/025_20725life1101_160_171.pdf[^])

Drupal has an entire project at Quran | Drupal.org[^]

This resource may also be useful - SemanticQuran - Datasets - the Datahub[^]

You might also gain some insight by looking at how the christian bible has been digitalised as the structure is similar e.g. GitHub - scrollmapper/bible_databases: Bible versions and cross-reference databases.[^]

As you say you are new to databases then you should make sure you understand The basics of Normalization[^].

这篇关于古兰经数据库架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！