Log in

Relevant bibliographies by topics / And Oracle SQL / Journal articles

To see the other types of publications on this topic, follow the link: And Oracle SQL.

Journal articles on the topic 'And Oracle SQL'

Author: Grafiati

Published: 2 June 2025

Last updated: 31 July 2025

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles

Select a source type:

Consult the top 50 journal articles for your research on the topic 'And Oracle SQL.'

Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.

You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.

Browse journal articles on a wide variety of disciplines and organise your bibliography correctly.

1

Ricky, Michael Yoseph. "Aplikasi Migrasi Database dan Replikasi Bi-Directional." ComTech: Computer, Mathematics and Engineering Applications 2, no. 2 (2011): 788. http://dx.doi.org/10.21512/comtech.v2i2.2828.

Full text

Abstract:

This study aims to analyze and design a migration and replication configurations in an enterprise using several methods such as literary study and direc survey to the company; analysis on hangar systems, process migration and replication as well as existing problems; and a prototype design for migration process implementated with Oracle SQL Developer and replication process implementated with Oracle GoldenGate. The study resluts ini a prototype for migration and replication configuration processes using Oracle's Golden Gate which can produce two sets of identical data for backup and recovery.

APA, Harvard, Vancouver, ISO, and other styles

2

Dhiya' Ulhaq Ahmad Ramsi, Ahmad Alfian Ertiansyah, and Siti Mukaromah. "PERBANDINGAN PERFORMA WAKTU EKSEKUSI KUERI ANTARA DATABASE ORACLE DAN SQL SERVER." Prosiding Seminar Nasional Teknologi dan Sistem Informasi 3, no. 1 (2023): 254–59. http://dx.doi.org/10.33005/sitasi.v3i1.369.

Full text

Abstract:

Pada era saat ini, kebutuhan sistem basis data menjadi sangat penting dalam sebuah aplikasi atau pengelolaan di suatu perusahaan. Informasi semakin meningkat sehingga memerlukan tempat penyimpanan yang baik agar dapat dikelola dengan mudah. Terdapat banyak faktor yang mempengaruhi individu atau perusahaan dalam memilih sistem basis data. Salah satunya yaitu kecepatan database dalam memproses eksekusi kueri. Pada artikel ini dilakukan perbandingan waktu kecepatan eksekusi kueri antara database Oracle dan SQL Server untuk perintah SELECT, UPDATE, dan DELETE dengan jumlah maksimal data sebanyak 1

APA, Harvard, Vancouver, ISO, and other styles

3

Zhao, De Yu. "Research on Improving Oracle Query Performance in MES." Applied Mechanics and Materials 201-202 (October 2012): 39–42. http://dx.doi.org/10.4028/www.scientific.net/amm.201-202.39.

Full text

Abstract:

The tuning for Oracle database system is vital to the normal running of the whole system, but it is a complicated work. SQL statement tuning is a very critical aspect of database performance tuning. It is an inherently complex activity requiring a high level of expertise in several domains: query optimization, to improve the execution plan selected by the query optimizer, access design to identify missing access structures and SQL design to restructure and simplify the text of a badly written SQL statement. In this paper, the author analyzes the execution procedure of oracle optimizer, and res

APA, Harvard, Vancouver, ISO, and other styles

4

Price, G. "Review: Oracle PL/SQL Programming." Computer Bulletin 40, no. 3 (1998): 32. http://dx.doi.org/10.1093/combul/40.3.32-d.

Full text

APA, Harvard, Vancouver, ISO, and other styles

5

Arb, Ghusoon Idan. "Design of Administration System in Client Side Using Oracle Form Builder." INTERNATIONAL JOURNAL OF COMPUTERS & TECHNOLOGY 15, no. 10 (2016): 7156–59. http://dx.doi.org/10.24297/ijct.v15i10.4392.

Full text

Abstract:

This paper focuses on the creation of a single system for distribution to a team of developers. Oracle Form Builder are popular and made the function of project expansion easier and comparably faster to reduce costs and improve service levels for users. Design of administration system in client side is made available to employees to assist them in the performance of their job duties. Both Oracle Database and MySQL are strong relational database management systems that effectively run great amounts of data. Oracle Database is a full distinct database engine that has successfully passed severe s

APA, Harvard, Vancouver, ISO, and other styles

6

Aleksic, Slavica, Ivan Lukovic, Pavle Mogin, and Miro Govedarica. "A generator of SQL schema specifications." Computer Science and Information Systems 4, no. 2 (2007): 81–100. http://dx.doi.org/10.2298/csis0702081a.

Full text

Abstract:

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema according to ANSI SQL:2003 standard. The generator may also produce a database schema specification for Microsoft SQL Server or Oracl

APA, Harvard, Vancouver, ISO, and other styles

7

Suharjito, Suharjito, Raymond Raymond, and Ida Ratna. "DATABASE OF MIGRATION AND REPLICATION WITH ORACLE GOLDEN GATE." CommIT (Communication and Information Technology) Journal 8, no. 2 (2014): 62. http://dx.doi.org/10.21512/commit.v8i2.597.

