Sistem Pendukung Keputusan Penentuan Tingkat Kecanduan Masyarakat Terhadap Rokok dengan Metode Fuzzy Mamdani

A person's addiction to smoking can be seen from the characteristics of the cigarette addict, including: difficulty controlling the desire to smoke, high appetite, frequent coughing, sleep disturbances, and difficulty concentrating. A person's addiction to cigarettes can have a bad impact on the health of that person. The research used the Fuzzy Mamdani method. The system was built using the Hypertext Preprocessor (PHP) programming language. The database management system uses My Structured Query Language (MYSQL). The criteria for the level of community addiction to cigarettes are cost, smoking frequency, and the environment. This study aims to design a Decision Support System for determining the level of community addiction to smoking and applying the Fuzzy Mamdani method for determining the level of community addiction to cigarettes. So it can be concluded that the person's level of addiction is at number 13 or categorized as CANDU.

Download Full-text

JUSTIFICATION OF THE STRUCTURE OF THE DECISION SUPPORT SYSTEM FOR SIMPLIFYING CONTROL PROCEDURES AT CROSSING POINTS

Computer Systems and Information Technologies ◽

10.31891/csit-2020-1-4 ◽

2020 ◽

Vol 1 (1) ◽

pp. 28-41

Author(s):

O. BOROVYK ◽

◽

L. BOROVYK ◽

N. SURZHAVSKA ◽

◽

...

Keyword(s):

Decision Support ◽

Decision Support System ◽

Support System ◽

Management System ◽

Database Management ◽

Control Process ◽

The State ◽

Database Management System ◽

Border Control ◽

Control Procedures

The article is devoted to the substantiation of the structure of the decision support system for the simplification of control procedures at road checkpoints across the state border. As a result of the research, the structure of the decision support system for simplification of control procedures at road checkpoints is proposed. The structure is based on the analysis of the border control process at road checkpoints and technological features of its simplification, analysis of decision support models for the organization and technology of border control simplification, as well as analysis of problematic aspects of their implementation and identification of possible solutions. The article substantiates that the basis of the database management system models of the studied decision support system should be a model for determining the need for simplification of border control at road checkpoints, a model for determining the duration of simplification of border control and a model for selecting appropriate control actions for individuals and vehicles. queues. The basis of the database management system of the studied decision support system should be databases relating to the situation at the checkpoint, which changes dynamically over time, the characteristics of the queue of vehicles, tactical and technical characteristics of those vehicles from which the queue may be formed. car checkpoint, departmental database "Gart - 1 P", a database concerning the rules of crossing the state border, a database of information signs of offenses at the state border and risk profiles.

Download Full-text

A decision support system for rehabilitation of sewer pipes

Canadian Journal of Civil Engineering ◽

10.1139/l01-006 ◽

2001 ◽

Vol 28 (3) ◽

pp. 394-401 ◽

Cited By ~ 3

Author(s):

Tariq Shehab-Eldeen ◽

Osama Moselhi

Keyword(s):

Decision Support ◽

Decision Support System ◽

Support System ◽

Database Management ◽

New Technologies ◽

Database Management System ◽

Sewer Pipes ◽

Sewer Rehabilitation ◽

Multi Attribute Utility Theory ◽

Need For Rehabilitation

The condition of sewer pipes in North America has severely deteriorated, over the last few decades, creating a need for rehabilitation. Sewer rehabilitation methods are numerous and are constantly being developed, benefiting from emerging technologies. The implementation of these methods is driven by the need to improve quality and to reduce cost and project duration. One of the rapidly expanding fields in the sewer rehabilitation industry is trenchless technology. Due to the large number of methods associated with emerging new technologies in this field, selecting the most suitable method can be a challenging task. Selection in this environment, without a computerized tool, may also suffer from the limited knowledge and (or) experience of the decision-maker and could result in overlooking some of the suitable methods that could do the job at less cost. This paper describes a recently developed system for rehabilitation of concrete and clay sewer pipes and focuses primarily on two of its components: (i) the database management system (DBMS) and (ii) the decision support system (DSS). The system can assist municipal engineers and contractors in selecting the most suitable trenchless rehabilitation technique that specifies job conditions and user requirements. An example application is presented to demonstrate the use and capabilities of the developed system.Key words: pipe defects, rehabilitation, sewer pipes, database management systems, decision support systems, multi-attribute utility theory.

Download Full-text

SQL Code Poisoning

Cyber Warfare and Cyber Terrorism ◽

10.4018/978-1-59140-991-5.ch021 ◽

2011 ◽

pp. 161-171

Author(s):

Theodoros Tzouramanis

Keyword(s):

Anomaly Detection ◽

Management System ◽

Database Management ◽

Query Language ◽

Database Management System ◽

Sql Injection ◽

Database Administrator ◽

Structured Query Language ◽

Sql Injection Attack ◽

Cross Site

Anomaly Detection; Cookie Poisoning; CRLF Injection Attack; Cross-Site Scripting (or CSS) Attack Database Administrator (DBA); Database Management System (DBMS); Database Structured Query Language (SQL); Directory Traversal Attack; Google Hacking Attack; Secrecy; Integrity; and Availability; SQL Code Poisoning (or SQL Injection) Attack

