--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Lookup.java 2014/05/07 16:07:46 2153 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Lookup.java 2015/03/03 08:52:39 2424 @@ -1,95 +1,102 @@ package dk.daoas.fulddaekning; -import java.io.File; -import java.io.FileReader; -import java.util.ArrayList; -import java.util.List; import java.util.Map; -import java.util.Properties; import java.util.Queue; import java.util.concurrent.ConcurrentHashMap; +import java.util.concurrent.CyclicBarrier; +import java.util.concurrent.ThreadPoolExecutor; import java.util.logging.Level; import java.util.logging.Logger; import dk.daoas.fulddaekning.BoundingBox.BoundingBoxException; public class Lookup { - static int max_workers; - static boolean verbose; + + - static Properties conf; - static Logger logger = Logger.getLogger( Lookup.class.toString() ); + final static Logger logger = Logger.getLogger( Lookup.class.toString() ); int postnr; Database db; - ArrayList daekkedeAdresser; + Adresse daekkedeAdresser[]; + Adresse udvidetDaekkedeAdresser[]; Queue queue; Map workers = new ConcurrentHashMap(); - static int flestDaekkedeAntal = 0; - static int flestDaekkedePostnr; - - static int flestIkkeDaekkedeAntal = 0; - static int flestIkkeDaekkedePostnr; + ThreadPoolExecutor threadPool; + CyclicBarrier barrier; + + - public Lookup(int postnr, Database db) { + public Lookup(int postnr, Database db, ThreadPoolExecutor threadPool) { this.postnr = postnr; this.db = db; + this.threadPool = threadPool; } - + public void doLookup() throws BoundingBoxException { logger.info("Starting for postnr=" + postnr); - int queueSize=-1; + Statistik stat = new Statistik(); + Constants consts = Constants.getInstance(); + long start1 = System.currentTimeMillis(); long start2 = 0; + barrier = new CyclicBarrier(LookupMain.max_workers + 1); + try { + + logger.info("Henter _ikke_ daekkede adresser i " + postnr); + queue = db.hentIkkedaekkedeAdresserCache(postnr); + if (queue.size() == 0) { + logger.info("Fandt ikke nogen _ikke_ daekkede adresser i " + postnr); + return; + } + BoundingBox bbox = db.getBoundingbox(postnr); bbox.validateBbox(); + BoundingBox udvidetBbox = db.getBoundingbox(postnr); + udvidetBbox.adjustToMargin( consts.getMaxDistance() ); + + logger.info("Henter udvidet daekkede adresser i " + postnr); + udvidetDaekkedeAdresser = db.hentDaekkedeAdresserCache(udvidetBbox); + + logger.info("Bbox=" + bbox); - bbox.adjustToMargin(); + bbox.adjustToMargin( consts.getKmMargin() ); logger.info("Bbox Adjusted=" + bbox); logger.info("Henter daekkede adresser i " + postnr); - daekkedeAdresser = db.hentDaekkedeAdresser(bbox); - - logger.info("Henter _ikke_ daekkede adresser i " + postnr); - queue = db.hentIkkedaekkedeAdresser(postnr); - queueSize = queue.size(); + daekkedeAdresser = db.hentDaekkedeAdresserCache(bbox,udvidetDaekkedeAdresser); - if (daekkedeAdresser.size() > flestDaekkedeAntal) { - flestDaekkedeAntal = daekkedeAdresser.size(); - flestDaekkedePostnr = postnr; - } + - if (queueSize > flestIkkeDaekkedeAntal) { - flestIkkeDaekkedeAntal = queueSize; - flestIkkeDaekkedePostnr = postnr; - } + stat.postnr = postnr; + stat.antalDaekkede = daekkedeAdresser.length; + stat.antalIkkeDaekkede = queue.size(); + stat.totalDataset = stat.antalDaekkede * stat.antalIkkeDaekkede; + logger.info("Starter beregning for " + postnr); start2 = System.currentTimeMillis(); - for (int i =0; i 0) { - Thread.sleep(10);//wait for worker threads - } + barrier.await(); + + db.saveBatch();//Save any unsaved rows } catch(Exception e) { @@ -103,16 +110,13 @@ } long now = System.currentTimeMillis(); - logger.info("Antal daekkede:" + daekkedeAdresser.size() + " postnr=" + postnr); - logger.info("Antal ikke-daekkede:" + queueSize + " postnr=" + postnr); - + stat.forbrugtTid = (now-start1); + LookupMain.saveStatistics(stat); + + logger.info( stat.toString() ); logger.info("Done! elapsed=" + (now-start1) + "/" + (now-start2) + " postnr=" + postnr); } - public void shutdownWorker(int workerid) { - logger.info("Shutting down worker: " + workerid); - workers.remove(workerid); - } // Getters and setters @@ -123,69 +127,18 @@ - public ArrayList getDaekkedeAdresser() { + public Adresse[] getDaekkedeAdresser() { return daekkedeAdresser; } - - public Queue getQueue() { - return queue; + public Adresse[] getUdvidetDaekkedeAdresser() { + return udvidetDaekkedeAdresser; } - - - - - ///////////////////////////// - // Static functions - + public Queue getQueue() { + return queue; + } - - public static void main(String[] args) throws Exception { - - File confFile = new File("fulddaekning.properties"); - if (! confFile.exists() ) { - logger.warning("Config file not found"); - System.exit(1); - } - - conf = new Properties(); - conf.load( new FileReader(confFile) ); - - max_workers = Integer.parseInt( conf.getProperty("MAX_WORKERS") ); - logger.info("Starting with MAX_WORKERS:" + max_workers); - - verbose = Boolean.parseBoolean( conf.getProperty("VERBOSE") ); - logger.info("Starting with VERBOSE:" + verbose); - - Database db = new Database(conf); - - db.resetResultTable(); - - - - - long start = System.currentTimeMillis(); - - logger.info("Finder postnumre"); - List postnumre = db.hentPostnumre(); - - for(Integer postnr : postnumre) { - Lookup lookup = new Lookup(postnr, db); - lookup.doLookup(); - } - - long now = System.currentTimeMillis(); - - logger.info("Fuld load done : " + (now-start) ); - logger.info("Flest Ikke-dækkede, " + flestIkkeDaekkedePostnr + ": " + flestIkkeDaekkedeAntal); - logger.info("Flest Dækkede, " + flestDaekkedePostnr + ": " + flestDaekkedeAntal); - - - //Lookup lookup = new Lookup(7400, db); - //lookup.doLookup(); - } - }