CRUD Operations Research Articles

Comparison of performance of Xamarin and Flutter cross-platform frameworks

This article conducts a performance comparative study of two cross-platform development frameworks: Flutter and Xamarin. For this purpose, two test applications running on Android were developed, implementing the same functions, i.e. CRUD operations on the database and sorting an array of objects by the Merge Sort algorithm. Tests were performed on an emulator and on a physical device. The sorted arrays had different sizes, and database operations were performed for different sizes of data sets. The metric used for comparisons was the average implementation time of a given operation. The analysis of the research results showed that Xamarin was definitely more efficient in three CRUD operations, while Flutter performed computational operations, which in this case was sorting, much faster.

Performance analysis of selected database management systems

The article presents the results of performance tests of database management systems. In order to conduct the tests, an application running in Java environment and using an ORM tool such as Hibernate for communication with the database was used. The tests were carried out for test scenarios such as CRUD operations, join queries, aggregate functions, and filter conditions in queries. The DBMSes used for testing were MySQL, PostgreSQL and H2. Performance analysis looked at the execution time of operations, RAM usage and CPU load. Additionally, tests were carried out for different sizes of user groups using the application. PostgreSQL proved to be the best choice for complex operations.

Performance comparison of working with a database in Spring Boot version 3.2.3 and Laravel version 8.83.27

The subject of the article is the analysis of the efficiency of working with a database of applications created using programming frameworks: Spring Boot version 3.2.3 and Laravel version 8.83.27. Test applications were prepared in the REST API architecture, which examined the time efficiency of CRUD operations on the original database. Project structure and performance of test applications were compared. After analyzing the obtained results, it was found that in all scenarios, Spring Boot performed data operations on average 12 times faster.

Comparative analysis of the performance of selected database management system

Currently, in the era of large amounts of generated data, a significant challenge is fast data processing. The aim of the article is to conduct a comparative analysis of the performance of relational and non-relational databases using MS SQL Server, MongoDB, and CouchDB as examples. The comparison was carried out based on developed research scenarios designed to examine the execution time of CRUD operations. A performance ranking of databases was established based on the obtained results, with SQL Server taking the first place, MongoDB the second, and CouchDB the third. For the operations of deletion, downloading, and updating of data, MS SQL Server proved to be the most efficient database. Only in the operation of inserting data did MongoDB turn out to be the most efficient database.

SURE: Structure for Unambiguous Requirement Expression in Natural Language

This study presents three structures for clearly expressing functional requirements (FRs) and quantitative non-functional requirements (qt-NFRs). Expressing requirements with these structures will allow the understanding of requirements by stakeholders and software developers. The first structure is the SURE format, which is composed of three main sections: a title, a short definition, and a detailed description. The second proposed structure is a template to facilitate the definition of the title and description of unambiguous FRs. It is based on the application of CRUD operations on a certain entity, calling it the “CRUDE” structure. Finally, the third structure serves as a template to make it easier to clearly define the description and title of qt-NFRs. It is based on the application of system properties to computer events or actions, calling it the “PROSE” structure. In this, it is very important to specify those metric values that are desired or expected by the stakeholder. To know how much the definition of FRs and qt-NFRs improved when the proposed structures were used, 46 requirement specification documents elaborated as homework by students of the “Requirement Engineering” course offered at the University of Guayaquil between 2020 and 2022 were evaluated by five experts with more than 10 years of experience in software development for Ecuadorian companies. The findings showed that students reduced the percentage of unambiguous FRs and qt-NFRs from over 80% to about 10%. In conclusion, the findings demonstrate how crucial the three structures proposed in this paper are to helping students develop the ability to clearly express requirements.

Digital Product Passport Implementation Based on Multi-Blockchain Approach with Decentralized Identifier Provider

This paper examines the implementation of a digital product passport (DPP) using Hyperledger Fabric technology to enhance product lifecycle management within the European Union’s circular economy action plan. This study addresses the need for detailed product information on materials, origin, usage, and end-of-life instructions to improve recycling practices and promote sustainable consumption. The approach integrates decentralized identifier (DID) technology for unique product identification using the cheqd.io platform with an enterprise tailored Hyperledger Fabric blockchain network for DPP data management, leveraging their strengths to enhance security and efficiency. This paper details the data model for the DPP, including entities like Product, Manufacturer, Supplier, and Material. Performance tests on the Hyperledger Fabric network demonstrate the system’s efficacy, focusing on CRUD operations and scalability. Future work will extend to the development of client applications and more comprehensive performance evaluations considering scalability and network expansion.

