International Journal of Computer Science & Network Security

International Journal of Computer Science & Network Security (국제컴퓨터통신보호논문지학회)
권호 표지
DOI QR코드

DOI QR Code

EFFICIENT OPEN SOURCE DISTRIBUTED ERP SYSTEM FOR LARGE SCALE ENTERPRISE

  • ELMASSRY, MOHAMED (Computer Science Department, College of Computer and Information Sciences, King Saud University) ;
  • AL-AHAMADI, SAAD (Computer Science Department, College of Computer and Information Sciences, King Saud University)
  • Received : 2021.12.05
  • Published : 2021.12.30
Download PDF
⟨ Previous Next ⟩

Abstract

Enterprise Resource Planning (ERP) is a software that manages and automate the internal processes of an organization. Process speed and quality can be increased, and cost reduced by process automation. Odoo is an open source ERP platform including more than 15000 apps. ERP systems such as Odoo are all-in-one management systems. Odoo can be suitable for small and medium organizations, but duo to efficiency limitations, Odoo is not suitable for the large ones. Furthermore, Odoo can be implemented on both local or public servers in which each has some advantages and disadvantages such as; the speed of internet, synced data or anywhere access. In many cases, there is a persistent need to have more than one synchronized Odoo instance in several physical places. We modified Odoo to support this kind of requirements and improve its efficiency by replacing its standard database with a distributed one, namely CockroachDB.

Keywords

