Papers by Keyword: SQL

Abstract: Based on the analysis of several methods of storing OWL object in relational database, this paper presents a new method, namely storing the instances of each kind of object and attribute in a database table, and using views in the database to express relationships among the objects. Experiments prove that this method is applicable for moderate amount of storage of OWL objects.

Abstract: the employee information management system is mainly for enterprise employees information for centralized management, convenient enterprises to establish a perfect and powerful employee information database, it is a SQL 2000 database as a development platform, using JSP program, complete the data input, modification, storage, call query, etc; Form data, and use the SQL 2000 database for data storage.

Abstract: We design a structured big data management system which can deal with large-scale structured datasets and supports the cross-domain collaborative query. The system employs the HDFS as the storage layer. And it realizes a scheduling engine in reference with the splitting technology of the massive parallel processing (MPP) database. Using this engine, tasks can be split and distributed to different sub-nodes for parallel execution. Through cross-domain query module, users can execute SQL commands on the datasets of different datacenters or network domains. Meanwhile, the system supports the distributed deployment, so as to reduce the construction cost by making full use of existing software and hardware resources and equipments. We test the system functions and performance on a 80 nodes cluster, and compares with Hive. The result suggested that system performance is improved by 2-3 times than Hive and the function designed can be performed correctly.

Abstract: Apriori algorithm is a classical algorithm for association rules mining. But the algorithm must be connect repeatly and operate steps layer by layer to find frequent item sets. To overcome the shortcomings of Apriori algorithm, relational database language SQL is used proceed from the higher-order item sets and compute the support of item set to find frequent item sets in this paper. The solution process eliminates a large number of duplicate items produced by the connection from low-dimensional to high-dimensional in the traditional process. The calculation is simplified and efficiency improved.

Abstract: the student achievement management system is a typical application of managing information system (MIS), its development mainly includes the backstage database the establishment and maintenance of and front-end application development two aspects. For the former requirement to establish data consistency and integrality and security of data. For the latter requires the application program function complete, easy to use, etc. Use MICROSOFT ASP development tools, background database ACCESS, build system application prototype in a short time, then, to the initial prototype system needs iteration, constantly revised and improved, until forms the user satisfied feasible system.

Abstract: Due to the nature of project construction information and the inherent flexibility of “3L” (EXCEL, XML and SQL), “3L” have become the de-facto standard for data representation and exchange. The features of “3L” are briefly introduced. Meanwhile, the system framework, functional modules and some key problems of database management of project construction were discussed. The system implementation of the database management system of project construction based on “3L” platform technology was established seriously and the feasibility and applicability of the database management system was discussed finally.

Abstract: The purpose of this paper is to improve the process tracking system, in order to meet the factory MES system requirements. Through the research process control systems and single process control system used in iron and steel enterprises in home and abroad, the integrated process control system, tracking control system and data acquisition system were established, and applied to the heat treatment lines of JISCO. In this system, the store procedure was used to complete the transaction processing in the database for improve the flexibility of the system. Practical applications validate the security and stability of performance system.

Abstract: Popularity for the term Cloud-Computing has been increasing in recent years. In addition to the SQL technique, Map-Reduce, a programming model that realizes implementing large-scale data processing, has been a hot topic that is widely discussed through many studies. Many real-world tasks such as data processing for search engines can be parallel-implemented through a simple interface with two functions called Map and Reduce. We focus on comparing the performance of the Hadoop implementation of Map-Reduce with SQL Server through simulations. Hadoop can complete the same query faster than SQL Server. On the other hand, some concerned factors are also tested to see whether they would affect the performance for Hadoop or not. In fact more machines included for data processing can make Hadoop achieve a better performance, especially for a large-scale data set.

Abstract: This system is developed a Enter-Sale-Keep management system for Qinhuangdao Haineng new building materials Co., Ltd.. The system relates to such management operations as account, registration, modification, query summary, balance calculation, copy, paste, and etc.. Through the system analysis, a feasible system is determined. In the design PowerBuilder (PB) is used for testing and debugging, and finally GP-install is used to make a data package. It has been proved that not only a seamless connection for data transmission is accomplished, embedded into the system, the development of database management system is sped up, but a open transplantation of the system can be provided.

Abstract: Network bandwidth can effectively support learning content such as multimedia files under, and intelligent terminal equipment for mobile clients humanization and functional design. Therefore, through the rational design of mobile learning platform that can effectively complement traditional learning less flexible. This paper study the direct MYSQL command in the terminal to use SQL statements to the database building a database, insert the initial exam and so on. In the latter part of the maintenance process, while using the first method and the third method updates the database maintenance work.