Download Full-text

PENGERIAN DAN KOMPONEN SQL MUHAMMAD DENNY PRAYOGA 165100046

10.31219/osf.io/p8uxd ◽

2018 ◽

Author(s):

Muhammad denny prayoga

Keyword(s):

Relational Database ◽

Management System ◽

Database Management ◽

Query Language ◽

Database Management System ◽

Relational Database Management System ◽

Structured Query Language ◽

Relational Database Management

Pengertian SQLSQL (Structured Query Language) adalah sebuah bahasa yang digunakan untuk mengakses data dalam basis data relasional.SQL secara de facto merupakan bahasa standar yang digunakan dalam RDBMS (relational database management system).Saat ini hampir semua server basis data yang ada mendukung bahasa SQL untuk melakukan manajemen datanya.SQL merupakan bahasa baku (ANSI/SQL), non prosedural dan berorientasi himpunan (set oriented language)SQL dapat digunakan baik secara interaktif atau ditempelkan (embedded) pada sebuah program aplikasi.

Download Full-text

CLIPS based decision support system for water distribution networks

Drinking Water Engineering and Science ◽

10.5194/dwes-4-37-2011 ◽

2011 ◽

Vol 4 (1) ◽

pp. 37-50 ◽

Cited By ~ 3

Author(s):

K. Sandeep ◽

K. Rakesh

Keyword(s):

Decision Support ◽

Decision Support System ◽

Support System ◽

Water Distribution ◽

Query Language ◽

Water Distribution Network ◽

Distribution Networks ◽

Database Management System ◽

Geographical Information ◽

Knowledge Generation

Abstract. The difficulty in knowledge representation of a water distribution network (WDN) problem has contributed to the limited use of artificial intelligence (AI) based expert systems (ES) in the management of these networks. This paper presents a design of a Decision Support System (DSS) that facilitates "on-demand'' knowledge generation by utilizing results of simulation runs of a suitably calibrated and validated hydraulic model of an existing aged WDN corresponding to emergent or even hypothetical but likely scenarios. The DSS augments the capability of a conventional expert system by integrating together the hydraulic modelling features with heuristics based knowledge of experts under a common, rules based, expert shell named CLIPS (C Language Integrated Production System). In contrast to previous ES, the knowledge base of the DSS has been designed to be dynamic by superimposing CLIPS on Structured Query Language (SQL). The proposed ES has an inbuilt calibration module that enables calibration of an existing (aged) WDN for the unknown, and unobservable, Hazen-Williams C-values. In addition, the daily run and simulation modules of the proposed ES further enable the CLIPS inference engine to evaluate the network performance for any emergent or suggested test scenarios. An additional feature of the proposed design is that the DSS integrates computational platforms such as MATLAB, open source Geographical Information System (GIS), and a relational database management system (RDBMS) working under the umbrella of the Microsoft Visual Studio based common user interface. The paper also discusses implementation of the proposed framework on a case study and clearly demonstrates the utility of the application as an able aide for effective management of the study network.

Download Full-text

PENGERTIAN DAN KOMPONEN SQL MUHAMMAD DENNY PRAYOGA 165100046

10.31219/osf.io/kj43y ◽

2018 ◽

Author(s):

Muhammad denny prayoga

Keyword(s):

Relational Database ◽

Management System ◽

Database Management ◽

Query Language ◽

Database Management System ◽

Relational Database Management System ◽

Structured Query Language ◽

Relational Database Management

Download Full-text

Decision Support System of Ecological Security in Mining Area

Advanced Materials Research ◽

10.4028/www.scientific.net/amr.361-363.1810 ◽

2011 ◽

Vol 361-363 ◽

pp. 1810-1813

Author(s):

Sai Ming Yang ◽

Wen Guang Lu

Keyword(s):

Decision Support ◽

Decision Support System ◽

Support System ◽

Management System ◽

Mining Area ◽

Database Management System ◽

Geographical Information ◽

Ecological Security ◽

The Sustainable Development ◽

Gps Survey

Ecological security is the basis of the sustainable development. Based on the concept of ecological security, The framework and subsystems’ functions of decision support system for mining area’s ecological security are put forward. The support system, which gets data by methods of remote sensing(RS),geographical information system(GIS),global positioning system(GPS), survey data, statistics data and experiment data, being mainly composed of database management system, knowledge management system and models management system, can make regulating and controlling decision for mining area’s ecological security.

Download Full-text

Designing and Developing a Database Management System for Mosul University by Using Personal Home Page Language My Structured Query Language

Journal of Computational and Theoretical Nanoscience ◽

10.1166/jctn.2019.7994 ◽

2019 ◽

Vol 16 (3) ◽

pp. 1035-1038

Author(s):

Alyaa Ghanim Suliaman ◽

Taef Ghanim Hameed ◽

Sufyan Salim Mahmood Aldabbagh ◽

Khalid Abdulkareem Al-Enezi ◽

