Data Quality

Data Quality: Before doing ERP or CRM implementation or any new project make sure that the data quality is good. ETL process should not be used for fixing data problems

Type of Tools available for improving data quality are

Data Profiling software: sifts data fields for duplication, missing information and other errors
Data Cleansing and matching tools: parse data into discrete elements and clean it, standardize it in formats and match and merge records
Data Enhancements tools: enrich data by incorporating third-party elements
Data Monitoring tools: ensure that data maintains preset level of quality

Data Quality Vendors:
www.firstlogic.com uses a SOA to capture and validate data
www.trilliumsoftware.com
www.dataflux.com (SAS subsidiary)

Comments

Post a Comment

Popular posts from this blog

Spring Framework

Spring is a J2EE framework and aims to simplify J2EE development Lightweight – A non invasive container that can assemble set of loosely coupled POJOs. This allows software components to be tested in isolation Abstract Transaction Manager – Allows for pluggable transaction managers, not tied to J2EE environments JDBC abstratcion layer – meaningfull exception hierarchy (no need to extract vendor codes from SQLException) simplified error handling. Integrartes with Toplink, Hibernate, JDO and iBATIS SQL maps AOP functionality – can AOP any object and add aspects such as declarative transaction management. Transaction management can be done without EJB or JTA A flexible MVC architecture – Can work with Struts, WebWork or Tapestry and accomodates multiple view techonlogies like JSP, Velocity, Tiles, iText and POI Spring uses a setter based dependancy injection pattern (Inversion of Control) See my Spring AOP Sample Book Reference: Pro Spring by Rob Harrop Jan Machacek
Read more

Never use a String

http://stephan.reposita.org/archives/2008/05/02/never-never-never-use-string-in-java-or-at-least-less-often/ An excellent post on why you should minimize using String, int and other Primitive Data Types.One advantage I personally see is in the Code Completion feature of Oracle JDeveloper where it will show me the data type for the methods but not the variable name. One should be careful of not overdoing this approach as it can make your code a lot more verbose.
Read more

JSON Web Token

JWT or JSON Web Tokens can be used for securely transferring data between two apps. You can use this to build a lightweight Single Signon functionality within your webapps. An Introduction to JSON Web Tokens in Plain English
Read more