Đã 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:

MakerSA

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á)
0.0

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

(61 Nhận xét)
6.8
Truonggiang86

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)
5.7
devbaloni1983

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.4
(5 Nhận xét)
4.4
rockingrik

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)
4.0
jovanarizanovic0

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)
4.1
Devrits

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)
4.4
merinsinha

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)
3.9
ThetaSolutions

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)
3.7
devupfree

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)
3.3
theatasolution1

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)
2.9
MWaseemAmeen

*** 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)
3.0
freelancedev112

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)
2.3
Valuesolutions

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)
2.4
ArviMi

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)
1.3
AbhishekSingh08

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)
1.1
Pedfari

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)
0.0
prettyregina

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)
0.0
parashar1981

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)
0.0
artemanhel

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)
0.0