← Back to team overview

manarah.team team mailing list archive

Re: Database schema

 

Mehdi, Fath Al-Bari is not a Hadith book, it is the *explanation *of Sahih
AlBukhari, so it should have separate tables in DB (for explanation book
and explanation Hadith): http://en.wikipedia.org/wiki/Fath_al-Bari

2012/3/2 jmehdi <jmehdi@xxxxxxxxxx>

>  Actually, I've imported fath al-bari (
> http://www.bayt-al-hikma.com/bukhari-fath) for Bukhari in English (it's
> just that it has a different organization than the original sahih bukhari,
> that's why I have a second book: http://www.bayt-al-hikma.com/bukhariwhich will have the same hadeeths but organized differently )
>
> Mehdi Magnon
> Administrator of the Sabily Project - Free Islamic Operating System (http://www.sabily.org)
> Administrator of Bayt Al Hikma - Islamic resources and Hadiths (http://www.bayt-al-hikma.com)
>
>
> Le 02/03/2012 22:00, Abdelmonam Kouka a écrit :
>
> For Albukhari I don't find it in French but I find it in English here:
> http://saaid.net/book/open.php?cat=92&book=4821 after downloading the
> .rar file extract it and then you will find a .bok file which you can open
> with Thawab.
> For the other link it is not useful as I can see! besides this website is
> not known as a trusted one!
>
> Yep there is a lot of work to do :) now we are OK about this database, we
> should fix a road map for Manarah, who is ready to develop with us?
>
> 2012/3/2 jmehdi <jmehdi@xxxxxxxxxx>
>
>>  someone gave me this link:
>> http://alturath.info/hadeeth/moftah-kenoz-sona/moftah-kenoz-sona.htm,
>> could we find this kind of information in this book?
>> Otherwise it would be manually...
>>
>> I've retrieved hadiths from several websites or books that I have been
>> able to parse to automatically insert them in the database.
>> Now I'm filling manually al-Muwatta in French, and I have also sahih
>> Bukhari in French in 5 books (10kg :) ), that I use to fill the sanads and
>> french translations (I haven't found on the web the full sanads of Bukhari
>> hadiths...)
>> So it's a lot of work!
>>
>> Mehdi Magnon
>> Administrator of the Sabily Project - Free Islamic Operating System (http://www.sabily.org)
>> Administrator of Bayt Al Hikma - Islamic resources and Hadiths (http://www.bayt-al-hikma.com)
>>
>>
>>  Le 02/03/2012 20:35, Abdelmonam Kouka a écrit :
>>
>> Good, but how you manage that? as I know there is no book/software that
>> do that, so the only solution is to do it manually!
>> BTW: how did you populate the database? manually or using a script?
>>
>>  2012/3/1 jmehdi <jmehdi@xxxxxxxxxx>
>>
>>>  The schema already supports that.
>>> Look at: http://www.bayt-al-hikma.com/nawawi/hadeeth/1
>>> The hadeeth is related by Bukhari (n°1), Muslim (n°4692) and Nawawi
>>> (n°1). In the database the hadeeth exists only once, and as the sanad can
>>> be found in Bukhari, all other books inherit this information.
>>>
>>> For hadeeths that I haven't yet added in Bukhari or Muslim, I only put
>>> one rawi, as in this hadeeth:
>>> http://www.bayt-al-hikma.com/nawawi/hadeeth/2
>>>
>>> About this, do you know any book in which we can find matching hadeeths
>>> in different books? For example, to know that Bukhari n°1 = Muslim n°4692.
>>>
>>> sanad.png is attached again
>>>
>>> wa salam
>>>
>>> Mehdi Magnon
>>> Administrator of the Sabily Project - Free Islamic Operating System (http://www.sabily.org)
>>> Administrator of Bayt Al Hikma - Islamic resources and Hadiths (http://www.bayt-al-hikma.com)
>>>
>>>
>>>  Le 01/03/2012 22:43, Abdelmonam Kouka a écrit :
>>>
>>> Wa alaykom assalem,
>>>
>>> Good design, I think we will adopt it inshallah.
>>> Juste for the case of 40 Nawawi there is no sanad! there is only the
>>> rawi and the book in which exist the hadith, exemple:
>>> "hadith 1: *On the authority of Omar bin Al-Khattab, who said : I
>>> heared the messenger of Allah salla Allah u alihi wa sallam say :Actions
>>> are but by intention and every man shall have but that which he intended.
>>> Thus he whose migration was for Allah and His messenger, his migration was
>>> for Allah and His messenger, and he whose migration was to achieve some
>>> worldly benefit or to take some woman in marriage, his migration was for
>>> that for which he migrated. related by Bukhari and Muslim*"
>>>
>>> so we should find a solution to link this hadith from this book with its
>>> equivalent in Bukhari and Muslim, we will need this option when we will
>>> start adding books that explain the Hadith.
>>>
>>>  2012/3/1 jmehdi <jmehdi@xxxxxxxxxx>
>>>
>>>> assalamu alaykum,
>>>>
>>>> Attached is the database schema of Bayt Al-Hikma .
>>>>
>>>> The main tables are Book -> Kitab -> Bab -> Hadeeth
>>>> A book is a set of kitabs; a kitab is a set of babs; a bab is a set of
>>>> hadeeths.
>>>> Let's explain that with examples:
>>>> * "sahih bukhari" = book
>>>>  - "1. The book of commencement of revelation" = kitab
>>>>     - "1 How the Divine Revelation commenced" = bab
>>>>        - Hadiths...
>>>>
>>>> * babs are optional:
>>>>  "Sunan Abu-Dawud" = book
>>>>  - "1 Purification" = kitab
>>>>     - hadiths....
>>>>
>>>> * kitabs are also optional:
>>>>  "40 hadiths of An-Nawawi" = book
>>>>  - Hadiths....
>>>>
>>>> Reference table (which contains Qudsi/Marfu/Mauquf... categories),
>>>> Reliability table (which contains Sahih/Hasan/... categories), IsnadLink
>>>> table (Musnad/Mursal/Muttasil...) and IsnadNature table (Munkar/Mudraj) are
>>>> not yet used.
>>>>
>>>> Chains of transmettors are defined using: Hadeeth -> Sanad -> Isnad ->
>>>> Rawi
>>>> The Isnad table contains the list of Rawis with their position; each
>>>> hadeeth can have several chains, they are stored using the Sanad table.
>>>>
>>>> --
>>>> Mehdi Magnon
>>>> Administrator of the Sabily Project - Free Islamic Operating System (
>>>> http://www.sabily.org)
>>>> Administrator of Bayt Al Hikma - Islamic resources and Hadiths (
>>>> http://www.bayt-al-hikma.com)
>>>>
>>>>
>>>> --
>>>> Mailing list: https://launchpad.net/~manarah.team
>>>> Post to     : manarah.team@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~manarah.team
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> عبد المنعم كوكة
>>> Abdelmonam Kouka
>>> http://sabily-guru.blogspot.com/
>>> http://geek-tounsi.blogspot.com/
>>>
>>>
>>> --
>>> Mailing list: https://launchpad.net/~manarah.team
>>> Post to     : manarah.team@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~manarah.team
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> عبد المنعم كوكة
>> Abdelmonam Kouka
>> http://sabily-guru.blogspot.com/
>> http://geek-tounsi.blogspot.com/
>>
>>
>
>
> --
> عبد المنعم كوكة
> Abdelmonam Kouka
> http://sabily-guru.blogspot.com/
> http://geek-tounsi.blogspot.com/
>
>


-- 
عبد المنعم كوكة
Abdelmonam Kouka
http://sabily-guru.blogspot.com/
http://geek-tounsi.blogspot.com/

Follow ups

References