Integrated Design of Graduate Education Information System of Universities in Digital Campus Environment

This study takes the digital campus construction planning of the high school as an example and determines the requirements of the postgraduate management information system under the digital campus environment through the analysis of the overall framework and technology of the digital campus. Combining the current situation of computer technology, network technology, and the actual situation of our university, the current mainstream B/S three-layer architecture is adopted, the web adopts the current popular Java Server Pages technology, and the struts framework connects to the Oracle backend database through the Java Database Connectivity interface to design the browser-side and server-side programs. The struts framework connects to the Oracle backend database through the Java Database Connectivity interface to design browser-side and server-side programs. The functional model and data flow model of the system were established through a detailed and effective analysis of the entire workflow of postgraduate students’ training management during their school years. Then, the system analysis, design, and drawing of the swim lane diagram and data business flow diagram were carried out. The system was designed in detail in terms of system architecture, development tools, functional modules, and database design, and the core module of training program making in postgraduate training management was highlighted as an example to discuss the principles and methods in the construction of departmental business systems and informatization under the digital campus environment, and a flexible and efficient postgraduate management information system was realized. It standardizes the construction of data standardization in universities; does a good job of standardizing and normalizing information; improves the accuracy, validity, and real-time production of data collection and the real and safe unified management of historical data; and provides scientific and reasonable data support for the leadership to make relevant decisions.

Movie Recommendation System by Using Collaborative Filtering

This is the era of modern technology where we are all surrounded and covered by technology. This eases our daily life and saves our time and one of the most important techniques that played a very important role in our day-to-day life is the recommendation system. The recommendation system is used in various fields like it is used to recommend products, books, videos, movies, news, and many more. In this paper, we use a Recommendation system for movies we built or a movie recommendation system. It is based on a collaborative filtering approach that makes use of the information provided by the users, analyzes them and recommends movies according to the taste of users. The recommended movie list sorted according to the ratings given to this system is developed in python by using pycharm IDE and MYSQL for database connectivity. The presented recommendation system generates recommendations using various types of knowledge and data about users. Our Recommendation system recommends movies to each and every user by their previous searching history. Here we use some searching techniques as well. We also tried to overcome the cold start problem we use Movielens database. Keywords: Collaborative-filtering, Content-based filtering, Clustering, Recommendation system searching technique, Movies

MUTWEB- A Testing Tool for Performing Mutation Testing of Java and Servlet Based Web Applications

Mutation testing is one of the oldest and unique testing techniques to perform white box testing of software applications. Code coverage becoming an increasing concern in the testing cycle of software, mutation testing technique aids in achieving higher code coverage and unearthing more number of errors at the testing site itself. The parameters like the database connectivity, session management, cookie management, are the beginning point of web application testing failures given the heterogeneity aspects associated with the development of a web application. A detailed account on list of available testing tools for performing mutation testing are presented here. A big bundle of mutation testing tools are still available, however they are not focussing on some of the crucial web vulnerabilities like session and cookie management in web apps. In the current work, a tool to perform mutation testing of web applications is developed and tested to see if desired results are occurring. An architecture of the tool is designed is discussed and presented. A brief analysis on results is presented

Accessing Data From Multiple Heterogeneous Distributed Database Systems

This chapter describes the method to retrieve data from multiple heterogeneous distributed relational database management systems such as MySQL, PostgreSQL, MS SQL Server, MS Access, etc. into Oracle RDBMS using Oracle's Heterogeneous Gateway Services. The complete process starting from downloading and installation of required software, creation of data source names using open database connectivity, modification of system parameter files, checking connections, creation of synonyms for tables of remote databases into oracle, creation of database links and accessing data from non-oracle databases using database links is explained in great detail. Apart from this, data manipulation in remote databases from Oracle and execution of PL/SQL procedures to manipulate data residing on remote databases is discussed with examples. Troubleshooting common errors during this process is also discussed.

Enhancing Call-Level Interfaces with Thread-Safe Local Memory Structures

Database applications are being increasingly under pressure to respond effectively to ever more demanding performance requirements. Software architects can resort to several well-known architectural tactics to minimize the possibility of coming across with any performance bottleneck. The usage of call-level interfaces (CLIs) is a strategy aimed at reducing the overhead of business components. CLIs are low-level APIs that provide a high-performance environment to execute standard SQL statements on relational and also on some NoSQL database (DB) servers. In spite of these valuable features, CLIs are not thread-safe when distinct threads need to share datasets retrieved through Select statements from databases. Thus, even in situations where two or more threads could share a dataset, there is no other possibility than providing each thread with its own dataset, this way leading to an increased need of computational resources. To overcome this drawback, in this paper we propose a new natively thread-safe architecture. The implementation herein presented is based on a thread-safe updatable local memory structure (LMS) where the data retrieved from databases is kept. A proof of concept based on Java Database Connectivity type 4 (JDBC) for SQL Server 2008 is presented and also a performance assessment.