A Collaborative Code Platform with Advanced AI Features and Real-Time Collaboration Tools

Abstract: Good collaboration and code management are crucial in today's software development environment. Our research has launched a new collaborative process that combines AI resources, including AI and global research, to improve products and enhance and facilitate collaboration. The platform features real-time collaboration tools such as dynamic text with multilanguage support, dialog functionality, and notepad functionality. With OAuth authentication, users can seamlessly perform CRUD operations on files and directories, share code repositories, and participate in live coding sessions. The platform supports compilation and execution of a code file and follows good design principles such as caching, microservices architecture, and containerization to ensure scalability and performance. The platform focuses on user experience by providing simple user interface design and easy interface navigation. Users can create workspaces, share them collaboratively, and seamlessly import repositories from Git. The platform's intelligent data manager helps manage files and directories, while the collaborative platform allows developers to collaborate on code libraries efficiently. The platform is modern web-based, using React on the frontend and Node.js on the backend; Supported with syntax highlighting and smart initialization along with Socket.io for runtime with SQL and NoSQL databases. Provides comprehensive language support. All progress is saved, providing users with peace of mind. While the basic design is for desktops, future iterations are expected to support mobile devices.

Enhancing Event Exploration and Engagement: A Social Events Networking Platform Leveraging Cosine Similarity Recommendations and Google Maps Integration

This project introduces a Social Events Networking Platform, strategically engineered to streamline event exploration and engagement through the effective utilization of user preferences. With a comprehensive range of functionalities, users can seamlessly navigate and participate in diverse events, while event planners gain the ability to create and manage their own events. At its core, the platform employs cosine similarity recommendation algorithms to analyze user preferences, providing personalized event suggestions tailored to individual likes and interests. This approach significantly heightens the probability of user attendance and interaction. In tandem with the recommendation feature, the platform seamlessly integrates Google Maps API, offering a map functionality that enables users to visualize event locations alongside pertinent details. This feature empowers users to efficiently plan their attendance by considering factors such as proximity and accessibility. The overarching goal is to cultivate a vibrant, interactive community by connecting event enthusiasts with organizers. The platform's reliance on Firebase Cloud Function APIs for CRUD operations, such as post creation, reading, updating, and deletion, ensures robust support. Additionally, the recommendation function, based on cosine similarity, is deployed as an API to Firebase Cloud Function. These APIs empower administrators to perform CRUD operations on events, while users can access events based on location and receive recommendations rooted in their favorite events. By seamlessly integrating event recommendations and location-based information, the platform elevates the overall event discovery and participation experience, rendering it more engaging and personalized for users.

Performance Analysis and Improvement for CRUD Operations in Relational Databases from Java Programs Using JPA, Hibernate, Spring Data JPA

The role of databases is to allow for the persistence of data, no matter if they are of the SQL or NoSQL type. In SQL databases, data are structured in a set of tables in the relational database model, grouped in rows and columns. CRUD operations (create, read, update, and delete) are used to manage the information contained in relational databases. Several dialects of the SQL language exist, as well as frameworks for mapping Java classes (models) to a relational database. The question is what we should choose for our Java application, and why? A comparison of the most frequently used relational database management systems, mixed with the most frequently used frameworks should give us some guidance about when to use what. The evaluation is conducted based on the time taken for each CRUD operation to run, from thousands to hundreds of thousands of entries, using the possible combinations in the relational database system and the framework. Aiming to assess and improve the performance, the experiments included the possibility of warming-up the Java Virtual Machine before the execution of queries. Also, the research investigated the time spent using different methods of code to determine the critical regions (bottlenecks). Thus, the conclusions provide a comprehensive overview of the performances of Java applications accessing databases depending on the suite decisions considering the database type, the framework in use, and the type of operation, with clear comparisons between the alternatives, the key findings of the advantages and drawbacks of each of them, and supporting architects and developers in their technological decisions and improving the speed of their programs.

Comparative analysis of Node.js frameworks

The aim of the article is to compare two popular NodeJs frameworks. The analysis was performed for the ExpressJs and NestJs frameworks. Two proprietary applications supporting CRUD operations, implemented in these technologies, containing the same functionalities were used for the research. The comparison includes application performance, code metrics, documentation quality and completeness, and community support. The analysis showed that ExpressJs is minimalistic and suitable for less complex applications, while NestJs provides a standardized framework that allows the creation and development of large and complex projects.

