• Title/Summary/Keyword: Relational Data Model

Search Result 336, Processing Time 0.025 seconds

A Design on Informal Big Data Topic Extraction System Based on Spark Framework (Spark 프레임워크 기반 비정형 빅데이터 토픽 추출 시스템 설계)

  • Park, Kiejin
    • KIPS Transactions on Software and Data Engineering
    • /
    • v.5 no.11
    • /
    • pp.521-526
    • /
    • 2016
  • As on-line informal text data have massive in its volume and have unstructured characteristics in nature, there are limitations in applying traditional relational data model technologies for data storage and data analysis jobs. Moreover, using dynamically generating massive social data, social user's real-time reaction analysis tasks is hard to accomplish. In the paper, to capture easily the semantics of massive and informal on-line documents with unsupervised learning mechanism, we design and implement automatic topic extraction systems according to the mass of the words that consists a document. The input data set to the proposed system are generated first, using N-gram algorithm to build multiple words to capture the meaning of the sentences precisely, and Hadoop and Spark (In-memory distributed computing framework) are adopted to run topic model. In the experiment phases, TB level input data are processed for data preprocessing and proposed topic extraction steps are applied. We conclude that the proposed system shows good performance in extracting meaningful topics in time as the intermediate results come from main memories directly instead of an HDD reading.

A Product Information system for Semantic Web (시맨틱 웹 환경을 위한 상품 정보 시스템)

  • Gong, Gi-Hyun;Lee, Dong-Joo;Lee, Sang-Goo
    • Proceedings of the Korea Database Society Conference
    • /
    • 2008.05a
    • /
    • pp.413-419
    • /
    • 2008
  • Product information system contains information concerning products such as classification, attributes and UOM. Product information system stores their product information to a Relational Database. However, they do not support interoperability between product systems since their database is designed and optimized for their services. We suggest a standard product model and the scenarios of web services based on our model.

  • PDF

Ski-end shape control based on the model in heavy plate mill (후판 압연공정에서의 판 선단부 형상제어 연구)

  • Chun, M.S.;Park, H.D.
    • Proceedings of the Korean Society for Technology of Plasticity Conference
    • /
    • 2007.10a
    • /
    • pp.93-95
    • /
    • 2007
  • Studies on ski-end shape control at the top end of rolling plate in heavy thick plate mill by using FEM analysis and measuring system have been performed. Plate shape behaviour at the top-end on rolling by the two different methods in finishing rolling process has been observed. One is to minimize the height of ski-end by using pass line based on the relational model between shape factor and pick-up and the other one is to prevent turn down problem caused by the impact between table roller and down bended plate on rolling by using roll speed difference. To minimize the height of ski-end, the prediction models based on the FEM analysis and measuring data was developed. The control method of ski - end shape on finishing rolling process was applied in actual mill and the height of ski-end was reduced by about 50% compared with conventional operation.

  • PDF

The Impact of Conflict and Influence Strategies Between Local Korean-Products-Selling Retailers and Wholesalers on Performance in Chinese Electronics Distribution Channels: On Moderating Effects of Relational Quality (중국 가전유통경로에서 한국제품 현지 판매업체와 도매업체간 갈등 및 영향전략이 성과에 미치는 영향: 관계 질의 조절효과)

  • Chun, Dal-Young;Kwon, Joo-Hyung;Lee, Guo-Ming
    • Journal of Distribution Research
    • /
    • v.16 no.3
    • /
    • pp.1-32
    • /
    • 2011
  • I. Introduction: In Chinese electronics industry, the local wholesalers are still dominant but power is rapidly swifting from wholesalers to retailers because in recent foreign big retailers and local mass merchandisers are growing fast. During such transient period, conflicts among channel members emerge important issues. For example, when wholesalers who have more power exercise influence strategies to maintain status, conflicts among manufacturer, wholesaler, and retailer will be intensified. Korean electronics companies in China need differentiated channel strategies by dealing with wholesalers and retailers simultaneously to sell more Korean products in competition with foreign firms. For example, Korean electronics firms should utilize 'guanxi' or relational quality to form long-term relationships with whloesalers instead of power and conflict issues. The major purpose of this study is to investigate the impact of conflict, dependency, and influence strategies between local Korean-products-selling retailers and wholesalers on performance in Chinese electronics distribution channels. In particular, this paper proposes effective distribution strategies for Korean electronics companies in China by analyzing moderating effects of 'Guanxi'. II. Literature Review and Hypotheses: The specific purposes of this study are as follows. First, causes of conflicts between local Korean-products-selling retailers and wholesalers are examined from the perspectives of goal incongruence and role ambiguity and then effects of these causes are found out on perceived conflicts of local retailers. Second, the effects of dependency of local retailers upon wholesalers are investigated on local retailers' perceived conflicts. Third, the effects of non-coercive influence strategies such as information exchange and recommendation and coercive strategies such as threats and legalistic pleas exercised by wholesalers are explored on perceived conflicts by local retailers. Fourth, the effects of level of conflicts perceived by local retailers are verified on local retailers' financial performance and satisfaction. Fifth, moderating effects of relational qualities, say, 'quanxi' between wholesalers and retailers are analyzed on the impact of wholesalers' influence strategies on retailers' performances. Finally, moderating effects of relational qualities are examined on the relationship between conflicts and performance. To accomplish above-mentioned research objectives, Figure 1 and the following research hypotheses are proposed and verified. III. Measurement and Data Analysis: To verify the proposed research model and hypotheses, data were collected from 97 retailers who are selling Korean electronic products located around Central and Southern regions in China. Covariance analysis and moderated regression analysis were employed to validate hypotheses. IV. Conclusion: The following results were drawn using structural equation modeling and hierarchical moderated regression. First, goal incongruence perceived by local retailers significantly affected conflict but role ambiguity did not. Second, consistent with conflict spiral theory, the level of conflict decreased when retailers' dependency increased toward wholesalers. Third, noncoercive influence strategies such as information exchange and recommendation implemented by wholesalers had significant effects on retailers' performance such as sales and satisfaction without conflict. On the other hand, coercive influence strategies such as threat and legalistic plea had insignificant effects on performance in spite of increasing the level of conflict. Fourth, 'guanxi', namely, relational quality between local retailers and wholesalers showed unique effects on performance. In case of noncoercive influence strategies, 'guanxi' did not play a role of moderator. Rather, relational quality and noncoercive influence strategies can serve as independent variables to enhance performance. On the other hand, when 'guanxi' was well built due to mutual trust and commitment, relational quality as a moderator can positively function to improve performance even though hostile, coercive influence strategies were implemented. Fifth, 'guanxi' significantly moderated the effects of conflict on performance. Even if conflict arises, local retailers who form solid relational quality can increase performance by dealing with dysfunctional conflict synergistically compared with low 'quanxi' retailers. In conclusion, this study verified the importance of relational quality via 'quanxi' between local retailers and wholesalers in Chinese electronic industry because relational quality could cross out the adverse effects of coercive influence strategies and conflict on performance.

  • PDF

Development and application of a floor failure depth prediction system based on the WEKA platform

  • Lu, Yao;Bai, Liyang;Chen, Juntao;Tong, Weixin;Jiang, Zhe
    • Geomechanics and Engineering
    • /
    • v.23 no.1
    • /
    • pp.51-59
    • /
    • 2020
  • In this paper, the WEKA platform was used to mine and analyze measured data of floor failure depth and a prediction system of floor failure depth was developed with Java. Based on the standardization and discretization of 35-set measured data of floor failure depth in China, the grey correlation degree analysis on five factors affecting the floor failure depth was carried out. The correlation order from big to small is: mining depth, working face length, floor failure resistance, mining thickness, dip angle of coal seams. Naive Bayes model, neural network model and decision tree model were used for learning and training, and the accuracy of the confusion matrix, detailed accuracy and node error rate were analyzed. Finally, artificial neural network was concluded to be the optimal model. Based on Java language, a prediction system of floor failure depth was developed. With the easy operation in the system, the prediction from measured data and error analyses were performed for nine sets of data. The results show that the WEKA prediction formula has the smallest relative error and the best prediction effect. Besides, the applicability of WEKA prediction formula was analyzed. The results show that WEKA prediction has a better applicability under the coal seam mining depth of 110 m~550 m, dip angle of coal seams of 0°~15° and working face length of 30 m~135 m.

