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
3
votes
4
answers
517
views
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
14
votes
10
answers
10k
views
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-...
- 396
1
vote
1
answer
210
views
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
50
votes
4
answers
10k
views
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
6
votes
1
answer
658
views
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 ...
- 245
2
votes
2
answers
3k
views
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
0
votes
1
answer
154
views
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 ...
0
votes
2
answers
2k
views
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
0
votes
1
answer
220
views
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 ...
1
vote
1
answer
458
views
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 ...
0
votes
3
answers
589
views
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
0
votes
1
answer
93
views
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
1
vote
2
answers
80
views
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
1
vote
1
answer
285
views
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 ...
- 190
1
vote
0
answers
686
views
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