manarah.team team mailing list archive
-
manarah.team team
-
Mailing list archive
-
Message #00023
Re: Database schema
In Arabic yes..but not in other languages!
In Arabic I find it in three trusted web sites:
http://www.islamweb.net/newlibrary/display_book.php?ID=1&idfrom=1&idto=13851&bk_no=52
http://hadith.al-islam.com/Loader.aspx?pageid=194&BookID=33
http://www.al-eman.com/%D8%A7%D9%84%D9%83%D8%AA%D8%A8/%D9%81%D8%AA%D8%AD+%D8%A7%D9%84%D8%A8%D8%A7%D8%B1%D9%8A+%D8%B4%D8%B1%D8%AD+%D8%B5%D8%AD%D9%8A%D8%AD+%D8%A7%D9%84%D8%A8%D8%AE%D8%A7%D8%B1%D9%8A+**/i9&p1
2012/3/2 jmehdi <jmehdi@xxxxxxxxxx>
> It depends on the format; the easiest way is to find a website with an
> HTML structure that can be parsed automatically.
> Do you know a website with explanations of Fath al-Bari?
>
> 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 23:11, Abdelmonam Kouka a écrit :
>
> if you have a script that did it automatically it will be great to add two
> new tables (explanation book, and explanation hadith) and populate them,
> and then we can link each hadith from albukhari to its explanation...
>
> 2012/3/2 jmehdi <jmehdi@xxxxxxxxxx>
>
>> No I mean I have imported the hadiths of Fath al-Bari (and only the
>> hadiths, not the explanations)
>>
>> 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:24, Abdelmonam Kouka a écrit :
>>
>> 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/
>>
>>
>
>
> --
> عبد المنعم كوكة
> Abdelmonam Kouka
> http://sabily-guru.blogspot.com/
> http://geek-tounsi.blogspot.com/
>
>
--
عبد المنعم كوكة
Abdelmonam Kouka
http://sabily-guru.blogspot.com/
http://geek-tounsi.blogspot.com/
References
-
Database schema
From: jmehdi, 2012-03-01
-
Re: Database schema
From: Abdelmonam Kouka, 2012-03-01
-
Re: Database schema
From: jmehdi, 2012-03-01
-
Re: Database schema
From: Abdelmonam Kouka, 2012-03-02
-
Re: Database schema
From: jmehdi, 2012-03-02
-
Re: Database schema
From: Abdelmonam Kouka, 2012-03-02
-
Re: Database schema
From: jmehdi, 2012-03-02
-
Re: Database schema
From: Abdelmonam Kouka, 2012-03-02
-
Re: Database schema
From: jmehdi, 2012-03-02
-
Re: Database schema
From: Abdelmonam Kouka, 2012-03-02
-
Re: Database schema
From: jmehdi, 2012-03-02