The purpose of this work is to compare the ways in which relational databases—more especially, Microsoft SQL Server—and non-relational databases—MongoDB—handle unstructured data in JSON format. Although a lot of study has been done comparing different database management systems in terms of security, performance, and other aspects, little is known about how these databases are evaluated according to the type of data they handle. The main goal of this study is to examine the various features that relational and non-relational databases provide (...) for handling JSON data. We will conduct a number of tests to do this, making sure that the relevant data doesn't need to be normalised. To draw a conclusion, the outcomes of these studies will thereafter be examined. (shrink)

Businesses and people outsource database to realize helpful and low-cost applications and administrations. In arrange to supply adequate usefulness for SQL inquiries, numerous secure database plans have been proposed. In any case, such plans are helpless to protection leakage to cloud server. The most reason is that database is facilitated and handled in cloud server, which is past the control of information proprietors. For the numerical extend inquiry (“>”, “<”, etc.), those plans cannot give adequate protection security against viable challenges, (...) e.g., security spillage of measurable properties, get to design. Besides, expanded number of questions will definitely spill more data to the cloud server. In this paper, we propose a two-cloud engineering for secure database, with a arrangement of crossing point conventions that give security conservation to different numeric-related extend questions. Security analysis shows that privacy of numerical information is strongly protected against cloud providers in our proposed scheme. (shrink)

In the contemporary landscape of public procurement, organizations face increasing complexities in managing procurement and vendor payment processes. This project focuses on developing a real-time procurement and vendor payment management system for North Eastern Electric Power Corporation Limited (NEEPCO), leveraging modern web technologies, including React, Node.js, Express, and SQL. The proposed system aims to centralize and automate the procurement lifecycle, enhancing operational efficiency, transparency, and compliance with government regulations. By integrating with the Government e-Marketplace (GeM), the system facilitates seamless procurement (...) from Micro and Small Enterprises (MSEs), promoting inclusivity and economic participation. The procurement data portal will provide real-time tracking of all procurement activities, from requisition to delivery, while automating workflows to reduce manual intervention and errors. The vendor payment portal will streamline payment processes, ensuring timely payments and realtime updates for vendors, thus fostering stronger relationships. Additionally, advanced analytics will be integrated into the system, enabling data-driven decision-making and improved financial management. The expected outcomes include reduced procurement cycle times, improved compliance, and enhanced vendor satisfaction. By addressing the challenges inherent in traditional procurement methods, this project will contribute significantly to NEEPCO's operational efficiency. Ultimately, the system aims to set a benchmark for procurement practices in the public sector, reinforcing the importance of adopting modern technologies to meet the demands of a dynamic marketplace. (shrink)

I aim to develop a tool for comparing theories of vagueness, using Structured Query Language. Relevant SQL snippets will be used throughout.

In 2013, I've transformed the each_co_uk server side system (aspx / c#) to the client system of a few javascript files ≈400KB potentially webassembly, without plugins / 3rd party / css.. The system maximally reuses functions & data to apply: 1) Linguistic principle of arbitrariness of the sign maximizing repetitions, 2) Multi layer logic of the chess composition, 3) Information Theory minimizing entropy. Some of these ideas were presented at conferences in Santorini, Adelaide, Geneva, Daejon and virtually. Philosophically, any system (...) only organizes the existing reality (information), but can't create it. Its fragmentation easily leads to illusions (entropy): e.g. Zeno's Achilles can't overtake the slower tortoise because as he gets closer, the tortoise gets a bit further, so he gets closer and closer but never reaches her. So the more are logic and data fragmented in various layers (server, javascript, css, sql, frameworks..), the less capable system is. (shrink)

Application of the reliability of repairable systems on solving problems from constructing production systems takes an important place in the process of finding the optimal solution among the suggested system choices. The basic hypothesis when using the reliability of the repairable systems is that every machine is representing a component, a fact that is debatable when talking about technical sciences. However, considering the second assumption of the stationary process, the function of the availability is introduced. It represents the measure between (...) the reliability and the benefit of maintaining the components and the system as a whole one. An additional and the last reason for analyzing constructing machine as a whole one has an economic reason. From the aspect of the total cost and the capacity of the system, the function of the availability is catching more and more impact in the process of determinating the total cost in bill of quantities as the most important part of tender documents. Until former works, techno-economic optimisation usually ran over when choosing the system of the construction machines. In the work, there are shown the methodologies for gathering and analyzing the indicators of availabilities per unit of a company's machine park. The time of demission and reparation have been investigated among 34 components in the period of 6 years. Based on the obtained result for different conditions of machine exploitation and facilities, it is suggested the methodology of the future behaviour of the corresponding within the model optimization availability of constructing production system with the aim of eliminating extra criterion. The suggested model takes in consideration the total cost of the components when they are functional, and when they are not. This kind of approach enables the one who take choices decision of the height of profits, in the lenght of work in function of the projection of cash flow and managing with real indicators of functioning the system at the project level. Given the fact that the maintanance policy of machines is based on availability, and not on reliability of components, with the aim of maximizing the availability of different budget scenarios, a logical approach to the selection of the objective function in the terms of management of construction production systems is to minimize costs for a given availability of system constructing machinery is based on the use of historical data base with the values of the operational availability of components, conditions in which they function, in the process of forecasting the project availability for projects that follow. Ranking variant solutions is the result of the adopted function of the aim as a consequence due to enlargement methods of availability for serial parallel systems with the associated restrictions. For optimal system availability is taken a value that belongs to minimal total cost. However, it is predicted that after the end of the financial year, the real and projected indicators of system functions get compared to each other. Informational support to the proposed model is informational company system, which was built in the PHP programming language on the Linux software platform, and with data based in My SQL. The suggested model is tested on the system for the production and embedding bitumen bound materials on the specific project. Obtained results confirm the assumptions used in work. (shrink)

Web applications are increasing day by day and the choice of technology for building a web application is a tedious task. A good website needs to be scalable, functional, responsive, reliable, secure etc. Therefore, comparing the different trending technologies for web design is crucial. The entire design of our website requires the selection of the programming languages. It is difficult to give a quick solution to this issue without first considering what our website will do both now and in the (...) future. One of the initial decisions to be made is whether the website will be static, interacting with users relatively little, or dynamic, displaying personalised information to users in response to interactions. Also, there are many stacks trending and available in the market for web development like MERN stack, MEAN stack, MEVN stack or ruby on rails or DERN technology. It's very necessary to understand all, the key differences between them and which one is right to choose when. This paper attempts to assist web developers through conducting an empirical comparison of the most significant web-based programming languages and databases. The paper compares frontend technologies like React and Angular based on certain parameters like DOM, architecture and data binding, in each case comparing their performance and also do the performance analysis of backend technologies like MongoDB and PostgreSQL, which are no-SQL and SQL databases respectively, based on e-commerce use case application. The paper finally suggests which technology to choose for which use case and under what conditions and requirements. (shrink)

In the era of big data and distributed ecosystems, understanding the origin, flow, and transformation of data across complex infrastructures is critical for ensuring transparency, accountability, and informed decision-making. As data-driven enterprises increasingly rely on hybrid cloud architectures, data lakes, and real-time pipelines, the complexity of tracking data movement and transformations grows exponentially. Traditional data lineage solutions, often based on static metadata extraction or rule-based approaches, are insufficient in dynamically evolving environments and fail to provide granular, context-aware insights. This research (...) introduces an AI-augmented, cognitive graph-based framework for autonomous data lineage, designed to enhance data traceability in large-scale and heterogeneous data ecosystems. The framework leverages cutting-edge machine learning (ML), natural language processing (NLP), and graph-based reasoning techniques to enable intelligent discovery, semantic interpretation, and continuous monitoring of data assets throughout their lifecycle. The core of the solution lies in the construction of a dynamic cognitive graph that represents relationships between datasets, processes, systems, and users, enriched with contextual annotations and temporal dimensions. Our architecture incorporates self-learning mechanisms, enabling adaptive lineage discovery and automated anomaly detection. By applying reinforcement learning and stream analytics, the framework not only maps data flows in real time but also evolves with system changes, schema variations, and business logic updates. It provides both forward and backward traceability, supports impact analysis, and enhances compliance auditing capabilities. Furthermore, our system is capable of processing both structured and unstructured metadata, employing advanced NLP models to extract implicit lineage information from data dictionaries, SQL queries, and documentation. The result is a holistic, intelligent, and scalable data lineage solution that reduces manual intervention, mitigates operational risks, and supports regulatory compliance frameworks such as GDPR, HIPAA, and SOX. Experimental evaluations conducted in hybrid cloud environments using tools such as Apache Kafka, Neo4j, Spark, and Python-based ML libraries demonstrate a significant improvement in lineage coverage, anomaly detection accuracy, and system scalability. Compared to conventional lineage tools, our AI-augmented framework delivers a 30% increase in traceability precision and a 40% reduction in manual effort required for lineage tracking and governance. This research lays the foundation for a new paradigm in data governance, where AI not only enhances observability but enables autonomous cognition within data infrastructure. The framework is poised to play a critical role in enabling data democratization, operational agility, and enterprise-wide data literacy. (shrink)

In many areas, technology has facilitated many things, diagnosing diseases, regulating traffic and teaching students in schools rely on Intelligent systems to name a few. At present, traditional classroom-based education is no longer the most appropriate in schools. From here, the idea of intelligent e-learning for students to increase their culture and keep them updated in life began. E-learning has become an ideal solution, relying on artificial intelligence, which has a footprint in this through the development of systems based on (...) education without a teacher taking into account the individual differences of students. This study describes intelligent tutoring system for teaching the Data Manipulation Language (DML) Commands Using SQLite to non IT students to overcome the difficulties they face. The System was built as education system by using the researcher own authoring tool that based on mobile and web App. The basic idea of this system is a systematic introduction into the concept of Database and its DML query. The system presents the topic of DML Commands, help student to execute what they are learn from the system content using the practical part of the system and administers automatically adapted at run time to the student’s individual growth. The system was assessed by a group of teachers and students and the outcome showed as 91% from the database specialists, 94% from Diploma students group and 89% from the secondary school students group. (shrink)

This paper describes an Intelligent Tutoring System for helping users with ADO.NET called ADO-Tutor. The Intelligent Tutoring System was designed and developed using (ITSB) authoring tool for building intelligent educational systems. The user learns through the intelligent tutoring system ADO.NET, the technology used by Microsoft.NET to connect to databases. The material includes lessons, examples, and questions. Through the feedback provided by the intelligent tutoring system, the user's understanding of the material is assessed, and accordingly can be guided to different difficulty (...) level of exercises and/or the lessons. The Intelligent Tutoring System was evaluated by a group of users and the results were more than satisfactory in terms of the quality of the material and the design of the system. (shrink)

To secure computers and information systems from attackers taking advantage of vulnerabilities in the system to commit cybercrime, several methods have been proposed for real-time detection of vulnerabilities to improve security around information systems. Of all the proposed methods, machine learning had been the most effective method in securing a system with capabilities ranging from early detection of software vulnerabilities to real-time detection of ongoing compromise in a system. As there are different types of cyberattacks, each of the existing state-of-the-art (...) machine learning models depends on different algorithms for training which also impact their suitability for detection of a particular type of cyberattack. In this research, we analyzed each of the current state-of-the art machine learning models for different types of cyberattack detection from the past 10 years with a major emphasis on the most recent works for comparative study to identify the knowledge gap where work is still needed to be done with regard to detection of each category of cyberattack. (shrink)