Management Information System For
Science And Technology In Indonesia (MISSTI)

Koswara Natakusumah
(Indonesian Institute Of Science)
koswara@inkom.lipi.go.id

Abstract

MISSTI is one of information system used for science and technology (ST) data management in Indonesia. The purpose of  this system is to manage ST data and disseminate to the user through Intranet in Indonesian Institute Of  Science and Internet. The system mangos the data from Department, Non-Department, Council, Integrated Research, Society Self Fund Institution, Industry and Universities in Indonesia. This system run multi users, has completed science and technology databases, and can be accessed through Internet. Methodology used to build the system comprises: data collection, analysis, design, testing, and implementation; including building the database, data transfer, computer network, context diagram, data flow diagram, menu structure, input design, output design. In the implementation section explained the need of hardware, software, network preparation, server preparation, client preparation, database migration,  program installation, and training program.

 
Figure 2. 22 Output design of department manpower (bar)  

 
Figure 2. 25 Output design of non-department manpower

Figure 2. 26 Output design of non-department Finance

Figure 2. 27 Output design of non-department activities

3. Implementation

Implementation of MISSTI uses hardware, software, computer network, server installation, client installation and program installation. Hardware consists of server computer, workstation, adaptor network or network interface card (NIC), cable, and hub. Server is a central computer that manages all computer network activities, to store the data and program that can be accessed by all clients. This server runs Windows NT 4 and Microsoft SQL Server 6.5. Workstation is a computer client that can access data and program in the server computer. This client uses windows 98 to connect to the network and uses network adaptor card NE-2000. The function of this card is to have connection among computers in a network, so that all connected computers can communicate each other. To have connection among adaptor cards uses UTP cable.

Delphi 3.0 is used to build a computer program, whereas Borland database engine and ODBC are used for databases connection between client and server. The server uses operating system, database server, and driver for DBMS. Operating system uses Windows NT Verse 4.0 with Service Pack 3 or more; Database Server uses Microsoft SQL Server 6.5; and Driver for DBMS uses ODBC (available in windows NT) and BDE (Borland Database Engine). The client uses operating system and driver for DBMS. Operating system uses Windows 95/98 or newest version, whereas driver for DBMS uses ODBC and BDE.

Computer network comprises several integrated computer hardware in a network, uses certain kind of network topology and protocol that be used for computer communication. Network topology is used to manage data communication traffic, so that the network can run optimal. MISSTI uses Ethernet network architecture.  This network needs preparation of Network Card Installation for server, and network driver for ethernet card. This network needs system structure and network area for calculating how long connected cable is needed for the network, and also to manage cable lines for each workstation.

Windows NT operating system and Microsoft SQL server are installed to the computer server. This installation needs special skills of the experts, and the network administrators attend and follow the installation process in order to gain its knowledge. Microsoft SQL server 6.5 installation needs also the knowledge of how to manage the server and its SQL administration, so that the SQL server can work properly. Computer clients use Windows 95 (minimum) and in every computer client uses driver for running MIS software. There is also facility for database migration, which is carried out in the server. Before that, it prepares server and SQL administrations, and then application program for migration can be executed. The computer program is installed in the server and client. The program in the server is also prepared for the client, so that, the client can run the server’s program, but this situation  reduces capabilities of  process time and working load of the server.

4.   Conclusion

Basic concepts of integrated system development of MISSTI is well prepared, adding new system modules can be carried out easily; and changing every modules in making reports can also be done easily, without changing source program. Databases for the future are prepared, and can be accessed through Internet. MISSTI is developed to produce different report based on user’s need. Preparation of the report uses SQL (Structured Query Language) that written in a report script. Information for Internet is selected. This selection is helped by interface computer program for having good connection between MISSTI and the Internet. Up to now, MISSTI is used to manage the data for analysis and development of science and technology in Indonesia Institute of Science (see Attachment); it will develop for  the need of infrastructure Archipelagic Super-Lane 1999 in Indonesia.

Reference: 1. LIPI; A Master Plan For The R & D Management Information System, Jakarta: LIPI, 1994.

Attachment :  S&T Development Budget according to type of Expenditure and Activities in Department (DM), 1998/1999

Source: Document DIP, processed by Papiptek-LIPI

S&T Development budget according to type of Expenditure and Activities in Non Departmental Government Institutions (NDGI), 1998/1999         (x Rp. 1.000)

Source: Document DIP, processed by Papiptek-LIPI

Figure  Archipelagic Super-Lane 1999 in Indonesia

(last updated 12 July 2000)