用Web将数据从Excel导入到SQL Server中遇到的问题及其解决方法

分析Web方式下将数据从Excel导入到Microsoft SQL Server数据库遇到的问题,并提出了相应的解决方法,给出了实现数据校验和导入功能的C#程序。     

运用ASP进行企业人事管理系统开发问题研究

人才已成为企业自身战略目标的一个非常关键的因素。＂公平、公正、合理＂的企业管理理念和管理水平的提高,使社会对人事管理有了更高的需求。同时,由于数据库技术、客户/服务器技术,特别是Web技术的发展,使得新一代人事信息管理系统的出现成为必然。     

基于C#的ASP．NET建立气象数据查询系统

ASP．NET是基于通用语言编译运行的程序,有着很强的适应性,C#编程语言语法灵活,功能强大．论述基于C#的ASP．NET建立气象数据查询系统的构建及其编程。     

基于SharePoint的一种企业在线文档管理解决方案设计

本文针对现有企业文档管理中存在的问题和需求,设计了一种基于网络的、分布式的文档在线管理方案。以微软新产品SharePoint Server 2007为该解决方案的设计平台,研究了SharePoint Server 2007为文档管理提供的几个重要的功能并在此基础上设计了一个实际的案例。     

SQL Server CE中RDA与Replication的研究

介绍移动数据库SQL Server CE及其特点,详细分析RDA(远程数据访问)和Replication(合并复制)数据同步技术,探讨两种技术的各自特点和应用环境,描述两种数据同步技术的实现过程,比较这两种技术适合的环境.     

基于Web学生成绩管理系统的设计与实现

该系统基于校园网,采用ASP．NET＋SQL Server开发技术,解决了传统人工方式处理学生成绩信息的弊端,实现了学校人力资源的优化和学生成绩信息的科学管理,具有较高的实用价值。     

Performance analysis of a non-preemptive priority queuing system subjected to a correlated Markovian interruption process

In this paper, we consider a discrete-time queuing system with head-of-line non-preemptive priority scheduling and a single server subjected to server interruptions. We model the server interruptions by a correlated Markovian on/off process with geometrically distributed on and off periods. Two classes of traffic are considered, namely high-priority and low-priority traffic. In the first part of the paper, we derive an expression for the functional equation describing the transient evolution of this priority queuing system. This functional equation is then manipulated and transformed into a mathematical tractable form. This allows us to derive the joint probability generating function (pgf) of the system contents. From this pgf, closed-form expressions for various performance measures, such as mean and variance of system contents and customer delay can be derived. Finally, we illustrate our solution technique with some numerical examples, whereby we demonstrate the negative effect of correlation in the interruption process on the performance of both classes. Some numerical results illustrating the impact of second-order characteristics of the arrival process on mean delays are also presented. The proposed approach which is purely based on pgfs is entirely analytical and enables the derivation of not only steady-state but transient performance measures, as well. The paper presents new insights into the performance analysis of discrete-time queues with service interruption and it also covers some previously published results as a special case.

Scope and purpose

In this contribution, we consider a practical queuing model, with HOL priority scheduling, two classes of traffic, and a server which is subjected to a correlated Markovian interruption process. We first derive a non-linear functional equation relating the joint pgf of the system state vector between two consecutive slots. Then we outline a solution technique to solve for this functional equation. This allows us to derive the joint pgf of the system contents of both classes, from which various performance measures related to mean system contents and customer delays are derived. We also demonstrate how the proposed approach allows for derivation of transient performance measures, as well. It should be noted that detailed coverage of the transient analysis of the system is beyond the scope of this paper.To our best knowledge, this is the first initiative that aims to explore the performance of queuing systems with priority scheduling when the shared server is subjected to service interruption. The paper also generalizes the results of Walraevens et al. (Analysis of a single-server ATM queue with priority scheduling, Computers & Operations Research 2003;30(12):1807–30) by incorporating service interruption into their original queuing model. By means of numerical results, the paper also demonstrates the effect of correlation in the service interruption process on the performance of both classes of customers. The impact of second-order characteristics of the arrival process on mean delays is also investigated.     

Queueing analysis of a server node in transaction processing middleware systems

Quantitative performance modeling of complex information systems is of immense importance for designing enterprise e-business infrastructures and applications. In this paper, we present a traffic model of a server node in a typical transaction processing middleware system as well as a quantitative framework to model and analyze its performance. A multi-class open queueing network model is presented in which multi-class jobs are admitted to a number of server processes sharing hardware resources including the CPU and the disk. We have developed a viable approximation method, which decomposes the dependent components into their independent counterparts while preserving their relevant characteristics. We have conducted queueing-theoretic delay analyses and verified the approach using simulation. Results demonstrate the strength of our approach in predicting delays, elapsed times and other system performance measures.     

数据挖掘在仓库物资补给预测中的应用研究

介绍使用数据挖掘工具SQL Server 2005 Data Mining、SPSS／Clementine进行仓库物资补给预测的方法和步骤并就使用两种教据挖掘工具,利用不同的挖掘算法进行物资补给预测的结果进行比对分析,以便使库存数量和成本之间取得平衡。     

基于vsftpd的安全FTP服务器的构建

Vsftpd是Linux操作系统下最常用的FTP服务器配置软件,利用vsftpd和Linux的磁盘配额功能可以构建出安全性更好的FTP服务器。本文介绍了利用vsftpd构建安全的FTP服务器的方法和过程,并且通过参数的设置以方便在工作中的实际应用。