Đã hoàn thành

Write MySQL Queries for time based reporting and table indexing design

This is a simple but specific task for someone who's very knowledgeable about MySQL time based queries and table design.

The table already exists which stores metrics with a time stamp and some other fields. I already have queries running but need help with optimization of queries and creation of summary/aggregate tables.

The following 3 things are required:

1. Optimize the table including indexing and/or create new summary/aggregate tables (I think hourly time period would work) with query to automatically update summary/aggregate table.

2. Build Query to retrieve time series data (values=count/avg/min/max) from the table in minute, hourly and daily intervals ( with timezone).

3. Build Query to retrieve categories from the table in minute, hourly and daily intervals ( with timezone) - with or without pivot.

The challenge is that the table can have 1 million entries and the query should be able to produce the result as quick as it can. We can create summary/aggregate tables as well - which is also part of this project - if the query itself cannot be made faster.

Kĩ năng: MySQL, SQL, Lập trình cơ sở dữ liệu, Relational Databases

Về Bên Thuê:
( 3 nhận xét ) Apex, United States

ID dự án: #32713343

Được trao cho:


Good Day, One of my speciality is mySQL DBA. Part of my daily work is query optimisation against the database data model. I work with data comprising of multi million row large datasets. My rule of thumb is if a qu Thêm

$98 USD trong 7 ngày
(0 Đánh Giá)

25 freelancer chào giá trung bình$147 cho công việc này

(61 Nhận xét)

Hello there, it seems that you require to pre calculate the data for faster searching which is good but to be honest 1 million is not huge. Pls share me more details so we can discuss. I’ve been working with a hundred Thêm

$250 USD trong 3 ngày
(44 Nhận xét)

I have more then 15 year’ experienced in full stack .NET developer in ASP.NET Core / MVC / WinForm, C#, Razor, Jquery, HTML5, Telerik, DevExpress, SQL Server, MySQL, PostgreSQL. As i am expert, I can build it accord Thêm

$100 USD trong 7 ngày
(30 Nhận xét)
(5 Nhận xét)

I have designed and provided solution for similar problem in past. You will definitely need a aggregator table to store results day, week and month-wise. I can help you with this. Do note that quote is not actual. Wh Thêm

$250 USD trong 7 ngày
(11 Nhận xét)

Dear my client, This is my portfolio website "for you". [login to view URL] I am a database management engineer who has top skills in database design. I have worked with various types of databases li Thêm

$140 USD trong 7 ngày
(1 Nhận xét)

Hi Hiring manager C#, ASP.net, ETL, BI, DBA, SQL and PL/SQL Expert 15+ years experience in software development, database programming and administration, and project management. My proficiency are given in the follow Thêm

$250 USD trong 2 ngày
(2 Nhận xét)

SQL , Mysql Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this p Thêm

$200 USD trong 7 ngày
(24 Nhận xét)

I am profasional database designer and SQL query expert. I checked your mentioned details and confident one that I can do perfectly

$50 USD trong 1 ngày
(13 Nhận xét)

Hi There!! No upfront milestone and 24*7 Support With a 100% money-back guarantee. We are here to provide the best quality solution for all your requirements related to: - Websites design and development - Online Store Thêm

$190 USD trong 1 ngày
(3 Nhận xét)

Dear ! I'm ready for your Job this is owner able for me I'm work for you and complete it in professional way. Looking forward with you. Regards: Theata Solution

$100 USD trong 1 ngày
(8 Nhận xét)

*** EXPERT SQL DEVELOPER *** I may provide you all queries and optimize your database according to your requirements. My expertise includes the following - MySQL - MS SQL - Oracle - .NET - ASP. NET - C#.NET - WPF - WEB Thêm

$100 USD trong 2 ngày
(6 Nhận xét)

Passion + Creativity + Experience = Success Hi,there,How are you? I am Arsen and thank you for posting a job that fits my skill set. I'm really interested in your project that requires a lot of experience and good prob Thêm

$200 USD trong 7 ngày
(1 Nhận xét)

Hello, I hope this finds you well. I have just seen your project requiring; SQL MySQL Database Programming Relational Databases I believe that my 10-year experience in this field is what you need right away. Avoid the Thêm

$140 USD trong 7 ngày
(1 Nhận xét)

Hi there, I have more than 5 years of experience in web design and development. I think your job is very suitable for me . Our skills: Programming Skills: AngularJS, Bootstrap, CSS3, HTML5, jQuery, JavaScript and Ajax Thêm

$150 USD trong 3 ngày
(3 Nhận xét)

7+ years experience in Reactjs / Redux / Angular / flutter / Nodejs / PHP / Django / Backned - Frontend development! All of our programming skills: *Front-end: - HTML, HTML5, JSON. - TypeScript, JAVASCRIPT (Ajax, , Thêm

$250 USD trong 2 ngày
(1 Nhận xét)

Hello , My Name Is Pedro Faria, I Have a one idea for work this , in my last work i create a query automate for users in excel and have a created variables filters and Optimized's relatory, but need a discuss.

$30 USD trong 7 ngày
(0 Nhận xét)

Hello, I'm a MySQL expert, No problem to finish your job. Especially, I have strong skills in optimization of queries and creation of summary/aggregate tables I have a degree in computer science and 7 years of experie Thêm

$50 USD trong 3 ngày
(0 Nhận xét)

Hi We have a team of developers who are proficient in MySql, Oracle, and MS SQL. They work on enterprise applications like CRM, Supply Chain Management, ERP, Finance, and Insurance Domain. I assure you of timely deliv Thêm

$230 USD trong 7 ngày
(0 Nhận xét)

Hi, I sincerely hope you are doing well and safe from ✔️covid-19✔️. I like Data Modeling, DML(Data modeling language) and DDL (Data definition language) Hi, I have checked your description carefully and very interestin Thêm

$140 USD trong 7 ngày
(0 Nhận xét)