Page tree

在当前页:

介绍

 一旦完成功能点 校准 和计数,你应该把结果和所有证明你是如何得到这些结果的材料传达给团队。本节中显示的SQL查询允许你收集此信息。

收集已从计算中移除的对象

排除的数据实体

以下SQL查询收集已从计算中排除的数据库表:

set search_path=<Prefix>_local;

select * from FP_Lookup_Tables a join CDT_OBJECTS b on a.object_id = b.object_id;

已删除或忽略的事务功能

以下SQL查询收集计算中已删除或忽略的事务功能:

set search_path=<Prefix>_local;
 
select count (*) from dss_transaction t where t.appli_id in (select appli_id from fp_cms_application) and not exists(select 1 from ctt_object_applications oa, fp_cms_application a where t.form_id = oa.object_id and oa.application_id = a.module_id);

已删除或忽略的数据功能

以下SQL查询收集计算中已删除或忽略的数据功能:

set search_path=<Prefix>_local;
 
select count (*) from dss_datafunction df where not exists(select 1 from ctt_object_applications oa, fp_cms_application a where df.maintable_id = oa.object_id and oa.application_id = a.module_id);

计算功能点

应用程序的功能点总数是数据功能的功能点和事务功能的功能点之和。总数的每一部分可以单独列报。

数据功能的功能点

以下SQL查询提供计数过程中已考虑的数据功能数目:

set search_path=<Prefix>_local;
 
select count(*) from dss_datafunction where cal_flags in (  0, 2 , 256 );

这个数字可以与已计算的功能点的数量相关联。第二个数字由以下SQL查询提供:

set search_path=<Prefix>_local;
 
select sum(ilf_ex) from dss_datafunction where cal_flags in (  0, 2 , 256 );


事务功能的功能点

以下SQL查询提供了计数中已考虑的事务功能数目:

set search_path=<Prefix>_local;
 
select count(*) from dss_transaction where cal_flags in (  0, 2 );

这个数字可以与已计算的功能点的数量相关联。第二个数字由以下SQL查询提供:

set search_path=<Prefix>_local;
 
select sum(tf_ex) from dss_transaction where cal_flags in (  0, 2 );

收集功能

数据功能和事务功能是计数过程中要考虑的元素。它们是功能分级交付物的一部分。

数据功能

以下SQL查询提供了应用程序中已标识的数据功能的数量,这些数据功能对其功能大小有贡献:

set search_path=<Prefix>_local;
 
select count (1) as NumberOfSelectedLogicalFile from (
select cob.object_name as LogicalFile, 
cob.object_fullname as LogicalFileFullname, 
dtf.DET as DET, 
dtf.RET as RET, 
case dtf.isinternal when 0 then 'EIF' when 1 then 'ILF' END as DefaultType, 
case dtf.user_isinternal when 0 then 'EIF' when 1 then 'ILF' END as OverwriteType,
dtf.ilf_ex as DefaultFPValue,
dtf.user_fp_value as OverwriteFPValue,
case dtf.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_datafunction dtf, cdt_objects cob
where dtf.maintable_id = cob.object_id
and dtf.cal_flags in (0,2)
order by 9 ASC) as result;

结果应该如下所示:

以下SQL查询提供数据功能的关联列表:

set search_path=<Prefix>_local;
 
select cob.object_name as LogicalFile, 
cob.object_fullname as LogicalFileFullname, 
dtf.DET as DET, 
dtf.RET as RET, 
case dtf.isinternal when 0 then 'EIF' when 1 then 'ILF' END as DefaultType, 
case dtf.user_isinternal when 0 then 'EIF' when 1 then 'ILF' END as OverwriteType,
dtf.ilf_ex as DefaultFPValue,
dtf.user_fp_value as OverwriteFPValue,
case dtf.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_datafunction dtf, cdt_objects cob
where dtf.maintable_id = cob.object_id
and dtf.cal_flags in (0,2)
order by 9 ASC;

结果应如下所示:


事务功能

以下SQL查询提供了应用程序中标识的事务功能的数量,这些功能对其功能大小有贡献:

set search_path=<Prefix>_local;
 
