ActiveX Data Objects Research Articles

Research on the Mine Safety Monitoring System Based on Wireless Sensor Network Technology

The development of computers wireless network monitoring system mainly includes steps such as the selection of transmission protocol, the calls of database program, data display and automation implementation and so on. The transmission speed of protocol TD-SCDMA is faster. In addition, it also can transmit voice and pure data files. Thus, this article selects TD-SCDMA protocol as transport protocol of wireless sensor networks. On the basis of the software OLEDB, this paper has developed ActiveX Data Object program, and has implemented the safety supervision automation process of wireless sensor network technology. Finally, this paper uses VC++ software to make a numerical simulation experiment on computer programs by taking an example of coal mine gas monitoring. At the same time, through the display on the window, it is the gas concentration monitoring curve that is obtained when the mine safety is abnormal, which provides the safeguard for mine personnel safety and normal work.

Temperature Field Simulation Model for Rotary Kiln of Iron Ore Oxidized Pellet

Based on conduction, convection and radiation heat transfer among the flue gas, kiln wall, and the pellet bed material, and on the basis of the coal combustion and analysis of reaction heat of pellet induration in the rotary kiln, the temperature field model of rotary kiln was established. Using visual studio net, matlab and open source computer vision library as development tools, combining with the ActiveX data objects database technology, the temperature field simulation system for rotary kiln of iron ore oxidized pellet production was developed. Temperature distribution of pellet and flue gas in rotary kiln was dynamically displayed.

Information Processing Based on SQLite for Target Tracking System

As for the digital visual surveillance system, the traditional database and hardware platform can not be good at processing vast quantities of information. Combined with ActiveX Data Objects (ADO) technology, the information processing system was built by using SQLite database with embedded dual-core platform. The embedded database SQLite is implanted in the existing embedded hardware platform DM6446. And processing modules and operating interface were designed based on SQLite and the embedded hardware platform. The designed system can play a role as the core of data processing. The experiments show that the system can meet the requirements of the visual information processing such as data mining, online system analysis, data post-processing and so on.

SU-E-T-40: R&V System Direct-Accessing MU Second Check Tool

Purpose: In contrast to commercial dose (MU) second check software using data from treatment planning system, we developed the software which can directly access commercial record and verify, Mosaiq system ‐ to perform the MU and data integrity checks. Methods: Microsoft ActiveX Data Objects (ADO) and ActiveX Data Objects for .NET (ADO.NET) were used to access Mosaiq SQL server directly to retrieve the essential treatment parameters for MU second check. ADO was supported in Visual Basic for Applications (VBA); therefore, ADO was first applied to retrieve Mosaiq's parameters to our in‐house MU Calc Excel spreadsheet for non‐IMRT plan MU check. To perform more sophisticated data retrieving and dose calculation, ADO.NET was applied to develop an IMRT second check program using Microsoft Visual C#. Results: By using either ADO or ADO.NET, user can access Mosaiq database server directly to retrieve the corresponding fields through SQL queries. Patient identification (Pat_ID1)can be obtained from vw PatBro_Identifiers table through either IDA or Last_Name columns. Prescription ‐ (such as SIT_ID, Site_Name, Energy, Dose_Tx) can be read from Site table. Treatment field parameters (gantry, collimator, field aperture, accessories, and MLC for each control points) canbe found in T×Field and T×FieldPoints tables. The dose at the check point can be calculated according to those parameters retrieved directly from Mosaiq then compared with treatment planning result. Conclusion: Since patients are treated with parameters from R&V system, to perform a MU second check and data transfer from planning system check on the R&V system provides the most straightforward quality assurance control, especially in a heterogeneous vendor environment. Currently, our tools only work on Mosaiq. However, this concept and technique should be applied to other R&V systems.

Study on 3D Simulation Optimization for Digital Basin of Large-Scale Landform

Abstract For the need of digital basin 3D simulation, the paper proposes a visualization optimization method for large-scale landform and flow pattern. Based on call of landform data partitioning organization and dynamic processing of visual regional data, for the present situation of commonly using ADO(ActiveX Data Objects) developing interface to realize the operation for database, OCI (Oracle Call Interface) programming is adopted in order to improve exchange efficiency with database, which can realize call of database partitioning data, improve 3D space database loading efficiency and realize quick plotting of landform model in flight view. The water body flow effect is represented by means of texture movement mode on basis of flow field visualization. It is indicated by results that optimization strategy and method improves graph plotting efficiency, intensifies visualization effect, effectively solves the contradiction between complicated landform model and limited plotting capability of graphic dis...

