1. A computer implemented system for automatically determining a reliability score of a final destination, comprising:
data structure indicative of a data lineage- that includes a plurality of data assets, the data assets comprising data sources and data routines, wherein data is transferred and processed among the data sources via corresponding data routines and the processed data flows into a final destination;
a processor configured to calculate at least:
trust scores for each of the data assets based on characteristics of the data assets; and
a final destination trust density score indicative of the reliability score of the final destination based on at least the calculated trust scores; and
an output device configured to output the calculated final destination trust density score;
wherein the processor is configured to calculate the final destination trust density score by:
\u2211
i
=
1
\u2062
\u2062
to
\u2062
\u2062
n
\u2062
\u2062
(
TrustScore
i
*
Weight
i
)
\u2211
i
=
1
\u2062
\u2062
to
\u2062
\u2062
n
\u2062
\u2062
Weight
i
;
wherein the TrustScorei comprises the trust score of either of the data source or data routine, and wherein the Weighti of the data routine is the complexity score assigned to the data routine, and wherein the Weighti of the data source is is the maximum complexity score assigned to all the data routines that write to the respective data source.
2. The system according to claim 1, wherein the calculating the final destination trust density score is further based on at least the complexity of the data assets and wherein the complexity is dependent on at least the structure or function of each of the data assets.
3. The system according to claim 1, wherein the data lineage is represented as a data lineage graph.
4. The system according to claim 1, wherein the data traverses through the data structure between the data sources and corresponding data routines as defined by the data lineage.
5. The system according to claim 4, wherein each of the data sources comprise at least one of: an OLAP layer, a data mart, a data warehouse, a staging database, an intermediate file, and an operational data store.
6. The system according to claim 4, wherein each of the data routines comprises at least one of: a file transfer process and an Extract Transform and Load (ETL) process.
7. The system according to claim 1 , wherein the processor is configured to calculate the trust scores of the data sources based on data quality of the respective data sources.
8. The system according to claim 1, wherein the processor is configured to calculate the trust scores of the data routines based on data quality of the respective data routines.
9. The system according to claim 4, wherein the processor is configured to calculate the final destination trust density score further based on at least respective complexity scores of the data sources and data routines, wherein the complexity scores are dependent on at least the structure or function of the data sources and the data routines.
10. The system according to claim 1, wherein the processor is configured to calculate the trust score of each data source, based on the data characteristics, including:
adding X1 points if data quality monitoring is implemented for the data source;
adding X2 points if the data is fresh;
adding X3 points if there is data ownership for the data source;
adding X4 points if there is a data security system guarding unauthorized data access to the data source;
adding X5 points if there is a documentation of the data source;
adding X6 points if there is a data backuprestore mechanism of the data source; and
adding X7 points if there is a privacy system used to obfuscate the data of the data source,
wherein any of the X1 to X7 points fall within a given points range.
11. The system according to claim 1, wherein the processor is configured to calculate the trust score of each data routine based on the data characteristics, including:
adding Y1 points if a specification for the routine exists;
adding Y2 points if there are no operational failures;
adding Y3 points if there was testing done on the data routine;
adding Y4 points if there is ownership of the data routine; and
adding Y5 points if there is a documentation for the data routine, wherein any of the Y1 to Y5 points fall within a given points range.
12. The system according to claim 1, wherein the processor is configured to calculate the complexity score of each data routine, including:
adding Z1 points for each Aggregation function used in the data routine;
adding Z2 points for each Transformation function used in the data routine;
adding Z3 points for each Join function used in the data routine;
adding Z4 points for each Lookup function used in the data routine;
adding Z5 points for each Merge function used in the data routine;
adding Z6 points for each Filter function used in the data routine; and
adding Z7 points for each Sort function used in the data routine,
wherein any of the Z1 to Z7 points fall within a given points range.
13. The system according to claim 12, wherein the processor is configured to calculate for each one of the functions in compliance with the following equation
localScore
*
(
1
+
subTotal
200
)
wherein localScore are the points added to the respective function, and
subTotal is the aggregate complexity score of all the functions preceding the respective function.
14. The system according to claim 12, wherein the processor is configured to calculate the complexity score based also on complexity of the data lineage such that the more the data sources the more the points, and the more the data routines the more the points.
15. The system according to claim 1, wherein the final destination is a Business Intelligence (BI) related report.
16. A computer implemented method for automatically determining a reliability score of a final destination, comprising:
providing a data structure indicative of a data lineage that includes a plurality of data assets, the data assets comprising data sources and data routines, wherein data is transferred and processed among the data sources via corresponding data routines and the processed data flows into a final destination;
calculating trust scores for each of the data assets based on characteristics of the data assets;
calculating a final destination trust density score indicative of the reliability score of the final destination based on at least the calculated trust scores; and
outputting to an output device the calculated final destination trust density score;
wherein the method comprises calculating the final destination trust density score by:
\u2211
i
=
1
\u2062
\u2062
to
\u2062
\u2062
n
\u2062
\u2062
(
TrustScore
i
*
Weight
i
)
\u2211
i
=
1
\u2062
\u2062
to
\u2062
\u2062
n
\u2062
\u2062
Weight
i
wherein the TrustScorei comprises the trust score of either of the data source or data routine, and wherein the Weighti of the data routine is the complexity score assigned to the data routine, and wherein the Weighti of the data source is is the maximum complexity score assigned to all the data routines that write to the respective data source.
17. A computer program product that includes a computer readable medium embodying a computer program, comprising:
computer code portion for providing a data structure indicative of a data lineage that includes a plurality of data assets, the data assets comprising data sources and data routines, wherein data is transferred and processed among the data sources via corresponding data routines, and the processed data flows into a final data destination;
computer code portion for calculating trust scores for each of the data assets based on characteristics of the data assets;
computer code portion for calculating a final destination trust density score indicative of the reliability score of the final destination based on at least the calculated trust scores; and
computer code portion for outputting to an output device the calculated final destination trust density score;
wherein a computer code portion calculates the final destination trust density score by:
\u2211
i
=
1
\u2062
to
\u2062
n
\u2062
(
TrustScore
i
*
Weight
i
)
\u2211
i
=
1
\u2062
to
\u2062
\u2062
n
\u2062
Weight
i
the TrustScorei comprises the trust score of either of the data source or data routine, and wherein the Weighti of the data routine is the complexity score assigned to the data routine, and wherein the Weighti of the data source is the maximum complexity score assigned to all the data routines that write to the respective data source.
The claims below are in addition to those above.
All refrences to claim(s) which appear below refer to the numbering after this setence.
1. An electrical connector, comprising:
a fixed housing;
a moveable housing attached to the fixed housing, the moveable housing being moveable with respect to the fixed housing; and
a plurality of contacts, each of the contacts having a connecting member, a female contact member, and a flexible linking member extending there between; the connecting member being fastened to the fixed housing, the female contact member being fastened to the moveable housing, and the flexible linking member being twisted about 45 degrees relative to a direction of contact pressure applied to the female contact member by a mating male contact.
2. The electrical connector of claim 1, wherein the female contact member is disposed so that the direction of contact pressure is substantially parallel or perpendicular to a direction of length of a side of the moveable housing.
3. The electrical connector of claim 1, wherein the flexible linking member includes a substantially S-shaped bent member.
4. The electrical connector of claim 1, wherein the connecting members are twisted about 45 degrees relative to the direction of contact pressure applied to the female contact member by the mating male contact.
5. The electrical connector of claim 4, wherein the connecting members are fastened to the fixed housing at an inclination of about 45 degrees with respect to the direction of length of a side of the moveable housing.
6. The electrical connector of claim 1, wherein the female contact member includes a housing fastening member having a substantially C-shaped cross-section.
7. The electrical connector of claim 6, wherein the female contact member includes a pair of elastic contact pieces that extend upward from opposing side walls of the housing fastening member.
8. An electrical connector, comprising:
a fixed housing;
a moveable housing attached to the fixed housing, the moveable housing being moveable with respect to the fixed housing; and
a plurality of contacts, each of the contacts having a connecting member, a female contact member, and a flexible linking member extending there between; the connecting member being fastened to the fixed housing, the female contact member being fastened to the moveable housing, and the flexible linking member being positioned at an inclination of about 45 degrees with respect to a direction of length of a side of the moveable housing.
9. The electrical connector of claim 8, wherein the female contact member is disposed so that a direction of contact pressure applied to the female contact member by a mating male contact is at about 45 degrees relative to the direction of length of the side of the moveable housing.
10. The electrical connector of claim 8, wherein the female contact member is disposed so that a direction of contact pressure applied to the female contact member by a mating male contact is substantially parallel or perpendicular to the direction of length of the side of the moveable housing.
11. The electrical connector of claim 8, wherein the flexible linking member includes a substantially S-shaped bent member.
12. The electrical connector of claim 8, wherein the flexible linking member is twisted about 45 degrees relative to a direction of contact pressure applied to the female contact member by a mating male contact.
13. The electrical connector of claim 12, wherein the connecting members are twisted about 45 degrees relative to the direction of contact pressure applied to the female contact member by the mating male contact.
14. The electrical connector of claim 8, wherein the female contact member includes a housing fastening member having a substantially C-shaped cross-section.
15. The electrical connector of claim 14, wherein the female contact member includes a pair of elastic contact pieces that extend upward from opposing side walls of the housing fastening member.