Questions tagged [oracle]
Oracle Corporation is a multinational computer technology company mostly known for its "Oracle" RDBMS and - since the acquisition of Sun Microsystems - for Java and MySQL.
77 questions
3votes
4answers
461views
Encryption of PII data in database logic in store procedures and desktop application [closed]
I have an old desktop application (Delphi) with logic in stored procedures (Oracle). The application is storing some personal data including salaries. I want to encrypt data so someone with db access ...
- 39
13votes
10answers
9kviews
Is there any benefit to a separate table that is one-to-one with the primary data table?
I've inherited a system with an Oracle relational database with a couple of tables modeled like I've sketched below, where there's an entire child table that only stores a single status code in a one-...
- 386
1vote
1answer
197views
Feature Store Design for input data like JSON, CSV and Excel
I need a design approach for a feature store which accepts input data in the forms of CSV, EXCEL, JSON etc. The backend stack we support is Java, Spring boot and oracle DB. Note : Each file ...
- 113
50votes
4answers
10kviews
Why are there multiple different implementations of JVM?
While going over a java book I came across this phrase: Different JVMs can run threads in profoundly different ways. While it's completely understandable to me that code can behave differently ...
- 617
6votes
1answer
626views
Solving file system dependency with database storage
I have a software project A which makes API calls to a third-party software B that is heavily based on data stored on the file system. Also, those software and file systems are distributed on servers ...
2votes
2answers
3kviews
From Oracle to Apache Parquet : how to handle eventual consistency?
I have an existing production Oracle Database. However, there are performance issues for certain kind of operations, because of the volume of the data, or the complexity of queries. That's why I ...
- 31
0votes
1answer
139views
Is it okay to use a different JDK from what my team use? [closed]
I am a new hire (as a software engineer) in a company and the Linux (Ubuntu 18.04) machine I got has no java installed. I tried to install Java SE 8 kit from Oracle but apparently there is a new ...
0votes
2answers
2kviews
Approach to handling multiple instances of an application that make large database operations simultaneously
So, essentially the flow of my application works like this: A user selects some options to start a process on the server. Once they hit submit, on the server it opens up a console application that ...
- 127
0votes
1answer
205views
Should we do data migration from Oracle via the microservices, or should we do direct data migration from Oracle to Azure SQL DBs?
We are replacing a legacy application that runs on a single Oracle DB, and the decision has been made to replace it with a microservices-based application running on Azure SQL. Do we do data ...
1vote
1answer
422views
How to safely allow different end users to insert data into a table stored in an Oracle database?
This is a basic question, but I don't have any sense of what other developers do in this scenario. The Situation I am creating an interface to allow end users to insert and update data in a table ...
0votes
3answers
569views
Duplicated formula in front and back end
I'm struggling with logic that is duplicated in the front end code and the database. Right now, I just put a comment. Here is a small example (the current system has a lot of much more complicated ...
- 153
0votes
1answer
84views
Uploading file to the server for download
I've my front end written using HTML/CSS/Javascript. Front end is communicating with the backend(Oracle database) using Java Webservices (Spring boot app). Situation #1: User clicks on the Download ...
- 161
1vote
2answers
73views
migrating data in oracle DB
I am doing data migration from DB1 to DB2. First step in that is extracting data from base tables (6 tables with one big master table which has one million records and other 5 being detail tables) in ...
- 33
1vote
1answer
272views
Strategies for managing legacy data for a medium sized enterprise
I work for a mid market manufacturing company with around 1700 internal employees and about 7000 external users (employees of our customers). We grew through acquisition which means we have many ...
1vote
0answers
675views
How to Investigate the difference between query execution times?
I have a simple query, when executed directly in SQL Developer Studio (It's an Oracle Database) takes around 4 seconds. But when executed via my Java code it takes around 20 seconds. I'm using ...
- 1,191
