Hello I had a first interview with Bloomberg and did not pass. I thought about the possible solutions but I cannot figure out what the optimal solution is. \n\nDesign a module and insert a data looking like this.\n\n```python\n(id:1, timestamp: 1pm, tags: ["us", "uk", "japan"])\n```\n\nYou want to query all the data by passing in a tag and timestamp.\n\n```python\n(tag: "us", start_time: "12pm", end_time: "2pm")\n```\n\nThe module will read more than insert. Reading should be faster than inserting. What is the possible optimal solution that read is more optimized than insert? Thank you in advance\n\n\n\n\n

Hello I had a first interview with Bloomberg and did not pass. I thought about the possible solutions but I cannot figure out what the optimal solution is. \n\n