Database design and implementation - Industrial IOT Solution

Database design for a condition monitoring IOT solution.


We are developing an end-end solution for monitoring (Sensor + SaaS app).

Scope of work:

1. Define data schema

2. Implement data schema in AMW RDS using MySQL

3. Build data validations and

4. Facilitate & handhold during integration with production data

5. Make schema performant for CRUD and querying

6. Utilize AWS tools to troubleshoot performance issues

7. Detailed documentation and flowchart for the complete implementation

8. Known shortcoming assessment and mitigation strategies for/during scaling.

9. Data purging/ archival function implementation for old production data.

10. History table design & implementation. Data retrieval mechanism from the history table.

Magnitude of work:

Db details:

1. No of table 30 to 35 tables

2. Avg. 15 fields per table

3. 5-7 history tables

4. Data validations on very important fields.

Transaction data (Real Time sensor data logging) :

1. no. of hardware sensors - 100k sensors

2. Frequency of transmission - 2 sec to 1 hr

3. Quantum of data - 5 MB/ day/ device

Following data can be disclosed to interested candidates after formal NDA documentation:

1. Data flow schema

2. Excel sheet with all the dB tables.

3. Each table contains data name, data type, data validation extremities for each variable

4. Overall implementation of the system design.

Additional notes:

1. The whole system is being built using server less architecture.

2. The entire system will be deployed using AWS cloud services.

3. DB will be deployed on amazon RDS

4. We welcome any changes in our proposed DB schema

5. Proposed workflow= Discuss and finalize schema, deliverable and mutually agreeable milestones -> execute

5% of the project as a prototype implementation -> based on successful prototype implementation full implementation starts -> Payment released based on agreed milestone.

6. Final bid can be submitted after detailed discussion.

7. Please submit a very brief introduction about yourself with details about experiences relevant to this project.

8. Approx. start date: Jun 1

9. Approx. end : Sep 15

Evner: Database Design, MySQL, Amazon S3, Aws Lambda, SQL

Se mere: implementation database design ms access, database design implementation mysql, database design implementation, database design implementation project, assumptions database design implementation, database design implementation rails, access database design implementation, database systems design implementation and management, database systems design implementation and management 10th edition pdf, database design and implementation process, database design and implementation, database design and implementation pdf, relational database design and implementation pdf, database design and implementation sciore pdf, design of industrial information systems solution manual, database design vs implementation, sql database design and implementation, database design and implementation sciore, relational database design and implementation 4th edition free, database design and implementation course

Om arbejdsgiveren:
( 0 bedømmelser ) Bengaluru, India

Projekt ID: #29919509

6 freelancere byder i gennemsnit ₹88171 timen for dette job


Hi, I read your detailed project description about the database system. The requirements listed are very clear and i understand them completely. After reading the requirements, i am certain that i can design and devel Flere

₹65000 INR in 12 dage
(8 bedømmelser)

I'm having 4 years of experience in the required skills. I can complete this project in two months and having Experience in writing complex SQL queries, Stored Procedures, data warehouse, data mining , data manipulatio Flere

₹77778 INR in 60 dage
(0 bedømmelser)

HI I would like to work on this project for you, My name is Mbuyelo and i am a software developer with 12 years experience. I have extensive experience in SQL and have worked with both .Net and oracle technologies. I Flere

₹75000 INR in 60 dage
(0 bedømmelser)

Hi I have 15 years of SQL Server Database Development,MYSQL DB Developement Experience. I am working as an architect and built major Data Analytics platform. I have expert knowledge around SQL programming and Power BI. Flere

₹85000 INR in 45 dage
(1 bedømmelse)

I am a seasoned technology executive with proven expertise in IoT projects development and implementation. having knowledge of ThingsWorks and know how to. I have knowledge of thingsboard and its database, Also I have Flere

₹56250 INR in 7 dage
(0 bedømmelser)

I can develop the data model and implement on AWS I can optimize OLTP data schema and provide history tables for querying if you wish in OLAP optimized

₹170000 INR in 14 dage
(0 bedømmelser)