Full text

Abstract:

The main goal of this research is to analyze and design a database configuration of migration and replication in PT Metro Batavia. Research methodologies used in this research are data collecting, analysis and design model. Data collecting method is conducted with library research and direct survey in the company. Analysis method is conducted by analyzing hangar system, migration and reflection process and the available problems. Design method is conducted by designing a prototype for migration process with the implementation of Oracle SQL Developer and replication process with implementation

APA, Harvard, Vancouver, ISO, and other styles

8

N. Gedam, Madhuri, and B. B. Meshram. "Database Private Security Jurisprudence: A Case Study using Oracle." International Journal of Database Management Systems 13, no. 03 (2021): 01–21. http://dx.doi.org/10.5121/ijdms.2021.13301.

Full text

Abstract:

Oracle is one of the largest vendors and the best DBMS solution of Object Relational DBMS in the IT world. Oracle Database is one of the three market-leading database technologies, along with Microsoft SQL Server's Database and IBM's DB2. Hence in this paper, we have tried to answer the million-dollar question “What is user’s responsibility to harden the oracle database for its security?” This paper gives practical guidelines for hardening the oracle database, so that attacker will be prevented to get access into the database. The practical lookout for protecting TNS, Accessing Remote Server a

APA, Harvard, Vancouver, ISO, and other styles

9

Pasupuleti, Krishna Kantikiran, Jiakun Li, Hong Su, and Mohamed Ziauddin. "Automatic SQL Error Mitigation in Oracle." Proceedings of the VLDB Endowment 16, no. 12 (2023): 3835–47. http://dx.doi.org/10.14778/3611540.3611568.

Full text

Abstract:

Despite best coding practices, software bugs are inevitable in a large codebase. In traditional databases, when errors occur during query processing, they disrupt user workflow until workarounds are found and applied. Manual identification of workarounds often relies on a trial-and-error method. The process is not only time-consuming but also requires domain expertise that users are often lacking. In this paper, we propose a framework to automatically mitigate errors that occur during query compilation (including optimization and code generation) without any user intervention. An error is inte

APA, Harvard, Vancouver, ISO, and other styles

10

Wu, Yun, Zhi Xiong Zhang, and Wen Li Zhang. "Research of Oracle Database Performance Optimization in University Educational Management System Based on Information Technology." Advanced Materials Research 1023 (August 2014): 233–36. http://dx.doi.org/10.4028/www.scientific.net/amr.1023.233.

Full text

Abstract:

University educational management system is the core part of digital campus, this paper uses Oracle 11g database to study the educational management system, Oracle database performance directly impacts on the performance of management system, so the Oracle performance optimization is more and more attention to, the database performance optimization begins from the database design stage, through the database deployment stage and SQL realize process's optimization, to realize university educational management system Oracle database performance optimization goals.

APA, Harvard, Vancouver, ISO, and other styles

11

Góźdź, Rafał, and Maria Skublewska-Paszkowska. "Analiza możliwości zarządzania bazą danych przechowywaną w chmurze." Journal of Computer Sciences Institute 2 (December 30, 2016): 127–32. http://dx.doi.org/10.35784/jcsi.128.

Full text

Abstract:

W artykule przedstawiono porównawczą analizę wydajnościową wybranych systemów baz danych. Porównano czasy wykonania zapytań SQL przez przygotowane bazy danych działające w usłudze chmurowej. Przygotowana baza danych Northwind działająca na SQL Server została przeniesiona na systemy Oracle i PostgreSQL, a następnie trzy wymienione bazy zostały umieszczone w chmurze Microsoft Azure. Proces badawczy został podzielony na trzy etapy. W pierwszej kolejności analizie podlegają zapytania typu Select. W drugim etapie analiza skupia się na kwestii wydajności zapytań SQL DDL, a końcowy etap opisuje anali

APA, Harvard, Vancouver, ISO, and other styles

12

Kusi, Rajan, Kabir Kumar Sinkemana, Sanjeeb Prasad Pandey, and Shashidhar Ram Joshi. "SQL Optimization in Oracle using Hybrid Genetic and Ant Colony Algorithm." Nepal Journal of Science and Technology 21, no. 2 (2022): 21–28. http://dx.doi.org/10.3126/njst.v21i2.62353.

Full text

Abstract:

In this paper, the input user Structured Query Language (SQL) query is converted into an optimized SQL query using a hybrid algorithm. The main aim is to reduce query execution time using PHP language and oracle database. These performance has been evaluated using different performance metrics: Cost of individuals, Query execution time. The hybrid algorithm method combines the evolutionary effect of the Genetic Algorithm (GA) and the cooperative effect of Ant Colony Optimization (ACO). A GA with a great global converging rate aims to produce an initial optimum for allocating initial pheromones

APA, Harvard, Vancouver, ISO, and other styles

13

Wang, Rui, and Na Wang. "Research on Technology of CRM Stored Procedure." Applied Mechanics and Materials 519-520 (February 2014): 17–20. http://dx.doi.org/10.4028/www.scientific.net/amm.519-520.17.

Full text

APA, Harvard, Vancouver, ISO, and other styles

