All Questions
13 questions
2
votes
0
answers
39
views
Where sk = null clause gives an error when used in a query but not in a stored procedure in teradata
In teradata sql I get an error when I use
sel *
from table
where sk = null
However if I include this in a stored procedure and pass a null value in the parameter I don't.
replace procedure(In name ...
- 21
-3
votes
1
answer
66
views
MYSQL workbench like gui tool for oracle 10 g or more
I am a java full stack developer who want to write oracle sql queries to simplify writing is there any mysql workbench like similar gui tool for oracle by oracle or any other please sugest
1
vote
2
answers
461
views
Update Ledger Table In double entry accounting when there are millions of entries
I am creating an double entry accounting software where I have ledger table along with other tables. My cash account ledger table for is similar to following:
ledger_id
ledger_name
...
1
vote
1
answer
62
views
How does MySQL maintain confidentiality of files?
In a DBMS like MySQL, are the underlying files that contain the data encrypted since we want to have role and user based control? If they are encrypted, what encryption keys and algorithms are used? ...
- 111
0
votes
0
answers
20
views
Should I use many database in one application?
Currently I am working on a project of a management software. This software is currently in built with an old technology (Codeigniter-PHP). My job is to convert this software to latest technology (...
0
votes
1
answer
175
views
What could be the best DBMS to store airbnb data for price prediction [closed]
I have a school project in which I need to predict the airbnb listings prices in 5 different cities.
So I have about 400,000 records each with 19 columns.
All the examples on the internet that are ...
- 103
-1
votes
1
answer
30
views
Database design normalization elearning portal
Table : Class
Here the className is unique
classId| className
-------|---------
1 | 1st Class
2 | 2nd Class
3 | 3rd Class
4 | 4th Class
Table: Subject
In the Subject table ...
- 101
0
votes
1
answer
942
views
MySQL write performance after truncate & optimize [closed]
Once a year we truncate a table of several GBs and millions of rows and then run optimize in order to shrink the size of the corresponding ibd file on the file system.
However, as this is write ...
- 101
1
vote
1
answer
105
views
Physical co-clustering of two or more logical relations/tables in modern RDBMS
One possible approach to optimize search queries is (a) to store the records that retain data that corresponds to different relations/tables in (b) the same file → on the same pages. That way, a join ...
- 285
1
vote
0
answers
322
views
DBMS Query Preprocessor Checks Semantics or Syntax?
I encountered the following statement when reading about the constituents of a query processor in a DBMS:
... (b) A query preprocessor, which performs semantic checks on the query (e.g., making ...
- 111
0
votes
1
answer
55
views
_Batch_ priorities in PostgreSQL
I would want to tag many queries and mostly materialised view refreshing tasks as low priority in my RDBMS, in the fashion I run the web browser on the local machine as low priority (because JS, CSS, ...
- 96
2
votes
0
answers
183
views
Understanding multivalued dependencies
This is my first time studying multivalued dependencies and there is a question that was posted by my lecturer as a class exercise. I have an answer, but I'm not 100% sure it was right. Please let me ...
- 21
1
vote
0
answers
77
views
Logical data independence
I have a basic doubt about logical data independence. I read that in logical independence, we can remove attributes from relation without affecting external schema.
How can the removal of attribute ...
- 121