Discussion List Archives

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ddlm-group] LOOP versus LIST




On 6/02/10 12:48 AM, "Herbert J. Bernstein" <yaya@bernstein-plus-sons.com>
wrote:

> The real issue here is the data model that we are supporting -- databases
> or something with tighter control over internals.  Especially after the
> discussions at the ESRF HDF5 hyperspectral data workshop last month, I am
> increasingly convinced that it is a serious mistake to move away from
> the database model.  While tighter control over internals is tempting, in
> the end, as we move more into multithreaded, multiprocessor multiwriter
> applications, the greater the performance penalty we will pay for
> over-specifying the internal representation of a CIF, especially in ways
> that deviate from the relational model.

I agree that in essence we are enshrining a database model in what we do.
Though I am not keen that the only model we consider is the relational
model. Though the current form of CIF maps easily in to the relation model
it is not required to. But I agree having database model(s) in mind with
what we do is essential.
 
> Nothing is gained for users in making a mandatory distinction between
> single row loops and the same tags with individual values.  I propose
> that CIF2 adopt the DDL2 mmCIF approach of treating them as equivalent.
> Joe is right that having the distinction in the DDL then forces all
> parsers to refer to the dictionary to be able to make this pointless
> distinction.

But in most databases you define the schema (attribute ordering and type
etc) and then load multiple records. Yes you can update and insert one at a
time where you have a flattening of the loop, but that is more with updating
and changing. I can see a lot of application level software that would
handle individual rows in this way, but CIF is meant to be an archiving
formalism and to that extent I think it is more helpful to (at  least in
archiving) maintain a clear consistency between the schema (DDL) and the
data file.

cheers

Nick

--------------------------------
Associate Professor N. Spadaccini, PhD
School of Computer Science & Software Engineering

The University of Western Australia    t: +61 (0)8 6488 3452
35 Stirling Highway                    f: +61 (0)8 6488 1089
CRAWLEY, Perth,  WA  6009 AUSTRALIA   w3: www.csse.uwa.edu.au/~nick
MBDP  M002

CRICOS Provider Code: 00126G

e: Nick.Spadaccini@uwa.edu.au




_______________________________________________
ddlm-group mailing list
ddlm-group@iucr.org
http://scripts.iucr.org/mailman/listinfo/ddlm-group

Reply to: [list | sender only]
International Union of Crystallography

Scientific Union Member of the International Council for Science (admitted 1947). Member of CODATA, the ICSU Committee on Data. Member of ICSTI, the International Council for Scientific and Technical Information. Partner with UNESCO, the United Nations Educational, Scientific and Cultural Organization in the International Year of Crystallography 2014.

ICSU Scientific Freedom Policy

The IUCr observes the basic policy of non-discrimination and affirms the right and freedom of scientists to associate in international scientific activity without regard to such factors as ethnic origin, religion, citizenship, language, political stance, gender, sex or age, in accordance with the Statutes of the International Council for Science.