- glue-wg - lists.ogf.org

ldapsearch
by Burke, S (Stephen) 07 Apr '08

07 Apr '08

Hi *, I thought I'd publicise this page I wrote recently to explain how to use ldapsearch to query the information system: http://egee-uig.web.cern.ch/egee-uig/production_pages/Advancedldapsearch .html Let me know if you see any mistakes. Stephen

1 0

Minutes and next Call
by Felix Nikolaus Ehm 04 Apr '08

04 Apr '08

Dear all, please find the minutes of the today telcon here: http://forge.ogf.org/sf/wiki/do/viewPage/projects.glue-wg/wiki/PhoneMeet ing20080404 The next call is planned to take place 09.04.2008, 2pm CEST. Cheers, Felix --- Felix Ehm IT-GD tel : +41 22 7674580 CERN, Switzerland -----------------------------------------

1 0

Glue 2.0 Storage Schema Telcon
by Felix Nikolaus Ehm 04 Apr '08

04 Apr '08

Dear all, this is a reminder for our today telecon (2pm CEST): http://forge.ogf.org/sf/wiki/do/viewPage/projects.glue-wg/wiki/PhoneMeet ing20080404? Cheers, Felix --- Felix Ehm IT-GD tel : +41 22 7674580 CERN, Switzerland -----------------------------------------

1 0

Minutes and next Call
by Felix Nikolaus Ehm 03 Apr '08

03 Apr '08

Dear all, please find the minutes of the today telcon here: http://forge.ogf.org/sf/wiki/do/viewPage/projects.glue-wg/wiki/PhoneMeet ing20080403 the next telcon will to tomorrow 4.4.2008 at 2pm CEST. Cheers, Felix --- Felix Ehm IT-GD tel : +41 22 7674580 CERN, Switzerland -----------------------------------------

1 0

Glue 2.0 Storage Schema Telcon
by Felix Nikolaus Ehm 03 Apr '08

03 Apr '08

Dear all, this is a reminder for our today telecon (4pm CET) http://forge.ogf.org/sf/wiki/do/viewPage/projects.glue-wg/wiki/PhoneMeet ing20080403 Cheers, Felix --- Felix Ehm IT-GD tel : +41 22 7674580 CERN, Switzerland -----------------------------------------

2 1

minutes from today telecon
by Sergio Andreozzi 01 Apr '08

01 Apr '08

Dear all, please, find the minutes of the today telecons here: http://forge.ogf.org/sf/wiki/do/viewPage/projects.glue-wg/wiki/PhoneMeeting… http://forge.ogf.org/sf/wiki/do/viewPage/projects.glue-wg/wiki/PhoneMeeting… in the computing call, we have discussed the use case of dynamic deployment of VM exposed by Owen. We spent the rest of the session in cleaning all the data types and unit of measures which are now consistent in the whole document. The new draft (no. 33) is available in the document repository: http://forge.ogf.org/sf/go/projects.glue-wg/docman.root.drafts Have a nice weekend, Sergio -- Sergio Andreozzi INFN-CNAF, Tel: +39 051 609 2860 Viale Berti Pichat, 6/2 Fax: +39 051 609 2746 40126 Bologna (Italy) Web: http://www.cnaf.infn.it/~andreozzi

3 4

Re: [glue-wg] Modeling Relationships in GlueSQL
by Felix Nikolaus Ehm 31 Mar '08

31 Mar '08

Hi Timo, On Fri, 28 Mar 2008, Timo Baur wrote: > Hello Felix, > > we here at DMON now try to feed first data into our Glue2.0 based DB. > We have some issues regarding the unique IDs, while trying to model > relationships between ComputingResources, > Locations and AdminDomains. > > What we - still unsucessfully - tried to do is: > > REPLACE INTO Location (...) VALUES (...); > SELECT @locationID:=id FROM Location WHERE localID="..."; > REPLACE INTO AdminDomain (...,locationID) VALUES (...,@locationID); > > > mysql> SELECT uniqueID,locationID FROM AdminDomain; > +--------------------------------------+------------+ > | uniqueID | locationID | > +--------------------------------------+------------+ > | https://dmon-unic.fz-juelich.de:9115 | 197 | > +--------------------------------------+------------+ > > ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key > constraint fails (`GLUE20/AdminDomain`, CONSTRAINT > `fk_AdminDomainlocationID` FOREIGN KEY (`locationID`) REFERENCES > `Location` (`id`)) > It seems to me that you didn't specify a ParentTypeID which must exist in the EntryTable when you do the REPLACE INSERT. This is mandatory to identify of which type the parentID is. That could cause the constraint error.I'll recheck the cases with the schema. > We are wondering if we really should ask the DB for the id in the RS or > if there is another > way to relate the tables by only using the unique id of the DS. > I also thought of dropping the numerical presentation of the id and instead using the document schema ID. But then table joins with several key elements would get quite complicated. Example : If you want to find the Endpoint which serves a certain Share then you would need the localId and parentID from the Share in the EndpointShareLNK table. With the current solution you only have one id you need to join. Another reason I have in mind is the fact when doing joins string comparison operations are more heavy-weight than number comparisons. Furthermore, modern database systems also support partitioning which is an effective way of speeding up search access in large datasets. However, MySQL for example supports currently (5.1) only the datatype integer. Generally, I do agree with you that this argumentation looses it importance if you have exactly one uniqueID for a table (Service, Endpoint, etc.). I am currently updating the schema to the latest (draft 33) of GLUE 2.0. There isn't much change for the main enties and Computing but for the storage part. I'll check again the 'numerical id issue' and sent you an update as soon as I have finished it. Cheerio, Felix

1 0

Storge schema telcon
by Felix Nikolaus Ehm 31 Mar '08

31 Mar '08

Dear all, this is another proposal for two glue 2.0 storage schema telcons : * Thursday, 03.04.2008 4pm, 1.5h * Friday, 04.04.2008 2pm, 1.5h Please let me know if you can NOT make it. Thanks a lot. Cheerio, Felix --- Felix Ehm IT-GD tel : +41 22 7674580 CERN, Switzerland -----------------------------------------

1 0

telecon reminder - today 10 AM (implementation) and 11.30 AM (computing)
by Sergio Andreozzi 28 Mar '08

28 Mar '08

Dear all, this is a reminder for our today telecons: http://forge.ogf.org/sf/wiki/do/viewPage/projects.glue-wg/wiki/PhoneMeeting… http://forge.ogf.org/sf/wiki/do/viewPage/projects.glue-wg/wiki/PhoneMeeting… Cheers, Sergio -- Sergio Andreozzi INFN-CNAF, Tel: +39 051 609 2860 Viale Berti Pichat, 6/2 Fax: +39 051 609 2746 40126 Bologna (Italy) Web: http://www.cnaf.infn.it/~andreozzi

2 2

Minutes, Draft 30 and Next call
by Felix Nikolaus Ehm 27 Mar '08

27 Mar '08

Dear all, here are the minutes from today: Minutes from the today call: http://forge.ogf.org/sf/wiki/do/viewPage/projects.glue-wg/wiki/PhoneMeet ing20080327_1 Draft 30 of GLUE 2.0 Spec: http://forge.ogf.org/sf/docman/do/listDocuments/projects.glue-wg/docman. root.drafts Cheerio, Felix --- Felix Ehm IT-GD tel : +41 22 7674580 CERN, Switzerland -----------------------------------------

1 0