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.
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 start this right now and i have done many project with this skill i can do it so please give me chance to serve you thanks in advance :)
€100 EUR in 1 day
5.0 (139 reviews)
7.5
7.5
22 freelancers are bidding on average €152 EUR for this job
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 duties were: development of different types of reports, dashboards, KPIs, ETLs and functional modules for application`s data layer, Investigation and resolution of performance and locking issues on high loaded production environment. You could accept me and i will share my expertise with you.
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 with experienced professionals and have been designing, developing, modifying, maintaining and fixing bugs for websites, web/mobile app etc, from 7+ years.
Warm Regards,
Kartikay
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 from where it's coming?
- error_tolerance: == this will only check for upper case, lower case and position change of the character?
can You show me some example data from 2 table?
please reply me....
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 & start the project. Thanks
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 always unique?
From your example, it is clear that patterns are case sensitive.
Will there be any wild characters or its a fixed matching of patterns?
Looking forward to your reply.
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 me.
Thank you
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 quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
Thankyou.
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 discuss more details via chat.
THank you
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 all of them. So I have rich experience in DB management and SQL.
I can do your project in time and will be perfect.
Please message me and let me work on your task.
Thank you.
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 to connect and i can assure you i can complete the task with better efficiency. Project delivery corresponds to actual delivery after the project details are confirmed.
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 and PLSQL.
I would be really greatful to complete your tasks on given timeline.
Thanks.
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 business by doing my best.
My clients have never been frustrated with my work and I hope to make you one of them.
Please confirm that I am one of the best fits for you and drop me a message for further discussion.
Thanks and Best Regards.
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 an hour. PM me for a proper discussion.
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
