793 reputation
11839
bio website phpfreaks.com
location United States (but travelling)
age 35
visits member for 3 years, 1 month
seen Aug 24 at 14:04

intentionally left blank


Dec
17
asked How to categorize rows by SUM of a column in mysql?
Dec
16
accepted How to GROUP_CONCAT between given rows?
Dec
16
accepted How to split a string to and get info from another table in mysql
Dec
16
accepted Which RDBMS has the most advanced “table-valued” functions?
Dec
16
accepted How to order query results by tag weight in IN('tag1', 'tag2', 'tag3')
Dec
16
accepted Is it bad to create many mysql temporary tables simultaneously?
Dec
16
asked How to UPDATE a column to SET previous row value to NULL cells?
Dec
14
accepted Splitting a column to normalized table
Dec
14
asked How to GROUP_CONCAT between given rows?
Dec
13
asked Splitting a column to normalized table
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
@JustinCave The reason for denormalization is that the individual words, if see in the original question, have no meaning or dependency in the database. We just want to calculate the sum of scores for a sentence (not even word). Thus, splitting the cell to numerous rows is not beneficial. De-normation in this case, is to create another table with one-to-many relationships to calculate the sentence score. This is indeed my goal; but that table should be virtual, because after update it is no longer needed.
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
@JustinCave I agree with your standpoint, but sometimes it is needed to de-normalize a database.
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
Perl/Python/PHP all can handle string functions well, but the problem is that fetching data and updating the database for thousands of queries is not efficient in practice. I've heard that PostgreSQL is fairly advanced, but I did not find more string functions comparing with mysql (of course, by a quick review).
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
This is a subtle solution for my case, but unfortunately I'm on linux.
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
@RemusRusanu I do not look for an advanced RDMBS, as I think mysql is. I think string functions of mysql are not very extensive. I am looking for a RDBMS (advanced or basic) but with a wide range of functions for strings (table valued).
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
@MartinSmith I edited the title as you instructed.
Dec
12
revised Which RDBMS has the most advanced “table-valued” functions?
edited title
Dec
12
asked Which RDBMS has the most advanced “table-valued” functions?
Dec
12
asked How to split a string to and get info from another table in mysql
Dec
4
accepted How to concatenate a column after x rows?