14

Abdurashidova, Kamola Turgunbaevna, and Umidjon Ilxom o'g'li Ochilboyev. "ORACLE ma'lumotlar bazasi." JOURNAL OF UNIVERSAL SCIENCE RESEARCH 1, no. 6 (2023): 907–10. https://doi.org/10.5281/zenodo.8083694.

Full text

Abstract:

Bugungi kunda ma 'lumotlar oqimi ko 'payib borgani sari, ularni qayta ishlash, saqlash va ma'lumotlar ustida amallarni bajarish dolzarb mavjuga aylanmoqda. Ushbu maqolada ma'lumotlar bazasini boshqarish tizimlaridan eng mashhurlari tahlil qilindi, ularning kamchilik va afzalliklari o'rganildi.

APA, Harvard, Vancouver, ISO, and other styles

15

He, Li Jun, De Gao Wang, Shu Zhe Bao, and Jian Yun. "Implementation of the Object-Oriented Data Model in Oracle Database." Applied Mechanics and Materials 44-47 (December 2010): 3849–53. http://dx.doi.org/10.4028/www.scientific.net/amm.44-47.3849.

Full text

Abstract:

Oracle is a database management system supporting the object-oriented data model that is usually adopted by the storage technology of persistent object. This paper describes the main features and characteristics that an object-oriented database system must have to qualify as an object-oriented data model. The paper introduces how to describe and implement the main modeling elements of the object-oriented data model in Oracle database which are the main components of class diagram, including the class, attribute, method, inheritance and polymerization. The examples of SQL that the paper offers

APA, Harvard, Vancouver, ISO, and other styles

16

Partha, Sarathi Mohapatra. "Integrating AWS with SQL Databases." International Journal of Research in Engineering & Science ISSN:(P) 2572-4274 (O) 2572-4304 9, no. 2 (2025): 35–59. https://doi.org/10.5281/zenodo.15488890.

Full text

Abstract:

SQL databases have been in use for many years and have become the favorite data management system for many enterprise applications. However, like every other technology, SQL databases have their pros and cons. Even though the benefits of SQL databases may outweigh their shortcomings, the recent surge in the number of new technologies, such as NoSQL databases, data lakes, and cloud computing, have made many organizations rethink their SQL database usage. This book’s intent is to overcome the shortcomings or hurdles of SQL databases and let organizations take advantage of the benefits whil

APA, Harvard, Vancouver, ISO, and other styles

17

Amrish, Srivastava. "Enable Auditing in Oracle database." International Journal of Trend in Scientific Research and Development 4, no. 1 (2019): 1214–15. https://doi.org/10.5281/zenodo.3610059.

Full text

Abstract:

Auditing is the observing and recording of selected user database activities. It can be recorded individual actions, like type of SQL statement executed, action performed in database and can also observe any factors that can include user, application, and time. Based on the company security policies trigger auditing in an Oracle database are accessed. Amrish Srivastava "Enable Auditing in Oracle database" Published in International Journal of Trend in Scientific Research and Development (ijtsrd), ISSN: 2456-6470, Volume-4 | Issue-1 , December 2019, URL: https://www.ijtsrd.com/papers/

APA, Harvard, Vancouver, ISO, and other styles

18

Repas, Diogo, Zhicheng Luo, Maxime Schoemans, and Mahmoud Sakr. "Selectivity Estimation of Inequality Joins in Databases." Mathematics 11, no. 6 (2023): 1383. http://dx.doi.org/10.3390/math11061383.

Full text

Abstract:

Selectivity estimation refers to the ability of the SQL query optimizer to estimate the size of the results of a predicate in the query. It is the main calculation based on which the optimizer can select the least expensive plan to execute. While the problem has been known since the mid-1970s, we were surprised that there are no solutions in the literature for the selectivity estimation of inequality joins. By testing four common database systems: Oracle, SQL-Server, PostgreSQL, and MySQL, we found that the open-source systems PostgreSQL and MySQL lack this estimation. Oracle and SQL-Server ma

APA, Harvard, Vancouver, ISO, and other styles

19

Yelis, Yelis, Ranti Aryanti, Daffa Azhari Renaldi, Nicolas Matthew Tampubolon, and Yudi Prastyo. "Literatur Review : Analisa Penggunaan System Database Oracle Pada Sektor Manufactur." Jurnal Locus Penelitian dan Pengabdian 4, no. 1 (2025): 1079–85. https://doi.org/10.58344/locus.v4i1.3781.

Full text

Abstract:

Penggunaan sistem database berbasis Oracle telah menjadi kebutuhan strategis di sektor manufaktur dalam era transformasi digital dan globalisasi. Perusahaan manufaktur menghadapi tantangan pengelolaan data yang besar dan kompleks, sehingga diperlukan solusi teknologi yang andal dan efisien. Artikel ini bertujuan untuk menganalisis penerapan Oracle Database di sektor manufaktur, dengan menyoroti manfaat, tantangan, dan efektivitasnya dalam mendukung efisiensi operasional dan pengambilan keputusan. Penelitian ini menggunakan metode studi literatur yang mengacu pada berbagai jurnal, artikel, dan

