This Author published in this journals
All Journal Jurnal Infra
Silvia Rostianingsih
Program Studi Teknik Informatika

Published : 60 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Implementasi ETL dan Perbandingan Performa Column- Oriented Database dan Relational Database sebagai Data Warehouse Aaron Dwi Caesar Oktaviano; Silvia Rostianingsih; Henry Novianus Palit
Jurnal Infra Vol 7, No 1 (2019)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (1016.656 KB)

Abstract

Implementasi Non-Relational Database sebagai DataWarehouse dengan menggunakan Relational Data Warehousesebagai sumber menjadi dasar dalam pengerjaan skripsi ini.Non-Relational dan Relational Database memiliki asumsi yangberbeda dari segi model datanya, sehingga transformasi dariRelational Data Warehouse tidak akan membawa hasil yangmaksimal. Dalam pengerjaan implementasi ini, Non-RelationalDatabase yang akan digunakan bertipe Column-Oriented/Wide-Column Database, yaitu Cassandra. Perbandingan denganRelational Data Warehouse akan dilakukan dari segi latencyquery, memory usage, dan cpu usage.Implementasi ini akan dilakukan dengan membuat terlebihdahulu model data yang sesuai dengan tiap database yangdigunakan, serta dilakukan ETL untuk memasukkan data.Kemudian, akan diujikan 7 query atau permasalahan untukmenjawab kebutuhan reporting perspustakaan UniversitasKristen Petra.Berdasarkan hasil pengujian, didapat beberapa kesimpulan.Pemodelan data untuk Column-Oriented Databasemembutuhkan perhatian lebih, karena kebutuhan pengubahandata dapat mempengaruhi desain dari tabel. ETL juga perluperhatian, karena dengan tidak adanya fungsi commit, makaperlu diulang dari awal jika gagal. Column-Oriented Databasemenunjukkan hasil yang lebih baik pada query dengan kondisiyang banyak, karena data bisa semakin cepat ditemukan dandikembalikan.
Perancangan Dan Pembuatan Website Order Barang Parfumku.net Lucky Kurniawan; Silvia Rostianingsih; Lily Puspa Dewi
Jurnal Infra Vol 3, No 2 (2015)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (562.425 KB)

Abstract

Parfumku.net is an online-based company engaged in the service order and delivery of perfume. Business processes owned by parfumku.net today still use the short message service (SMS) media to serve the order and delivery of perfume. Therefore, parfumku.net want to create a website that facilitates the customer to select and purchase the desired perfume, as well as enable the company to serve existing purchases.Website created a variety of features, in accordance with the access rights owned by the user, the admin or customer. Features - features that are owned by users who have access rights as a customer is a view and buy products, features add to cart, and check the status of perfume features purchased. In addition, the website has an added feature that is the discount for booking a certain number of purchases in the form of a package, specific packages with a special price, and ease to choose the delivery services in accordance with customer wishes. As for the admin, there are a variety of features including to input, edit, and delete products, to check the incoming reservations, and see the existing charts. Design and manufacture of the website is done by using the programming language Hypertext Preprocessor (PHP), Ajax, and JavaScript for the manufacture user interface and functional website, and MySQL for database website. Typing and workmanship websites using notepad ++ software.Based on the questionnaire to 10 respondents which samples were taken randomly from customers parfumku.net. Overall with an average score of 80.28% indicates that the website parfumku.net order goods included in either category.
Pembuatan Sistem Keuangan pada Continuing Education Centre Universitas Kristen Petra Ryan Kick Kassidy; Silvia Rostianingsih; Agustinus Noertjahyana
Jurnal Infra Vol 4, No 2 (2016)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (713.553 KB)

Abstract