CRUD Application Using ReactJS Hooks

This Project is aimed to implement CRUD operations using the library called React.js which is the advanced version of the language Javascript. The question which pops out everyone’s mind now is why React? There’s lot of open – source framework/ library/ language that is available in today’s internet. The purpose of using react is anyone with the little knowledge of javascript can easily learn react and implementation of this library is user-friendly. Also, there’s many more packages react can easily get installed in NPM and run the application whatever changes in the code can do. React also delivers good UI for the developer and to create/develop new apps for future generation. There are more than 2000 developers and over one lakh sites making use of react.js among some of the most powerful are Instagram, Netflix, Whatsapp, Uber. It also integrates with any other javascript libraries or framework and speciality of react can make changes in the web browser without doing subsequent refresh of the pages. React can allow the developer to build any complex web application and more importantly mobile application. The CRUD is an acronym for Create, Read, Update and Delete which is very much essential for implementing any strong application with relational Database. Thus, the project results in Creating the user/users with their details, read the users task, updating if any new user is created through ‘Create’ operation, and finally delete the user/users list if not wanted for an application. Though the ‘crud’ functions for creating an application can be done in any language, the author specifically uses Javascript library called react.js which is one of the best platforms to create the single page user application interfaces. The overarching goal of this application is to bring easiness for any product development company in need of crud-user functions can stick to this.

Low-code development using requirements and knowledge representation models

Low-Code Development is a new software development paradigm which is typically used to generate web applications from high-level visual notations. These notations allow to express the User Interface and Application Logic (usersystem interactions) in a way which is understandable by the end-users. Using certain model-driven approaches, the low-code environments allow for generating the front-end layer and basic CRUD operations in the back-end. Yet still, non-standard domain logic (data processing) operations still necessitate the use of traditional programming. In this article we present a visual language, called RSL-DL that can be used to represent such non-standard domain logic in a visual form. It allows to capture domain knowledge with complex domain rules aligned with requirements models. The language synthesises and extends approaches found in knowledge representation (ontologies) and software modelling language engineering. The development environment of RSL-DL enables fully automatic generation of domain logic code by reasoning over and reusing domain knowledge. The environment includes a dedicated model editor and a transformation engine. The language?s abstract syntax is defined using a meta-model expressed in MOF. Its semantics is expressed with several translational rules that map RSL-DL models onto typical programming language constructs. The article presents a list of these rules in an informal way, and then introduces their formalisation using a graphical transformation notation. The RSL-DL environment includes an inference engine that enables processing queries to domain models and selecting appropriate invocations to generated code. It was also initially validated through studies that involve understandability, operability and complexity assessment. Based on these results, we conclude that declarative knowledge representations can be successfully used to produce imperative backend code with non-trivial logic.

Performance analysis of a cloud database on mobile devices

The article presents a performance analysis of Firebase cloud database. Two services, namely Realtime Database and Cloud Firestore, are examined, and their query speed are compared to those of the local SQLite database. Basic CRUD operations were examined, taking into account the number of records in the database, the size of individual records and the complexity of the database structure. Upon completion of the research, it was concluded that Realtime Database outperforms Cloud Firestore and cloud databases are slower than the local database when it comes to operations on a single record. However, when working with a larger volume of data, cloud database can achieve better results than SQLite. The accuracy of the outcome is also influenced by the stability of the network connection and the distance from the cloud server.

The Doubly Linked Tree of Singly Linked Rings: Providing Hard Real-Time Database Operations on an FPGA

We present a hardware data structure specifically designed for FPGAs that enables the execution of the hard real-time database CRUD operations using a hybrid data structure that combines trees and rings. While the number of rows and columns has to be limited for hard real-time execution, the actual content can be of any size. Our structure restricts full navigational freedom to every but the leaf layer, thus keeping the memory overhead for the data stored in the leaves low. Although its nodes differ in function, all have exactly the same size and structure, reducing the number of cascaded decisions required in the database operations. This enables fast and efficient hardware implementation on FPGAs. In addition to the usual comparison with known data structures, we also analyze the tradeoff between the memory consumption of our approach and a simplified version that is doubly linked in all layers.

CRUD Operation on WordPress Posts From C# over REST API

