随着信息技术的不断发展,不同类型的数据之间的数据迁移变得更加频繁,为了能使数据快速、安全迁移到目标文件,必须有一个较合理的迁移方案。基于ASP.NET+SQL Server 2005开发环境,介绍了从Excel到SQL Server 2005的迁移模型。以教务管...随着信息技术的不断发展,不同类型的数据之间的数据迁移变得更加频繁,为了能使数据快速、安全迁移到目标文件,必须有一个较合理的迁移方案。基于ASP.NET+SQL Server 2005开发环境,介绍了从Excel到SQL Server 2005的迁移模型。以教务管理系统中的成绩处理为例,具体阐述了对获取Excel数据库,自动侦测Excel数据库表名,利用存储过程实现行列转换等技术的阐述,实现了数据快速批量迁移到SQL Server 2005的方法。实践结果表明,此方法大大提高了工作效率。展开更多
The asymptotic theory for nonlinear transformations of fractionally integrated time series is developed. By the use of fractional Occupation Times Formula, various nonlinear functions of fractionally integrated series...The asymptotic theory for nonlinear transformations of fractionally integrated time series is developed. By the use of fractional Occupation Times Formula, various nonlinear functions of fractionally integrated series such as ARFIMA time series are studied, and the asymptotic distributions of the sample moments of such functions are obtained and analyzed. The transformations considered in this paper includes a variety of functions such as regular functions, integrable functions and asymptotically homogeneous functions that are often used in practical nonlinear econometric analysis. It is shown that the asymptotic theory of nonlinear transformations of original and normalized fractionally integrated processes is diffent from that of fractionally integrated processes, but is similar to the asymptotic theory of nonlinear transformations of integrated processes.展开更多
文摘随着信息技术的不断发展,不同类型的数据之间的数据迁移变得更加频繁,为了能使数据快速、安全迁移到目标文件,必须有一个较合理的迁移方案。基于ASP.NET+SQL Server 2005开发环境,介绍了从Excel到SQL Server 2005的迁移模型。以教务管理系统中的成绩处理为例,具体阐述了对获取Excel数据库,自动侦测Excel数据库表名,利用存储过程实现行列转换等技术的阐述,实现了数据快速批量迁移到SQL Server 2005的方法。实践结果表明,此方法大大提高了工作效率。
基金Supported by National Natural Science Foundation of China(No.70471050).
文摘The asymptotic theory for nonlinear transformations of fractionally integrated time series is developed. By the use of fractional Occupation Times Formula, various nonlinear functions of fractionally integrated series such as ARFIMA time series are studied, and the asymptotic distributions of the sample moments of such functions are obtained and analyzed. The transformations considered in this paper includes a variety of functions such as regular functions, integrable functions and asymptotically homogeneous functions that are often used in practical nonlinear econometric analysis. It is shown that the asymptotic theory of nonlinear transformations of original and normalized fractionally integrated processes is diffent from that of fractionally integrated processes, but is similar to the asymptotic theory of nonlinear transformations of integrated processes.
