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

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

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Bengaluru, India

Projektin tunnus: #29919509

6 freelanceria on tarjonnut keskimäärin ₹88171 tähän työhön


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 Lisää

₹65000 INR 12 päivässä
(8 arvostelua)

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 Lisää

₹77778 INR 60 päivässä
(0 arvostelua)

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 Lisää

₹75000 INR 60 päivässä
(0 arvostelua)

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. Lisää

₹85000 INR 45 päivässä
(1 arvostelu)

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 Lisää

₹56250 INR 7 päivässä
(0 arvostelua)

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 14 päivässä
(0 arvostelua)