Edit D:\app\Administrator\product\11.2.0\dbhome_1\md\jlib\oracle\spatial\network\PartitionKmeans.class
?? 1q ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? / ? / ? ? ? ? 3 ? 3 ? ? ? ? ? ? : ? ? ? ? ? ? ? ? : ? ? ? ? ? ? ? ? ? ? ? ? ? ??????? ? ? ? ? ? ? ? 3 ? ? ? ? ? ? ? ? ? ? ? ?@r? @Y @X? !"#$% & ' () * +,- p_numPartition I p_connection Ljava/sql/Connection; p_networkName Ljava/lang/String; p_maxNumIteration p_metadata (Loracle/spatial/network/NetworkMetadata; p_batchNum p_debug Z <init> ,(Ljava/sql/Connection;Ljava/lang/String;II)V Code LineNumberTable Exceptions getExternalCost (Z)D getNumNodes ()I getRandTabName &(Ljava/lang/String;)Ljava/lang/String; calNodesDistance (DDDD)D partitionNetwork ()V assignClusters ([D[DLjava/lang/String;I)D randomInitCluster ([D[DI)V updtMetadata updtPartitionId !(IILjava/sql/PreparedStatement;)V updtBatch (Ljava/sql/PreparedStatement;)V <clinit> SourceFile PartitionKmeans.java ? ? ? ? +oracle/spatial/network/NetworkDataException connection is NULL ?. ? ? Network Name is NULL ? ? Invalid Partition Number/01 ? ?234 8Can not partition non-spatial Networkwith K-Means Method ? ?56789:;<8=>? java/lang/StringBuilder +SELECT COUNT(DISTINCT partition_id) FROM @AB6CDEFGHI4JK SELECT SUM(l. ) FROM l, a, b ) WHERE (a.node_id = l.start_node_id AND ' b.node_id = l.end_node_id AND . a.partition_id < b.partition_id ) OR ' (a.node_id = l.end_node_id AND ) b.node_id = l.start_node_id AND * a.partition_id < b.partition_id) SELECT count(*) FROM LMN ? java/sql/SQLException SELECT count(*) FROM java/util/RandomOPQ ?RS ? java/lang/StringTBUV ? )SELECT count(*) FROM tab WHERE tname = ' ' ? ? oracle/spatial/network/NDMTimer ? ? ? ?WX randomInitCluster Time YZ@[\]. ? ? CREATE TABLE (node_id NUMBER, partition_id NUMBER) NOLOGGING 0 (node_id NUMBER, partition_id NUMBER) NOLOGGING^_` ? ? ?@a assignClusters Time the current distance sum is External cost is ? ? _idx CREATE index on (node_id) UPDATE a . SET a.partition_id = (SELECT b.partition_id FROM 6 WHERE a.node_id = b.node_id) DROP INDEX DROP TABLE ? ?b6 SELECT n.node_id, n. .sdo_point.x , n. .sdo_point.y n TRUNCATE TABLE INSERT /*+append */ INTO #(node_id, partition_id) VALUES(?,?)cdef .g.] ? ? ? ? ? ? ? ? ? A cluster should not be emptyh SELECT n. n. SAMPLE ( ) n ZUPDATE USER_SDO_NETWORK_METADATA SET NO_OF_PARTITIONS = ? WHERE NODE_TABLE_NAME = ? ijklm ? Partition Metadata Update Failedn ?op &oracle/spatial/network/PartitionKmeans java/lang/Object (Ljava/lang/String;)V %oracle/spatial/network/NetworkManager readNetworkMetadata Q(Ljava/sql/Connection;Ljava/lang/String;)Loracle/spatial/network/NetworkMetadata; &oracle/spatial/network/NetworkMetadata isSDOGeometry ()Z getLinkCostColumn ()Ljava/lang/String; getLinkGeomMetadata +()Loracle/spatial/network/GeometryMetadata; 'oracle/spatial/network/GeometryMetadata getTableName (Z)Ljava/lang/String; getNodeGeomMetadata java/sql/Connection createStatement ()Ljava/sql/Statement; append -(Ljava/lang/String;)Ljava/lang/StringBuilder; toString java/sql/Statement execute (Ljava/lang/String;)Z getResultSet ()Ljava/sql/ResultSet; java/sql/ResultSet next getInt (I)I getDouble (I)D close java/lang/System currentTimeMillis ()J (J)V nextInt java/lang/Integer (I)Ljava/lang/String; concat out Ljava/io/PrintStream; deltaDuration ()D (D)Ljava/lang/StringBuilder; java/io/PrintStream println setAutoCommit (Z)V commit (I)Ljava/lang/StringBuilder; getColumnName prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; print java/sql/PreparedStatement setInt (II)V setString (ILjava/lang/String;)V executeUpdate addBatch executeBatch ()[I ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? n*? *+? *? ? ? Y? ?*,? *? ? ? Y? ?*? *? ? ? Y ? ?*+,? ? *? ? ? ? Y ? ?*? ? ? >