database query
Recently Published Documents


TOTAL DOCUMENTS

306
(FIVE YEARS 43)

H-INDEX

22
(FIVE YEARS 2)

2023 ◽  
Vol 55 (1) ◽  
pp. 1-38
Author(s):  
Roberto Amadini

String constraint solving refers to solving combinatorial problems involving constraints over string variables. String solving approaches have become popular over the past few years given the massive use of strings in different application domains like formal analysis, automated testing, database query processing, and cybersecurity. This article reports a comprehensive survey on string constraint solving by exploring the large number of approaches that have been proposed over the past few decades to solve string constraints.


Author(s):  
Yaw Adjei Asante ◽  
Richard Essah

In network designs, the decision made when implementing dynamic routing protocols is very paramount to the speed of the network. To make the best choice of protocol to deploy, several decisions has to be considered. Usually, these decisions are made based on the performance of the routing protocol with respect to some quantitative parameters. The protocol that performs better than other protocols involved in a research is selected for routing purposes. In this research paper, performance comparison of two mixed protocols namely OSPFv3/IS-IS and RIPng/IS-IS in IPv6 network has been made. Their performances have been measured and comparison made by simulation using Riverbed Modeller Academic Edition. The objective of this paper is mainly to determine which of the mixed protocols will be more suitable to route traffic in IPv6 network. The main motivation for this paper is to find out if the difference in the routing algorithms of RIPng and IS-IS will offset and produce a better performance than a combination of two routing protocols of the same routing algorithm (thus OSPFv3 and IS-IS). To achieve this paper’s objective, the simulation was divided into two scenarios. The first scenario was an OSPFv3/IS-IS configured IPv6 network topology.  The second scenario is a copy of the first scenario but configured with RIPng/IS-IS. The two scenarios were simulated and the effect of using each of the scenarios to separately route the selected applications was measured and recorded. The performance comparison of the mixed protocols was based on the following quantitative parameters: database query response time, database query traffics received, email upload/download response time, ftp upload/download response time, ftp traffic received, http page response time, remote login response timeandIPv6 traffics dropped. The results obtained from the simulation indicated that RIPng/IS-IS scenario performed better in email download/upload response time, remote login response time, IPv6 traffics dropped and remote login response time while the mixture of OSPFv3/IS-IS performed better in database query response time, database query traffics received, ftp download/upload response time, ftp traffic received and http page response time. Hence OSPFv3/IS-IS is the better option when the choice is between RIPng/IS-IS and OSPFv3/IS-IS for most of the quantitative parameters involved in this paper. This is because the combination of RIPng and IS-IS took a longer time to converge, affecting the speed on the network scenario. The time the RIPng/IS-IS combination took to access most of the application servers is slower than that of OSPFv3/IS-IS network scenario. On the basis of database query and ftp traffics received, the simulation results showed that network configured with OSPFv3/IS-IS performs better than RIPng/IS-IS. This is because the OSPFv3/IS-IS received the highest database and ftp traffics. The mixture of OSPFv3/IS-IS sent and received more application packets because it had very high throughput values which had an effect on the total quantity of application traffics received. Although the OSPFv3/IS-IS network scenario recorded the highest database and ftp traffics, this could not affect its speed to become lower than the RIPng/IS-IS scenario.


2021 ◽  
Vol 33 (6) ◽  
pp. 1-19
Author(s):  
Linze Li ◽  
Jun Zhang

As an emerging online shopping method, e-commerce has been widely popular since the popularization of the Internet. Online sales and online shopping have become the trend of modern business development. However, the functionality and performance conditions of the existing platform cannot be closely integrated with the merchant's own business. The purpose of this paper is to study the enterprise e-commerce marketing system based on big data. The system design of this paper adopts SSH framework as the main technology, the database selects HBase database, and the front end combines with Web2.0 technology for the interaction of interface display and operation. The experimental results show that applying big data technology to enterprise e-commerce marketing system has extremely important practical significance. Perform a performance analysis on this system,when the amount of data reaches 4000, the speed of HBase is 10.486s, and the query time of Mysql is 50.184s. It can be seen that the Hbase database query speed is much faster than the Mysql database query speed.


2021 ◽  
Vol 33 (6) ◽  
pp. 0-0

As an emerging online shopping method, e-commerce has been widely popular since the popularization of the Internet. Online sales and online shopping have become the trend of modern business development. However, the functionality and performance conditions of the existing platform cannot be closely integrated with the merchant's own business. The purpose of this paper is to study the enterprise e-commerce marketing system based on big data. The system design of this paper adopts SSH framework as the main technology, the database selects HBase database, and the front end combines with Web2.0 technology for the interaction of interface display and operation. The experimental results show that applying big data technology to enterprise e-commerce marketing system has extremely important practical significance. Perform a performance analysis on this system,when the amount of data reaches 4000, the speed of HBase is 10.486s, and the query time of Mysql is 50.184s. It can be seen that the Hbase database query speed is much faster than the Mysql database query speed.


2021 ◽  
Vol 5 (OOPSLA) ◽  
pp. 1-30
Author(s):  
Haoran Xu ◽  
Fredrik Kjolstad

Fast compilation is important when compilation occurs at runtime, such as query compilers in modern database systems and WebAssembly virtual machines in modern browsers. We present copy-and-patch, an extremely fast compilation technique that also produces good quality code. It is capable of lowering both high-level languages and low-level bytecode programs to binary code, by stitching together code from a large library of binary implementation variants. We call these binary implementations stencils because they have holes where missing values must be inserted during code generation. We show how to construct a stencil library and describe the copy-and-patch algorithm that generates optimized binary code. We demonstrate two use cases of copy-and-patch: a compiler for a high-level C-like language intended for metaprogramming and a compiler for WebAssembly. Our high-level language compiler has negligible compilation cost: it produces code from an AST in less time than it takes to construct the AST. We have implemented an SQL database query compiler on top of this metaprogramming system and show that on TPC-H database benchmarks, copy-and-patch generates code two orders of magnitude faster than LLVM -O0 and three orders of magnitude faster than higher optimization levels. The generated code runs an order of magnitude faster than interpretation and 14% faster than LLVM -O0. Our WebAssembly compiler generates code 4.9X-6.5X faster than Liftoff, the WebAssembly baseline compiler in Google Chrome. The generated code also outperforms Liftoff's by 39%-63% on the Coremark and PolyBenchC WebAssembly benchmarks.


Author(s):  
Richard Essah ◽  
Isaac Ampofo Atta Senior ◽  
Darpan Anand

The Analysis of common conceptual frameworks associated with Performance analysis of OSPFV3 and EIGRP in applications in IPV6 for analysis of articles published in Scopus between 2016 and 2021 by applying the Corresponding method analysis. The number of times an article is downloaded is also being considered as a measurement instrument or method of analysis. The Corresponding analysis method has analysis 117 articles from 2016 to 2021. All the articles are based on performance analysis of OSPFV3 AND IPV6.IPv6 has gained legitimacy and inevitability as a result of the internet's expansion, which has resulted in IPv4 address space exhaustion. An internet next-generation protocol that will replace eventually IPv4 is IPv6. Using Riverbed Modeler Academic Edition, 2state link protocols’ performance for IPv6, IS–IS and OSPFv3 was compared and tested for the greatest commonly utilized applications enterprise for example remote login, database query, file transfer, web surfing, and email. The major characteristics used to assess performance include IPv6 packets dropped, network convergence time, link utilization, throughput, remote login response time, file upload/download response times, http page response times, email, and database query response time,. The primary goal of this dissertation is to compare, simulate, and assess both routing protocols’ performance in order to decide which one is best for routing IPv6 network traffic. Based on the parameters utilized, the protocol that performed better than the others would be suggested for routing network traffic in IPv6. The study was separated into two scenarios to achieve this goal: the IS–IS and OSPFv3 scenario. After the simulation for the IS–IS scenario was completed, the data from both scenarios were compared and examined using the provided parameters to see which protocol worked better. Based on the majority of the simulation parameters employed, the simulation results showed that OSPFv3 was performed as compared toIS–IS.


TEM Journal ◽  
2021 ◽  
pp. 1011-1015
Author(s):  
George Pashev ◽  
Silvia Gaftandzhieva

The paper presents a chatbot oriented linguistic approach and a software prototype which addresses the need of delivering learning content based on queries in Bulgarian language. Two distinct database query generation approaches are presented, discussed and implemented. Pros and cons for each of them are discussed.


2021 ◽  
Vol 50 (1) ◽  
pp. 59-59
Author(s):  
Marcin Zukowski

Hash tables are possibly the single most researched element of the database query processing layers. There are many good reasons for that. They are critical for some key operations like joins and aggregation, and as such are one of the largest contributors to the overall query performance. Their efficiency is heavily impacted by variations of workloads, hardware and implementation, leading to many research opportunities. At the same time, they are sufficiently small and local in scope, allowing a starting researcher, or even a student, to understand them and contribute novel ideas. And benchmark them. . . Oh, the benchmarks. . . :)


Sign in / Sign up

Export Citation Format

Share Document