|
| Featured Contents |
| Question of the Day |
|
| The Voice of the DBA |
Daily Coping Tip Reflect on what you accomplished this week I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours. |
Complex Searching Searching for data in our systems is sometimes hard. If you've ever needed to generically search a lot of text, it's not easy to write code to do this in an efficient manner. If you get into full-text searching, likely you would look beyond SQL Server as the full-text indexing in SQL Server isn't great. What if you had to search in more complex data? Imagine that your users were looking for words in audio files, or they wanted to find images that matched others. Those are even more complex searches, and I expect that few people have had to deal with this, though I do expect it to be something more people will do more across time in some applications. I saw an article about Google Lens coming to the desktop, allowing you to clip an image and then search for similar items. While I haven't used this for searching, my kids have. Often they are looking for matches of a product or a place, and they like being able to search for related images. Image search is interesting, as you are looking to match patterns of numbers, but not exact matches. The idea of fuzzy matching parts of an image, which is a series of numeric values,, but not all of them, has to be a very challenging process. I would find this even more complex than doing a -speech-to-text translation from audio and searching for words. Many of us would know how to do produce a solution for searching audio recordings. The theory of how to search for images based on another image is a complex field of study. I don't pretend to know how this might work, and I'm not sure I care. If I have a need for this, I wouldn't expect to need to understand how the system works as this would really be an API call of some sort. I might need to work with the API and understand how to better use it to produce the results my clients need, but that might be the most I'd care about. As with a lot of deeply technical things, I care more about practical applications. On a recent trip, I watched my wife use Google Lens to translate some menus, something I hadn't considered. I usually would type in text and look for meanings, but using the image is much easier. I expect we'll see the need for more complex searches in the future, but for most of us, it will be another service we consume without really understanding how it works, which is probably fine in these situations. Steve Jones - SSC Editor Join the debate, and respond to today's editorial on the forums |
|
| Featured Contents |
