PiCA - Pi Chef Challenge Blog #2 : Unpacking and Initial Database Development

2 Feb 2018

Since I am in the business trip (academic) until around three days ago so that in this post I will show you the unpacking of received the package and the initial database (DB) development for my server machine.

Unpacking received Package

Yesterday I received my package and today I have unpackaged it in my laboratory. The image of unpacking process is shown figure below,

Figure 1. Unpacking the received package

As the proposed design, I will use all of the components except NXP Explore NFC Expansion Board and Sense Hat.However, in the future, I will consider to explore it further. Besides, I will use my own components such as Raspberry Pi 3 B for slave machine and webcam camera.

DB development

In this proposed system, we use a server machine for centralizing the data and communication among all component including the out part of systems. For simplicity, we use MySQL as the basis of development which will be installed in the Raspi server. Figure 2 shows you the part of the design I develop. This figure reveals that this DB system takes an important role in this proposed system work.

Figure 2. Develop DB in general system overview

The relational database system I develop is shown by Fig.3 below,

Figure 3. Design of RDBMS

The name of database is picadb as this project title

Table receipt_tb will save the receipt saved by user
Table ingredient_tb will save the material/ingredient of receipt recorded in receipt_tb
Table supplier_tb will save the supplier of each ingredient
Table existing_tb will save the ingredient existing in the fridge
Table request_tb and received_tb will save the sent and received correspondence between system and supplier.

The design of database above is in the initial phase. We will consider to change it depend on the change of system development process.

Closing Remarks

We have described our progress in this project including unpacking process and DB development for server part. The next stage after this is the integration of raspberry pi - camera and then installation before computer vision development and evaluation step. Hopefully, our project can run well.

Top Comments

giganggu over 6 years ago in reply to dixonselvan +1

Thank you Dixon. The database will save the messaging content only. In other words, it will take a role as a logger. Of course there is a designed format for request and reply message so that it can be…

Parents

dixonselvan over 6 years ago

Hi giganggu ,

Nice update with diagram and database outline. Out of curiosity, how are you going to integrate a whats app messaging feature in your project? Is it something like the message seller / supplier sends in some format uploads and stores in your DB in respective tables?

Thanks
Dixon Selvan
- Cancel
- Vote Up 0 Vote Down
- Sign in to reply
- More
- Cancel

Comment

dixonselvan over 6 years ago

Hi giganggu ,

Nice update with diagram and database outline. Out of curiosity, how are you going to integrate a whats app messaging feature in your project? Is it something like the message seller / supplier sends in some format uploads and stores in your DB in respective tables?

Thanks
Dixon Selvan
- Cancel
- Vote Up 0 Vote Down
- Sign in to reply
- More
- Cancel

Children

giganggu over 6 years ago in reply to dixonselvan

Thank you Dixon. The database will save the messaging content only. In other words, it will take a role as a logger. Of course there is a designed format for request and reply message so that it can be understandable to both supplier and systems.

Thanks,
Budiman PAR
- Cancel
- Vote Up +1 Vote Down
- Sign in to reply
- More
- Cancel