Abstract

Data Warehousing is arisen in order to overcome the issues faced by the excel file. When several database is maintained by the excel file a conflict will arise such that which source file belongs to which excel sheet. In order to overcome the problem a data warehousing is used and a new technique used in data warehousing is soft concatenation mapping which depicts a relationship between column during transformation and concatenation .At that time many redundancy and loss of data may occur in order to overcome the issue an efficient method is used that is used to derive an approximate algorithm. This approximation is used both in real time and synthetic data sets.

Keywords

Database management, data profiling, data integration, data analysis, Concatenation,

Downloads

Download data is not yet available.

References

  1. https://www.oracle.com/datawarehousing.
  2. W. A. Giovinazzo, Object-Oriented Data Warehouse Design: Building a Star Schema, Englewood Cliffs, NJ, USA: Prentice Hall, 2000.
  3. P. Bohannon, W. Fan, F. Geerts, X. Jia, A. Kementsietsidis, Conditional functional dependencies for data cleaning, IEEE 23rd Int. Conf. Data Eng., , 2007.pp. 746-755.
  4. P. G. Brown and P. J. Hass, Bhunt: Automatic discovery of fuzzy algebraic constraints in relational data, in VLDB, 2003, pp. 668–679
  5. H. Liu, J. Xiao, X. Guo, H. Tan, Q. Luo, and L. M. Ni, Cuttle: Enabling cross-column compression in distributed column stores, in APWeb-WAIM 2017, 2017, pp. 219–226
  6. J. Liu, J. Li, C. Liu, and Y. Chen, Discover dependencies from data a review, IEEE Trans. on Knowl. and Data Eng., 2012, vol. 24, no. 2, pp. 251–264.