References

  1. CockroachDB - For Global Cloud Services." Cockroach Labs, Odoo SA., 6 Mar. 2018, www.cockroachlabs.com/product/cockroachdb/#distributed-sql.
  2. Technical Architecture." Technical Architecture, Odoo SA., 6 Mar. 2018, oc.odoo.com/6.0/developer/12_module_development/1_server_module/. March 06, 2018
  3. Homepage." Odoo S.A., Odoo SA., 4 Mar. 2018, www.odoo.com/.
  4. Nicolas, B. Odoo Community Association, what is GeoEngine Cited 2.3.2018 http://oca.github.io/geospatial/what_is_geoengine.html
  5. Pinckaers, F., Gardiner, G. & Vossel, E. 2011. Open ERP a modern approach to integrated business management Release 6.0.0.
  6. Gartner, 75% of all ERP projects Fail but why? Cited 1.3.2018 http://officeoffinance.com/gartner-75-of-all-erpprojects-fail-but-why/
  7. ERP Systems-Popularity Ranking Open Source, Cited1.3.2018 https://erp-systems.zone/ranking/licenceopen-source
  8. "Electronic News" Overview, Yesser gov SA, 9 Mar. 2018, www.yesser.gov.sa/EN/programdefinition/pages/overview.aspx.
  9. S.A., Odoo, and Serpent Consulting Services Pvt. Ltd. "Multi-DB Synchronization." Odoo S.A., Odoo S.A., 9 Mar. 2018, www.odoo.com/apps/modules/8.0/base_synchro/.
  10. "OpenERP- Base_Synchro (Synchronization)" The toolkit, Toolkit inc., 9 Mar. 2018, toolkt.com/site/openerpbase_synchrosynchronization/.
  11. BrowseInfo. "Auto Multiple Database Synchronization." Odoo S.A., BrowseInfo Odoo S.A., 9 Mar. 2018, apps.openerp.com/apps/modules/10.0/bi_base_synchro/.
  12. HallFeed12votes, Jim, et al. "Homepage." Opensource.com, 9 Mar. 2018, opensource.com/.
  13. Start a Local Cluster (Insecure)." Cockroach Labs, 9 Mar. 2018, www.cockroachlabs.com/docs/stable/start-a-localcluster.html.
  14. Anatoly E Doroshenko and Vlad Romanenko. Object-relational mapping techniques for. net framework. In ISTA, pages 81-92, 2004.
  15. Coulouris, George; Jean Dollimore; Tim Kindberg; Gordon Blair (2011). Distributed Systems: Concepts and Design (5th Edition). Boston: Addison-Wesley. ISBN 0-132-14301-1.
  16. Magnoni, L. (2015). "Modern Messaging for Distributed Sytems." Journal of Physics: Conference Series. 608 (1): 012038. DOI:10.1088/1742-6596/608/1/012038. ISSN 1742-6596.
  17. Seth Gilbert and Nancy Lynch. 2002. Brewer's conjecture and the feasibility of consistent, available, partition-tolerant web services. SIGACT News 33, 2 (June 2002), 51-59. DOI: https://doi.org/10.1145/564585.564601.
  18. Edgar F Codd. \A relational model of data for large shared data banks". In: Communications of the ACM 13.6 (1970), pp. 377{387. https://doi.org/10.1145/362384.362685
  19. Pramod J Sadalage and Martin Fowler. NoSQL distilled: a brief guide to the emerging world of polyglot persistence. Pearson Education, 2012.
  20. Prof. Dr. Stefan Edlich. NoSQL Databases. http://nosqldatabase.org/. Accessed: 2018-03-30.
  21. PC freak. What is Vertical scaling and Horizontal scaling Vertical and Horizontal hardware/ services scaling.http://www.pc-freak.net/blog/vertical-horizontalserver-services-scaling-vertical-horizontal-hardwarescaling/. Accessed: 2018-04-04.
  22. Diego Ongaro and John Ousterhout. "In search of an understandable consensus algorithm." In: 2014 USENIX Annual Technical Conference (USENIX ATC 14). 2014, pp. 305{319.
  23. RocksDB. A persistent key-value store for fast storage environments. http://rocksdb.org/. Accessed: 2018-03-30.
  24. Tamir Duberstein Peter Mattis. SQL in CockroachDB: Mapping Table Data to Key-Value Storage. https://www.cockroachlabs.com/blog/sql-in-cockroachdbmapping-table-data-to-key-value-storage/. Accessed: 2018-03-30.
  25. Corbett, J. C., Dean, J., Epstein, M., Fikes, A., Frost, C., Furman, J. J., Ghemawat, S., Gubarev, A., Heiser, C., Hochschild, P., Hsieh, W., Kanthak, S., Kogan, E., Li, H., Lloyd, A., Melnik, S., Mwaura, D., Nagle, D., Quinlan, S., Rao, R., Rolig, L., Saito, Y., Szymaniak, M., Taylor, C., Wang, R., and Woodford, D. 2013. Spanner: Google's globally distributed database. ACM Trans. Comput. Syst. 31, 3, Article 8 (August 2013),22 pages. DOI:http://dx.doi.org/10.1145/2491245
  26. Gattiker, T.F., Goodhue, D.L.: Understanding the local-level costs and benefits of ERP through organizational information processing theory. Information & Management 41(4), 431-443 (2004) https://doi.org/10.1016/S0378-7206(03)00082-X
  27. Enaya, MHD Fawaz: An Experimental Performance Comparison of NoSQL and RDBMS Data Storage Systems in the ERP System Odoo, November-2016.
  28. Knolmayer, Gerhard F. - Quality of Material Master Data and Its Effect on the Usefulness of Distributed ERP Systems - Berlin, Heidelberg SN - 978-3-540-47704-4 2006.
  29. C. (n.d.). Deploy CockroachDB On-Premises (Insecure). Retrieved April 21, 2018, from https://www.cockroachlabs.com/docs/stable/deployCockroachdb-on-premises-insecure.html
  30. P. Maheshwari, Enterprise application integration using a component-based architecture, in 27th Annual International Computer Software and Applications Conference, Dallas, USA, November 03-06, 2003.
  31. D. Smith, L. O'Brien, M. Barbacci, A roadmap for enterprise integration, in 10th International Workshop on Software Technology and Engineering Practice, Montre'al, Canada,October 6-8, 2002.
  32. James Cowling and Barbara Liskov. "Granola: Low-Overhead Distributed Transaction Coordination." Proc. of USENIX ATC.2012, pp. 223-236.
  33. Alexander Shraer et al. "Dynamic Reconfiguration of Primary/ Backup Clusters." Proc. of USENIX ATC. 2012, pp. 425-438.
  34. Ashish Thusoo et al. "Hive - A Petabyte Scale Data Warehouse Using Hadoop." Proc. of ICDE. 2010, pp. 996-1005.
  35. Jeff Shute et al. "F1-The clearly Fault-Tolerant Distributed RDBMS Supporting Google's Ad Business". Proc. of SIGMOD. May 2012, pp. 777-778.
  36. L. Frank, 'Architecture for Integration of Distributed ERP Systems and E-commerce Systems,' Industrial Management and Data Systems (IMDS), Vol. 104(5), 2004, pp 418-429. https://doi.org/10.1108/02635570410537507
  37. L. Frank, 'Trends in Enterprise Application Architecture, chapter 7, Architecture for Distributed ERP Systems' Industrial Management and Data Systems (IMDS), 2016, 978-3-540-32735-6.
  38. Alanne, Aki; Pekkola, Samuli; and Kahkonen, Tommi, "CENTRALIZED AND DISTRIBUTED ERP DEVELOPMENT MODELS: OPERATIONS AND CHALLENGES" (2014). PACIS 2014 Proceedings. 337
  39. Nico Brehm, Jorge Marx Gomez, and Claus Rautenstrauch. 2016. An ERP solution based on web services and peer-to-peer networks for small and medium enterprises. Int. J. Inf. Syst. Chang. Manage. 1, 1 (November 2006), 99-111. DOI=http://dx.doi.org/10.1504/IJISCM.2006.008288
  40. Ramez Elmasri and Shamkant Navathe. 2010. Fundamentals of Database Systems (6th ed.). Addison-Wesley Publishing Company, ISBN:01360862099780136086208, SA.
  41. O. (2008, March 13). Database Administrators Guide. Retrieved May 5, 2018, from https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts001.htm#ADMIN12078
  42. Ozsu, M. T., & Valduriez, P. (2011). Principles of Distributed Database Systems, Third Edition [recurso electronico]. Estados Unidos: Springer New York