APA, Harvard, Vancouver, ISO, and other styles

20

Blankley, Alan I. "Using SQL to Develop Database Query Proficiency: A Follow-Up Note to Borthick, Jones, and Kim (2001)." Journal of Information Systems 20, no. 1 (2006): 117–37. http://dx.doi.org/10.2308/jis.2006.20.1.117.

Full text

Abstract:

In the Spring 2001 issue of Journal of Information Systems (JIS), Borthick et al. (2001) presented a case in which students were to query a Microsoft Access database in order to determine the mutual assurance concerning customer service for an automobile manufacturer and its local dealer network. I follow-up this case by presenting an additional teaching note to the case that develops query strategies and solutions for the case using Oracle and its SQL application, SQL-Plus.

APA, Harvard, Vancouver, ISO, and other styles

21

Dziewit, Grzegorz, Jakub Korczyński, and Maria Skublewska-Paszkowska. "Performance analysis of relational databases Oracle and MS SQL based on desktop application." Journal of Computer Sciences Institute 8 (November 30, 2018): 263–69. http://dx.doi.org/10.35784/jcsi.693.

Full text

Abstract:

Comparison of efficiency is not a trivial phenomenon because of disparities between different database systems. This paper presents a methodology of comparing relational database systems in respect of mean time of execution individual DML queries containing subqueries and conjunction of tables. The presented methodology can be additionally accommodated to studies of efficiency in a range of database system itself (study of queries executed directly in database engine). The described methodology allows to receive statement telling which database system is better in comparison to another in depe

APA, Harvard, Vancouver, ISO, and other styles

22

Hidayati, Ilma Nur, Tien Fabrianti Kusumasari, and Faqih Hamami. "Comparison of Apache SparkSQL and Oracle Performance: Case Study of Data Cleansing Process." JOIV : International Journal on Informatics Visualization 6, no. 1-2 (2022): 208. http://dx.doi.org/10.30630/joiv.6.1-2.928.

Full text

Abstract:

A dataset with good quality is a valuable asset for a company. The data can be processed into information to help companies improve decision-making. However, the data increased more and more over time to decrease data quality. Thus, good data management is important to keep data quality meeting company standards. One of the efforts that can be done is conducting data cleansing to clean data from errors, inaccuracies, duplication, format discrepancies, etc. Apache Spark is an engine that can analyze large amounts of data. Oracle Database is a database management system used to manage databases.

APA, Harvard, Vancouver, ISO, and other styles

23

Syed, Ashraf. "Performance Analysis of Oracle APEX Applications in Multi-Tenant Cloud Environments." International Scientific Journal of Engineering and Management 04, no. 04 (2025): 1–9. https://doi.org/10.55041/isjem03278.

Full text

Abstract:

The rapid adoption of multi-tenant cloud environments has transformed how enterprises deploy database- driven applications, offering cost efficiency and streamlined management. Oracle Application Express (APEX), a leading low-code platform integrated with Oracle Database, is increasingly utilized in such setups to develop scalable web applications. This paper investigates the performance of APEX applications within multi-tenant cloud environments, leveraging Oracle Database Multitenant architecture. We configured a container database (CDB) hosting multiple pluggable databases (PDBs), each runn

APA, Harvard, Vancouver, ISO, and other styles

24

Ибрагимов, И. Р., та И. А. Магомедов. "Шифрование данных и его виды". ТЕНДЕНЦИИ РАЗВИТИЯ НАУКИ И ОБРАЗОВАНИЯ 92, № 10 (2022): 97–99. http://dx.doi.org/10.18411/trnio-12-2022-490.

Full text

Abstract:

Шифрование данных является одной из многих функций, необходимых для защиты информации, и может потребоваться для выполнения многих требований соответствия. Большинство современных баз данных, включая Oracle, Microsoft SQL и MySQL, включают процедуры шифрования данных. В данной статье мы рассмотрим понятие «шифрование данных» и какие виды в нем выделяют.

APA, Harvard, Vancouver, ISO, and other styles

25

Adnan, Nada. "Automatic Determining Of Candidate Keys Sets Depending On Functional Dependency." Journal of Al-Rafidain University College For Sciences ( Print ISSN: 1681-6870 ,Online ISSN: 2790-2293 ), no. 2 (October 24, 2021): 183–202. http://dx.doi.org/10.55562/jrucs.v25i2.455.

Full text

Abstract:

This paper presents a step in automatic database design, re-engineering and schema modification, design weak points detection, and normalization. This step represents determining the candidate keys of the tables automatically via proposing and implementing an algorithm which depends on the functional dependency and attribute set closure. Also, some techniques of Apriori algorithm of association rule mining are used to generate keys and minimize the keys space. The implementation is done by using Oracle PL/SQL to utilize the facilities provided by ORACLE DBMS and to give the features of embedde

APA, Harvard, Vancouver, ISO, and other styles

26

Dimitrov, Vladimir. "Codd's Recommendations for Date & Time Data Types and its implementations in ISO SQL, DB2, Oracle, and Transact-SQL." Serdica Journal of Computing 12, no. 4 (2019): 247–64. http://dx.doi.org/10.55630/sjc.2018.12.247-264.

Full text

Abstract:

Date and time data types are very important for business. From the point of view of the relational model of data, these data types are simply atomic domains - their structure and operations are unimportant. After the initial introduction of the relational model of data and the next following implementations based on that model, Codd, in Version 2 of the relational model of data, corrected his point of view introducing 14 recommendations about date and time data types. This paper investigates implementations of date and time data types in ISO SQL, DB2, Oracle and Transact-SQL.

APA, Harvard, Vancouver, ISO, and other styles

27

Cheng, Jian Hui, Cheng Jin, and Ran Zhao. "General Design and Implementation of Heterogeneous Data Conversion Tools." Applied Mechanics and Materials 303-306 (February 2013): 2249–53. http://dx.doi.org/10.4028/www.scientific.net/amm.303-306.2249.

Full text

Abstract:

We will undertake an in-depth analysis of the data conversion,and take a detailed study of thoughts and realization methods of data conversion. On the basis of methods above-mentioned,we design and implement the sofeware of the data conversion between the heterogeneous databases of MS SQL Server,Oracle,Access,Excel.

APA, Harvard, Vancouver, ISO, and other styles

28

Sugiarto, Bambang, Argan Imam Bagusputra, and Samidi Samidi. "Optimasi Kueri pada Database Oracle Melalui Indeks dan Partisi Tabel untuk Data Besar." Jurnal Pendidikan dan Teknologi Indonesia 5, no. 7 (2025): 1845–56. https://doi.org/10.52436/1.jpti.862.

Full text

Abstract:

Mengoptimalkan kinerja database sangat krusial di era dominasi data. Pertumbuhan data eksponensial, khususnya pada data Kredit Usaha Rakyat (KUR) sejumlah 227.587.131 baris di database Oracle yang digunakan dalam penelitian ini, menjadi tantangan utama. Eksekusi kueri SQL yang lambat menghambat efisiensi operasional. Penelitian ini menerapkan strategi optimasi kinerja database Oracle melalui teknik pengindeksan (indeks tunggal dan komposit) dan partisi tabel berdasarkan rentang (kolom tahun). Kedua teknik ini bertujuan mempercepat pengambilan data dan meningkatkan efisiensi akses pada tabel be

APA, Harvard, Vancouver, ISO, and other styles

29

Bernal Ontiveros, Juan Manuel, Francisco Zorrilla Briones, Noé Ramón Rosales Morales, Margarita Bailón Estrada, and Marisela Palacios Reyes. "Proceso de seguridad para evitar la infiltración de inyección SQL (SQL injection)." REVISTA IPSUMTEC 5, no. 1 (2022): 52–62. https://doi.org/10.61117/ipsumtec.v5i1.99.

Full text

Abstract:

Las bases de datos son por demás importantes y utilizadas extensamente en los procesos productivos y de servicios en muchas organizaciones; estas bases de datos contienen, en muchos casos, datos sensibles para el(los) dueño(s) de los mismos y se almacenan en sistemas gestores de bases de datos, tales como Oracle, Microsoft SQL Server, entre otros. Atacar una base de datos es uno de los objetivos favoritos para los criminales cibernéticos. Estas bases de datos se han convertido, desde hace tiempo, en un gran blanco para los atacantes que buscan información de interés. Uno de los usos de las bas

APA, Harvard, Vancouver, ISO, and other styles

30

Lin, Li, Qinglin Zhu, Hongqiao Chen, Zhuangda Wang, Rongxin Wu, and Xiaoheng Xie. "QTRAN: Extending Metamorphic-Oracle Based Logical Bug Detection Techniques for Multiple-DBMS Dialect Support." Proceedings of the ACM on Software Engineering 2, ISSTA (2025): 731–52. https://doi.org/10.1145/3728908.

Full text

Abstract:

Metamorphic testing is a widely used method to detect logical bugs in Database Management Systems (DBMSs), referred to herein as MOLT (Metamorphic-Oracle based Logical Bug Detection Technique). This technique involves constructing SQL statement pairs, including original and mutated queries, and assessing whether the execution results conform to predefined metamorphic relations to detect logical bugs. However, current MOLTs rely heavily on specific DBMS grammar to generate valid SQL statement pairs, which makes it challenging to adapt these techniques to various DBMSs with different grammatical

APA, Harvard, Vancouver, ISO, and other styles

31

Paci, Hakik. "Protecting Oracle PL/SQL Source Code From a DBA User." International Journal of Database Management Systems 4, no. 4 (2012): 43–52. http://dx.doi.org/10.5121/ijdms.2012.4404.

Full text

APA, Harvard, Vancouver, ISO, and other styles

32

Murti, Darlis Heru, Firman Azizi, and Esther Hanaya. "PERANGKAT BANTU UNTUK OPTIMASI QUERY PADA ORACLE DENGAN RESTRUKTURISASI SQL." JUTI: Jurnal Ilmiah Teknologi Informasi 5, no. 2 (2006): 118. http://dx.doi.org/10.12962/j24068535.v5i2.a237.

Full text

APA, Harvard, Vancouver, ISO, and other styles

33

Jankauskas, Robertas, and Dmitrij Šešok. "Duomenų migravimo iš OLTP į OLAP duomenų bazę greitaveikos tyrimas." Jaunųjų mokslininkų darbai 47, no. 2 (2017): 42–49. http://dx.doi.org/10.21277/jmd.v47i2.136.

Full text

Abstract:

Duomenų sinchronizacija tarp kelių sistemų yra vienas iš dažniausiai pasitaikančių procesų. Iš esamų duomenų norima atlikti analizę, kuria naudojantis būtų galima priimti tam tikrus sprendimus, padėsiančius pateikti išvadas apie organizacijų veiklas. Šiame darbe analizuojamas duomenų migravimo procesas tarp „Oracle“ ir „Microsoft SQL Server“ duomenų bazių valdymo sistemų naudojantis skirtingomis duomenų įkėlimo metodologijomis ir sistemų teikiamomis technologijomis.

APA, Harvard, Vancouver, ISO, and other styles

34

Hussein, Dana Lattef. "Evaluating Aggregate Functions and Machine Learning Integration: A Comparative Analysis of Performance, Security, and NoSQL Connectivity in Oracle, SQL Server, and MySQL." UHD Journal of Science and Technology 8, no. 2 (2024): 7–23. http://dx.doi.org/10.21928/uhdjst.v8n2y2024.pp7-23.

Full text

Abstract:

This paper is a comparison study on aggregate functions and windows function between the three major Relational Database Management Systems (RDBMSs): Oracle, SQL Server, and MySQL. These functions are essential to handle a huge data set and prepare it for effective analysis. The research is conducted to analyse the performance of these systems, their utilization of resources, while executing aggregate queries. Further, this paper examines the integration of machine-learning abilities and NoSQL database connectivity within these platforms. All these were measured under a constant benchmarking f

APA, Harvard, Vancouver, ISO, and other styles

35

Nindito, Hendro, Evaristus Didik Madyatmadja, and Albert Verasius Dian Sano. "Replikasi Unidirectional pada Heterogen Database." ComTech: Computer, Mathematics and Engineering Applications 4, no. 2 (2013): 1280. http://dx.doi.org/10.21512/comtech.v4i2.2656.

Full text

Abstract:

The use of diverse database technology in enterprise today can not be avoided. Thus, technology is needed to generate information in real time. The purpose of this research is to discuss a database replication technology that can be applied in heterogeneous database environments. In this study we use Windows-basedMS SQL Server database to Linux-based Oracle database as the goal. The research method used is prototyping where development can be done quickly and testing of working models of the interaction process is done through repeated. From this research it is obtained that the database repli

APA, Harvard, Vancouver, ISO, and other styles

36

Lorena Lazo, Paul, and Edgar Ruiz Lizama. "REUTILIZACIÓN DE SOFTWARE Y SU IMPACTO EN EL COSTO DEL SISTEMA." Industrial Data 7, no. 2 (2014): 052. http://dx.doi.org/10.15381/idata.v7i2.6134.

Full text

Abstract:

El artículo presenta dos programas en C# que utilizan un componente de acceso de base de datos SQL Server 2002, el cual se modifica para ser utilizado con una Base de Datos Oracle 9i, a fin de evaluar la productividad de un desarrollador realizando el análisis comparativo de 2 escenarios: un sistema desarrollado reutilizando software, y otro sin reutilización de software.

APA, Harvard, Vancouver, ISO, and other styles

37

Ran, Qing Yun, and Jie Zhang. "Comparative Study on Currently Popular Network Databases." Applied Mechanics and Materials 380-384 (August 2013): 2629–32. http://dx.doi.org/10.4028/www.scientific.net/amm.380-384.2629.

Full text

Abstract:

With the continuous expansion of the amount of data resources, network databases are becoming increasingly critical to the development of enterprises. This paper is a comparative analysis and study on the basic information, characteristics and performance of the currently popular network databases, mainly including Oracle, DB2 of IBM, Informix Dynamic Server products, Adaptive Server of Sybase and SQL Server of Software.

APA, Harvard, Vancouver, ISO, and other styles

38

Rakesh Jena, Krishna Kishor Tirupati, Pronoy Chopra, Er. Aman Shrivastav, Shalu Jain, and Prof. (Dr) Sangeet Vashishtha. "Advanced Database Security Techniques in Oracle Environments." Darpan International Research Analysis 12, no. 3 (2024): 811–44. http://dx.doi.org/10.36676/dira.v12.i3.133.

Full text

Abstract:

This research paper proposes a comprehensive framework for integrating advanced database security techniques in Oracle environments to address emerging security threats and compliance challenges. The study focuses on implementing a multi-layered security strategy that combines data encryption, role-based access control (RBAC), Oracle Database Vault, dynamic data masking, and real-time monitoring using Oracle Audit Vault and Database Firewall (AVDF). The framework is designed to safeguard sensitive data, prevent unauthorized access, mitigate insider threats, and ensure compliance with regulatio

APA, Harvard, Vancouver, ISO, and other styles

39

Yash, Jani. "Strategies for Seamless Data Migration in Large-Scale Enterprise Systems." Journal of Scientific and Engineering Research 6, no. 12 (2019): 285–90. https://doi.org/10.5281/zenodo.13347837.

Full text

Abstract:

Data migration is a critical process in the evolution of enterprise systems, particularly when transitioning from traditional relational databases like SQL Oracle to NoSQL solutions like MongoDB. This paper explores comprehensive strategies for successful data migration in large-scale environments, emphasizing meticulous planning, efficient execution, and thorough post-migration verification. Drawing on practical experiences, this study provides actionable insights and best practices to mitigate risks and ensure data integrity during migration, with a focus on the limitations and challenges of

APA, Harvard, Vancouver, ISO, and other styles

40

Рустамов, Бахтиёр Нормаматович. "ORACLE МАЪЛУМОТЛАР БАЗАСИНИ БОШҚАРИШ ТИЗИМИДА МАЪЛУМОТЛАРНИ ҚИДИРИШНИ ТЕЗЛАШТИРИШ УСУЛЛАРИ". "Science and Innovation" international scientific journal 1, № 1 (2022): 5–8. https://doi.org/10.5281/zenodo.6462720.

Full text

Abstract:

<em>Ушбу мақолада oracle маълумотлар базасини бошқариш тизимида (МББТ) маълумотлар жуда кўп бўлганда, улар ичидан кераклисини ажратиб олишни тезлаштириш усулларини шакллантириш кўриб чиқилган. Бир қанча оптимал вариантлар тажрибада синаб кўрилган.</em>

APA, Harvard, Vancouver, ISO, and other styles

41

G.A, Ambrosius Ludang, and Evangs Mailoa. "Pengembangan Sistem Oracle Forms untuk Optimisasi Proses Penjualan di PT.XYZ." Jurnal Indonesia : Manajemen Informatika dan Komunikasi 5, no. 2 (2024): 1532–42. http://dx.doi.org/10.35870/jimik.v5i2.711.

Full text

Abstract:

This research focuses on the development of an efficient sales system for PT. XYZ a retail company in Indonesia. The company faces challenges in its sales processes due to the lack of efficiency in the manual system, which is susceptible to errors. The research aims to optimize the sales process by utilizing Oracle Forms 10g and implementing the Rapid Application Development (RAD) methodology to ensure timely solutions. The developed system demonstrates a significant improvement in efficiency, accuracy, and speed. The use of Oracle Forms and SQL Developer simplifies data entry and management p

APA, Harvard, Vancouver, ISO, and other styles

42

Khudaiberdiev, Sakhobiddin Abdurayimovich. "ANALYSING THE MOST CURRENT SERVER-BASED DATABASE MANAGEMENT SYSTEMS." Nazariy va amaliy tadqiqotlar xalqaro jurnali - SJ International journal of theoretical and practical research 5, no. 3 (2023): 36–47. https://doi.org/10.5281/zenodo.8159175.

Full text

Abstract:

<em>This paper discusses the signs by which it is possible to analyze the advantages and disadvantages of database management systems (DBMS). The main criteria considered in the study are performance, scalability, data availability, server functionality, DBMS openness, as well as the availability of development and administration tools for the most up-to-date DBMS, such as DB2, Oracle, Microsoft SQL Server and Informix. During the performance analysis, the indicators of query execution speed, transaction processing and scalability of the system with an increase in data volume are considered. D

APA, Harvard, Vancouver, ISO, and other styles

43

Deshmukh, Om. "Data Migration Techniques across DBMS by Using Metadata." International Journal for Research in Applied Science and Engineering Technology 10, no. 12 (2022): 457–63. http://dx.doi.org/10.22214/ijraset.2022.47846.

Full text

Abstract:

Abstract: The data migration process is usually needed when there is a change in system, format, or storage type. Currently, there are several techniques and tools for migrating data, for example, CSV files, ODBC, SQL Dump, and so on. Inappropriately not all of these techniques can be implemented for migrating data between two different DBMS. This research describes a data migration technique that can be used to migrate data across DBMS. The data migration technique described makes use of existing metadata in each DBMS. The data migration process described here goes through three stages, namel

APA, Harvard, Vancouver, ISO, and other styles

44

Khan, Wisal, Teerath Kumar, Cheng Zhang, Kislay Raj, Arunabha M. Roy, and Bin Luo. "SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review." Big Data and Cognitive Computing 7, no. 2 (2023): 97. http://dx.doi.org/10.3390/bdcc7020097.

Full text

Abstract:

The competent software architecture plays a crucial role in the difficult task of big data processing for SQL and NoSQL databases. SQL databases were created to organize data and allow for horizontal expansion. NoSQL databases, on the other hand, support horizontal scalability and can efficiently process large amounts of unstructured data. Organizational needs determine which paradigm is appropriate, yet selecting the best option is not always easy. Differences in database design are what set SQL and NoSQL databases apart. Each NoSQL database type also consistently employs a mixed-model approa