Development of an Optimal Three-Dimensional Visualization System for Rough Lumber Edging and Trimming in Central Appalachia

An optimal three-dimensional visualization system was developed for edging and trimming of rough lumber in central Appalachia. ActiveX Data Objects were implemented via MS Visual C++/Open Graphics Library to manipulate board data at the backend supported by a relational data model with four data entity types: Board, Shape, Defect, and Defect Type. Exhaustive search procedures and a dynamic programming algorithm were used to achieve the optimal edging and trimming solution. A lumber grading module was also developed to grade hardwood lumber based on National Hardwood Lumber Association grading rules. The system was validated through comparing the total lumber values generated by the system with those generated by six local sawmills. A total of 360 boards were measured for board dimensions, defects, shape, wane, and the results of edging and trimming. Results indicated that the lumber value and surface measure gained in these six sawmills could be increased, on average, by 21.37 and 6.1 percent, respectively, using the optimal edging and trimming system. The optimal edging and trimming system not only can be used as a training tool but also can be installed on a field PC to aid the edging and trimming process.

Research of SQL Server Automatic Marking Based on Logical Formal

The author proposes a scheme of SQL Server Automatic Marking based on logical formal. The scheme consists of three parts: generating paper, skill assessment and automatic marking. Describe the question's Marking information by using the logical formal method. Achieve automatic Marking by building the logical formal system. Focus on three components of the scheme: logical formal description, get information of database based on ADOX(Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security) and automatic marking of three database operations:Creat,Modify and Delete. Describes the whole process of logical formal Marking with example. Analysis the assessment effect of the results about the example. Analysis between manual and automatic Marking shows that: logical Formal automatic Marking is better than the average artificial error and close to the minimum artificial error.

Development of Parametric CAD System Based on Pro / Toolkit and Database Technology

With Pro/Toolkit of Pro/E and ADO(ActiveX Data Object) database technology, part parametric CAD system is developed and an successful instance is introduced in the paper. In the CAD system, interface between Pro/E and VC++6.0 is created correctly using Pro / Toolkit and user interface for part parametric designing can be achieved by means of dll( dll dynamic link) library built in VC++6.0 .Meanwhile ADO database is applied in the CAD system to manage all part parameters and thus part revising and updating can be realized quickly. The developing method in the CAD system not only is applicable to typical mechanical part designing but also be helpful to establishing standard part library.

Study on the Dedicated CAD Sub-System for Custom Tooling

Custom tooling is an effective method to improve surface roughness, geometrical accuracy, machining efficiency, and consequently the core competitiveness of the final products in very complicated freeform creation and micro/nano machining, such as the propeller, blisk and ductile-mode machining of hard and brittle materials. However, commercially available CAM systems have limitations in generating CNC programs for these customized tools due to considerations for special custom tool fabrication processes. Therefore unique CAM system is needed and consequently dedicated CAD sub-system is the prerequisite for such CAM system. In this paper, the dedicated CAD sub-system design is studied to extend the authors’ previous study. The characteristics of customized tools are summarized and analyzed. Then, the functions for the dedicated CAD sub-system are analyzed and defined. Finally, the system is designed and developed by using VC++, Open CASCADE, and ActiveX Data Object techniques.

A Three-Dimensional Bucking System for Optimal Bucking of Central Appalachian Hardwoods

An optimal tree stem bucking system was developed for central Appalachian hardwood species using three-dimensional (3D) modeling techniques. ActiveX Data Objects were implemented via MS Visual C++/OpenGL to manipulate tree data which were supported by a backend relational data model with five data entity types for stems, grades and prices, logs, defects, and stem shapes. A network analysis algorithm was employed to achieve the optimal bucking solution with four different alternative stage intervals under the bucking by value principle. A total of 264 tree stems were measured in the field including stem dimensions, defects, sweep, and the manual bucking solution of each stem. Results when using the 3D optimal bucking system suggest that compared to manual bucking the total log value and volume gain from each tree stem could be increased on average by 31 to 38 percent and 16 to 17 percent, respectively. Results also show the individual tree stem utilization rate could be increased by 10 to 11 percent. The optimal bucking system developed can be used as a training tool on desktop PCs and can also be installed on field PCs to aid field buckers and operators of sawbucks. The 3D bucking optimization system developed in this research should be valuable to operators in the central Appalachian region due to the variability in tree stems and species of hardwoods.

