Selection of Access Method for a Set of Table Records in a Relational Databases

Author(s):  
Aleksey I. Baranchikov ◽  
Pavel A. Baranchikov ◽  
Sergey I. Babaev ◽  
Andrey S. Tarasov
2014 ◽  
Vol 1036 ◽  
pp. 891-896
Author(s):  
Rafal Rzasinski

The main achievements presented in this paper are developed method orientated on computer aiding and computer program method, both used in designing process of the new technical features. Analyzed methods develop algorithmisation of selection features and support integration with the process of the preparation of the production. Further analyses will be carried on in order to specify the theory of the technological similarity in the new forms of computer aiding (relational databases). The represented programs were being developed on the practical examples of creating the module systems of hydraulic cylinders used in mining, slag cars used in metallurgy and gears series of types. Programs and data bases presented in the paper are basis of selection of the technological features in the process series of types of the technology creating. All of these applications support the intensive development of the types of technical features and affect on their competitive on the ready market.


Author(s):  
Oksana Mazurova ◽  
Artem Naboka ◽  
Mariya Shirokopetleva

Today, databases are an integral part of most modern applications designed to store large amounts of data and to request from many users. To solve business problems in such conditions, databases are scaled, often horizontally on several physical servers using replication technology. At the same time, many business operations require the implementation of transactional compliance with ACID properties. For relational databases that traditionally support ACID transactions, horizontal scaling is not always effective due to the limitations of the relational model itself. Therefore, there is an applied problem of efficient implementation of ACID transactions for horizontally distributed databases. The subject matter of the study is the methods of implementing ACID transactions in distributed databases, created by replication technology. The goal of the work is to increase the efficiency of ACID transaction implementation for horizontally distributed databases. The work is devoted to solving the following tasks: analysis and selection of the most relevant methods of implementation of distributed ACID transactions; planning and experimental research of methods for implementing ACID transactions by using of NoSQL DBMS MongoDB and NewSQL DBMS VoltDB as an example; measurements of metrics of productivity of use of these methods and formation of the recommendation concerning their effective use. The following methods are used: system analysis; relational databases design; methods for evaluating database performance. The following results were obtained: experimental measurements of the execution time of typical distributed transactions for the subject area of e-commerce, as well as measurements of the number of resources required for their execution; revealed trends in the performance of such transactions, formed recommendations for the methods studied. The obtained results allowed to make functions of dependence of the considered metrics on loading parameters. Conclusions: the strengths and weaknesses of the implementation of distributed ACID transactions using MongoDB and VoltDB were identified. Practical recommendations for the effective use of these systems for different types of applications, taking into account the resources consumed and the types of requests.


1993 ◽  
Vol 11 (3) ◽  
pp. 207-233 ◽  
Author(s):  
Sunil Choenni ◽  
Henk M. Blanken ◽  
Thiel Chang

2007 ◽  
Vol 24 (1) ◽  
pp. 13-20 ◽  
Author(s):  
Robert A. Power

AbstractThe performance of the mysql and oracle database systems have been compared for a selection of astronomy queries using large catalogues of up to a billion objects. The queries tested are those expected from the astronomy community: general database queries, cone searches, neighbour finding and cross matching. The catalogue preparation, sql query formulation and database performance is presented. Most of the general queries perform adequately when appropriate indexes are present in the database. Each system performs well for cone search queries when the Hierarchical Triangular Mesh spatial index is used. Neighbour finding and cross matching are not well supported in a database environment when compared to software specifically developed to solve these problems.


2019 ◽  
Vol 42 ◽  
Author(s):  
Gian Domenico Iannetti ◽  
Giorgio Vallortigara

Abstract Some of the foundations of Heyes’ radical reasoning seem to be based on a fractional selection of available evidence. Using an ethological perspective, we argue against Heyes’ rapid dismissal of innate cognitive instincts. Heyes’ use of fMRI studies of literacy to claim that culture assembles pieces of mental technology seems an example of incorrect reverse inferences and overlap theories pervasive in cognitive neuroscience.


1975 ◽  
Vol 26 ◽  
pp. 395-407
Author(s):  
S. Henriksen

The first question to be answered, in seeking coordinate systems for geodynamics, is: what is geodynamics? The answer is, of course, that geodynamics is that part of geophysics which is concerned with movements of the Earth, as opposed to geostatics which is the physics of the stationary Earth. But as far as we know, there is no stationary Earth – epur sic monere. So geodynamics is actually coextensive with geophysics, and coordinate systems suitable for the one should be suitable for the other. At the present time, there are not many coordinate systems, if any, that can be identified with a static Earth. Certainly the only coordinate of aeronomic (atmospheric) interest is the height, and this is usually either as geodynamic height or as pressure. In oceanology, the most important coordinate is depth, and this, like heights in the atmosphere, is expressed as metric depth from mean sea level, as geodynamic depth, or as pressure. Only for the earth do we find “static” systems in use, ana even here there is real question as to whether the systems are dynamic or static. So it would seem that our answer to the question, of what kind, of coordinate systems are we seeking, must be that we are looking for the same systems as are used in geophysics, and these systems are dynamic in nature already – that is, their definition involvestime.


Sign in / Sign up

Export Citation Format

Share Document