← Back to team overview

manarah.team team mailing list archive

Re: Database schema

 

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/bukhari which 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 <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 <mailto: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 <mailto: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 <mailto: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
            <https://launchpad.net/%7Emanarah.team>
            Post to     : manarah.team@xxxxxxxxxxxxxxxxxxx
            <mailto:manarah.team@xxxxxxxxxxxxxxxxxxx>
            Unsubscribe : https://launchpad.net/~manarah.team
            <https://launchpad.net/%7Emanarah.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
        <https://launchpad.net/%7Emanarah.team>
        Post to     : manarah.team@xxxxxxxxxxxxxxxxxxx
        <mailto:manarah.team@xxxxxxxxxxxxxxxxxxx>
        Unsubscribe : https://launchpad.net/~manarah.team
        <https://launchpad.net/%7Emanarah.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/

Follow ups

References