Which DB technology is sued to solve the following search issue? [closed]

by

Practically any database should be able to run such queries.

In the case of SQL, using a simple WHERE ... LIKE ... condition with wildcards should be sufficient for simple cases.

The interesting question will be how to scale this once you are dealing with much larger amounts of data, think YouTube for video portals. But until performance really becomes an issue, adding additional complexity can most likely be considered premature optimization and should be avoided.

More Related Contents:

  1. How to select the nth row in a SQL database table?
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  5. Storing JSON in database vs. having a new column for each key
  6. How do I restore a dump file from mysqldump?
  7. Using an Alias in SQL Calculations
  8. Adding a leading zero to some values in column in MySQL
  9. Cast int to varchar
  10. View’s SELECT contains a subquery in the FROM clause
  11. Check for x consecutive days – given timestamps in database
  12. MySQL Insert Into from one Database in another
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. Import SQL file into mysql
  15. Does mysql have the equivalent of Oracle’s “analytic functions”?
  16. How to skip certain database tables with mysqldump?
  17. “where 1=1” statement [duplicate]
  18. How to set a MySQL row to READ-ONLY?
  19. MySQL: LAST_INSERT_ID() returns 0
  20. Remove special characters from a database field
  21. Using reserved words in column names
  22. MySQL query, MAX() + GROUP BY
  23. Calculating a Moving Average MySQL?
  24. MySQL – Replace Character in Columns
  25. Strings as Primary Keys in MYSQL Database [closed]
  26. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  27. FIND_IN_SET with multiple value [duplicate]
  28. What is the difference between SQL and MySQL? [closed]
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment