![Scientific and Technical Journal of Information Technologies, Mechanics and Optics](/images/mag-ntv.png)
"NORMALIZATION PARADOX" RESEARCH IN FACTUAL RELATIONAL DATABASES ON ORACLE PLATFORM
![Scientific and Technical Journal of Information Technologies, Mechanics and Optics](/images/mag-ntv.png)
Annotation
Subject of Research.The paper presents the results of experimental assessment of relationship force between database normalization degree and database response formation time on a query. The research aim lies in the search of objective assessment of correlation force between database normalization degree and the run time of the enclosed inquiries to it depending on the required depth of the recursion realized in the inquiry ("normalization paradox" model). Method. The applied method is based on implementation of the correlation analysis according to the results of a numerical experiment for "normalization paradox" identification. Main Results. It is established that correlation between the recursion depth caused by achievement of a certain normal form of tables and inquiry performance time is rather weak in databases on the ORACLE platform. Interrelation between the database volume determined by the number of considered objects and delivery formation time is also weak. The valid conclusion is formulated about the absence of grounds for carrying out the database denormalization or not achievement of high normal forms for the good of the increase in its speed when performing requests for selection of records. All significant conclusions are drawn on the relation of factual databases on the ORACLE platform. Transposition of results on the other up-to-date database systems was not performed. Practical Relevance. The practical relevance of work consists in objective justification of the need (but not sufficiency) for reductions of the relations of the relational database under control of ORACLE Database 11g R2 to the highest normal forms for ensuring its integrity. The research result novelty is caused by experimental confirmation of the hypothesis validity about selection time dependence of tuples on database normalization degree at the recursive selection procedure and formulation of "normalization paradox" model for databases on the ORACLE platform
Keywords
Постоянный URL
Articles in current issue
- STUDY OF GAIN FACTOR EFFECT OF ERBIUM DOPED FIBER AMPLIFIER ON NOISE FLOOR LEVEL OF FIBER-OPTIC INTERFEROMETRIC SENSOR
- OBJECT STRUCTURE EFFECT ON OPTIMAL LEVELS OF HOLOGRAM BINA-RIZATION IN TERMS OF RECONSTRUCTED IMAGE QUALITY
- A METHOD OF IMAGES CONTRAST ENHANCEMENT UNDER CONDITIONS OF THE EARTH SURVEY FROM SPACE
- EXPERIMENTAL RESEARCH ON CHROMATICITY FORMATION ON METALS SURFACE BY LASER RADIATION
- REFRACTOMETRY METHOD IN STUDY OF FATTY OILS AND THEIR BLENDS AS EXTRACTANTS OF PLANT RAW MATERIALS
- COMPUTER MODELING OF INTERACTION OF LYSINE DENDRIMER WITH EPITHALON PEPTIDES
- ELECTROMECHANICAL SYSTEMS BASED ON POLYMER HYDROGELS FOR MICRO-SCALE ACTUATORS
- INFRARED SPECTROSCOPIC STUDY OF DYNAMICS AND COMPLEXATION MECHANISM IN CHEMOSORPTION OF IONS OF METALS BY ACRYLATE HYDROGELS
- FULL FACTORIAL EXPERIMENT IN STUDY OF CONTROL BLOCK OPERATION OF INTERSECTION PASSAGE BY UNMANNED VEHICLE
- DETECTION OF SPOOFING ATTACKS ON SPEAKER VERIFICATION SYSTEMS IN TELEPHONE CHANNEL
- MODELING OF SELECTION PROCESSES OF CLOUD SYSTEMS PARAMETERS PROVIDING THEIR STABILITY IN ACCORDANCE WITH RELIABILITY AND SAFETY
- APPLICATION OF SPARTIAL INTERPOLATION METHOD IN SYNTHESIS OF VIDEO SEQUENCE INTERMEDIATE FRAMES
- A MULTI-AGENT SYSTEM FOR MANAGEMENT INFORMATION SUPPORT OF REGIONAL INNOVATIONS
- STUDY OF HIGH-SPEED REALIZATION TECHNICS FOR ELEMENTS OF SYMMETRIC ENCRYPTION ALGORITHMS DURING CALCULATIONS ON GRAPHICS PROCESSOR
- "NORMALIZATION PARADOX" RESEARCH IN FACTUAL RELATIONAL DATABASES ON ORACLE PLATFORM
- MODELING OF INERTIA MOMENTS FORMATION FOR ELECTROSTATIC GYROSCOPE ROTORS
- ROBUSTNESS ESTIMATION OF FREE MOTION DEVIATIONS OF APERIODIC SYSTEMS WITH SENSITIVITY THEORY METHODS
- CONTROL LAW DESIGN FOR FULL-BRIDGE CONVERTER WITH SOFT COMMUTATION BASED ON FREQUENCY VARIATION OF TRANSISTORS SWITCHING
- PHOTO- AND THERMODEGRADATION OF HOLOGRAMS RECORDED IN NANOCOMPOSITE
- ALGORITHM COMPOSITION OF TEXT THEMATIC SEGMENTATION AS INTELLECTUALIZATION INSTRUMENT FOR DESIGN OF TECHNICAL SYSTEMS
- INFORMATION RETRIEVAL SYSTEM OF SCIENTIFIC AND EDUCATIONAL CONTENT BASED ON LINKED OPEN DATA