1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

What will be the best way of developing this kind of database?

Discussion in 'Databases' started by choyj, Feb 8, 2015.

  1. #1
    Hi,

    I got a lot of products. Each product has a PDF with info/description.
    My thought process is:
    - Create a website/database, so I can access this website from any computer to use this database.
    - Each product has its own entry, there should be a framework able to parse the PDF and store the info for each product.
    - With the info I got from the PDF, I can start computing things I need to do.

    Any idea how should I start this? Or is there any developer interested in this project?
    SEMrush
    Thank you
     
    choyj, Feb 8, 2015 IP
    SEMrush
  2. King-Servers

    King-Servers Greenhorn

    Messages:
    270
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    23
    #2
    I can help you to set this up!. Please PM me if you are interested.
     
    King-Servers, Feb 8, 2015 IP
  3. TheDataPlanet.com

    TheDataPlanet.com Active Member

    Messages:
    496
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #3
    Basically,

    1. Sort the PDF files in directories or upload them one by one
    2. Parse them in PHP by http://www.pdfparser.org/
    3. With parsed text in structured arrays, insert them in pre-created tables of MySQL database
    4. Normalize the database structure and develop the website based from the data.

    I would do it this way. Hope it helps.
     
    TheDataPlanet.com, Feb 17, 2015 IP
  4. choyj

    choyj Member

    Messages:
    47
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #4
    Hi, Are you interested in developing this database/web for me?

    Thank you.
     
    choyj, Feb 17, 2015 IP
  5. GORF

    GORF Well-Known Member

    Messages:
    216
    Likes Received:
    21
    Best Answers:
    3
    Trophy Points:
    115
    #5
    Use Open Cart free ecommerce script.

    You don't have to be selling the products. Just use the script as a catalog to organize the products, decsription, associated files (pdf), etc.
     
    GORF, Feb 17, 2015 IP
  6. choyj

    choyj Member

    Messages:
    47
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #6
    Thanks but seems not what I need.
    Main idea is i want to compute the info from the PDF, and if I have 1000+ products, I will able to do my analysis.

    Thanks,
     
    choyj, Feb 17, 2015 IP
  7. Dominic Ceraso

    Dominic Ceraso Member

    Messages:
    52
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    38
    #7
    Personally,

    I would upload the pdf files structured directory based off of genre / category etc.
    Then parse these pdf's out into JSON attached to a NOSQL db on the backend
    that way you could establish the website based off the array in the db as well as scale out into the mobile wordspace if ever needed.

    D
     
    Dominic Ceraso, Feb 21, 2015 IP
  8. TheDataPlanet.com

    TheDataPlanet.com Active Member

    Messages:
    496
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #8
    Nice approach. NoSQL seems really in these days.
     
    TheDataPlanet.com, Feb 21, 2015 IP
  9. Dominic Ceraso

    Dominic Ceraso Member

    Messages:
    52
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    38
    #9
    Yeah, I implement NoSQL when and where I can any more.
     
    Dominic Ceraso, Feb 21, 2015 IP
  10. choyj

    choyj Member

    Messages:
    47
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #10
    are you able to help me out?
    the pdf will keep building every year, probably 13K per year, and each is unique
    each will have a sale price, a buyer, a vendor details associate with it

    lets say A product and B product, B product can be related to A product and will show on both A and B description

    i was thinking to use pandas or numpy to do calculations

    first thing is i need to have a good setup to gather all information is a correct manner

    please contact me if you are interested

    thanks mate
     
    choyj, Feb 21, 2015 IP
  11. Shyamin Ayesh

    Shyamin Ayesh Active Member

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    76
    #11
    basically you need to add data to your database using PDF's, so best option is making solution with something like this :D

     
    Shyamin Ayesh, Mar 12, 2015 IP
  12. SalvadorWilliam

    SalvadorWilliam Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #12
    By using access 2010 you can share your data throught the company or in the web server, to make it accessable from any computer. Or you can make a software at your own. It will take around 2 months to get ready.
     
    SalvadorWilliam, Jul 24, 2015 IP