Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > alt.folklore.computers > #164322

Re: CS instead of math?

From Morten Reistad <first@last.name.invalid>
Newsgroups alt.folklore.computers
Subject Re: CS instead of math?
Date 2016-06-02 15:02 +0200
Organization Me, Myself and I
Message-ID <jbn52d-tff.ln1@sambook.reistad.name> (permalink)
References <573fb25c.33979790@nntp2.rawbw.com> <dra8d6F4papU1@mid.individual.net> <draa83F57qgU1@mid.individual.net> <PM00053449D55C3826@aca41013.ipt.aol.com>

Show all headers | View raw

In article <PM00053449D55C3826@aca41013.ipt.aol.com>,
jmfbahciv  <See.above@aol.com> wrote:
>Andy Burns wrote:
>> Huge wrote:
>>
>>> I spent a LOT of time before retiring (last year)
>>> working on restricting the use of live data in testing
>>
>> One system I look after (the o/s and networking parts rather than the
>> software) takes a nightly copy of the live database into the test
>> database, in the process it mangles all the human readable names,
>> addresses, and identifiers. This gives the same size of data with the
>> same relations between rows in the tables to work on.
>>
>> I think it uses a temporary hash to form the mangled version then throws
>> it away before committing to the test database, I suppose the mangling
>> could be subverted by the developer but he (one left from the original
>> team of three) could subvert the system anyway.
>>
>> It allows testing or demonstrating of problems to the likes of me
>> without seeing patient data, and when I need to test printing it ends up
>> looking like it's in Klingon, hopefully no pharmacy would ever issue
>> such a methadone prescription!
>>
>How do you test anything which needed to be sorted if all the fields
>have junk in them?

It is not junk. It is encrypted transformations of the data.

Example from telephone logs.

There we have fields like caller, callee, when, duration etc.
The caller and callee are telephone numbers. These must match the
routing tables, which are prefix, cost based.

So the scambler matches the caller and callee with the cost
prefix, keeps the numbers that are necessary for that, and scrambles
the rest. The duration is kept, but the time is moved a random 
time back or forward with a 12 hour limit.

e.g. 

I call my parents, caller=4722688356, callee=4755280165, when=1.june.2005 12:33, duration=4m38sec
prefix for the caller is 472 and for the callee 475. So the record in the test
version becomes caller=4720123456, callee=4750987654, when=1.june 2005 18:14 duration=4m38sec.

All the billing code should work fine with this. It is also important that the
scrambled numbers are the same for every scrambling in that run.

Doing such stuff requires a bit of insight into the nature of the data, and
the limits of their confidensiality.

-- mrr

Back to alt.folklore.computers | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

