SQL-Query for Maria-DB, linking two tables

Completato Pubblicato 4 anni fa Pagato alla consegna
Completato Pagato alla consegna

I run a Maria DB (10.3.15-MariaDB-1). In this DB, there are two tables, say a and b. there are the following columns in both tables:

- id (unique)

- timestamp (e.g. 2019-11-15 02:39:31)

- pattern (text and numbers mixed, approx length 10 chars, more or less)

The tables consit of 100'000 to 150'000 rows each.

The task is the fill data into a new table, say ab, as follows:

Parameters:

- t_min: interval in seconds

- t_max: interval in seconds

- error_tolerance: integer

The new table shall contain the following columns:

- id (unique)

- [login to view URL] (id from table a)

- [login to view URL] (timestamp from table a)

- [login to view URL] (pattern from table a)

- [login to view URL] (id from table b)

- [login to view URL] (timestamp from table b)

- [login to view URL] (pattern from table b)

- time_difference (int) in seconds, contains [login to view URL] - [login to view URL]

- errors_in_pattern (int) contains the number of errors found in comparing the actual patterns (and not the maximum defined in the parameters)

The table ab shall be filled with records fulfilling the following criterias:

- Look for patterns from table a mathing patterns in table b, fullfillig the error_tolerance (see below)

- AND the difference between the corresponding entries shall be minimum t_min seconds (>=) and maximum t_max seconds (<=)

The error_tolerance defines the maximum tolerated error between the pattern compared. Examples:

error_tolerance = 0 means ONLY the following is true

- abcdef = abcdef

error_tolerance = 1 means there is a maximum of one error accepted. There might be a difference in one character (which includes, that the character might also be ommitted or extra). The following is true

- abcdef = abcdef

- abcdef = abCdef

- abcdef = abdef

- abcdef = abcXdef

- abcdef = abcde

- abcdef = bcdef

error_tolerance = 2 means there is a maximum of two errors accepted. There might be a difference in two characters (which includes, that the characters might also be ommitted or extra). The following is true

- abcdef = abcdef

- abcdef = abCdef

- abcdef = abCDef

- abcdef = abcXdef

- abcdef = abcXdeXf

- abcdef = abdf

- abcdef = abdXf

etc.

The deliverable is the query to perform the task as described above and insert the matching pairs into the new table ab.

Questions to be asked in the beginning, not after the project starts.

Quick delivery preferred.

SQL Amministrazione Database Programmazione Database MariaDB MySQL

Rif. progetto: #24376439

Info sul progetto

22 proposte Progetto a distanza Attivo 4 anni fa

Assegnato a:

zukovski1987

Hi, Marco S. How are you? I am a senior Web developer with strong MariaDB skill. I am very interested in your project. Let's discuss details via chat friendly. Look forward to your positive reply. Thank you.

€99 EUR in 7 giorni
(2 valutazioni)
2.7
bjrupani

Hello hiring member i hope you are doing well i am bhavika i have 4+years experience in php ,laravel ,ajax , jquery , javascript , html , css , bootstrap i have done many project with this types of all query i can star Altro

€100 EUR in 1 giorno
(139 valutazioni)
7.5

22 freelance hanno fatto un'offerta media di €152 per questo lavoro

SqlDevelopment

I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday Altro

€222 EUR in 2 giorni
(45 valutazioni)
5.3
AIPDTech

Hi there, We reviewed your requirements and our full stack web developer team would like manage and build your project as per needs and willing to discuss project requirements in detail. We are a reputed IT company Altro

€175 EUR in 7 giorni
(6 valutazioni)
5.2
ripasahasl

Hi There, In Your new table "ab" - there will be 6 fileds. Right? what do You mean by below:- - t_min: interval in seconds - t_max: interval in seconds both of the field doesn't exist in Your existing table. then f Altro

€120 EUR in 2 giorni
(35 valutazioni)
5.0
mtdevil369

please check my profiles?? I have understand the project requirement & interested to work for this project. I will start right now and I will do it before your time . Please send a message so we can discuss more & star Altro

€120 EUR in 2 giorni
(22 valutazioni)
5.0
bestflancer

Hi I am a senior database developer. Will the timestamp of b always greater than a for the respective pattern? Is there always a 1 : 1 relationship between table a and b for each unique pattern? Are the patterns alw Altro

€90 EUR in 7 giorni
(10 valutazioni)
4.7
MrConco

Hi, there. I am a experienced web developer with over 10 years of professional experience, specialized in database management and Sql query. I can deliver the best result what you want in a short time. Kindly contact m Altro

€50 EUR in 1 giorno
(2 valutazioni)
4.5
shanmup

I can do this task and finish it quickly and can be delivered fast. The query is clearly understood what to be done and can start immediatley if you come in chat .. Thanks

€140 EUR in 7 giorni
(6 valutazioni)
4.4
merinsinha

Hi i am an senior devoloper. For Professional works -Hire me. As 10+ 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 qua Altro

€150 EUR in 3 giorni
(20 valutazioni)
3.7
jeyhunilysov

Hi, there. I have read your job description very carefully. I am a senior database administrator and have 5+ years of experience with making qery like yours. I am sure that I can do your job perfect quickly. Let's disc Altro

€120 EUR in 1 giorno
(4 valutazioni)
3.2
ecksdeegege

Hello SQL expert is here. I am a new freelancer here but I am a senior Web developer with over 5 years of experience in PHP, Javascript, MySQL, MongoDB and so on. I have developed so many web sites and used dbs for al Altro

€140 EUR in 7 giorni
(6 valutazioni)
2.8
nisharkr

SQL Expert with experience of 15 years in various applications. I have done many sql projects in India and overseas.

€140 EUR in 7 giorni
(0 valutazioni)
0.0
sumitrohilla

Hi, I can work on this project. I have prior knowledge of working with sql databases. I am into designing queries from past 6 yrs so i am a good fit for you. But before the project i need some more details. Feel free t Altro

€140 EUR in 2 giorni
(0 valutazioni)
0.0
Hitesh27111991

hello, i have good experience in SQL query. i can do your task if you are interested please contact me. thanks

€250 EUR in 7 giorni
(0 valutazioni)
0.0
vw7413653vw

Dear Sender, I have profound experience in SQL & PLSQL, Oracle Forms and Reports 10g. I have also experience on Oracle EBS 11i and R12 on various modules. I have 2 years of training/tutoring experience for Oracle SQL Altro

€118 EUR in 5 giorni
(0 valutazioni)
0.0
larryleung743

Hi, Hope you are doing well! Thanks for sharing your project requirement with us. As a highly skilled Full-Stack developer and I can help you perfectly. I am very confident with my skills and I'd like to help your busi Altro

€250 EUR in 1 giorno
(0 valutazioni)
0.0
proficientium

Hi. I've read your SQL problem and this looks straightforward with a couple of joins and some SQL operations comparing the difference between two strings. I have MariaDB installed right now. I can delivery this within Altro

€140 EUR in 1 giorno
(0 valutazioni)
0.0
puneetforwork

Hello Let's connect together so we can discuss the scope of work in more detailed manner and after analyzing the same will provide you no obligation analysis and cost estimate. Regards

€140 EUR in 1 giorno
(0 valutazioni)
0.0