1 PACKAGE SDO_ROUTER_PARTITION AUTHID current_user AS
2 FUNCTION adjust_m(start_m IN NUMBER, end_m IN NUMBER, m IN NUMBER)
3 RETURN NUMBER;
4
5 FUNCTION get_pid(m IN NUMBER, pid IN NUMBER)
6 RETURN NUMBER;
7
8 FUNCTION min_eigenvector(sum_x2 IN NUMBER, sum_y2 IN NUMBER, sum_xy IN NUMBER)
9 RETURN mdsys.vector_2d;
10
11 PROCEDURE cleanup_router(all_tables IN BOOLEAN DEFAULT TRUE);
12
13 PROCEDURE create_sdo_router_log_dir(
14 router_schema IN VARCHAR2,
15 new_dir_path IN VARCHAR2 DEFAULT NULL);
16
17 PROCEDURE partition_router(log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
18 max_v_no IN NUMBER DEFAULT 10000,
19 driving_side IN VARCHAR2 := 'R',
20 network_name IN VARCHAR := 'ROUTER_NETWORK',
21 max_memory IN NUMBER := 1.75,
22 cleanup IN BOOLEAN DEFAULT TRUE,
23 use_securefiles IN BOOLEAN DEFAULT TRUE,
24 generate_11g_restrictions IN BOOLEAN DEFAULT TRUE);
25
26 PROCEDURE validate_sdo_router_log_dir(log_file_name IN VARCHAR2 := 'sdo_router_partition.log');
27
28 PROCEDURE create_trucking_data(
29 log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
30 cleanup IN BOOLEAN DEFAULT TRUE);
31
32 PROCEDURE create_turn_restriction_data(
33 log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
34 cleanup IN BOOLEAN DEFAULT TRUE);
35
36 PROCEDURE dump_partitions(log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
37 start_pid IN NUMBER DEFAULT 0,
38 end_pid IN NUMBER DEFAULT -1,
39 verbose IN BOOLEAN DEFAULT FALSE);
40
41 PROCEDURE dump_trucking_data(log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
42 start_pid IN NUMBER DEFAULT 0,
43 end_pid IN NUMBER DEFAULT -1,
44 skip_unsupported IN BOOLEAN DEFAULT TRUE);
45
46 PROCEDURE dump_turn_restriction_data(log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
47 start_pid IN NUMBER DEFAULT 0,
48 end_pid IN NUMBER DEFAULT -1,
49 dump_soft_restrictions IN BOOLEAN DEFAULT FALSE);
50
51 PROCEDURE validate_partitions(log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
52 start_pid IN NUMBER DEFAULT 0,
53 end_pid IN NUMBER DEFAULT -1,
54 verbose IN BOOLEAN DEFAULT FALSE);
55
56 PROCEDURE gather_table_stats(table_name IN VARCHAR2);
57
58 PROCEDURE get_version(log_file_name IN VARCHAR2 := 'sdo_router_partition.log');
59
60 PROCEDURE create_router_network(log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
61 network_name IN VARCHAR2 := 'ROUTER_NETWORK');
62
63 PROCEDURE delete_router_network(log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
64 network_name IN VARCHAR2 := 'ROUTER_NETWORK',
65 log_delete IN BOOLEAN := TRUE);
66
67 PROCEDURE elocation_partition_router (logfile_name IN VARCHAR2,
68 blob_format IN VARCHAR2) AS LANGUAGE java
69 NAME 'oracle.spatial.router.partitioning.ElocationPartition.partition_router(
70 java.lang.String, java.lang.String)';
71
72 PROCEDURE elocation_trucking_data (logfile_name IN VARCHAR2) AS LANGUAGE java
73 NAME 'oracle.spatial.router.partitioning.ElocationPartition.create_trucking_data(
74 java.lang.String)';
75
76 PROCEDURE elocation_turn_restrict_data (logfile_name IN VARCHAR2) AS LANGUAGE java
77 NAME 'oracle.spatial.router.partitioning.ElocationPartition.create_turn_restriction_data(
78 java.lang.String)';
79
80 PROCEDURE elocation_dump_partition (logfile_name in VARCHAR2,
81 start_pid in NUMBER,
82 end_pid in NUMBER,
83 verbose in BOOLEAN,
84 is10g in BOOLEAN) AS LANGUAGE java
85 NAME 'oracle.spatial.router.partitioning.ElocationPartition.dumpPartition(
86 java.lang.String, int, int, boolean, boolean)';
87
88 PROCEDURE elocation_dump_trucking_data (logfile_name IN VARCHAR2,
89 start_pid IN NUMBER,
90 end_pid IN NUMBER,
91 skip_unsupported IN BOOLEAN) AS LANGUAGE java
92 NAME 'oracle.spatial.router.partitioning.ElocationPartition.dumpTruckingData(
93 java.lang.String, int, int, boolean)';
94
95 -- PLSQL limit, full name elocation_dump_turn_restrict_data
96 PROCEDURE elocation_dump_turn_restrict (logfile_name IN VARCHAR2,
97 start_pid IN NUMBER,
98 end_pid IN NUMBER,
99 dump_soft_restrictions IN BOOLEAN) AS LANGUAGE java
100 NAME 'oracle.spatial.router.partitioning.ElocationPartition.dumpTurnRestrictionData(
101 java.lang.String, int, int, boolean)';
102
103
104 PROCEDURE elocation_validate_partition (logfile_name in VARCHAR2,
105 start_pid in NUMBER,
106 end_pid in NUMBER,
107 verbose in BOOLEAN,
108 is10g in BOOLEAN) AS LANGUAGE java
109 NAME 'oracle.spatial.router.partitioning.ElocationPartition.validatePartition(
110 java.lang.String, int, int, boolean, boolean)';
111
112 PROCEDURE build_turn_restrictions (logdir in VARCHAR2,
113 drivingside in VARCHAR2) AS LANGUAGE java
114 NAME 'oracle.spatial.router.partitioning.TurnRestriction.buildTurnRestrictions(java.lang.String, java.lang.String)';
115
116 PROCEDURE elocation_validate_logfile(logfile_name IN VARCHAR2,
117 schema_name IN VARCHAR2) AS LANGUAGE java
118 NAME 'oracle.spatial.router.partitioning.ElocationPartition.validate_logfile(
119 java.lang.String, java.lang.String)';
120
121 FUNCTION get_edge_info(edge_ids IN sdo_list_type,
122 to_edge_ids OUT sdo_list_type,
123 rets OUT mdsys.string_array,
124 angle_segments OUT sdo_list_type)
125 RETURN mdsys.string_array ;
126
127
128 FUNCTION get_geometry_info(edge_ids IN sdo_list_type,
129 merged_coords OUT sdo_list_type)
130 RETURN NUMBER;
131
132 END SDO_ROUTER_PARTITION;