Construction of Online Reading Corpus Based on SQL Server Database Management System

RANCANG ULANG APLIKASI PENGARSIPAN SIDOL (SISTEM INFORMASI DOKUMEN LEGAL) PADA PT BUKAKA TEKNIK UTAMA

Jurnal Ilmiah Informatika Komputer ◽

10.35760/ik.2018.v23i1.2068 ◽

2018 ◽

Vol 23 (1) ◽

pp. 66-79

Author(s):

Condro Wibawa ◽

Dessy Tri Anggraeni

Keyword(s):

Management System ◽

Database Management ◽

Database Management System ◽

Sql Server ◽

E Mail ◽

Design Construction

PT Bukaka Teknik Utama adalah perusahaan yang bergerak di bidang engineering, konstruksi, dan manufaktur. Dalam operasional usaha, diperlukan berbagai izin seperti izin usaha dan izin proyek yang merupakan bagian dari Dokumen Legal. Saat ini informasi Dokumen Legal di PT Bukaka Teknik Utama dikelola dalam aplikasi desktop yang bernama SIDOL (Sistem Informasi Dokumen Legal). Aplikasi juga digunakan untuk memonitoring masa berlaku dokumen. Namun begitu, aplikasi ini memiliki beberapa kekurangan, diantaranya adalah hanya dapat diakses oleh komputer yang terpasang aplikasi tersebut, hanya dapat diakses dari jaringan lokal (LAN), dan sistem notifikasi yang hanya dapat dilihat saat pengguna membuka aplikasi. Untuk mengatasi kekurangan tersebut, akan dilakukan perancangan ulang aplikasi sehingga mampu menjawab kekurangan yang ada. Pembuatan aplikasi menggunakan metode prototipe. Metode ini memiliki lima tahapan pengembangan yaitu communication, quick plan, modeling quick design, construction of prototype, and deployment delivery and feedback. Aplikasi dibangun menggunakan bahasa pemrograman HTML untuk tampilan, PHP untuk pengolahan data di sisi server, CSS untuk page styling, Code Igniter sebagai framework, dan Micsosoft SQL Server sebagai Database Management System. Hasil akhir aplikasi adalah menyediakan aplikasi yang dapat diakses semua karyawan yang membutuhlkan informasi Dokumen Legal serta memberikan notifikasi melalui e-mail ketika terdapat dokumen yang masa berlakunya akan segera berakhir.

Download Full-text

Concurrency Control in Database Management System

European Journal of Electrical Engineering and Computer Science ◽

10.24018/ejece.2021.5.4.352 ◽

2021 ◽

Vol 5 (4) ◽

pp. 76-79

Author(s):

Thi Ngoc Thanh Nguyen

Keyword(s):

Concurrency Control ◽

Management System ◽

Database Management ◽

Database Management System ◽

Sql Server ◽

Software Systems ◽

Application Software

Nowadays, most application software systems are aimed at multi-user environments and simultaneous access to the same database. Therefore, concurrency controllers are an integral part of any database management system. The concurrency controller plays an important role in controlling transactions which perform simultaneous access to the database without conflict. This paper presents an overview and illustration how to use concurrency control in database management system of Microsoft SQL Server.

Download Full-text

Design and realization of rock salt gas storage database management system based on SQL Server

Petroleum ◽

10.1016/j.petlm.2017.10.001 ◽

2018 ◽

Vol 4 (4) ◽

pp. 466-472 ◽

Cited By ~ 1

Author(s):

Yingjie Wang ◽

Jianjun Liu ◽

Xiang He ◽

Bing Wang

Keyword(s):

Rock Salt ◽

Management System ◽

Database Management ◽

Gas Storage ◽

Database Management System ◽

Sql Server

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

Research on Management Information System of University Archives Based on B/S Mode

Applied Mechanics and Materials ◽

10.4028/www.scientific.net/amm.651-653.2485 ◽

2014 ◽

Vol 651-653 ◽

pp. 2485-2489

Author(s):

Guang Yi Chen ◽

Chang Yi Chen

Keyword(s):

Information Visualization ◽

Database Management ◽

High Reliability ◽

Database Management System ◽

Frame Structure ◽

Sql Server ◽

Management Technology ◽

University Archives ◽

Sql Server Database ◽

Development Technology

By using.NET and SQL Server database management technology, anf this paper adopts B/S frame structure, innovatively designs the archives of Colleges and universities with database management system by C#.NET development technology. The association archives information data mining and improves the efficiency of archives management and inquiry statistics. The system uses MD5 encryption to encrypt user login system. The file can be printed information visualization, and the system can decently uses the internal operation of efficient. A detailed understanding of the different student user operation is convenient for the latter system, which can be used to update maintenance, accurate positioning system fault, which has high reliability, high security, scalability, easy expansibility and reusability.

Download Full-text

Cardiological Database Management System as a Mediator to Clinical Decision Support

Methods of Information in Medicine ◽

10.1055/s-0038-1634632 ◽

1996 ◽

Vol 35 (01) ◽

pp. 52-58 ◽

Cited By ~ 3

Author(s):

A. Mavromatis ◽

N. Maglaveras ◽

A. Tsikotis ◽

G. Pangalos ◽

V. Ambrosiadou ◽

...

Keyword(s):

Management System ◽

Database Management ◽

Medical Information ◽

Object Oriented ◽

Medical Personnel ◽

Database Management System ◽

Ease Of Use ◽

Medical Database ◽

Analysis And Design ◽

Object Oriented Design

AbstractAn object-oriented medical database management system is presented for a typical cardiologic center, facilitating epidemiological trials. Object-oriented analysis and design were used for the system design, offering advantages for the integrity and extendibility of medical information systems. The system was developed using object-oriented design and programming methodology, the C++ language and the Borland Paradox Relational Data Base Management System on an MS-Windows NT environment. Particular attention was paid to system compatibility, portability, the ease of use, and the suitable design of the patient record so as to support the decisions of medical personnel in cardiovascular centers. The system was designed to accept complex, heterogeneous, distributed data in various formats and from different kinds of examinations such as Holter, Doppler and electrocardiography.

Download Full-text