LISTSERV mailing list manager LISTSERV 16.5

Help for QSERV-L Archives


QSERV-L Archives

QSERV-L Archives


QSERV-L@LISTSERV.SLAC.STANFORD.EDU


View:

Message:

[

First

|

Previous

|

Next

|

Last

]

By Topic:

[

First

|

Previous

|

Next

|

Last

]

By Author:

[

First

|

Previous

|

Next

|

Last

]

Font:

Proportional Font

LISTSERV Archives

LISTSERV Archives

QSERV-L Home

QSERV-L Home

QSERV-L  October 2013

QSERV-L October 2013

Subject:

Re: data loading

From:

Kian-Tat Lim <[log in to unmask]>

Reply-To:

General discussion for qserv (LSST prototype baseline catalog)

Date:

Thu, 24 Oct 2013 06:48:59 -0700

Content-Type:

text/plain

Parts/Attachments:

Parts/Attachments

text/plain (31 lines)

> flag (by email or on the page) issues that
> we should think about, discuss etc.

	A few things that came to mind right away:

	Every step should produce metrics (number of rows, at a minimum)
that allow for at least minimal checks on progress and correctness.

	If you don't run manual quality checks after doing a "LOAD DATA
INFILE", why should you need to do so after doing a qserv load?  We need
to make the process so bulletproof that no such checks are needed.  Yes,
things will go wrong during loading; yes, some of those might even be
things we haven't though of; even so, we should be able to develop
essentially a mathematical *proof* that the load will happen correctly
if it is reported as successful (at least given certain assumptions like
"LOAD DATA INFILE" works correctly).

	The partitioning step is very map/reduce-like (with a simple
reduce that could just be concatenation).  While we don't have to use an
off-the-shelf M/R system, we should be able to use all available
resources (i.e. workers) to do this.

-- 
Kian-Tat Lim, LSST Data Management, [log in to unmask]

########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1

Top of Message | Previous Page | Permalink

Advanced Options


Options

Log In

Log In

Get Password

Get Password


Search Archives

Search Archives


Subscribe or Unsubscribe

Subscribe or Unsubscribe


Archives

March 2018
February 2018
January 2018
December 2017
August 2017
December 2016
November 2016
October 2016
September 2016
August 2016
July 2016
June 2016
May 2016
April 2016
March 2016
February 2016
January 2016
December 2015
November 2015
October 2015
September 2015
August 2015
July 2015
June 2015
May 2015
April 2015
March 2015
February 2015
January 2015
December 2014
November 2014
October 2014
September 2014
August 2014
July 2014
June 2014
May 2014
April 2014
March 2014
February 2014
January 2014
December 2013
November 2013
October 2013
September 2013
August 2013
July 2013
June 2013
May 2013
April 2013
March 2013
February 2013
January 2013
December 2012

ATOM RSS1 RSS2



LISTSERV.SLAC.STANFORD.EDU

Secured by F-Secure Anti-Virus CataList Email List Search Powered by the LISTSERV Email List Manager

Privacy Notice, Security Notice and Terms of Use