Tamamlanmış

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.

Beceriler: MySQL, SQL, Veritabanı Programlama, Relational Databases

About the Client:
( 3 değerlendirme ) Apex, United States

Proje NO: #32713343

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 98%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)
0.0

Bu iş için 25 freelancer ortalamada $147 teklif veriyor

(61 Değerlendirme)
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 Daha Fazla

$250 USD in 3 gün içinde
(44 Değerlendirme)
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 Daha Fazla

$100 USD in 7 gün içinde
(30 Değerlendirme)
5.4
(5 Değerlendirme)
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 Daha Fazla

$250 USD in 7 gün içinde
(11 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

$250 USD in 2 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$200 USD in 7 gün içinde
(24 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
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 Daha Fazla

$100 USD in 2 gün içinde
(6 Değerlendirme)
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 Daha Fazla

$200 USD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

$140 USD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

$150 USD in 3 gün içinde
(3 Değerlendirme)
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, , Daha Fazla

$250 USD in 2 gün içinde
(1 Yorum)
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 in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$50 USD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$230 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0