SQL-Query for Maria-DB, linking two tables

Ολοκληρωμένο Αναρτήθηκε Πριν 4 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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 Διαχείριση Βάσεων Δεδομένων Προγραμματισμός Βάσης Δεδομένων MariaDB MySQL

Ταυτότητα Εργασίας: #24376439

Σχετικά με την εργασία

22 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 4 χρόνια

Ανατέθηκε στον:

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 σε 7 μέρες
(2 Αξιολογήσεις)
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 Περισσότερα

€100 EUR σε 1 μέρα
(139 Αξιολογήσεις)
7.5

22 freelancers κάνουν προσφορές κατά μέσο όρο €152 για αυτή τη δουλειά

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 Περισσότερα

€222 EUR σε 2 μέρες
(45 Αξιολογήσεις)
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 Περισσότερα

€175 EUR σε 7 μέρες
(6 Αξιολογήσεις)
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 Περισσότερα

€120 EUR σε 2 μέρες
(35 Αξιολογήσεις)
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 Περισσότερα

€120 EUR σε 2 μέρες
(22 Αξιολογήσεις)
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 Περισσότερα

€90 EUR σε 7 μέρες
(10 Αξιολογήσεις)
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 Περισσότερα

€50 EUR σε 1 μέρα
(2 Αξιολογήσεις)
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 σε 7 μέρες
(6 Αξιολογήσεις)
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 Περισσότερα

€150 EUR σε 3 μέρες
(20 Αξιολογήσεις)
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 Περισσότερα

€120 EUR σε 1 μέρα
(4 Αξιολογήσεις)
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 Περισσότερα

€140 EUR σε 7 μέρες
(6 Αξιολογήσεις)
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 σε 7 μέρες
(0 Αξιολογήσεις)
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 Περισσότερα

€140 EUR σε 2 μέρες
(0 Αξιολογήσεις)
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 σε 7 μέρες
(0 Αξιολογήσεις)
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 Περισσότερα

€118 EUR σε 5 μέρες
(0 Αξιολογήσεις)
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 Περισσότερα

€250 EUR σε 1 μέρα
(0 Αξιολογήσεις)
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 Περισσότερα

€140 EUR σε 1 μέρα
(0 Αξιολογήσεις)
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 σε 1 μέρα
(0 Αξιολογήσεις)
0.0