Re: Update of the MySQL backend database (Csongor Nyulas)
<[email protected]> Fri, 26 Apr 2013 06:24:18 +0000
| Newsgroups | gmane.comp.misc.ontology.protege.general |
|---|---|
| Message-ID | <1CEB352769F2A34A9FB65BC8322A363A1D1299DE@S-DC-ESTJ04-B.net1.cec.eu.int> |
Hi Csongor, MappingMaster is really great and works fine for my purpose! Some small hints I would like to share which took me some trials to find out: - if more than one Facts: or Annotations: attributes are entered, they need to be separated by a comma (,) - if Facts: and Annotations: need to be entered, they need to be entered in 2 separate descriptions. Further the tutorials on DSL and GUI of the MappingMaster were of great help. Thanks a lot for all that (also for the DataMaster)!! Best regards Eddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, April 25, 2013 9:05 PM To: [email protected] Subject: protege-discussion Digest, Vol 81, Issue 27 Send protege-discussion mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://mailman.stanford.edu/mailman/listinfo/protege-discussion or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of protege-discussion digest..." Today's Topics: 1. Re: Update of the MySQL backend database (Csongor Nyulas) (Csongor Nyulas) 2. Plugin development in 4.1 (Uri Shani) 3. Cfp - 1st International Workshop on Data Mining on Linked Data (DMoLD'13) with Linked Data Mining Challenge @ ECML/PKDD (Claudia d'Amato) ---------------------------------------------------------------------- Message: 1 Date: Wed, 24 Apr 2013 14:47:02 -0700 From: Csongor Nyulas <[email protected]> To: [email protected] Subject: Re: [protege-discussion] Update of the MySQL backend database (Csongor Nyulas) Message-ID: <[email protected]> Content-Type: text/plain; charset=windows-1252; format=flowed Hi Eddy, You should definitely try out DataMaster [1] and MappingMaster [2]. Both should work with Protege 3.4.8 and later. In DataMaster, class names and individual URIs are created automatically based on a pattern that ensure unique names based on the imported data source. If the class/individual URIs are important to you, you can rename them later in another process. DataMaster works with any database that has a JDBC driver, and with anything that can be served as an ODBC data source (such as CSV and text files). MappingMaster works with Excel spread sheets, and has a very powerful mapping language that allows you to manipulate your input data, and it also allows you to specify how the created class/instance names should be generated based on the source content. Another good alternative would be to write a small Java application using the Protege OWL API [3] that would do the import. In that case you would have the freedom to do custom processing of the data prior to import, and you could reuse the application in the future. Csongor [1] http://protegewiki.stanford.edu/wiki/DataMaster [2] http://protege.cim3.net/cgi-bin/wiki.pl?MappingMaster [3] http://protegewiki.stanford.edu/wiki/ProtegeOWL_API_Programmers_Guide On 04/23/2013 11:15 PM, [email protected] wrote: > Hi Csongor, > > Thanks a lot for your advice. > > What I try to do is uploading new individuals, some hundreds. > > Configuring the Data master tab in Prot?g? 3.4.8 might help perhaps. > I'm not sure if the tab supports 3.4.8 and as far as I remembered, new classes were created automatically based on the tab name of the Excel sheet. > The direct import in MySQL seemed a swift alternative but, I would appreciate your advice for any alternative you judge better. > The import may be from .CSV files too. > > Thanks in advance. > > Kind regards - Meilleures salutations - Mit freundlichen Gr?ssen - Met vriendelijke groeten > > Eddy Vanderlinden > > ------------- > DIGIT Unit 01, Brussels > MIA - Methodologies, Interoperability and Architectures > Tel.: +32 2 295 26 64 > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] > Sent: Tuesday, April 23, 2013 9:04 PM > To: [email protected] > Subject: protege-discussion Digest, Vol 81, Issue 25 > > Send protege-discussion mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://mailman.stanford.edu/mailman/listinfo/protege-discussion > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of protege-discussion digest..." > > > Today's Topics: > > 1. Re: Update of the MySQL backend database (Csongor Nyulas) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 23 Apr 2013 11:09:15 -0700 > From: Csongor Nyulas <[email protected]> > To: [email protected] > Subject: Re: [protege-discussion] Update of the MySQL backend database > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1"; Format="flowed" > > Hi Eddy, > > The Protege 3 database back-end is not meant to be edited directly > (through SQL updates or Excel or anything). The adding of new > information (new rows) is an especially bad idea, since it is very easy > to break things. > The Protege back-end is NOT a triple store, but rather a "proprietary" > storage format developed originally for frames ontologies, and later > adapted to be used to store OWL ontologies. > > You should use the Protege/WebProtege client or the Protege API to > modify the content of your ontology. > > If you explain what you try to achieve, maybe we can provide even more > specific advise. > > Regards, > Csongor > > > On 04/23/2013 02:15 AM, [email protected] wrote: >> Hello, >> MS Excel offers in the 2010 version a nice feature. >> When we have the MySQL workbench installed on the same PC, there is a >> connection possible from Excel to MySQL. >> This is accessible through the button as shown hereby . >> We can retrieve and update information in the spreadsheet. >> The possibility to upload triples is available too. >> However, when we do so, they do not appear in the ontology (updates of >> existing triples do). >> We are using Prot?g? 3.4.8 with Webprot?g? 1 as user interface, the >> collaborative version in the background does not show the new triples >> neither. >> An example of the uploaded data in the spreadsheet is shown here: >> *frame* *frame_type* *slot* *facet* *is_template* *value_index* >> *value_type* *short_value* *long_value* >> ArisDiagram 25 :DIRECT-TYPE >> 0 1 9 http://ec.europa.eu/ontologies/EC_Glossary.owl#EC_Concept >> http://ec.europa.eu/ontologies/EC_Glossary.owl#EC_Concept 9 >> :DIRECT-INSTANCES >> 0 206 25 ArisDiagram >> ArisDiagram 25 :NAME >> 0 0 3 ArisDiagram >> ArisDiagram 25 http://www.w3.org/1999/02/22-rdf-syntax-ns#type >> 0 0 9 http://ec.europa.eu/ontologies/EC_Glossary.owl#EC_Concept >> ArisDiagram 25 http://www.w3.org/2004/02/skos/core#prefLabel >> 0 0 3 Aris diagram >> >> Is there anything we are missing here to make this function? >> Thanks in advance. >> Kind regards >> Eddy Vanderlinden >> ------------- >> DIGIT Unit 01, Brussels >> MIA - Methodologies, Interoperability and Architectures >> Tel.: +32 2 295 26 64 >> >> >> _______________________________________________ >> protege-discussion mailing list >> [email protected] >> https://mailman.stanford.edu/mailman/listinfo/protege-discussion >> >> Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03 > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://mailman.stanford.edu/pipermail/protege-discussion/attachments/20130423/d42eafc9/attachment-0001.html> > -------------- next part -------------- > A non-text attachment was scrubbed... > Name: not available > Type: image/jpeg > Size: 2600 bytes > Desc: not available > URL: <http://mailman.stanford.edu/pipermail/protege-discussion/attachments/20130423/d42eafc9/attachment-0001.jpe> > > ------------------------------ > > _______________________________________________ > protege-discussion mailing list > [email protected] > https://mailman.stanford.edu/mailman/listinfo/protege-discussion > > > End of protege-discussion Digest, Vol 81, Issue 25 > ************************************************** > _______________________________________________ > protege-discussion mailing list > [email protected] > https://mailman.stanford.edu/mailman/listinfo/protege-discussion > > Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03 ------------------------------ Message: 2 Date: Thu, 25 Apr 2013 10:27:58 +0300 From: Uri Shani <[email protected]> To: [email protected] Subject: [protege-discussion] Plugin development in 4.1 Message-ID: <OF5BFCA621.844A03F5-ONC2257B58.00289A1B-C2257B58.0029071E@il.ibm.com> Content-Type: text/plain; charset="us-ascii" Well, I have figured it out by myself after hacking around in all possible directions. Seems that the tabs are initialized and shown only if enabled in the Preferences, so it turned out the Preferences have discovered my new plugin and once Protege opened and I checked the label of the new plugin, the tab appeared as well on the tabs row. Still - I could not find where the extension points are documented so that the time I spent to discover that wisdom can be saved... Thanks, - Uri -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mailman.stanford.edu/pipermail/protege-discussion/attachments/20130425/1f8e1e53/attachment-0001.html> ------------------------------ Message: 3 Date: Thu, 25 Apr 2013 18:41:40 +0200 From: Claudia d'Amato <[email protected]> To: destinatari-ignoti:; Subject: [protege-discussion] Cfp - 1st International Workshop on Data Mining on Linked Data (DMoLD'13) with Linked Data Mining Challenge @ ECML/PKDD Message-ID: <[email protected]> Content-Type: text/plain; charset="iso-8859-15"; Format="flowed" [Apologies for multiple postings] --------------------------------------------------------------------------------- Call for Papers for Data Mining on Linked Data (DMoLD'13) workshop with Linked Data Mining Challenge --------------------------------------------------------------------------------- To be held during the European Conference on Machine Learning and Principles and Practice of Knowledge Discovery in Databases, ECML/PKDD 2013, 23-27 September 2013 Prague, Czech Republic (http://www.ecmlpkdd2013.org/) The workshop consists of an Open Track and of a Challenge Track. The Open Track will expect submission of regular research papers, describing novel approaches to applying Data Mining techniques on the Linked Data sources. Participation in the Challenge Track will require the participants to download a real-world RDF dataset from the domain of Public Contract Procurement, and accomplish at least one of the three pre-defined tasks on it using their own or publicly available data mining tool. IMPORTANT DATES: * May 1, 2013 - Challenge Track data for Task 1 and Task 3 * May 15, 2013 - Challenge Track data for Task 2 * June 21, 2013 - Deadline for Challenge Track results * June 28, 2013 - Deadline for paper submissions (both Open Track and of a Challenge Track) For more info about the Challenge, visit http://keg.vse.cz/dmold2013 For more info about the ECML/PKDD 2013, visit http://www.ecmlpkdd2013.org Claudia d'?Amato, Petr Berka, Vojtech Svatek & Krzysztof Wecel Workshop organizers -------------- next part -------------- A non-text attachment was scrubbed... Name: claudia_damato.vcf Type: text/x-vcard Size: 331 bytes Desc: not available URL: <http://mailman.stanford.edu/pipermail/protege-discussion/attachments/20130425/ec2a3628/attachment-0001.vcf> ------------------------------ _______________________________________________ protege-discussion mailing list [email protected] https://mailman.stanford.edu/mailman/listinfo/protege-discussion End of protege-discussion Digest, Vol 81, Issue 27 ************************************************** _______________________________________________ protege-discussion mailing list [email protected] https://mailman.stanford.edu/mailman/listinfo/protege-discussion Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03