Perancangan perangat lunak perhitungan dan pemograman database optimasi proses pemesinan

Perkembangan teknologi CIM (Computer Integrated Manufacturing) memaksa perusahaan manufaktur untuk meningkatkan kebijaksanaan strategi kompetisinya dengan fleksibelitas dan optimasi proses pemesinan untuk tetap mampu bersaing dalam pasar dan konsumen yang berubah-ubah. Perhitungan waktu dan biaya produksi haruslah dapat meningkatkan efektifitas kerja dan optimasi proses pemesinan. Tujuan dari penulisan jurnal ini adalah membuat suatu perangkat lunak dan pemograman database yang dapat melakukan perhitungan waktu, biaya produksi secara otomatis dan tersedianya database yang terintegrasi dengan menggunakan bahasa pemrograman Visual Basic 6.O. Sistem kerja dari database elektronik yang tergabung dalam Database Management System (DBMS) ini meliputi hampir seluruh langkah proses, input data, penyimpanan data, verifikasi data dan perhitungan optimasi proses pemesinan. Penggunaan perangkat Iunak ini menunjukan ketelitian, kemudahan pemanggilan dan penyimpanan data, edit data, dan efisiensi waktu perhitungan biaya dan waktu produksi proses pemesinan secara keseluruhan tanpa harus menggunakan tenaga ahli.

Download Full-text

A Grammar Driven Data Translation System for Computer Integrated Manufacturing

Journal of Mechanical Design ◽

10.1115/1.1434268 ◽

1999 ◽

Vol 124 (1) ◽

pp. 136-142 ◽

Cited By ~ 2

Author(s):

Glen L. Niebur ◽

Thomas R. Chase

Keyword(s):

Data Sharing ◽

Management System ◽

Database Management ◽

Query Language ◽

Database Management System ◽

Computer Integrated Manufacturing ◽

Translation System ◽

Integrated Manufacturing ◽

Application Data ◽

Data Files

The ability to share data among the numerous software applications used to design and analyze products is an important aspect of computer integrated manufacturing. In the past, data sharing has been implemented by direct translation of data files, through neutral data formats, and through central shared databases. This paper describes a data sharing architecture that addresses some of the limitations of these systems. It employs a database management system as a central repository for part data in an application independent format. A configurable translator, called Datatrans, is used to transfer data between the database management system and native application data files. In this way software from multiple independent vendors or legacy software can be supported, because applications need not incorporate code specific to any database management system nor have knowledge of the centralized database schema. The translator uses grammars to define and recognize the data to be translated. The grammar is augmented with commands that are passed to the front-end of the database management system or to application programs to store and retrieve data. Thus the query language and the application commands serve as a high level interface to the underlying database and application data files. Entity transformations that are beyond the scope of a grammatical description are performed by database methods, which are available to all applications. An implementation of the system demonstrates the feasibility of this approach.

Download Full-text

Aplikasi Pengukuran Berat dan Tinggi Badan Anak Balita Menggunakan Metode Radbms Berbasis Python

JTEIN: Jurnal Teknik Elektro Indonesia ◽

10.24036/jtein.v2i1.130 ◽

2021 ◽

Vol 2 (1) ◽

pp. 71-79

Author(s):

Juli Sardi ◽

Hamdani Hamdani ◽

Vito Basjika Pramuja

Keyword(s):

Management System ◽

Database Management ◽

Input Data ◽

Database Management System ◽

Active Database

Penelitian ini merupakan pembuatan aplikasi pengukuran berat dan tinggi badan anak balita menggunakan metode realtime active database management system (RADBMS) berbasis python. Yang mana tujuan dari penelitian ini adalah merancang dan membuat aplikasi pengukuran berat dan tinggi bada anak balita yang dapat menyimpan database-nya dengan aman menggunakan metode realtime active dattabase management system. Perancangan dan pembuatan aplikasi pengukuran berat dan tinggi balita ini dibuat dengan python sebagai bahasa pemrograman untuk membuat aplikasi-nya dan MySQL sebagai database-nya. Dengan menggunakan metode realtime active database management system, pengguna aplikasi ini dapat menggunakan database yang tersimpan untuk digunakan kembali menampilkan grafik pertumbuhan balita. Dan database yang tersimpan dalam bentuk softcopy dalam bentuk database bisa dicetak menjadi hardcopy dengan mengkonversi menjadi file berekstensi .xlsx dan diprint setelahnya. Setelah dilakukan pengujian aplikasi yang dapat digunakan dengan baik mulai dari keamanan login interfacenya, biodata yang disimpan saat melakukan input data pada input data interface, dan saat melakukan pengukuran pada measurement interface.

Download Full-text

Development of Case Database of Fixtures Based on SolidWorks

Key Engineering Materials ◽

10.4028/www.scientific.net/kem.426-427.289 ◽

2010 ◽

Vol 426-427 ◽

