Development of Web-based Research and Community Service Database at Universitas Negeri Surabaya

One of the data used as a benchmark for determining the progress of a university can be seen from the productivity of research and community service. The research objectives are to (1) analyze Unesa lecturer research based on the distribution of faculties/departments/study programs; (2) analyzing trends in the research focus of Unesa lecturers; (3) analyzing the achievement of Unesa lecturer research outcomes compared with the target research outcomes; and (4) analyzing the profile of the service to the Unesa lecturer community based on the distribution of faculties/departments/study programs. The reference used in analyzing is from 2015-2019. The development model used is the Waterfall model with a linear development system. The research subject used was the procedure of developing Sistem Informasi Riset dan Pengabdian Kepada Masyarakat (SIRIP) in Higher Education. Data analysis techniques were carried out in three stages, namely pre-development, development, and post-development. Based on the results and discussion, the conclusions in this study are as follows. The results of the trial of Sistem Informasi Riset dan Pengabdian Kepada Masyarakat (SIRIP) using the black box testing method in accordance with 18 functional requirements of the system can run successfully. The profile of research in Unesa from 2015-2019 experienced a significant increase and decrease (fluctuation). The number of research titles funded from 2015-2019 was as many as 250 titles, 585 titles, 700 titles, 480 titles, and 447 titles. Meanwhile, the number of community service titles funded from 2015-2019 was 46 titles, 51 titles, 29 titles, 22 titles, and 338 titles, respectively.


Introduction
At present, the use of information systems is a necessity that must be owned by various institutions, both private and government, not least in higher education institutions. Through the use of information systems, all required data can be accessed easily because it has been recorded and stored in a database. Meanwhile, through all the data that has been stored in the database, higher education institutions or universities can quickly determine whether they are in positive trends or vice versa [1,] [2]. One of the data that can be used as a benchmark for assessing the progress of a university can be seen from the 2nd 2019 ICERA Journal of Physics: Conference Series 1577 (2020) 012042 IOP Publishing doi: 10.1088/1742-6596/1577/1/012042 2 productivity of research and community service. The productivity includes the number of outputs, the number of scientific article publications, and the acquisition of intellectual property generated by researchers [3].
Besides, other data that can be used as benchmarks are the results of an assessment of research performance and community service based on data collected by each college in Simlitabmas [4], [5]. Where the evaluation of research performance and community service is divided into four clusters. Based on the analysis of data that has been verified, 47 universities are included in the independent group, 146 main groups, 479 middle groups, and 1.305 target groups [6]. Aspects measured in performance appraisal generally include aspects of resources, aspects of management, aspects of the resulting output, and revenue that can be generated from research activities and community service. [7].
We can imagine the benefits that can be obtained if all the data can be accessed easily both for the needs of supporting research data and the need to measure the extent of the trend (progress) of the university from year to year. Besides, by implementing an open access policy through the use of information and communication systems, it can support government policies as stated in Law No. 14 of 2008, concerning Public Information Openness. [8]. The essence and this law are to give an obligation to every Public Agency to open access for every applicant for public information in obtaining general information, except for certain confidential information.
Universitas Negeri Surabaya (Unesa) is one of the institutions of higher education that continues to strive to improve the quality of Higher Education Tridharma, which includes teaching, research, and community service. Even based on the results of an assessment of research performance and community service, Unesa became one of 47 universities included in the independent cluster. This shows that all Unesa academicians, lecturers, students, and employees must be able to show consistency in the preparation of research proposals and community service. Through this consistency, it certainly has a positive impact on improving the quality and quantity of research in the Unesa environment. However, unfortunately, until now, no information system facility can store or record research results for lecturers, students, and employees as the cause of Institute for Research and Community Service (RCSI) difficulty in determining trends in research productivity and service to the Unesa community.
Based on the description of the background and existing problems, the formulation of the research includes: (1) how is the research profile of Unesa lecturers starting in 2015-2019 based on the distribution of faculties/departments/ study programs ?; (2) what is the trend in the focus area of Unesa lecturer research starting in 2015-2019 ?; (3) how is the achievement of Unesa lecturer research outcomes starting in 2015-2019 compared to the target research outcomes?; and (4) how is the profile of the service to the Unesa lecturer community from 2015-2019 based on the distribution of faculties/ departments/study programs?

Method
In this study, the waterfall model is used as a software development model. The waterfall model has five stages developed by Winston Royce and is a classic development model with a linear development system [9]. The stages in this model include analysis requirements, design, implementation, verification, and maintenance [10], [11]. The scheme of developing the Waterfall model can be seen in Figure 1. . Actors, as well as users involved in this information system, include lecturers, research centers, community service centers, and research and community service institutions. The sample used in this study includes data on research results and community service for five years in a row (2015-2019). Data collection techniques through documentation analysis. Data analysis techniques were carried out in three stages, namely pre-development, development, and postdevelopment. Pre-development is carried out with observation techniques to analyze the simlitabmas system that already exists in Kemenristekdikti. Development is done by testing the system using the black box testing method. Then post-development is done by questionnaire method to find out the user's response to the developed system.