Husain Yaser Alsafran

Keyword(s):

Management System ◽

Database Management ◽

Query Language ◽

Home Page ◽

Database Management System ◽

Structured Query Language

Download Full-text

SPATIAL DECISION SUPPORT SYSTEM FOR ZINC CONTENT IN SOIL

International Journal of Information Technology & Decision Making ◽

10.1142/s021962200500174x ◽

2005 ◽

Vol 04 (04) ◽

pp. 567-580 ◽

Cited By ~ 1

Author(s):

DINESH K. SHARMA ◽

RAKESH K. SHARMA ◽

DEBASIS GHOSH

Keyword(s):

Decision Support ◽

Decision Support System ◽

Support System ◽

Management System ◽

Spatial Database ◽

Zinc Content ◽

Software Tool ◽

Database Management System ◽

Spatial Decision Support System ◽

Spatial Decision Support

Spatial decision support systems can enhance the efficiency and effectiveness of decision-making about the zinc status of soil. In this paper, we present an interactive spatial decision support system (ISDSS), identifying the zinc deficiency zone(s), thus enabling the decision-maker to take appropriate measures for correcting zinc deficiencies in soil. The system can display a contour map of the required Block, District, or State of West Bengal along with information about the quantity of zinc to be added to the soil, if the available zinc is not sufficient for a particular crop. The ISDSS consists of a non-spatial database management system and corresponding spatial database, a model base management system, and a user interface. The ISDSS is developed using the scripting language EASI (Engineering Analysis and Scientific Interface) under the GIS software tool, SPANS (Spatial Analysis System). The system runs under the Microsoft Windows operating system.

Download Full-text

Fungsi Date dalam Data Manipulation Language Dengan Bahasa Query Menggunakan SQL Server 2008

INFORMATICS FOR EDUCATORS AND PROFESSIONAL : Journal of Informatics ◽

10.51211/itbi.v4i2.1329 ◽

2020 ◽

Vol 4 (2) ◽

pp. 163

Author(s):

Didik Setiyadi ◽

Henderi Henderi ◽

Rita Wahyuni Arifin

Keyword(s):

Management System ◽

Database Management ◽

Query Language ◽

Database Management System ◽

Sql Server ◽

Data Manipulation ◽

Data Query ◽

Structured Query Language ◽

Search Data ◽

Manipulation Language

Abstrak: Fungsi date dalam melakukan manipulasi data dengan bahasa query merupakan fungsi yang diperuntukkan bagi data, variable atau field yang berkaitan dengan data tanggal dan dapat pula diterapkan untuk data dari tanggal sistem komputer yang sedang aktif. Fungsi tanggal dalam SQL (Structured Query Language) meliputi fungsi DateAdd, DateIff, DatePart, DateName dan GetDate. Data Manipulation Language (DML) merupakan bahasa basis data yang berfungsi untuk melakukan penelusuran data pada suatu basis data didalam DBMS (Database Management System) diantaranya melakukan insert data, delete data, update data dan penelurusan data (query). SQL (Structured Query Language) terdiri dari sintaks sederhana dalam bentuk instruksi-instruksi dalam melakukan manipulasi data, instruksi tersebut sering disebut dengan query. Sedangkan untuk proses query merupakan kemampuan untuk melakukan penelusuran data dari basis data, data yang ditampilkan bisa dari satu atau lebih tabel, dimana kolom-kolom yang dipilih bisa kita tentukan sendiri. Pada penulisan ini akan dibahas tentang bagaimana melakukan operasi query untuk fungsi date dengan menggunakan SQL Server 2008. Langkah awal yang dilakukan adalah dengan mengambil studi kasus database Nilai Mahasiswa yang telah terbentuk diagrammnya beserta isi datanya. Selanjutnya bagaimana melakukan operasi dengan menggunakan fungsi DateAdd, DateIff, DatePart, DateName dan GetDate untuk melakukan penelusuran data dengan menggunakan DBMS SQL Server 2008. Kata Kunci: Fungsi date, DML, Query, Sql Server 2008, Nilai Mahasiswa. Abstract: The date function in manipulating data with the query language is a function that is intended for data, variables or fields relating to date data and can also be applied to data from the date of an active computer system. Date functions in SQL (Structured Query Language) include DateAdd, DateIff, DatePart, DateName and GetDate functions. Data Manipulation Language (DML) is a database language that functions to search data in a database in a DBMS (Database Management System) including inserting data, deleting data, updating data and searching data (query). SQL (Structured Query Language) consists of simple syntax in the form of instructions in manipulating data, these instructions are often called queries. As for the query process, it is the ability to search data from a database, the data displayed can be from one or more tables, where the columns we choose can be determined by us. At this writing will be discussed about how to perform a query operation for the date function using SQL Server 2008. The initial step is to take a case study of the Student Value database that has been formed diagramm along with the contents of the data. Next how to perform operations using the DateAdd, DateIff, DatePart, DateName and GetDate functions to perform data tracing using SQL Server 2008 DBMS. Keywords: Date function, DML, Query, Sql Server 2008, Student Value.

Download Full-text