Search

With the development of ASP.NET platform, ASP.NET architecture system increasingly mature and increasingly wide range of applications, ADO.NET technology to become the key technology of this system, database access, data processing and application development. This paper mainly studies the database access of ADO.NET. First introduced ASP.NET technology and several ways of ASP access to the database, which shows the advantages of ADO database access; secondly expounded the principle of ASP.NET access to the database, ASP.NET to access database through the ADO of the internal components; then introduces the main object types of ADO.NET database access required, ADO.NET is an improved version of ADO, including Command, Connection, DataAdapter, DataSet and DataReader, and so on. And describes their respective functions; finally, introduces the basic process of ADO.NET to access the database. And implementation of SQL Server database connection.

The paper starts from performance optimization of Oracle database. Based on analysis of Oracle structure, the paper explores performance optimization of Oracle database for database parameters, application system and network load. And the paper expounds reasonable planning of database and how to analyze and improve the performance after operation, and how to optimize a database with satisfying performance.

In this paper, according to the needs of the application, discussed the necessity of constructing the database of wireless sensor network, and analyzes the difference in function of the traditional database management system, and the problems faced in the implementation; the architecture of the system is analyzed in detail, including the database and network node on the function composition, and between nodes cooperate to complete the key technology of query.

Database is the core part of university digital campus platform. Database encryption is an effective method to guarantee the security of data. The paper analyze the structure design of database security model, and study the design of mode function, key features and further implementation model. The system is suitable for security protection for network database management, and has a certain degree of universality, portability and security.

How to coordinate heterogeneous database to realize sharing and consistency of information not only is an important research subject in the database filed, but also is an emerging research hot spot in the field of database system. As a new development direction of computer software, it applies some new techniques to integrate the existing systems to develop new applications. The paper analyzes CSCW, XML, JDBC and heterogeneous database, and proposes a solution of heterogeneous database. The solution absorbs the thoughts of database meta data, middle ware and LDAP directory service.

Accurately and efficiently managing mechanical parts database is extremely important and pivotal in the machinery industry. In this paper, a dynamic management database system of mechanical parts is established by the Microsoft Access database management system and the VB visualized integrated development environment. This system adopts ADOX object to establish a new database and edit the existing database dynamically, applies data files, ADO and ADOX object to dynamically manage database, and utilizes Datacombo control to realize the selection of data. Being simple, convenient and feasible, this system is an intelligent man-machine interactive operating system, which enhances the work efficiency and substantially decreases repetitive operation.

Database is distributed stored in cloud. The paper found that joint distribution can base on frequent data manipulation, and frequent connection property. So it proposed cloud database data distribution strategy based on association rules. The data distributed storage is according to the frequent data manipulation rules. Experiments demonstrate that this strategy can significantly reduce database query response time, especially in connection query response time.

With the development of Internet technology and the increasing popularity of the Internet, the amount of information data of enterprises increased sharply. How to avoid unexpected data corruption and to improve the system of data security and data recovery capabilities has been the focus of attention of users and enterprises. Regular backups of the database is to restore the data the easiest and most effective guarantee method and is an effective measure database administrators to manage data. This paper proposes a plan of database scheduled tasks based on Linux environment. This plan can be timed to export the database, be sent automatically to a secure backup mailbox and complete the regular backup of the database finally.

according to the current situation of small and medium-sized library carried out feasibility analysis and the actual demand. The library's basic business processes are described. Combining with the knowledge of library and database technology to design each module. The system using the Windows XP/Windows 6.0 as system platform, using Visual basic 6.0 as a front-end application development tools, Microsoft SQL Server 2000 as the background database. Through to the small and medium-sized books management system management system requirements analysis, functional module division, database model analysis, designed the database structure and application. Due to the use of computer management, improved the traditional manual management way, improve the management level.

This paper analyzes the functional design and structure design of the database security model networks, research and further realizes the key features of the model. The system is suitable for network security database management system, which has a certain universality and portability.

Database as a service in cloud computing enables the user to create, store, modify, and retrieve data over the Internet. The user does not have to install and maintain the database himself. Instead, the database service provider takes responsibility for installing and maintaining the database. Storing data in a cloud database introduces security risks in data confidentiality, data integrity, and privacy. This research aims to design a method for storing data in a cloud database that provides data confidentiality and privacy and allows querying data. The comparison operations and aggregate functions can be performed on the cloud server. The research employs a combination of data masking and data encryption to achieve the objectives.

In order to improve data query speed, there are four methods: optimization of SQL (Structured Query Language) statements and reasonable use of index, temporary tables and views are researched. Practice demonstrates these four methods can improve query speed and database performance.

In order to gain high response speed, the paper presents a hybrid Timesten and Oracle database structure. First, the paper creates concepts of real-time database and historical database. It also points out their relationships. Second, it builds a hardware structure which involves an application server, a Timesten database server and an Oracle database server. The structure adopts uninterruptible power supply for data reliability. Last, it presents a software structure of databases. The Timesten acts as the real-time database and the Oracle acts as the historical database. There is a layer in front of the Timesten for data acquiring and an agent layer between the Timesten and the Oracle for data transmission. Experiment shows that the Timesten is about 6.69 times faster than the Oracle disk database.

According to the ternary number data mining algorithm, this paper combines SQL program operation and Oracle 10 g database system together. And then, numerical modeling and meshing technique are adopted to abstract data parameter from the database system. In addition,a mathematical model is established to abstract information from the ternary number database and the information literacy algorithm is also designed. In order to verify the reliability of the mathematical model and algorithm, a database abstracting numerical simulation experiment is designed for the velocity and temperature parameter. Through the experiment, it is discovered that there does not exist residual shock in the ternary number method when the data is being abstracted, which has a relatively stable convergence. At the same time, this paper gains the speed data distribution vector diagram. Eventually, the reliability of the algorithm designed in this paper is verified by comparing temperature data and the experimental data.

In this paper we introduce cross tree and block mathematical principles into the design of database system, divide the time sequence and storage space of computer database system, establish the mathematical model and algorithm of computer resources database system, and design the test database system. In this paper, we use high performance interface of Display Port, by way of coupling to communicate on two port control, and use RHEL 6.2 Linux virtual machine to do simulation experiment on process of database system. Through the simulation we find the API which is called by Read, Close, Mmap, Stat, Fstat is similar. It is consistent with the actual situation, and verifies the reliability of the program. Finally, we apply the database system to the network database construction of sports literature resources in the new town of Poyang Lake area. It reaches the effect that sport resources are shared by all. It provides technical support for the application of computer database system.

Sensitive data in database should be encrypted to protect it from malicious access. Do this in application is hard and costly. Utilizing the user-defined function technology supported by database management system, data encryption could be done separately and transparently for application. The principle and system architecture of encrypting database content with user-defined function is introduced, and the method handling long object encrypting is discussed specially. Experiments show that the proposed method is easy to implement, effective in system running and application development, and applicable for both new developing and old developed application.

Many legacy applications rely on a single instance relational database. In the age of big data, applications with growing popularity may continue to generate large amount of data. The data would be beyond the limit of a traditional relational database. These applications can be migrated to a distributed database system for acquiring high scalability and performance. But the migration process is complicated especially for user defined stored procedure. In order to obtain the correct behavior, a stored procedure usually has to be rewritten in the application code. This rewriting is usually a time consuming and unpleasant task. This study gives a mechanism for migrating stored procedure from single instance relational database to distributed sharded database without the need of application code rewriting. In the migration solution offered by this study, Oracle stored procedure code is parsed, analyzed, and translated so as to be stored and executed globally in a sharded database.

Wireless embedded database system is more complex and flexible than conventional computing environment. Embedded database computing platform requires more technologies such as asymmetric mobility, instability connected topology diversity, network communications, highly scalable systems, low reliability. This paper described the design and development process of embedded database, analyzed the database indexes, data storage and lexical analyzer. It supports CAPI interfaces and standard SQL subset, also supports ODBC or JDBC and bi-directional data exchange, and has a two-way flow of data between the central database and the embedded database.

The ADO.NET is a brand-new data access technique of the Microsoft. It is the bridge of the .NET application and database communication, which use the XML to exchange data, and add many new program interface to access simply database. This paper introduce the structure, feature and inner object of the ADO.NET, and analysis database access technique of the ADO.NET, give the method of the ADO.NET connection various kinds of database. Finally, an example of the C# connection SQLSEVER database is enumerated, and the detailed implementation code is given.

The convenient living is created by IT industry, on the other hand industries are from human production transform robotics automation. In the future, robots not only possess manufacturing functions but also have service property. However, if the interaction that robots with service property just only be entered with a single, it has limited functionality. The purpose of this study is investigating the conception of database into robots, load data from database and save processed data into database, it will lessen wrongs and improve speed of response. In this study, will be compared two programs, one is the input and output processing by program, the order one is add database with function of save and load. Result of the comparison apply to processing mode of robot. The experimental results show that use database model can upgrade speed and accuracy that stream transmit, it will provide more convenient automated service contribution.

This paper analyzed on real-time database system, and applied the cloud manufacturing technology and distributed system technology to the database system model. Through the analysis on the real time database, we can got the distributed real-time data system types and data storage model, establish two kinds of memory T-mode and S-mode, database storage model and make the production of block. Finally establish the work flow of distributed real-time database system, get relevant application program. A large number of real-time data collection and administration can be realized, which can improve the real-time information data processing efficiency and system model performance. Through the establishment of model and analysis of its working process in the real-time distributed system real time database application path, it can provide guidance for the establishment of distributed real-time database system model.

Nowadays, a variety of database systems coexist and the application softwares access and operation for database is often custom-written, which can lead to more complicated cross-database access. Through analysis of the operational process of the database middleware, adding the generic database query middleware eQueryMW which can shield the difference of the data source to the traditional three-tier architecture as the middleware level can realize the access of relational heterogeneity database, providing a unified database query interface and cross-database integration method for the users.

In this paper we introduce a kind of management mechanism for computer immune system GECISM (GEneral Computer Immune System Model)[. With it when emergency happens it can be timely and actively response according to the current state of database. Thus it improved the executive efficiency of the computer immune system. The method is that we design the local rules in the form of active database. It neednt user intervention for the processes to be handled by the processor. The database of the client machine can automatically carry out the judgment of "self" and "non-self". So it can improve the system's processing capability.

This paper mainly introduces the design idea of real-time database in embedded configuration software. According to the characteristics of real-time database, this paper using three layer storage structures which consist of shared memory, file system and general database. It improves the access efficiency of real-time database and data reliability in a timely manner.

The data management of urban and rural planning is very important and special. It is quite necessary to customize a thematic database system for urban and rural planning. According to their characteristics and classifications, the requirements of this system are firstly analyzed in this paper. With the integration of traditional relation database management system and geographical information system, an extendable data model for this thematic database is proposed. In this model, Client/Server architecture is adopted, Oracle is extended to store both attribute data and spatial data, and spatial database engine is utilized to access the spatial data in Oracle. At the client side, some functional modules such as data import and export, browse and display, query and retrieval, update and maintain, and security management are designed and developed. Finally, a case study of the thematic database system is applied. It is concluded that the customized spatial database management system for urban and rural planning is not only able to unify and store all types of data, but also able to improve the efficiency and visualization.

In order to improve the performance of the query optimization for the distribute database, an improved query optimization algorithm was proposed based on the genetic algorithm. The query execution cost model based on the genetic algorithm was proposed in this paper. The distributed database was emerged in the 70's of the last century and developed with the progress of the computer technology and network technology, the distributed database was the database system which is distributed storage dispersedly in physics and with centralized processing in mathematic logic. Because the storage points were not uniform, the structure of the distributed database is much more complicated than the centralized database. Both the genetic algorithm and the dynamic exhaustive planning algorithm were taken in the query simulation for the performance comparison. The result shows that the genetic query optimization method in this paper has better performance in the distributed database query application. The case study and the simulation result show that the algorithm can get a satisfactory optimization result in a few iterations and the query optimization algorithm based on the genetic method has nice performance of the query optimization property, and the consumption and costs of the query is reduced to the minimum. The method which this paper proposed has good application performance and is valuable to put into practice.

This paper is based on a numerical control milling cutting parameters database, DataCut, which is constructed on SQL Server. This paper focuses on a normal measure to separate and combine databases. This kind of measure can transfer databases, which are from different areas, into metabases of cutting parameters database of industry-oriented applications, and then combine them. This will take advantage of all the resource, and help to build a cutting parameters database of industry-oriented applications. Besides, in order to protect the commercial secrets of different areas expertise, this database system should also be able to be used separately. This normal measure has been applied to an experiment, which realized the combination of databases.

The forest fire has been threatening the forest ecosystem and has brought huge economic losses to humans. Traditional fire detection systems use ion-optical smoking type and other physical or chemical means to discover a fire, which is not suitable for outdoor forest fires with long-distance and large-area characteristics. This paper presents the early fire detection algorithm based on smoke dynamic characteristics and its main part includes smoke color model, dynamic feature extraction and fire area connected component analysis. Through standard video database performance testing and compared to the algorithm and the traditional fire detection method, we can achieve early warning of a fire and can effectively reduce false and negative rate of fire monitoring system.

Novel substation training system is developed based on configuration database constituted of three parts: user layer, communication interface and configuration database. The substation equipment module’s graphic files in the configuration database are categorized and easily created. Thus the development of different substation training system is convenient and expandable.

Currently, the embedded real-time database is widely applied in the embedded system and plays an important role. But on account of being mainly applied to the most important fields such as Communication, Spaceflight and Military as a key task control management, errors by it often results in irreversible fatal losses. Therefore, it is necessary to analyze the embedded real-time database key characteristics and test. This paper, by researching the characteristics, architecture and implementation technique of the embedded real-time database, analyzes its key properties including real-time transaction processing, concurrency control, recovery management, etc., and finally proposes applicable testing strategy and methods which have been proved in the actual test, being as a technique to evaluate the performance of the embedded real-time database.

Due to the poor database performance situation on Android operating system, put forward a methods of database access performance optimization. The paper first analyze the Android database access principle, architecture of SQLite and Berkeley DB, and methods of Berkeley DB in concurrent access, then put forward a method of porting Berkeley DB to Android to replace SQLite to enhance the database access performance. Finally a series of practical benchmark results shows that the porting brings performance improvement effect.

The database design process for failure diagnosis expert system is divided into two parts. One part is, in the knowledge base, we mainly introduce design ideas of each maintaining module of in knowledge base, including the implementation method for entry, retrieval, modification and inquiring function interface of knowledge. Another part is dynamic database. We mainly introduce the modules of specific design process for data transmission. The entire system realize by C++Builder language. And the detailed codes of database are written into the program code book.

The tuning for Oracle database system is vital to the normal running of the whole system, but it is a complicated work. SQL statement tuning is a very critical aspect of database performance tuning. It is an inherently complex activity requiring a high level of expertise in several domains: query optimization, to improve the execution plan selected by the query optimizer, access design to identify missing access structures and SQL design to restructure and simplify the text of a badly written SQL statement. In this paper, the author analyzes the execution procedure of oracle optimizer, and researches how to improve the oracle database query performance in MES.

Using the automation production and management system of modern manufacturing industry product line for reference, a new industrialized PL-ISEE (product line based integrated software engineering environment) model was proposed by us in reference [4]. In the new model, the middle part in the PL-ISEE architecture is data layer which is composed of the software components bus and environment database platform to achieve the storage and managements of product line core assets data. In this paper, the environment database platform architecture and its schema design as well as implementation mechanism are further researched. Whole database platform architecture consists of the product line asset objects management service and core assets database system. The data model and database schema of the database system are designed and created by using a united core asset concept model and data organization model. The database supporting platform with the model and schema can well satisfy all the requirements of interfaces, tools and data integration as well as product line assembling production in the PL-ISEE. Therefore, the design and realizing ideas of the PL-ISEE database platform will be useful for researching on product line engineering and methodology in the future.

In order to improve the security of database system and resist threat from all aspects, especially the threat from database administrators, the paper designed a new database encryption system. In this system sensitive information is encrypted and establishes ciphertext address index table for it. Encryptions for character fields and numeric fields have different processing methods. Decryption key should be synthesized by both client and server. System can execute SQL query like equality queries, range queries and so on which are difficult to deal with after encryption. The analysis shows that the system has better security.