pp. 289-293

Author(s):

J. Lin ◽

Guang Yu Tan ◽

B.C. Liu ◽

Yi Ming Rong

Keyword(s):

Management System ◽

Database Management ◽

Visual Basic ◽

Search Display ◽

Database Management System ◽

Secondary Development ◽

System Management ◽

Actual Situation ◽

Simple Operation

This work employs Visual Basic and Access to develop a case database management system for flexible fixtures using coding technology and parameter driving technology. The database management system of fixtures’ cases is built. The secondary development of SolidWorks is performed by VB 6.0, and the system is transplanted to SolidWorks. The system can realize the fixtures’ auto coding, storage, search, display and system management with simple operation and convenient maintenance. The system has a large flexibility as the case database can be expanded and the fixtures’ parameters can be modified according to actual situation of enterprise without limitations of the software.

Download Full-text

Rancangan Sistem Informasi Berbasis Web Untuk Mengatasi Perbaikan Mesin Menggunakan Group Tecnologhy

JAMI: Jurnal Ahli Muda Indonesia ◽

10.46510/jami.v1i2.30 ◽

2020 ◽

Vol 1 (2) ◽

pp. 53-61

Author(s):

Ahmad Farhan ◽

Yeni Sumantri ◽

Purnama Budi Santoso

Keyword(s):

Management System ◽

Database Management ◽

Industrial Revolution ◽

Group Technology ◽

Query Language ◽

Visual Basic ◽

Database System ◽

Database Management System ◽

Structured Query Language ◽

Visual Basic For Application

Abstrak Objektif. Dunia memasuki revolusi industri 4.0 yang ditandai dengan era digitalisasi. Digitalisasi juga merambah ke ilmu perawatan mesin, salah satunya adalah dalam hal troubleshooting (TS). TS adalah serangkaian tindakan yang diperlukan untuk menangani kerusakan yang terjadi pada mesin. Permasalahan yang sering timbul pada TS adalah: teknisi belum tentu ada dilokasi setiap saat, buku manual TS suatu mesin masih berupa buku cetak yang berisiko : buku hilang, buku keselip, dan letak buku jauh dari lokasi kerusakan mesin. Riset ini berusaha mengatasi permasalahan ini dengan cara mengembangkan aplikasi yang disebut Sistem Informasi Troubleshooting Mesin Produksi (SITMEP). Metode. Metode penelitian untuk membuat SITMEP dikembangkan dengan cara mengintegrasikan beberapa ilmu seperti: Group Technology (GT) untuk membantu merancang arsitektur database SITMEP, database relasional untuk membangun sistem database SITMEP, dan bahasa Structured Query Language (SQL) untuk mempercepat pencarian cara TS yang tepat. Hasil. Sebagai hasil penelitian adalah arsitekstur SITMEP dalam bentuk Entity Relation Diagram (ERD). Atas dasar ERD ini dapat dikembangkan menjadi sistem basis data SITMEP. Selanjutnya dikembangkan statmen SQL untuk mempermudah proses pencarian TS komponen yang rusak. Dengan menggunakan database management system (DBMS) dan Ms.Access 2016. Kesimpulan. SITMEP dapat di tempatkan di website perusahaan yang menggunakannya. Aplikasi SITMEP diletakkan di web agar dapat diakses oleh siapa saja, kapan saja, dan dimana saja. Tools yang digunakan adalah Microsoft Acces beserta Visual Basic for Application (VBA) adapun langkah selanjutnya aplikasi dapat digunakan dan dikembangkan di banyak mesin industri. Abstrack Objective. The world entered the 4.0 industrial revolution marked by the era of digitalization. Digitalisation also extends to the science of machine maintenance, one of which is in terms of troubleshooting (TS). TS is a series of actions needed to deal with damage that occurs in the engine. Problems that often arise in the TS are: technicians are not necessarily in the location all the time, the TS manual of a machine is still a printed book at risk: books are missing, books are slipped, and the books are far from the location of damage to the machine. This research seeks to overcome this problem by developing an application called the Production Machine Troubleshooting Information System (SITMEP). Methods. The research method to create SITMEP was developed by integrating a number of sciences such as: Group Technology (GT) to help design the SITMEP database architecture, relational databases to build a SITMEP database system, and Structured Query Language (SQL) language to speed up the search for the right TS method. Results. As a result of the research is the architecture of SITMEP in the form of Entity Relations Diagram (ERD). On the basis of this ERD it can be developed into a SITMEP database system. Then the SQL statement was developed to simplify the process of finding TS damaged components. By using a database management system (DBMS) and Ms.Access 2016. Conclusion. SITMEP can be placed on the website of the company that uses it. The SITMEP application is placed on the web so that it can be accessed by anyone, anytime, and anywhere. The tools used are Microsoft Access along with Visual Basic for Application (VBA). As for the next step, the application can be used and developed in many industrial machines.

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