Regular Expression Matching

Day 67 — Regular Expression Matching

Coding problem

Solution outline (coding)

Focus on the DP pattern. Start by writing out a few examples by hand, then identify the invariant you must maintain (e.g., prefix sums, window bounds, visited set, heap ordering). Aim for an implementation you can explain in under a minute, including time and space complexity.

# Solution template based on the main pattern for this day.
# Replace this with your final, production-ready solution as you practice.

SQL question

pattern(text_id, s, p). BigQuery: for simplified regex patterns, show how far you can go using SQL functions vs external engines and prototype a limited matcher.

How to approach (SQL)

Break the prompt into steps:

• Identify source tables, required joins, and filters (especially on time partitions).
• Decide where you need GROUP BY vs. window functions (e.g., ROW_NUMBER, SUM() OVER, COUNT() OVER).
• For BigQuery, think about partitioning and clustering to avoid unnecessary full scans.
• Write the query in stages (CTEs) so each step is easy to debug and reason about. Finish by checking edge cases: nulls, late events, duplicated keys, and extreme values.