Design and implementation of an effective information system for Nigerian universites

The population explosion in Nigeria Universities even in the second generation Universities like the University of Port Harcourt has brought its own attendant problems in terms of handling student records and in the computation of results to accertain the true positions of students. Such records and computation of results are needed for the graduation of students. In view of these, there is the need to design and implement an effective information system for Nigerian Universities. In the development of this system various data object models were used such as the Data Access Object as well as the latest Microsoft technology for database management, the ActiveX Data Object. The implementation is done using Microsoft Visual Basic With the developed system, it is possible to add, delete, update or edit records in the database. Range searches as well as the use of wildcard character are supported by the system. Various reports are produced such as student progress score sheets, probation list, withdrawal list, as well as final graduation list. The system has been tested using student results in the department of Chemical Engineering, Faculty of Engineering, University of Port Harcourt. The computer resources required to use this system are: windows 98 and above, 16 MB RAM with a minimum hard disk space of 113.40 MB. Keywords: Information System; System Design; Nigerian UniversitiesJournal of Modeling, Design and Management of Engineering Systems, Vol. 3 (1) 2005: pp. 39-51

클릭스트림 분석을 위한 웹 서버 시스템의 설계 및 구현

인터넷을 통한 비즈니스에 수익 모델에 대한 관심이 높아지면서 방문자별로 개인화된 서비스를 제공하려는 노력이 커지고 있다. 개인화(Personalization)란 고객 한 명을 대상으로 하여 그 고객 한 사람을 위한 정보나 제품을 제공해주는 작업을 말한다. 개인화 서비스를 위해서 전 처리과정인 사용자 프로파일 생성과정이 필요하며, 적극적인 개인화 서비스를 제공하기 위해서는 충분한 고객 데이터가 필요하다. 본 논문에서는 웹사이트 상에서 사용자 행위 패턴을 파악할 수 있는 클릭스트림 정보를 모듈화 하였으며, 이를 이용하여 확장된 웹 로그 시스템을 구현하였다. 클릭스트림 정보를 웹 로그정보에 포함시켜 사용자의 행위 패턴을 파악할 수 있도록 웹 서버 시스템을 설계하고 구현하였다. 그리고 이 웹 서버는 웹사이트로부터 얻은 클릭스트림 정보를 분류하고 저장하여 관리자가 쉽게 분석할 수 있다. 이때 데이터베이스 저장 기술로 OLE DB Provider상에서 수행되는 ADO(ActiveX Data Object)기술을 사용함으로써 확장된 웹 로그 처리 시스템을 설계하였다. 확장된 웹 로그 DB를 패턴분석, 군집분석 등의 마이닝(Mining) 기법을 통하여 맞춤서비스에 대한 사용자 프로파일을 구축할 수 있다. Clickstream is the information which demonstrate users' path through web sites. Analysis of clickstream shows how web sites are navigated and used by users. Clickstream of online web sites contains effective information of web marketing and to offers usefully personalized services to users, and helps us understand how users find web sites, what products they see, and what products they purchase. In this paper, we present an extended web log system that add to module of collection of clickstream to understand users' behavior patterns In web sites. This system offers the users clickstream information to database which can then analyze it with ease. Using ADO technology in store of database constructs extended web log server system. The process of making clickstreaming into database can facilitate analysis of various user patterns and generates aggregate profiles to offer personalized web service. In particular, our results indicate that by using the users' clickstream. We can achieve effective personalization of web sites.

A web-based cleft lip and palate registry

Am J Orthod Dentofacial Orthop 2002;121:424-5

Using activeX data objects to publish an Excel grade book on the World Wide Web

The World Wide Web is recognized as an ideal grade publishing medium. In this paper, several goals for a web-publishable grade book system are discussed. We reviewed several existing systems but found that none achieved all the goals. A system is described here that meets all the goals and is unique. To publish grades, the instructor does not have to perform any special tasks other than entering and saving the grade information in the provided grade book. When a student requests his or her grades via a web page, the current grade information will be automatically retrieved from the grade book. The software is provided as open source and is freely available for modification and enhancement.