Design and Implementation of XML Based Relational Database Metadata Repository (XML을 기반으로 한 관계형 데이터베이스 메타데이터 리파지토리 설계 및 구현)

  • Gwon, Eun-Jeong;Yong, Hwan-Seung
    • The KIPS Transactions:PartD
    • /
    • v.9D no.1
    • /
    • pp.1-10
    • /
    • 2002
  • Metadata is data about data that is used to mange data itself. As applications based on DBMS are increased, it is suggested that metadata model and metadata interchange model to manage metadata in DBMS. but metadata which is in the form of XML (eXtensible Markup Language) document is generally stored into RDBMS. Therefore In this paper, as for the method to store metadata of RDBMS into OODBMS, we design metadata model, metadata interchange model and implement new repository system. The metadata of RDBMS is translated into in the form of XML Document and integrated into XML Data Server on OODBMS, eXcelon and executes retrieval metadata information about RDBMS by XQL(XML Query Language). So It is possible to searchm edit a metadata. The metadata of XML documents stored in eXcelon is easily made to be printed in web browser by applying a XSL (extensible StyleSheets Language). So we can have a detail information about property of metadata in DBMS.

Investigation on the Side Effects of Denormalizing Corporate Databases

  • Lee, Sang-Won;Kim, Nam-Gyu;Moon, Song-Chun
    • Journal of Information Technology Applications and Management
    • /
    • v.16 no.2
    • /
    • pp.135-150
    • /
    • 2009
  • Corporate databases are usually denormalized, due to the data modelers' impetuous belief that denormalization could improve system performance. By providing a logical insight into denormalization, this paper attempts to prevent every database modeler from falling into the denormalization pit. We indicate loopholes in the denormalization advocates' assertions, and then present four criteria to analyze the usefulness and validity of denormalization; 1) the level of concurrency among transactions, 2) the database independence of the application program, 3) the independence between the logical design and the physical one, and 4) the overhead cost to maintain database integrity under various query patterns. This paper also includes experimental results to evaluate performance of denormalized and fully normalized structures under various workloads.

  • PDF

Analysis of Contract Price in a B2B Automobile Auction

  • Namatame, Takashi;Asahi, Yumi;Motoyoshi, Natsuki;Saito, Yuzo
    • Industrial Engineering and Management Systems
    • /
    • v.8 no.4
    • /
    • pp.201-212
    • /
    • 2009
  • This study analyzed the structure of pricing in the automobile auction market by using real trade data. We focused on the bidding behavior of bidders and the contract price of exhibits. First, we proposed a relational framework among exhibits, number of bidders, and the contract price. Next, we utilized a neural network model to estimate the number of bidders and the contract price. Subsequently, we investigated the relationship between the number of bidders and the contact price, and evaluated our method through an analysis that employed verifying data. Lastly, we listed our suggestions for bidding in auction markets.

Database Structure and Information Exchange System of KEPCO's EMS SYSTEM (한전(韓電)EMS의 데이터베이스 및 정보교환체제(情報交換體制))

  • Lee, Kyung-Jae;Yu, Sung-Chul;Kim, Yeong-Han;Lee, Hyo-Sang
    • Proceedings of the KIEE Conference
    • /
    • 1988.11a
    • /
    • pp.87-91
    • /
    • 1988
  • For the electric power system operation, the information to monitor the operation status of power plants and transmission lines is very important factor in the view point of system security and economic operation. This paper presents the logical and physical structures of database used by KEPCO's EMS. The adopted DataBase Management System (DBMS) of a relational model type offers many advantages such as easy maintenance of database. In addition, this paper briefly introduces the data exchange system between application programs and database.

  • PDF

A Study on Industrial Accident Cases by an Application of Correlation Analysis (상관분석을 응용한 산업재해 사례요인의 고찰)

  • 정국삼;홍광수
    • Journal of the Korean Society of Safety
    • /
    • v.14 no.1
    • /
    • pp.141-149
    • /
    • 1999
  • At present time, industrial accidents statistics are used as the basic data of the policy to prevent industrial accidents and the plan to applicate the industrial accident insurance. But this statistical data is not sufficient for the effective safety management because it is the expression of the itemized distribution and the frequency for the whole cases. This study tried to correlational analysis for each causes by defining investigational items as their accident parameters. The correlational analysis, between the unsafe action and status and their relational causes, was performed to analyze the occurrence causes of industrial accident. And to assume the severity of accident, the correlativity and independency between causes and direct causes which are defined hospital days subordinate parameter were analyzed. In addition, this study expressed numerically the effectiveness of subordinate parameters depended on the level of independent parameter by presenting the predictive model between dependent parameter and independent parameter, which have the categorical parameter, through the Logit analysis method.

  • PDF