Continuing Education Centre is an unit engaged in education services under coordination of Vice Rector Academic Petra Christian University. Continuing Education Centre is qualified for continuing education with variety in their programs. Until now, Continuing Education Centre doesn’t have a system that helps its transaction process so mistakes often made in transaction process. Therefore, in this thesis will be made accounting information system and the estimated expenditure programs, which  help the Continuing Education Centre in processing transactions and records them into useful reports for Continuing Education Centre.The process of making this system starts from analyzing the needs of the company, making the design system using Data Flow Diagram and Entity Relational Diagram. The system is built using the MySQL database and Hypertext Prepocessor (PHP). Scope of the development includes transaction recording, scheduling and estimation, manufacture of Chart of Accounts, manufacture of transaction expenses, as well as the manufacture of journals and reports automatically.  All of these are supported using a VPN server based on Windows 7 OS and website interface.Test result shows the programs are able to assist in processing transactions, forecasting and producing reports which useful for the finance of Continuing Education Centre. According to the questionnaire, it is proven to be able fulfilling the company needs with satisfaction level of 66.66% are pleased and 33.33% are adequate.
Website Pencari Produk Terlaris untuk Membantu Penjualan Pada Toko Online Audrey Setiono; Silvia Rostianingsih; Anita Nathania Purbowo
Jurnal Infra Vol 6, No 2 (2018)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (653.65 KB)

Abstract

Development of technologies become a positive impact for people who want to open new business opportunities by selling their products online. The obstacle is in the selection of products that will be sold, people tend to have a hard time deciding the product that they needed because they don't know what products are on demand in the market. In order to facilitate users who want to know the current best-selling products, website by using Web Scraping method is made as a support to collect information about the best-selling products contained in the marketplace of Tokopedia, Shopee and Bukalapak. The informations include name of the goods, price of the goods, number of products sold, product image and origin of the site. In conclusion, the website can help users finding the best selling products according to the categories selected.
Implementasi Animasi Pada Multimedia Interaktif Michael Chang; Liliana Liliana; Silvia Rostianingsih
Jurnal Infra Vol 3, No 2 (2015)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (271.584 KB)

Abstract

Most  people  do  reading  activities  to  gain knowledge,  as entertainment or a hobby for people to read. From generation to generation,  reading  begins  to  decreases.  Reading  becomes obsolete. Nowadays, reading a book filled with writing would be boring.  Books  preferably  instant  and  interesting  than  a  book filled with long writing and tedious. While in general almost all history  books  are  full  of  writing.  So  this  time  i  will  make  an interactive multimedia that interesting and not boring about the history of the kingdom of Majapahit.In the manufacture of interactive multimedia about the history of Majapahit  i  implemented  several  important  elements  in interactive  multimedia  ie  text,  images,  sounds,  and  animations are  placed  and  adjusted  the  alignment  between  text,  images, sound, and animation. The  menu also made efficiently so that it can move from one topic to another topic. The addition of some visual effects that make interactive multimedia applications about the history of Majapahit becoming more.The apllication was tested to some people to see  if the interactive multimedia  about  the  history  of Majapahit  interesting  or  not. Amounting to 75,52% people said that the interactive multimedia about the history of Majapahit is more interesting rather than the book full of writing.
Pembuatan Sistem Informasi untuk Divisi Marketing PT. Diparanu Rucitra Ignatius Dwihan Prajogo; Silvia Rostianingsih; Alexander Setiawan
Jurnal Infra Vol 6, No 1 (2018)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (547.692 KB)

Abstract

PT. Diparanu Rucitra located at Surabaya, as property developer, all of documents are stored in physical documents, and Microsoft Excel for every work they do. This may causes searching documents very difficult and spend lot of time because still uses manual system, difficult to record all work from marketing division, especially when they held event, looking new customer, sales order, property sales and property payment along with all reports.This application created using HTML5, PHP, Javascript, CSS3, framework PHP and database MySQL. Application interface is created using Bootstrap Template Pooled Admin panel.The final result of this application is make all job more integrated and structural from got new customer, sales order, property sales and property payment along with created/ongoing/ended event for this marketing division at PT. Diparanu Rucitra.
Pembuatan Aplikasi Manajemen Sumber Daya Manusia Berbasis Web pada PT. X Faren Areita Kharisma; Lily Puspa Dewi; Silvia Rostianingsih
Jurnal Infra Vol 7, No 1 (2019)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (294.752 KB)

