{"title":"使用彩色petri网为并发用户建模数据库服务器规模","authors":"N. Gaur, Padmaja Joshi, Rajeev Srivastava","doi":"10.1109/CSCITA.2017.8066530","DOIUrl":null,"url":null,"abstract":"Architecture of database servers is one of the important parameters in the performance of web applications. In this paper, a model is proposed for guiding Postgre SQL database server sizing for concurrent users. Coloured Petri-nets are chosen to represent the model that brings out need to change the deployment architecture when the current architecture may not suffice. The focus of the proposed model is mainly on identifying how the increase in number of concurrent users and type of query affects the performance of the database server. The model is based on the experience as well as experimentation. The model is demonstrated in PlPE-2 using different scenarios. The paper also covers analysis of the proposed model.","PeriodicalId":299147,"journal":{"name":"2017 2nd International Conference on Communication Systems, Computing and IT Applications (CSCITA)","volume":"5 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2017-04-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Modelling database server sizing for concurrent users using coloured Petri-nets\",\"authors\":\"N. Gaur, Padmaja Joshi, Rajeev Srivastava\",\"doi\":\"10.1109/CSCITA.2017.8066530\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Architecture of database servers is one of the important parameters in the performance of web applications. In this paper, a model is proposed for guiding Postgre SQL database server sizing for concurrent users. Coloured Petri-nets are chosen to represent the model that brings out need to change the deployment architecture when the current architecture may not suffice. The focus of the proposed model is mainly on identifying how the increase in number of concurrent users and type of query affects the performance of the database server. The model is based on the experience as well as experimentation. The model is demonstrated in PlPE-2 using different scenarios. The paper also covers analysis of the proposed model.\",\"PeriodicalId\":299147,\"journal\":{\"name\":\"2017 2nd International Conference on Communication Systems, Computing and IT Applications (CSCITA)\",\"volume\":\"5 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2017-04-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2017 2nd International Conference on Communication Systems, Computing and IT Applications (CSCITA)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/CSCITA.2017.8066530\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2017 2nd International Conference on Communication Systems, Computing and IT Applications (CSCITA)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/CSCITA.2017.8066530","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Modelling database server sizing for concurrent users using coloured Petri-nets
Architecture of database servers is one of the important parameters in the performance of web applications. In this paper, a model is proposed for guiding Postgre SQL database server sizing for concurrent users. Coloured Petri-nets are chosen to represent the model that brings out need to change the deployment architecture when the current architecture may not suffice. The focus of the proposed model is mainly on identifying how the increase in number of concurrent users and type of query affects the performance of the database server. The model is based on the experience as well as experimentation. The model is demonstrated in PlPE-2 using different scenarios. The paper also covers analysis of the proposed model.