Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I would start by deciding on a standard way to represent all the information I'm interested in: event name, start/end time (and date), guest list, location. For example, I might use an XML notation like this:</p> <pre><code>&lt;event&gt; &lt;name&gt;meet Sam&lt;/name&gt; &lt;starttime&gt;16:30 07/06/2010&lt;/starttime&gt; &lt;endtime&gt;17:30 07/06/2010&lt;/endtime&gt; &lt;/event&gt; </code></pre> <p>I'd then aim to build up a corpus of diary entries about dates, annotated with their XML forms. How would I collect the data? Well, if I was Google, I'd probably have all sorts of ways. Since I'm me, I'd probably start by writing down all the ways I could think of to express this sort of stuff, then annotating it by hand. If I could add to this by going through friends' e-mails and whatnot, so much the better.</p> <p>Now I've got a corpus, it can serve as a set of unit tests. I need to code a parser to fit the tests. The parser should translate a string of natural language into the logical form of my annotation. First, it should split the string into its constituent words. This is is called tokenising, and there is off-the-shelf software available to do it. (For example, see <a href="http://www.nltk.org/" rel="nofollow noreferrer">NLTK</a>.) To interpret the words, I would look for patterns in the data: for example, text following 'at' or 'in' should be tagged as a location; 'for X minutes' means I need to add that number of minutes to the start time to get the end time. Statistical methods would probably be overkill here - it's best to create a series of hand-coded rules that express your own knowledge of how to interpret the words, phrases and constructions in this domain.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do you think the "Quick Add" feature in Google Calendar works?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USTommy Herbert
    1. USTommy Herbert
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONLTK is a fantastic resource and this approach seems similar to my own thinking! Would you be aware of any PHP-based toolkits which you could recommend. I understand the limitations of PHP regarding speed to perform such a complex operation, but am interested in leveraging HipHop (http://developers.facebook.com/blog/post/358) solve this challenge.
      singulars
      1. PO
      1. USmikegreenberg
    2. COI'm afraid I don't know of anything. The following blog entry suggests you need to either roll your own or jump through hoops to use NLTK from PHP. It's a year and a half old, though. http://www.akshatsinghal.com/content/natural-language-processing-php
      singulars
      1. PO
      1. USTommy Herbert
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload