SQL-Query for Maria-DB, linking two tables
€30-250 EUR
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #24376439
Σχετικά με την εργασία
Ανατέθηκε στον:
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.
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 Περισσότερα
22 freelancers κάνουν προσφορές κατά μέσο όρο €152 για αυτή τη δουλειά
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
SQL Expert with experience of 15 years in various applications. I have done many sql projects in India and overseas.
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 Περισσότερα
hello, i have good experience in SQL query. i can do your task if you are interested please contact me. thanks
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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