a Schema Extraction of Document-Oriented Database for Data Warehouse

The data warehouse is a very famous solution for analyzing business data from heterogeneous sources. Unfortunately, a data warehouse only can analyze structured data. Whereas, nowadays, thanks to the popularity of social media and the ease of creating data on the web, we are experiencing a flood of unstructured data. Therefore, we need an approach that can "structure" the unstructured data into structured data that can be processed by the data warehouse. To do this, we propose a schema extraction approach using Google Cloud Platform that will create a schema from unstructured data. Based on our experiment, our approach successfully produces a schema from unstructured data. To the best of our knowledge, we are the first in using Google Cloud Platform for extracting a schema. We also prove that our approach helps the database developer to understand the unstructured data better.

MENINGKATKAN PEMANFAATAN PASAR DIGITAL UNTUK EKSPOR PRODUK UMKM DI JAWA TIMUR

ABSTRAKSektor usaha mikro, kecil dan menengah (UMKM) memiliki peran yang sangat penting dalam membangkitkan perekonomian di daerah, tidak terkecuali Jawa Timur. Kontribusi UMKM dalam peningkatan perekonomian provinsi Jawa Timur merupakan yang terbesar dibandingkan sektor lainnya. Gubernur Jawa Timur Khofifah Indar Parawansa pada acara Briliant Preneur 2021 bahwa kontribusi UMKM terhadap produk domestik regional bruto (PDRB) di Jawa Timur bahkan mencapai 57,25 persen. Agar pasar UMKM dapat lebih luas hingga ke luar negeri, maka pelatihan ekspor kepada para pelaku UMKM di Jawa Timur perlu diadakan. Kegiatan “Workshop Peluang Ekspor UMKM Melalui Pasar Digital” dilakukan untuk memfasilitasi para pelaku UMKM dalam memulai ekspor produk mereka. Kegiatan yang ini diikuti kurang lebih 50 perwakilan UMKM di Jawa Timur ini terdiri dari 3 tahap kegiatan, tahap persiapan, tahap pelaksanaan, dan tahap monitoring evaluasi. Pada tahap persiapan, panitia melakukan koordinasi internal juga memberikan lembar untuk diisi dengan data usaha pelaku UMKM. Pada tahap pelaksanaan, workshop dilakukan melalui dua (2) sesi. Sesi pertama merupakan pemberian materi terkait pemanfaatan pasar digital untuk ekspor produk-produk UMKM Jawa Timur. Pada sesi kedua, para peserta dapat langsung melakukan praktek atas materi yang diberikan, dan dapat melaporkan hasilnya. Monitoring dan evaluasi pelaksanaan dilakukan dengan mengisi lembar evaluasi kegiatan, baik yang dilakukan oleh narasumber terhadap pelaksanaan acara maupun para pelaku UMKM terhadap pelaksanaan acara. Seluruh peserta workshop dapat mengikuti dengan baik walaupun ada beberapa kendala saat sesi praktek seperti banyaknya penggunaan bahasa asing dalam praktek pembuatan akun website e-commerce maupun pembuatan deskripsi produk. Kata kunci: ekspor; pasar digital; UMKM. ABSTRACTThe micro, small and medium enterprise (MSMEs) sector has a very important role in generating the economy in the region. East Java is no exception. The contribution of MSMEs in improving the economy of East Java province is the largest compared to other sectors. East Java Governor Khofifah Indar Parawansa at the Briliant Preneur 2021 event that the contribution of MSMEs to gross regional domestic product (GRDP) in East Java even reached 57.25 percent. So that the MSME market can be wider overseas, then export training for MSME actors in East Java needs to be held. The activity "Workshop on MSME Export Opportunities Through Digital Markets" was carried out to facilitate MSMEs players in exporting their products. This activity, attended by approximately 50 representatives of MSMEs in East Java, consisted of 3 stages of activity, the preparation stage, the implementation stage, and the evaluation monitoring stage. The committee carried out internal coordination at the preparation stage and provided a sheet filled with business data for MSME actors. The workshop was conducted in two (2) sessions at the implementation stage. The first session was the provision of material related to the use of the digital market to export East Java MSME products. In the second session, the participants could immediately practice the provided material and report the results. Monitoring and evaluation of implementation are carried out by filling out activity evaluation sheets, both those carried out by resource persons on the implementation of the event and MSME actors on the implementation of the event. All workshop participants were able to follow well. However, there were several obstacles during the practice session, such as using foreign languages to create e-commerce website accounts and making product descriptions. Keywords: exports; digital market; MSMEs.

FENOMENOLOGI APLIKASI TIKTOK BAGI USAHA ONLINE MARICA FARMS