APA, Harvard, Vancouver, ISO, and other styles

45

B. Kalaiselvi, B. Kalaiselvi, Mannepalle Sai Chandu, Maridhu Narendra, and Mannepalle Deekshith Kumar. "SQL-Injection Vulnerability Scanning Tool for Automatic Creation of SQL-Injection Attacks." International Journal of Advances in Engineering and Management 7, no. 1 (2025): 577–87. https://doi.org/10.35629/5252-0701577587.

Full text

Abstract:

This research introduces an advanced automated scanning tool for detecting and analyzing SQL injection vulnerabilities in web applications, addressing the critical need for robust security testing mechanisms in modern web development. The proposed tool employs sophisticated dynamic analysis techniques combined with machine learning algorithms to automatically generate, execute, and validate SQL injection attack vectors. By implementing a multilayered detection approach, the system first identifies potential injection points through comprehensive input parameter analysis, followed by intelligen

APA, Harvard, Vancouver, ISO, and other styles

46

Kusejko, Katharina, Daniel Smith, Alexandra Scherrer, et al. "Migrating a Well-Established Longitudinal Cohort Database From Oracle SQL to Research Electronic Data Entry (REDCap): Data Management Research and Design Study." JMIR Formative Research 7 (May 31, 2023): e44567. http://dx.doi.org/10.2196/44567.

Full text

Abstract:

Background Providing user-friendly electronic data collection tools for large multicenter studies is key for obtaining high-quality research data. Research Electronic Data Capture (REDCap) is a software solution developed for setting up research databases with integrated graphical user interfaces for electronic data entry. The Swiss Mother and Child HIV Cohort Study (MoCHiV) is a longitudinal cohort study with around 2 million data entries dating back to the early 1980s. Until 2022, data collection in MoCHiV was paper-based. Objective The objective of this study was to provide a user-friendly

APA, Harvard, Vancouver, ISO, and other styles

47

Liang, Yong Chao, Xi Jia Zhang, and Tian Yi Zhu. "Using the ORACLE Database Management for 500kV Transmission Line Fault Features." Applied Mechanics and Materials 336-338 (July 2013): 2083–86. http://dx.doi.org/10.4028/www.scientific.net/amm.336-338.2083.

Full text

Abstract:

Through the analysis in SCADA systems data of Hunan province electric power maintenance company, found out transmission line fault types, switch and protection action information table of 500kv. Using ORACLEs PL/SQL statements to help the data be neat and also with data preprocessing. Fault features needed for mining properties can fully reflect the fault information, use VS2010 tool programming, data can be carried out in time, space multi-dimensional queries, the researchers used software can dig out the failure rules, increase the efficiency of the data.

APA, Harvard, Vancouver, ISO, and other styles

48

Holt, Tom G., Claude Dufresne, Jerrold M. Liesch, and Gary K. Mallow. "The Design and Development of an Integrated Natural Products Screening Database." Journal of Biomolecular Screening 5, no. 6 (2000): 421–33. http://dx.doi.org/10.1177/108705710000500605.

Full text

Abstract:

We designed and developed NEXUS—a new natural products screening database and related suite of software applications-to utilize the spectacular increases in assay capacity of the modern high throughput screening (HTS) environment. NEXUS not only supports seamless integration with separate HTS systems, but supports user-customized integration with external laboratory automation, particularly sample preparation systems. Designed and developed based on a detailed process model for natural products drug discovery, NEXUS comprises two integrated parts: (1) a single schema of Oracle tables and calla

APA, Harvard, Vancouver, ISO, and other styles

49

Łata, Zygmunt, and Maria Skublewska-Paszkowska. "Performance analysis of databases created in virtualized and containerized environment." Journal of Computer Sciences Institute 28 (September 30, 2023): 264–72. http://dx.doi.org/10.35784/jcsi.3743.

Full text

Abstract:

Database systems are currently implemented on different environments - containerized and virtualized. This paper aimed to compare the performance of relational databases running on these two environments. Therefore, two research hypotheses were formulated. The first hypothesis assumed that databases running on Docker containers are more efficient than those on virtual machines. The second one assumed that the Oracle is the most efficient database regardless of which environment it was run on. MySQL, PostgreSQL, Microsoft SQL Server and Oracle databases were tested. The study measured the execu

APA, Harvard, Vancouver, ISO, and other styles

50

Moreno Arboleda, Francisco Javier, Guillermo Ospina Romero, and Rafael Larios Restrepo. "The performance of relational and object-relational SQL queries when using Oracle." Ingeniería e Investigación 25, no. 3 (2005): 4–12. http://dx.doi.org/10.15446/ing.investig.v25n3.14658.

Full text

Abstract:

This article presents a study in which the performance of several queries involving GROUP BY clause, sub-queries (using IN and EXISTS clauses) and joins are measured and compared by means of specific queries. The behavior of relational and object-relational models is also shown.

APA, Harvard, Vancouver, ISO, and other styles

We offer discounts on all premium plans for authors whose works are included in thematic literature selections. Contact us to get a unique promo code!