summarization

About "AUTOMATIC TEXT SUMMARIZER (lingustic based)"

Hello, I am having "AUTOMATIC TEXT SUMMARIZER (linguistic approach)" as my final year project. I have collected enough research papers and gone through them. Still i am not very clear about the 'how-to-go-for-it' thing. Basically i found "AUTOMATIC TEXT SUMMARIZER (statistical based)" and found that it is much easier compared to my...

MySQL ON DUPLICATE KEY UPDATE with nullable column in unique key

Our MySQL web analytics database contains a summary table which is updated throughout the day as new activity is imported. We use ON DUPLICATE KEY UPDATE in order that the summarization overwrites earlier calculations, but are having difficulty because one of the columns in the summary table's UNIQUE KEY is an optional FK, and contains ...

Count records having three or more items

I'd like to group records in two categories: Items having three or more records Items having less than three items How do I go about this? I'm looking at using annotate(). ...

Data in different resolutions

I have two tables, records are being continuously inserted to these tables from outside source. Lets say these tables are keeping statistics of user interactions. When a user is clicking a button the details of that click (the user, time of click etc.) is written to one of the tables. When a user mouseovers that button a record is added ...

disaggregate summarised table in SQL Server 2008

Hi I've received data from an external source, which is in a summarised format. I need a way to disaggregate this to fit into a system I am using. To illustrate, suppose the data I received looks like this: receivedTable: Age Gender Count 40 M 3 41 M 2 I want this is a disaggregated format like t...

How can I access the in-progress SummaryRow in the summaryFunction of a GroupingCollection?

In Flex 3, I'm using a GroupingCollection to create a hierarchical display of data in my app. One of the summarizations I'm doing requires access to another value in the summary row; I'm calculating the average of a column in one place that is necessary for the calculation of a related value in a second summary column. This related value...

How to select part of a text on mysql?

I have a column saved as LONGTEXT on mysql. This text saves rich text. I'm currently reading all the text then fixing it using javascript to get the first 100 characters in a way not to split the word in its middle. Yet this way don't seem the best way to do it. I want to select a summary directly using the query, yet I also want to be ...

Software to find the most occurring unique words in a file

Hi, I remember once visiting a website that would present a book/novel summary in the most interesting way. It would show a list of words that were repeated most often in that book and which were unique/uncommon. In other words, it would show the maximum frequency words but not common words like the, I, you etc. Then it needs to have th...