Data Transformation Services (DTS): Creating Data Mart by Consolidating Multi-Source Enterprise Operational Data
Trends in business intelligence, e-commerce and
remote access make it necessary and practical to store data in
different ways on multiple systems with different operating systems.
As business evolve and grow, they require efficient computerized
solution to perform data update and to access data from diverse
enterprise business applications. The objective of this paper is to
demonstrate the capability of DTS [1] as a database solution for
automatic data transfer and update in solving business problem. This
DTS package is developed for the sales of variety of plants and
eventually expanded into commercial supply and landscaping
business. Dimension data modeling is used in DTS package to
extract, transform and load data from heterogeneous database
systems such as MySQL, Microsoft Access and Oracle that
consolidates into a Data Mart residing in SQL Server. Hence, the
data transfer from various databases is scheduled to run automatically
every quarter of the year to review the efficient sales analysis.
Therefore, DTS is absolutely an attractive solution for automatic data
transfer and update which meeting today-s business needs.
[1] Dan Lampkin,Baya Pavliashvili, 2002, "Introduction to Data
Transformation Services (DTS)", http://www.informit.com/isapi/
product_id~%7BFA835B2D-C9BD-4349-96D0-A127A5045154%7D/
content/index.asp
[2] Steve Hughes, Steve Miller, Jim Samuelson, Marcelino Santos, Brian
Sullivan, 2002, SQL Server DTS. New Riders.
[3] Timothy Peterson, 2001, Microsoft SQL Server 2000 DTS. Sams.
[4] Gerald V. Post, David L. Anderson, 2003, Management Information
Systems. McGraw-Hill Irwin.
[5] Mark Chaffin, Brian Knight and Todd Robinson., 2000, Professional
SQL Server 2000 DTS. Wrox Press Ltd.
[6] Joe Guerra, November 2002, "Using Microsoft SQL Server Data
Transformation Services with IBM Databases". Andrews Consulting
Group.
[7] George Colliat, 1996, "OLAP, Relational and Multidimensional
Database Systems", SIGMOD Record.
[8] Don Awalt and Brian Lawton, 1999, "Introduction to Data
Transformation Services: DTS takes the movement of data to a new
level",
http://www.sqlmag.com/Articles/index.cfm?ArticleID=4879&pg=1>.
[9] K.W. Chau, Ying Cao, M. Anson, Jianping Zhang, 2002, "Application
of data warehouse and Decision Support System in construction
management", Elsevier.
[10] C.M. Chao, "Incremental maintenance of object-oriented data
warehouses", Information Sciences 160 (2004) 91-110.
[11] Gutie'rrez, A. Marotta, An overview of data warehouse design
techniques, Reporte Te'cnico INCO-01-09. InCo-Pedeciba, Facultad
deIngenierÛ'a, Universidad de la Republica, Montevideo, Uruguay.
November, 2000.
[12] M. H. Shi, H. C. Tung, L. S. Jia, "Data warehouse enhancement: A
semantic cube model approach", Information Sciences 177 (2007) 2238-
2254.
[1] Dan Lampkin,Baya Pavliashvili, 2002, "Introduction to Data
Transformation Services (DTS)", http://www.informit.com/isapi/
product_id~%7BFA835B2D-C9BD-4349-96D0-A127A5045154%7D/
content/index.asp
[2] Steve Hughes, Steve Miller, Jim Samuelson, Marcelino Santos, Brian
Sullivan, 2002, SQL Server DTS. New Riders.
[3] Timothy Peterson, 2001, Microsoft SQL Server 2000 DTS. Sams.
[4] Gerald V. Post, David L. Anderson, 2003, Management Information
Systems. McGraw-Hill Irwin.
[5] Mark Chaffin, Brian Knight and Todd Robinson., 2000, Professional
SQL Server 2000 DTS. Wrox Press Ltd.
[6] Joe Guerra, November 2002, "Using Microsoft SQL Server Data
Transformation Services with IBM Databases". Andrews Consulting
Group.
[7] George Colliat, 1996, "OLAP, Relational and Multidimensional
Database Systems", SIGMOD Record.
[8] Don Awalt and Brian Lawton, 1999, "Introduction to Data
Transformation Services: DTS takes the movement of data to a new
level",
http://www.sqlmag.com/Articles/index.cfm?ArticleID=4879&pg=1>.
[9] K.W. Chau, Ying Cao, M. Anson, Jianping Zhang, 2002, "Application
of data warehouse and Decision Support System in construction
management", Elsevier.
[10] C.M. Chao, "Incremental maintenance of object-oriented data
warehouses", Information Sciences 160 (2004) 91-110.
[11] Gutie'rrez, A. Marotta, An overview of data warehouse design
techniques, Reporte Te'cnico INCO-01-09. InCo-Pedeciba, Facultad
deIngenierÛ'a, Universidad de la Republica, Montevideo, Uruguay.
November, 2000.
[12] M. H. Shi, H. C. Tung, L. S. Jia, "Data warehouse enhancement: A
semantic cube model approach", Information Sciences 177 (2007) 2238-
2254.
@article{"International Journal of Information, Control and Computer Sciences:62419", author = "J. D. D. Daniel and K. N. Goh and S. M. Yusop", title = "Data Transformation Services (DTS): Creating Data Mart by Consolidating Multi-Source Enterprise Operational Data", abstract = "Trends in business intelligence, e-commerce and
remote access make it necessary and practical to store data in
different ways on multiple systems with different operating systems.
As business evolve and grow, they require efficient computerized
solution to perform data update and to access data from diverse
enterprise business applications. The objective of this paper is to
demonstrate the capability of DTS [1] as a database solution for
automatic data transfer and update in solving business problem. This
DTS package is developed for the sales of variety of plants and
eventually expanded into commercial supply and landscaping
business. Dimension data modeling is used in DTS package to
extract, transform and load data from heterogeneous database
systems such as MySQL, Microsoft Access and Oracle that
consolidates into a Data Mart residing in SQL Server. Hence, the
data transfer from various databases is scheduled to run automatically
every quarter of the year to review the efficient sales analysis.
Therefore, DTS is absolutely an attractive solution for automatic data
transfer and update which meeting today-s business needs.", keywords = "Data Transformation Services (DTS), ObjectLinking and Embedding Database (OLEDB), Data Mart, OnlineAnalytical Processing (OLAP), Online Transactional Processing(OLTP).", volume = "1", number = "10", pages = "3255-5", }