Dyalog-APL application with threads on the basis of ActiveX data objects

This paper presents an implementation of ActiveX Data Objects (ADO) in multithreading Dyalog-APL applications providing high performance access to any data source. The suggested approach is based upon an OLEClient object of Dyalog-APL that provides an OLE (Object Linking and Embedding) automation mechanism for working with ADO as an OLE Automation Server. This concept of such Dyalog-APL applications consists in a presentation of data-processing on 3 levels of hierarchy:{ {OPERATION)ε TASK}εJOB.A synchronisation of database operations in threads is supported by ADO events. Low level operations are accumulated in a library of functions that can also be used autonomously in a single thread for solution of private tasks. These functions are optimised to work in a Dyalog-APL environment. It is available to use in a root of a objects tree RECORDSET object. Data-processing can be carried out directly at a low level to optimise performance, other objects can be created when necessary for the solution of concrete tasks. Many of the RECORDSET operations can be notified before and after each other. OLE is very dependent on the Visual Basic programming language and the syntax of APL is more restricted than the syntax of Visual Basic. It is discussed accommodation problems from syntax point of view.

CIS3/398: Implementation of a Web-Based Electronic Patient Record for Transplant Recipients

IntroductionWhile the "Electronic patient record" (EPR) is a frequently quoted term in many areas of healthcare, only few working EPR-systems are available so far. To justify their use, EPRs must be able to store and display all kinds of medical information in a reliable, secure, time-saving, user-friendly way at an affordable price. Fields with patients who are attended to by a large number of medical specialists over a prolonged period of time are best suited to demonstrate the potential benefits of an EPR. The aim of our project was to investigate the feasibility of an EPR based solely on "of-the-shelf"-software and Internet-technology in the field of organ transplantation.MethodsThe EPR-system consists of three main elements: Data-storage facilities, a Web-server and a user-interface. Data are stored either in a relational database (Sybase Adaptive 11.5, Sybase Inc., CA) or in case of pictures (JPEG) and files in application formats (e. g. Word-Documents) on a Windows NT 4.0 Server (Microsoft Corp., WA). The entire communication of all data is handled by a Web-server (IIS 4.0, Microsoft) with an Active Server Pages extension. The database is accessed by ActiveX Data Objects via the ODBC-interface. The only software required on the user's computer is the Internet Explorer 4.01 (Microsoft), during the first use of the EPR, the ActiveX HTML Layout Control is automatically added. The user can access the EPR via Local or Wide Area Network or by dial-up connection. If the EPR is accessed from outside the firewall, all communication is encrypted (SSL 3.0, Netscape Comm. Corp., CA).The speed of the EPR-system was tested with 50 repeated measurements of the duration of two key-functions: 1) Display of all lab results for a given day and patient and 2) automatic composition of a letter containing diagnoses, medication, notes and lab results. For the test a 233 MHz Pentium II Processor with 10 Mbit/s Ethernet connection (ping-time below 10 ms) over 2 hubs to the server (400 MHz Pentium II, 256 MB RAM) was used.ResultsSo far the EPR-system has been running for eight consecutive months and contains complete records of 673 transplant recipients with an average follow-up of 9.9 (SD :4.9) years and a total of 1.1 million lab values. Instruction to enable new users to perform basic operations took less than two hours in all cases. The average duration of laboratory access was 0.9 (SD:0.5) seconds, the automatic composition of a letter took 6.1 (SD:2.4) seconds. Apart from the database and Windows NT, all other components are available for free. The development of the EPR-system required less than two person-years.ConclusionImplementation of an Electronic patient record that meets the requirements of comprehensiveness, reliability, security, speed, user-friendliness and affordability using a combination of "of-the-shelf" software-products can be feasible, if the current state-of-the-art internet technology is applied.

Microsoft universal data access platform

Microsoft Universal Data Access defines a platform for developing multi-tier enterprise applications that require efficient access to diverse relational or non-relational data sources across intranets or the Internet. Universal Data Access consists of a collection of software components that interact with each other using system-level interfaces defined by OLE DB and providing an application-level data access model called ActiveX Data Objects (ADO). This talk provides an overview of the platform.