Análisis Comparativo entre los RDBMS Ligeros SQLITE Y SQL Server Compact en Windows Phone para el sistema de facturación del Hotel los Lirios.

Abstract

Today, at the hotel "Los Lirios" arise needs daily in the process of billing and order management, the inconvenience generated by the waste of time and discomfort to the client as they do not have a computer system that automates these processes, which are performed manually giving the possibility generating errors when registering the detail by way of accommodation and room services. For this reason, the Hotel want to implement a billing system and a module for order management as an mobile application to provide better service. This research includes a comparative analysis of the efficiency in the use of hardware resources (CPU time, CPU processing units, RAM and storage, defined as parameters for comparison) between light RDBMS SQLite and SQL Server Compact on Windows Phone; the RDBMS that uses less these resources will be the most efficient and the mobile module for order management billing system will be implemented. The experiment was designed to create the prototype testing each light RDBMS operations such as Insert, Update, Delete, Select for measuring the performance of each prototype, through the analysis tool Profiling Tools IDE Visual Studio development 2013 data was collected using SPSS software and statistical methods were used in the information obtained with a significance level of 95% and a margin of error of 5% was processed; thus it was found that if there is significant difference between the samples of the data as presented SQLite percent better efficiency with respect to 96.09 SQL Server Compact with 60.95. Therefore as a result of research SQLite it is more efficient than SQL Server Compact in the consumption of these resources. Through agile methodology SCRUM proceeded to develop the billing system hotel "Los Lirios” and mobile module for order management. It was possible with this software meet the needs presented by the hotel, thus improving the quality of service and customer satisfaction.