Purpose: WordPress is a sound content management system on the web. We can build a website with little effort. Around 40% of internet websites are powered by WordPress. Using the WordPress website, our researcher can store research data inside the website database without spending money on the cloud. We demonstrate how to run CRUD operations on a WordPress-powered website database using WordPress Posts. We observe the essential CRUD operation so that our researcher can integrate it easily into their project with complex procedures. We use REST API for communication between the WordPress and the client application. We created a GUI in Visual Studio using C# language for easy operation. An HTTP client is used for communication. The complete project code is available to download and continue research work. Design/Methodology/Approach: First, we install a “local” application in our working system. Then, we create a brand-new WordPress website. We activated the latest theme, which is now Twenty twenty-four. We make a custom route and add a posts operation handling module inside the theme folder. This is the server-side action. On the other hand, inside the Visual Studio 2022 community edition, using C# language, we created a GUI-based client application to interact with users. We added an HTTP client module to communicate with the server. Findings/Result: We experimented with practical, real-world examples. The overall performance is excellent and helpful in real-world scenarios without any issues. Network latency is sometimes present, creating problems in real-time data processing. The researcher creating a custom route in their online website can experiment. It will not have any adverse effect on keeping the website live. Originality/Value: WordPress uses the database to store post-type data and some WordPress-related configurations. Out of the traditional way, we can also reserve our research data as post-type content according to our project requirements. Keeping our data as the post-type of content from the C# application is the least available documentation on the web. We demonstrate here through Practical examples. Some valuable reference information can be found here. Paper Type: Experimental-based Research.

Concurrent Data Processing in Microsoft Dynamics CRM Using Python

The realm of Customer Relationship Management (CRM) has seen significant improvements with the integration of automation and data analytics. Python, known for its robust data manipulation libraries, offers a seamless experience for handling data in Microsoft Dynamics CRM. This paper aims to serve as a comprehensive guide on how Python can be employed to perform CRUD operations— Read, Update, Insert—on data in Microsoft Dynamics CRM. We delve into the intricacies of using Python's 'requests' library for API calls and 'concurrent futures' for parallel processing, thereby optimizing data manipulation tasks. The paper also presents a performance evaluation showcasing the efficiency gains achieved through these methods. Furthermore, the paper highlights the challenges associated with large-scale data management in CRM systems and proposes Python-based solutions as a scalable and effective approach. The paper concludes with a discussion on the scope of this approach in the broader context of CRM data analytics and automation. The methods and findings presented herein are expected to be of particular interest to data engineers, software developers, and CRM administrators.

Web-based Academic Information System Design at Al-mukhlisin High School Bogor

Academic information system is an application designed for the needs of managing school academic data so that schools can manage academic data better and more efficiently. Website creation in this study uses the programming language PHP Native and JavaScript, for the design used is CSS and the CSS Framework, namely Bootstrap, and the Database Engine used is the MySQL Database. The application that will be made will be able to perform CRUD operations for student data, student grades, teachers, subjects, posts, student and user accounts, besides that the front page will display information about school profiles and activities. Complete CRUD operations can only be performed by the admin, while students can only see their own data (including grades). Forms that will be created include Admin Login Form, Student Login Form, User Registration Form (Admin), Student Account Registration Form, Add Student Data Form, Value Input Form, Create Post Form, Student Data Edit Form, Value Edit Form, Post Edit Form and User Edit Forms. In the development which will later produce a web-based academic information system application, it is hoped that it can further assist Al-Mukhlisin Bogor Islamic High School in terms of managing academic data so that it can be even better and more effective. Students can access and view grades, personal data or information about school activities on the web-based academic application.

Performance analysis of working with databases with Spring and Symfony

The article presents a comparative analysis of the efficiency of work with MySQL and PostgreSQL databases, using the popular Spring (Java) and Symfony programming frameworks. The research was carried out with the use of proprietary test applications that perform CRUD operations on a different number of records. The test results showed that the execution time of writing and deleting data using the Spring application is longer than when performing the same operations in Symfony. On the other hand, in the case of UPDATE and SELECT operations, the operation execution time with the Spring application turned out to be shorter than in the case of Symfony. The test results also confirmed that, regardless of the development framework, MySQL is less efficient than PostgreSQL while operating on 10 000 records except for DELETE, where MySQL combined with Symfony is the fastest.

Creating lightweight FAIR Digital Objects with RO-Crate

Creating lightweight FAIR Digital Objects with RO-Crate

Updating Linked Data practices for FAIR Digital Object principles

Updating Linked Data practices for FAIR Digital Object principles