select count (1) as NumberOfSelectedEntry from (
select cob.object_name as transaction, 
cob.object_fullname as transactionfullname, 
dtr.DET as DET, 
DTR.FTR as FTR, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO_EQ' END as DefaultType, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO' when 2 then 'EQ' END as OverwriteType,
DTR.tf_ex as DefaultFPValue,
DTR.user_fp_value as OverwriteFPValue, DTR.cal_flags,
case DTR.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
and dtr.cal_mergeroot_id = 0 -- not a sub transaction
and dtr.cal_flags not in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
order by 9 ASC, 2 ASC) as result;

结果应如下所示:


以下SQL查询提供事务功能的关联列表:

set search_path=<Prefix>_local;
 
select cob.object_name as transaction, 
cob.object_fullname as transactionfullname, 
dtr.DET as DET, 
DTR.FTR as FTR, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO_EQ' END as DefaultType, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO' when 2 then 'EQ' END as OverwriteType,
DTR.tf_ex as DefaultFPValue,
DTR.user_fp_value as OverwriteFPValue, 
case DTR.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
and dtr.cal_mergeroot_id = 0 -- not a sub transaction
and dtr.cal_flags not in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
order by 9 ASC, 2 ASC;

结果应如下所示:


与事务配置相关的信息

它有助于将收到功能分级结果的人员了解在 配置阶段考虑了哪些对象。这里提供的SQL查询允许您收集这些信息。

事务候选列表

下面显示的SQL查询收集所有可以视为启动事务的对象。其中一些已被排除或忽略,其他已保留并通向事务功能。

set search_path=<Prefix>_local;
 
select cob.object_name as Transaction, 
cob.object_fullname as LogicalFileFullname, 
cob.object_mangling, 
cob.object_type_str 
from dss_transaction dtf, cdt_objects cob 
where dtf.form_id = cob.object_id 
order by 3 ASC, 2 ASC;

结果应如下所示:

点击放大

 

与事务功能校准相关的信息

它有助于将收到功能分级结果的人员了解在校准阶段是否进行了调整。这里提供的SQL查询允许您收集这些信息。

收集已合并的事务入口点

以下SQL查询收集在校准阶段已合并的事务功能:

set search_path=<Prefix>_local;
 
select * from (
select dtr.object_id as form_id,
cob.object_name as transaction, 
cob.object_fullname as transactionfullname, 
dtr.DET as DET, 
DTR.FTR as FTR, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO_EQ' END as DefaultType, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO' when 2 then 'EQ' END as OverwriteType,
DTR.tf_ex as DefaultFPValue,
DTR.user_fp_value as OverwriteFPValue, 
case DTR.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
and dtr.cal_mergeroot_id = 0 -- not a sub transaction
and dtr.cal_flags not in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
union all
select dtr.cal_mergeroot_id as form_id,' |-------' || cob.object_name as transaction, cob.object_fullname as transactionfullname, dtr.DET as DET, DTR.FTR as FTR, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO_EQ' END as DefaultType, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO' when 2 then 'EQ' END as OverwriteType,
DTR.tf_ex as DefaultFPValue,
DTR.user_fp_value as OverwriteFPValue, 
case DTR.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
and dtr.cal_mergeroot_id > 0 -- not a sub transaction
and dtr.cal_flags not in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
) as result
order by 1 ASC, 10 DESC;

结果应如下所示:


收集已调整的事务功能

以下SQL查询收集在校准阶段调整了类型或功能点值的事务:

set search_path=<Prefix>_local;
 
select cob.object_name as transaction, 
cob.object_fullname as transactionfullname, 
dtr.DET as DET, 
DTR.FTR as FTR, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO_EQ' END as DefaultType, 
case DTR.user_isinput when 0 then 'EI' when 1 then 'EO' when 2 then 'EQ' END as OverwriteType,
DTR.tf_ex as DefaultFPValue,
DTR.user_fp_value as OverwriteFPValue
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
and (DTR.user_fp_value >= 0 or DTR.user_isinput >= 0)
order by 2 ASC;

结果应如下所示:


收集已忽略或删除的事务功能