Abstract

PT. X is a company engaged in the culinary sector. PT. X has 3 outlets and 1 production site. The Department of Human Resources and Development & General Affairs is centered on an outlet which is also the head office in Surabaya. Before application development begins, analysis and design are carried out with data flow diagrams and entity relation diagrams. This application is created using HTML, PHP, JavaScript, MySQL database, and Bootstrap framework languages. The application created includes features of permission requests, sickness, overtime, and leave via the web. In addition the application is made calculation of employee salaries, employee evaluation, recap. The end result of application development is the calculation of employee salaries each month and the calculation costs of PPh 21, making staff evaluation criteria and evaluating staff. As well as making report attendance reports, training reports, administrative reminder for employees who will be retired in the near future. The results of the questionnaire showed that the user's assessment of the application's appearance was 66.66% of respondents answered well and 33.33% of respondents answered very well, the user's assessment of information integration was 66.66% of respondents answered well and 33.33% of respondents answered very well, assessment users of the application feature are 100% of respondents answered well, the user's assessment of the HRD manager's features is 66.66% of respondents answered well and 33.33% of respondents answered very well, the user's assessment of the suitability of performance evaluation features is 100% of respondents answered well, users towards the program report is 100% of respondents answered well, the user's assessment of the application speed is 66.66% of respondents answered well and 3.33% of respondents answered very well, the user's assessment of the ease of use of the application was 66.66% of respondents answered well and 33, 33% of respondents answered very well, the user's assessment of conformity with the problem was 33, 33% of respondents answered enough and 66.66% of respondents answered well, the user's assessment of the overall application was 33.33% of respondents answered well and 66.66% of respondents answered very well.
Pembuatan Aplikasi Sistem Informasi Administrasi dan Pemesanan Online Berbasis Web Pada Travel X Levi Julius Liumanta; Silvia Rostianingsih; Djoni Haryadi Setiabudi
Jurnal Infra Vol 4, No 2 (2016)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (807.667 KB)

Abstract

Administration system in Travel X still using manually all of the business process likely record a reservation in a document. With that condition  make Travel X need more time to get information, generating report and high risk to lost document. Therefore, Travel X needed system to accomodate administration quickly and preciesly. According to the analysis based on Travel X problems, an application to support the Travel X business performance must be made.The application would be implemented to process the passanger reservation, package reservation, online reservation and also generating report. The design of the Data Flow Diagram and the ERD uses Power Designer 16.5 The application will be based on CodeIgniter Framework and MySQL for the database.User satisfaction towards the application’s overall quality is 42% good responds and 28% very good responds which means the application has fulfilled and corresponds to the system requirements. This application can  records process by automate passanger reservation or online reservation.
PEMBUATAN APLIKASI SISTEM INFORMASI AKUNTANSI PADA PT. SARANA AGUNG SEJAHTERA William Onnyxiforus Purnomo; Silvia Rostianingsih; Christian Christian
Jurnal Infra Vol 4, No 1 (2016)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (773.406 KB)

Abstract

PT. Sarana Agung Sejahtera is a company that sold AC sparepart and AC service. This company wish to develop a new system, because had a difficulty in dealing with administrative issues because its operation is still manual, e.g. the sale and purchase transactions, preparing reports and other expenditures problem. Thus allow for errors in the calculation of sales and purchases and this can be troublesome if carried every day.Based on the problem faced by PT. Sarana Agung Sejahtera, application is made to support them. The application can process purchasing, sales order, selling, stock opname, debit and credit payment. To design the DFD of the new applications Microsoft Visio was used, and ERD application use Power Designer 15.3. This application was made using Code Igniter Framework and PostgreSQL as the database storage.The result of the application showed that this application can take notes of purchasing transactions and sales can be done according to the structure and computerize and also complemented with stock card using First In First Out (FIFO) method. Otherwise, with this application, owner can know some reports, e.g. stock card, general journal, purchasing journal, sales journal, stock position report, service report, employees report, customer reminder report, balance sheet, and income statement. This program help the transaction process with backdate feature which allows owner insert the transactions from the past time.
Pembuatan Website Wisata Pulau Madura Kenny Jonathan Wijaya; Silvia Rostianingsih
Jurnal Infra Vol 5, No 1 (2017)
Publisher : Jurnal Infra

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (465.381 KB)