The TikTok phenomenon has become a widespread phenomenon throughout the world. The TikTok application is now a trend as well as evidence of technological developments that help humans carry out their activities. Not only as a medium for self-existence but also used by online business actors, one of which is Marica Farms. This study aims to describe the phenomenology of the TikTok application for Marica Farms' online business. Marica Farms is an online animal sacrifice business that uses the TikTok application to help market its products. Using a phenomenological approach, the researcher finds out the meaning of the TikTok application for Marica Farms' online business. Equipped with Uses and Gratification Theory which helps researchers in analyzing the phenomenon of the TikTok application for Marica Farms online business. Data were collected using in-depth interviews with the owners of Marica Farms. The results of this study are the phenomenology of the TikTok application for Marica Farms' online business, namely as a medium that makes it easier for online businesses to have things out of the box, reach a broad market and help increase knowledge and awareness of Marica Farms' online business. The content provided by TikTok Marica Farms has also been adapted to the needs of its audience, such as information and entertainment needs so that the audience feels satisfied.

Conversational interfaces for unconventional access to business relational data structures

PurposeCurrent possibilities of accessing business data by regular users usually involve complicated user interfaces or require technical expertise. This results in situations when business owners are separated from their data. The aim of this research is to apply an innovative approach leveraging conversational interfaces to tackle this problem.Design/methodology/approachThe authors examine the current possibilities of accessing business data by business, users with an emphasis on conversational interfaces employing a chatbot as an alternative to traditional approaches. The authors propose a new concept relying on a guided conversation, and through experiments with a real chatbot and database, the authors demonstrate the benefits of the proposed approach.FindingsThe authors found out that the key to the success of our approach is a decomposition of complex database queries and their incremental construction in conversations. This also enables natural discovery of the domain model through constantly provided feedback. Based on the experiments with a real chatbot, the authors demonstrate that defining conversation flows and maintaining the conversation context is a crucial aspect contributing to the overall accuracy, together with keeping the conversation within the defined limits in its certain parts.Originality/valueThe authors present a novel approach using natural language interfaces for accessing data by business users. In contrast to existing approaches, the authors emphasize incremental construction of queries, predefined conversation flows and constraining the conversations, when necessary.

ANALYSIS OF CUSTOMER BEHAVIOR USING THE APRIORI METHOD

Data is a very valuable asset because it is able to provide accurate, easy and fast information. This study processes coffee shop business data in the city of Padang to determine how customers behave in choosing menus. From the results of data processing. Researchers processed the data using the a priori method. From the results of data processing at a support value of 15%, it is found that the majority of customers still buy menus in units.

Cultural Dynamism and Business Vitality in Medium-Sized Cities—Evidence and Proposals for Sustainable Development

This work uses tools recently designed to conduct analyses and proposals around the cultural development of medium-sized cities. The Cultural and Creative Cities Monitor model, or CCCM, is first applied to the 81 cities in Spain with between 50,000 and 100,000 inhabitants. We also refer to the UNESCO Culture/2030 Indicators, specifically indicator 8 (Cultural companies), to investigate whether cultural dynamism is related to business vitality in those cities. Our observation of the 29 CCCM indicators and the C3 index, which synthesizes cultural performance, is explained, and these data are complemented with cultural business data (on assets, benefits, and jobs) from a sample of 13,204 firms. The C3 index values reveal significant differences in the cultural and creative performance of the selected cities according to their location (metropolitan or non-metropolitan) and their administrative rank. Moreover, when comparing the C3 index with the indicators on business activity, evidence indicates a clear positive relationship between cultural dynamism and firm vitality. These results support the contribution of culture to the sustainable development of medium-sized Spanish cities and further establish the suitability of the tools used to assist cities in designing appropriate cultural policies.

INFORMATION SYSTEM OF CONSTRUCTION SERVICE WEB BASED ON PAPUA GAPEKSINDO ASSOCIATION

Information technology is currently growing rapidly. Computers as information technology tools play an important role in solving data processing problems. Therefore, many companies are using information technology to improve enterprise data management. One of them is GAPEKSINDO Association. It is the organization of companies in construction services. In collecting data and processing business entity data, the companies will apply for Business Certificate, Gapeksindo Association in Papua have the problems, they are data collection and data processing is still using Excel. The weakness use Excel is the data storage can be accidentally deleted and search data will take a long time. Based on the problems above, information system is needed to support Papua Gapeksindo Association in collecting data and processing business data. It can provide convenience in collecting data and processing business data, ensuring security in storing data and it will be stored in database. This information system based on web by using the Unified Modeling Language (UML) design method. The development method using the Waterfall method and the testing method using Black Box.