CS instead of math? usenet@only.tnx (Questor) - 2016-05-21 00:57 +0000
  Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-20 22:13 -0400
    Re: CS instead of math? jmfbahciv <See.above@aol.com> - 2016-05-21 11:39 +0000
  Re: CS instead of math? bert <bert.hutchings@btinternet.com> - 2016-05-21 13:23 -0700
    Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-21 22:36 -0400
      Re: CS instead of math? Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2016-05-24 18:00 +0000
        Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-05-24 20:27 +0200
        Re: CS instead of math? Bob Martin <bob.martin@excite.com> - 2016-05-25 06:56 +0100
          Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-05-25 07:42 +0100
            Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-05-25 09:39 +0200
              Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-05-25 09:37 +0100
                Re: CS instead of math? Huge <Huge@nowhere.much.invalid> - 2016-05-25 13:05 +0000
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-26 07:07 -0400
                Re: CS instead of math? Morten Reistad <first@Last.name.invalid> - 2016-05-26 13:34 +0200
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-05-26 14:02 +0100
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-26 19:46 -0400
                Re: CS instead of math? Dave Garland <dave.garland@wizinfo.com> - 2016-05-26 19:17 -0500
                Re: CS instead of math? Peter Flass <peter_flass@yahoo.com> - 2016-05-27 06:56 -0400
              Re: CS instead of math? JimP <solosam90@gmail.com> - 2016-05-25 07:26 -0500
                Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-05-25 14:40 +0200
              Re: CS instead of math? Mike Spencer <mds@bogus.nodomain.nowhere> - 2016-05-25 16:19 -0300
                Re: CS instead of math? Peter Flass <peter_flass@yahoo.com> - 2016-05-25 16:15 -0400
                Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-05-25 22:29 +0200
                Re: CS instead of math? Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2016-05-25 21:19 +0000
              Re: CS instead of math? sidd@situ.com (sidd) - 2016-05-26 16:34 -0400
          Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-26 07:04 -0400
            Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-05-26 13:28 +0200
              Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-05-26 14:06 +0100
                Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-05-26 18:57 +0200
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-05-26 18:19 +0100
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-05-26 18:35 +0100
                Re: CS instead of math? cb@elaine.df.lth.se (Christian Brunschen) - 2016-05-26 22:05 +0000
                Re: CS instead of math? Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2016-05-27 15:33 +0000
                Re: CS instead of math? Mike Spencer <mds@bogus.nodomain.nowhere> - 2016-05-27 15:40 -0300
            Re: CS instead of math? Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2016-05-26 14:43 +0000
              Re: CS instead of math? JimP <solosam90@gmail.com> - 2016-05-26 11:03 -0500
                Re: CS instead of math? scott@slp53.sl.home (Scott Lurndal) - 2016-05-26 16:27 +0000
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-05-26 17:52 +0100
              Re: CS instead of math? Peter Flass <peter_flass@yahoo.com> - 2016-05-26 16:22 -0400
            Re: CS instead of math? usenet@only.tnx (Questor) - 2016-05-31 17:27 +0000
              Re: CS instead of math? Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2016-05-31 20:06 +0000
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-31 21:08 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-01 07:17 +0100
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-01 05:31 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-01 11:56 +0100
                Re: CS instead of math? Andrew Swallow <am.swallow@btopenworld.com> - 2016-06-01 16:00 +0100
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-01 17:15 +0100
                Re: CS instead of math? Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2016-06-01 19:28 +0000
                Re: CS instead of math? Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2016-06-01 17:42 +0000
                Re: CS instead of math? Gene Wirchenko <genew@telus.net> - 2016-06-01 13:03 -0700
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-01 17:05 -0400
                Re: CS instead of math? Gene Wirchenko <genew@telus.net> - 2016-06-01 12:48 -0700
                Re: CS instead of math? Peter Flass <peter_flass@yahoo.com> - 2016-06-01 17:34 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-02 07:50 +0100
                Re: CS instead of math? Bob Eager <news0006@eager.cx> - 2016-06-02 10:37 +0000
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-02 12:33 +0100
                Re: CS instead of math? Bob Eager <news0006@eager.cx> - 2016-06-02 12:08 +0000
                Re: CS instead of math? Huge <Huge@nowhere.much.invalid> - 2016-06-02 08:17 +0000
                Re: CS instead of math? Andy Burns <feb2017-usenet@adslpipe.co.uk> - 2016-06-02 09:49 +0100
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-02 12:09 +0100
                Re: CS instead of math? jmfbahciv <See.above@aol.com> - 2016-06-03 13:16 +0000
                Re: CS instead of math? jmfbahciv <See.above@aol.com> - 2016-06-02 12:09 +0000
                Re: CS instead of math? Andy Burns <feb2017-usenet@adslpipe.co.uk> - 2016-06-02 14:09 +0100
                Re: CS instead of math? Andy Burns <feb2017-usenet@adslpipe.co.uk> - 2016-06-02 14:12 +0100
                Re: CS instead of math? Gene Wirchenko <genew@telus.net> - 2016-06-02 19:44 -0700
                Re: CS instead of math? jmfbahciv <See.above@aol.com> - 2016-06-03 13:16 +0000
                Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-06-02 15:02 +0200
                Re: CS instead of math? Huge <Huge@nowhere.much.invalid> - 2016-06-02 16:44 +0000
                Re: CS instead of math? Huge <Huge@nowhere.much.invalid> - 2016-06-02 16:43 +0000
                Re: CS instead of math? Huge <Huge@nowhere.much.invalid> - 2016-06-02 16:42 +0000
                Re: CS instead of math? Peter Flass <peter_flass@yahoo.com> - 2016-06-02 16:41 -0400
                Re: CS instead of math? Huge <Huge@nowhere.much.invalid> - 2016-06-02 22:18 +0000
                Re: CS instead of math? Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2016-06-01 17:42 +0000
                Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-06-01 22:03 +0200
                Re: CS instead of math? Gene Wirchenko <genew@telus.net> - 2016-06-01 12:47 -0700
              Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-31 20:58 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-01 07:29 +0100
                Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-06-01 11:59 +0200
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-01 06:48 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-01 12:41 +0100
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-01 17:04 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-02 07:59 +0100
                Re: CS instead of math? Huge <Huge@nowhere.much.invalid> - 2016-06-02 08:18 +0000
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-02 19:53 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-01 12:15 +0100
                Re: CS instead of math? Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2016-06-01 17:42 +0000
              Re: CS instead of math? jmfbahciv <See.above@aol.com> - 2016-06-01 13:51 +0000
    Re: CS instead of math? "gareth G4SDW GQRP #3339" <no.spam@thank.you.invalid> - 2016-05-22 11:27 +0100
      Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-22 07:21 -0400
        Re: CS instead of math? jmfbahciv <See.above@aol.com> - 2016-05-22 13:15 +0000
          Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-22 09:53 -0400
        Re: CS instead of math? usenet@only.tnx (Questor) - 2016-05-25 07:18 +0000
          Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-05-25 09:42 +0200
            Re: CS instead of math? jmfbahciv <See.above@aol.com> - 2016-05-25 13:11 +0000
              Re: CS instead of math? Peter Flass <peter_flass@yahoo.com> - 2016-05-25 16:15 -0400
                Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-05-25 22:31 +0200
                Re: CS instead of math? Andrew Swallow <am.swallow@btopenworld.com> - 2016-05-26 11:23 +0100
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-05-26 11:37 +0100
              Re: CS instead of math? usenet@only.tnx (Questor) - 2016-05-26 17:56 +0000
            Re: CS instead of math? sidd@situ.com (sidd) - 2016-05-26 16:36 -0400
              Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-26 19:51 -0400
          Re: CS instead of math? "Osmium" <r124c4u102@comcast.net> - 2016-05-25 07:43 -0500
            Re: CS instead of math? usenet@only.tnx (Questor) - 2016-05-26 17:55 +0000
          Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-26 07:14 -0400
            Re: CS instead of math? usenet@only.tnx (Questor) - 2016-05-27 17:40 +0000
              Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-27 18:46 -0400
                Re: CS instead of math? usenet@only.tnx (Questor) - 2016-05-31 17:28 +0000
                Re: CS instead of math? Peter Flass <peter_flass@yahoo.com> - 2016-05-31 16:09 -0400
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-05-31 21:07 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-01 08:58 +0100
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-01 05:48 -0400
                Re: CS instead of math? Morten Reistad <first@last.name.invalid> - 2016-06-01 12:06 +0200
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-01 06:46 -0400
                Re: CS instead of math? sidd@situ.com (sidd) - 2016-06-03 16:05 -0400
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-03 20:49 -0400
                Re: CS instead of math? sidd@situ.com (sidd) - 2016-06-04 22:29 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-01 12:27 +0100
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-01 17:07 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-02 08:12 +0100
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-02 19:56 -0400
                Re: CS instead of math? Ahem A Rivet's Shot <steveo@eircom.net> - 2016-06-03 09:17 +0100
                Re: CS instead of math? Gene Wirchenko <genew@telus.net> - 2016-06-01 13:20 -0700
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-01 17:10 -0400
                Re: CS instead of math? usenet@only.tnx (Questor) - 2016-06-02 17:58 +0000
                Re: CS instead of math? "Osmium" <r124c4u102@comcast.net> - 2016-06-02 13:57 -0500
                Re: CS instead of math? Mike Spencer <mds@bogus.nodomain.nowhere> - 2016-06-02 17:43 -0300
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-02 20:08 -0400
                Re: CS instead of math? usenet@only.tnx (Questor) - 2016-06-02 17:58 +0000
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-02 20:05 -0400
                Re: CS instead of math? Bob Eager <news0006@eager.cx> - 2016-06-03 10:38 +0000
                Re: CS instead of math? "gareth G4SDW GQRP #3339" <no.spam@thank.you.invalid> - 2016-06-03 11:41 +0100
                Re: CS instead of math? jmfbahciv <See.above@aol.com> - 2016-06-03 13:16 +0000
                Re: CS instead of math? usenet@only.tnx (Questor) - 2016-06-09 05:49 +0000
                Re: CS instead of math? "J. Clarke" <j.clarke.873638@gmail.com> - 2016-06-09 19:58 -0400
                Re: CS instead of math? usenet@only.tnx (Questor) - 2016-06-17 03:35 +0000
                Re: CS instead of math? Gene Wirchenko <genew@telus.net> - 2016-06-02 19:47 -0700

csiph-web