Abstract

Media for promotion is necessary to attract the attention of the public and tourists to come and visit island of Madura, Website is media that can be used to assist the promotion or publication with information that introduces attractions with easy access. This thesis will be made web-based application that utilizes MySQL, jQuery, JavaScript, YouTube iFrame API and the Google API with the programming language used is PHP. As well as making a video using Adobe Premiere Pro CS6 and Adobe After Effects Pro CS6 displayed on the page can be viewed by visitors.In this website, visitors can browse news, events, articles, gallery, destinations, and accommodation. Not only that, visitors can searching for destination through a search bar and a map using Google Map API and use rating and review on destinations. Visitors can also make requests to add destinations, news, events, articles, and accommodation.The test results indicate that the website created using MySQL, jQuery, JavaScript, YouTube iFrame API and the Google Map API can run well in Chrome, Firefox, and Safari browser. Geolocation function with Google Map API that used for map direction and nearest location cannot be used effectively when user use Chrome version 50. The results of questionnaires that obtained from 12 respondents concluded the percentage of overall application, design, navigation, and facilities provided on website with the percentage 25% for 5 points, 58.3% for 4 points, and 16.7% for 3 points with maximum 5 points.
Co-Authors Aaron Dwi Caesar Oktaviano Adi Wibowo Agustinus Noertjahyana Albert Kristian Dupa Alexander Christofer Liem Alexander Setiawan Alexandro Yamin Suwito Alvin Ferdinandus Alvin Nathaniel Santoso Andreanus Agung Andreas Handojo Andri Hermawan Sukasto Andryanto Hartono Andy Setiabudi Anita Nathania Purbowo Audrey Setiono Bill Roger Abel Billy Indrawan Bobby Alexandro Arifianto Cenius Sanjaya Christian Christian Christian Purnama Cindy Chandiarie Dandy Dhammatha Budi Rungkat Darmawan Hadiprasetyo David Gunawan David Tanujaya Davin Ardian Tansil Dedy Triyono Djoni Haryadi Setiabudi Eric Jonathan Riyanto Evan J Tanjaya Faren Areita Kharisma Fenycia Noviani Tjhandra Frederick Alexander Tedjokumolo Glenn Ferio Fernanto Gregorius Satia Budhi Hendy Thomas Herman Henry Novianus Palit Ignatius Dwihan Prajogo Irawan Hady Jennifer Giovanni Sumargo Justinus Andjarwirawan Justinus Andjarwirawan Justius Andjarwirawan Kartika Gunadi Kenny Jonathan Wijaya Kevin Kevin Kristiardy Hansel Guntoro Kristo Radion Purba Kurniawan Santoso Leo Willyanto Santoso Levi Julius Liumanta Lie Verry Erwan Liliana - Liliana Liliana Lily Puspa Dewi Lois Christian Lucky Kurniawan Machael Cahyadi Maximillian Jodjana Michael Chang Michael Perkasa Monica Cindy Nararindra Inggitasukma Nathania Limarsono Novia Melinda Sungguh Odwin Viator Hartedja Patric Avidjaja Roseli Patricia Tanjaya Paula Ayu Astelia Rolly Intan Rudy Adipranata Ryan Kick Kassidy Saarce Elsye Hatane Stefanus Ericko Stephanus Tantiono Steven Suteja Timotius Alvin Tanuseputero Tjio Roy Abrianto Suciono Tommy Mandala Suherman Victor Julian Lipesik Vincent Chiptodjojo William Onnyxiforus Purnomo Yulia - Yulia Yulia Yvonne Nathania