Rem
Rem $Header: sdo/admin/sdoseminfh.sql /st_sdo_11.2.0/2 2011/04/29 12:19:52 sdas Exp $
Rem
Rem sdoseminfh.sql
Rem
Rem Copyright (c) 2006, 2011, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      sdoseminfh.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    matperry    03/09/11 - add create_ent_views
Rem    alwu        01/10/11 - add transtivity related rules for NG local
Rem                           inference
Rem    alwu        01/03/11 - NG local inference part 3
Rem    alwu        12/21/10 - add local inference for named graph part2
Rem    alwu        12/17/10 - name graph local inference
Rem    sdas        11/22/10 - XbranchMerge sdas_ng_11.2.0.2.0_11.2.0.3.0 from
Rem                           st_sdo_11.2.0
Rem    sdas        11/22/10 - XbranchMerge sdas_ng_11.2.0.2.0 from
Rem    vkolovsk    09/14/10 - use sem_graphs
Rem    alwu        08/16/10 - auto dop for inference
Rem    vkolovsk    07/28/10 - XbranchMerge vkolovsk_bug-9724396 from
Rem                           st_sdo_11.2.0
Rem    vkolovsk    07/07/10 - add NG options
Rem    vkolovsk    06/02/10 - add build models union clause
Rem    vkolovsk    06/02/10 - introduce a new definer''s rights package to
Rem                           contain most of the logic
Rem    vkolovsk    05/27/10 - add build_models_union fcn since inf_i needs it
Rem                           to prevent potential sql inj.
Rem    alwu        02/04/09 - rename use_perfect_reverse_hashing to use_raw
Rem    alwu        01/27/09 - udpate m() mapping function
Rem    alwu        01/26/09 - add mapping function
Rem    alwu        01/05/09 - three column design
Rem    alwu        09/07/06 - bring back sdo_sem_inference to public for passing tst
Rem    alwu        09/07/06 - sync up 11g document and proposed APIs
Rem    alwu        06/29/06 - remove COPYRD option 
Rem    alwu        05/04/06 - add two APIs for COPYRD support 
Rem    alwu        04/25/06 - add replace for synonym 
Rem    alwu        04/21/06 - add grant to make this package public 
Rem    alwu        04/20/06 - start
Rem    alwu        04/20/06 - start
Rem    alwu        04/20/06 - Created
Rem

create or replace package sdo_sem_inf_internal as

  --table containing two number columns (M and G)
  procedure create_rules_index(index_name_in     varchar2,
                               models_in         mdsys.rdf_models,
                               rulebases_in      mdsys.rdf_rulebases,
                               passes            integer  default 0,
                               inf_components_in varchar2 default null,
                               options           varchar2 default null,
                               delta_in          mdsys.rdf_models default null,
                               ng_tab_name       varchar2,
                               ng_tab_schema     varchar2 default null,
                               inf_ng_name       varchar2 default null);

  procedure create_ent_views(index_name_in       varchar2,
                             ptn_name_in         varchar2);

  function m(i int) return varchar2;
  function build_models_union_clause(models            mdsys.rdf_models, 
                                     bJustModels       boolean,
                                     bDefaultGraphOnly boolean) return varchar2;
 end;
/

create or replace package sdo_sem_inference authid current_user as

  procedure create_rules_index(index_name_in     varchar2,
                               models_in         mdsys.rdf_models,
                               rulebases_in      mdsys.rdf_rulebases,
                               passes            integer  default 0,
                               inf_components_in varchar2 default null,
                               options           varchar2 default null,
                               delta_in          mdsys.rdf_models default null,
                               ng_tab_name       varchar2,
                               ng_tab_schema     varchar2 default null,
                               inf_ng_name       varchar2 default null);


  procedure create_rules_index(index_name_in     varchar2,
                               models_in         mdsys.rdf_models,
                               rulebases_in      mdsys.rdf_rulebases,
                               passes            integer  default 0,
                               inf_components_in varchar2 default null,
                               options           varchar2 default null,
                               delta_in          mdsys.rdf_models default null,
                               include_named_g   sem_graphs default null,
                               include_default_g mdsys.rdf_models default null,
                               include_all_g     mdsys.rdf_models default null,
                               inf_ng_name       varchar2 default null);

 end;
/

create or replace public synonym sdo_sem_inference for mdsys.sdo_sem_inference;
grant execute on sdo_sem_inference to public;

show errors;