Tag Info

New answers tagged

0

The Logical Storage Structures section in the Oracle Concepts Guide has a good explanation of both data blocks and data files (pages 259 - 296). There is quite a bit of good information including illustrations, but here are some excerpts: data block Smallest logical unit of data storage in Oracle Database. Other names for data blocks include Oracle ...


1

I think you might be a bit confused about virtualization. Which virtualization platform are you using? I havent come across one yet that doesnt allow you to map the drives however you choose. There are default configs and settings that allow the hypervisor to decide how to best make use of the available host's resources, but I have never seen an offering ...


0

In what's called Normalization, you want to prevent storing duplicate data. For example, it would be best to store the 'DVD' text only once in the database, not for each row that has a type of 'DVD'. To achieve this, you would create a lookup table (method 2). It will seem like extra code, but it's better in the long run. Also, if you wanted to get a list ...


0

You're correct that a new table is the best way to store it. Referencing Type from the ID of the value in a secondary table will allow you to normalize your data. This helps ensure integrity, reduce duplicate data, and allow for effective querying of any type. You're also correct that this results in the creation of several tables - welcome to the world of ...



Top 50 recent answers are included