以下SQL查询收集在校准阶段被忽略或删除的事务功能数目:

set search_path=<Prefix>_local;
 
select count (1) as NumberOfIgnoredOrDeletedEntry from (
select cob.object_name as transaction, 
cob.object_fullname as transactionfullname, 
dtr.DET as DET, 
DTR.FTR as FTR, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO_EQ' END as DefaultType, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO' when 2 then 'EQ' END as OverwriteType,
DTR.tf_ex as DefaultFPValue,
DTR.user_fp_value as OverwriteFPValue, DTR.cal_flags,
case DTR.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
and dtr.cal_mergeroot_id = 0 -- not a sub transaction
and dtr.cal_flags in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
order by 9 ASC, 2 ASC) as result;

结果应如下所示:


下一个SQL查询提供事务功能的关联列表:

set search_path=<Prefix>_local;
 
select cob.object_name as transaction, 
cob.object_fullname as transactionfullname, 
dtr.DET as DET, 
DTR.FTR as FTR, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO_EQ' END as DefaultType, 
case DTR.isinput when 0 then 'EI' when 1 then 'EO' when 2 then 'EQ' END as OverwriteType,
DTR.tf_ex as DefaultFPValue,
DTR.user_fp_value as OverwriteFPValue, 
case DTR.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
and dtr.cal_mergeroot_id = 0 -- not a sub transaction
and dtr.cal_flags in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
order by 9 ASC, 2 ASC;

结果应如下所示:


收集未被忽略或删除的空事务功能

以下SQL查询收集未完成但在校准阶段未被忽略或删除的事务功能:

set search_path=<Prefix>_local;
 
select count (1) as NumberOfEmptyTransactionNotIgnoredOrDeletedEntry from (
select cob.object_name as transaction, 
cob.object_fullname as transactionfullname, 
dtr.DET as DET, 
DTR.FTR as FTR,
case DTR.isinput when 0 then 'EI' when 1 then 'EO_EQ' END as DefaultType,
case DTR.isinput when 0 then 'EI' when 1 then 'EO' when 2 then 'EQ' END as OverwriteType,
DTR.tf_ex as DefaultFPValue,
DTR.user_fp_value as OverwriteFPValue, DTR.cal_flags,
case DTR.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
and dtr.cal_mergeroot_id = 0 -- not a sub transaction
and dtr.cal_flags not in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
and DTR.tf_ex=0
order by 9 ASC, 2 ASC) as result;

结果应如下所示:


下一个SQL查询提供事务功能的关联列表:

set search_path=<Prefix>_local;
 
select cob.object_name as transaction, 
cob.object_fullname as transactionfullname, 
dtr.DET as DET, 
DTR.FTR as FTR,
case DTR.isinput when 0 then 'EI' when 1 then 'EO_EQ' END as DefaultType,
case DTR.isinput when 0 then 'EI' when 1 then 'EO' when 2 then 'EQ' END as OverwriteType,
DTR.tf_ex as DefaultFPValue,
DTR.user_fp_value as OverwriteFPValue, DTR.cal_flags,
case DTR.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
and dtr.cal_mergeroot_id = 0 -- not a sub transaction
and dtr.cal_flags not in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
and DTR.tf_ex=0
order by 9 ASC, 2 ASC;

结果应如下所示:


与数据实体配置相关的信息

它有助于将收到功能分级结果的人员了解在配置阶段考虑了哪些对象。这里提供的SQL查询允许您收集这些信息。

数据实体候选列表

以下SQL查询收集已标识为潜在数据功能的所有数据实体。其中一些被忽略或删除,其他被保留并通向数据功能。

set search_path=<Prefix>_local;
 
select cob.object_name as logicalFile, 
cob.object_fullname as LogicalFileFullname, 
cob.object_mangling, 
cob.object_type_str 
from dss_datafunction dtf, cdt_objects cob 
where dtf.maintable_id = cob.object_id 
order by 3 ASC, 2 ASC;

结果应如下所示:


与数据功能校准相关的信息

它有助于将接收功能分级结果的人员了解校准阶段是否进行了调整。这里提供的SQL查询允许您收集这些信息。

