← Back to team overview

manarah.team team mailing list archive

Re: Database schema

 

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 <mailto: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 <mailto: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/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/




-- عبد المنعم كوكة
    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