Research of Parallel Data Transform Techniques between C++/CLR Database and Excel
Jin Ma · Computer Technology and Development · 2013
Based on the.NET 4.0 C++/CLR environment,program method and techniques of data transform between general databases were researched as well as some kind of software was developed to realize such functions.In visual studio 2010 IDE,C++/CLR was utilized to program and debug the codes which support Ole DB,Office COM object and multi-core CPU parallel processing technique.The trial application could list all tables in several databases for picking up to export into MS Excel file as separated sheets.Underwent repeatedly examination,the application was proved well stability and efficiency;compared with MFC,C++/CLR application developing is more convenient and efficient,most obviously in aspects such as parallel processing and thread-safe consideration.Moreover,Ole DB object was suitable for general database types,and all techniques mentioned above could meet the demand of data transform between multiplicate database and MS Excel files.