收集已合并的数据功能

以下SQL查询收集校准阶段已合并的数据功能:

set search_path=<Prefix>_local;
 
select * from (
select dtf.object_id as maintable_id,
cob.object_name as transaction, 
cob.object_fullname as transactionfullname,
dtf.DET as DET, 
dtf.RET as RET,
case dtf.isinternal when 0 then 'EIF' when 1 then 'ILF' END as DefaultType,
case dtf.user_isinternal when 0 then 'EIF' when 1 then 'ILF' END as OverwriteType,
dtf.ilf_ex as DefaultFPValue,
dtf.user_fp_value as OverwriteFPValue,
case dtf.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_datafunction dtf, cdt_objects cob
where dtf.maintable_id = cob.object_id
and dtf.cal_mergeroot_id = 0 -- not a sub transaction
and dtf.cal_flags not in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
union all
select dtf.cal_mergeroot_id as form_id,' |-------' || cob.object_name as transaction, 
cob.object_fullname as transactionfullname, 
dtf.DET as DET, 
dtf.RET as RET,
case dtf.isinternal when 0 then 'EIF' when 1 then 'ILF' END as DefaultType,
case dtf.user_isinternal when 0 then 'EIF' when 1 then 'ILF' END as OverwriteType,
dtf.ilf_ex as DefaultFPValue,
dtf.user_fp_value as OverwriteFPValue,
case dtf.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored'  when 258 then 'Child and Ignored' END as Status
from dss_datafunction dtf, cdt_objects cob
where dtf.maintable_id = cob.object_id
and dtf.cal_mergeroot_id > 0 -- not a sub transaction
and dtf.cal_flags not in (  8, 10, 126, 128,136, 138, 256, 258 ) -- transaction standalone or Root
) as result
order by 1 ASC, 10 DESC;

结果应如下所示:


收集已调整的数据功能

以下SQL查询收集在校准阶段调整了类型或功能点值的数据功能:

set search_path=<Prefix>_local;

SELECT cob.object_name as LogicalFile, cob.object_fullname as LogicalFileFullname, dtf.DET as DET, dtf.RET as RET, 
case dtf.isinternal when 0 then 'EIF' when 1 then 'ILF' END as DefaultType, 
case dtf.user_isinternal when 0 then 'EIF' when 1 then 'ILF' END as OverwriteType,
dtf.ilf_ex as DefaultFPValue,
dtf.user_fp_value as OverwriteFPValue
from dss_datafunction dtf, cdt_objects cob
where dtf.maintable_id = cob.object_id
and (dtf.user_fp_value >= 0 or dtf.user_isinternal >= 0)
order by 2 ASC;

收集已忽略或删除的数据功能

以下SQL查询收集在校准阶段被忽略或删除的数据功能:

set search_path=<Prefix>_local;
 
SELECT cob.object_name as LogicalFile, 
cob.object_fullname as LogicalFileFullname, 
dtf.DET as DET, 
dtf.RET as RET, 
CASE dtf.isinternal when 0 then 'EIF' when 1 then 'ILF' END as DefaultType, 
CASE dtf.user_isinternal when 0 then 'EIF' when 1 then 'ILF' END as OverwriteType, 
dtf.ilf_ex as DefaultFPValue, dtf.user_fp_value as OverwriteFPValue, 
CASE dtf.cal_flags when 0 then 'STD' when 2 then 'Root' when 4 then 'Child' when 4 then 'Child' when 8 then 'Deleted' when 10 then 'Root and Deleted' when 128 then 'Deleted' when 136 then 'Root and Deleted' when 138 then 'Child and Deleted' when 256 then 'Root and Ignored' when 258 then 'Child and Ignored' END as Status 
FROM dss_datafunction dtf, cdt_objects cob 
WHERE dtf.maintable_id = cob.object_id 
AND dtf.cal_flags in (8, 10, 128, 136, 138, 256, 158, 160) 
--AND (dtf.user_fp_value >= 0 or dtf.user_isinternal >= 0) 
ORDER BY 9 ASC;

结果应如下所示:


  • No labels