Results and Discussion
3.1 Development of web-based research and service information systems 3.1.1 System Requirements Analysis Analysis of system requirements in this study is divided into two parts, namely: functional requirements and non-functional requirements. The functional requirements of SIRIP generally describe the system that will be developed in this study. Functional needs consist of nine components which include: (1) lecturer data management; (2) research and service data management; (3) faculty, department and study program data management; (4) data management of research and service outcomes; (5) data management of research and service types; (6) data management in the fields of science, excellence, research, service; (7) data management research and community service schemes; (8) group or space data management; and (9) research and service data analysis.
The non-functional requirements of a career center system are the needs that are used to support the running of the system following the results of interviews and observations. Non-functional system requirements, namely the system, can store research data and devotion to lecturers and web-based systems that can be accessed for 24 hours.

System Design
SIRIP system design in this study was made by referring to the results of the system requirements analysis. The system design is made in the form of a Business Process / Flow Diagram as the flow of SIRIP in Unesa. Use Case Diagrams (UCD) are used to explain the distribution of user access rights. The role or power of access is adjusted to the needs analysis that has been done before. Entity Relationship Diagram (ERD) is used to explain the relationships between tables in the system. Contextual Data Model (CDM) and Physical Data Model (PDM) are used to connect 18 tables in the SIRIP system that are interconnected with each other.

System Implementation
The system developed in this study was carried out after the design stage. The intended event is to make a web-based SIRIP at Surabaya State University. The system was developed using the PHP programming language and MySQL database while facilitating development using the Laravel

System Testing
The system testing will be carried out using the black box testing method in accordance with the functional requirements of the system that have been defined in the system requirements analysis. The result is that all components are categorized as successful when tested.

System Maintenance
System maintenance is a process of improvement of the development of web-based SIRIP based on the results of system trials that have been carried out in the previous stage. This system maintenance serves to make improvements to the system in accordance with the functional requirements of the system. System maintenance refers to the results of system trials that have been carried out. In the future this system will develop according to the needs when implemented at the RCSI at Surabaya State University. So that this system will always develop according to needs. Thus, the research activities carried out by Unesa lecturers and students cover various types and fields of research both internally and externally funded. To guarantee the quality of research from proposal selection to reporting results, the LPI Unesa RPI Center involves internal and external reviewers. Now, Unesa has internal reviewers reaching tens of people (94 lecturers) and 15 nationally certified reviewers.

Unesa Research
The number of studies conducted at each faculty in Unesa in the period 2015-2019 is as follows.  FEd  17  78  134  57  58  FLA  36  87  81  67  67  FMNS  53  105  90  81  79  FSSL  54  106  106  97  92  FEng  70  134  177  105  81  FSS  7  26  58  29  29  FEc  13  49  54  44  41  Total  250  585  700  480  447   From table 1 above, if the graph is made, it will be like the following figures 2 and 3.  Students interest in researching in 2019 is very high. This is indicated by the number of proposals included in the desk evaluation reaching 550 titles, and only 52 titles were funded (very competitive). Meanwhile, for 2019, this research has been carried out by functional education staff for the first time and has passed 11 research titles. The involvement of Unesa lecturers in conducting research can be seen in Table 2.   is included in the "Independent" group which was previously included in the "Main" group. Unesa was ranked 38th out of 47 universities that were included in the "Independent" group. This achievement must continue to be improved in the coming years by increasing the quantity and quality of research, research funding, and research outputs. This is undoubtedly a proud achievement and needs to be maintained and improved in the years to come.
The performance of community service to RCSI Unesa in 2015-2019 has been categorized as good. In general, Unesa lecturers have competed to get community service funds at the national, university, faculty, and graduate levels. The amount of community service that has been carried out at each faculty in Unesa in the 2015-2019 period is presented in Table 3. Table 3 Total  37  51  29  22  338 From Table 3, it can be seen that the profile of community service in Unesa from 2015-2019 experienced a significant increase and decrease (fluctuation). In 2015, the number of community service proposals funded was 46 titles. In 2016, the number of funded community service proposals increased to 51 titles. In 2017, the number of proposals for community service fell to 29 titles. In 2018, the number of proposals for community service was funded by 22 titles. In 2019, the number of proposals for community service was 338 titles. The most community service acquisition in Unesa occurred in 2019 with 338 titles. From the data in Table 5.5 above, if a graph is made, it will look like the Figure 7.  From various community service schemes offered from 2015-2019, it can be seen that the distribution of Unesa lecturer community service is more in the Science and Technology for the Community (STC) or Community Partnership Program (CPP) scheme with a percentage of 81%, followed by the Real Work Lecture scheme -Learning for Community Empowerment (RWL-CE) of 8%, Campus Intellectual Product Unit Development Program (CIPUDP) scheme, Science and Technology for Campus Innovation and Creativity (STCIC), and Regional Superior Product Development Program (RSPDP) by 3% while the Science and Technology for Entrepreneurship (STE) scheme is only 2%. In full, the distribution of funded community service schemes can be seen in Figure 8.  belongs to the "Excellent" group which was previously included in the "Very Good" group. Unesa was ranked 23 out of 24 universities included in the "Excellent" group. This achievement must continue to be improved in the coming years by increasing the quantity and quality of community service, funding  Whereas the distribution of accredited national scientific articles indexed by Sprott from the results of research and community service Unesa lecturers from 2015-2019 was S1 articles 1, S2 were 39 articles, S3 was 74 articles, S4 was 83 articles, S5 was 25 articles, S6 was 7 articles , and 27,810 articles were not categorized (local journals). In full can be seen in Figure 13 below.