Advantages And Disadvantages Of SQL Databases

Although the database system yields considerable advantages over previous data management approaches, database systems do carry certain disadvantages. Such as:

Economy of scale - Combining all the organization’s operational data into one database and creating a set of applications that work on this one source of data can result in cost savings. In this case, the budget that would normally be allocated to each department for the development and maintenance of its file-based system can be combined, possibly resulting in a lower total cost, leading to an economy of scale.

Storage of data plays a major role in improving the performance of a company and this can happen either offline or online and in various formats.

Asymmetric clustering: one host runs the database application while the other host simply monitors it. If the server fails, the monitoring host becomes the active server. This is appropriate for providing redundancy. However, it does not utilize the potential processing power of both hosts.

Improved performance: A distributed DBMS fragments the database to keep data closer to where it is needed most. This helps to avoid unnecessary data transfer.

In a distributed database system, all the databases or the storage devices are not connected to a single common processing unit like CPU. The various data may be stored at different physical locations in multiple computers that are located in the same physical location; or they may be inter-connected over a network. In other words, distributed database system consists of various data locations but they do not share any physical components.

This type of database management system that stores the data in the form of related tables. It is a social database administrator which deals with some typical kind of queries and uses SQL for the development of the database. This type of database is a very powerful database as it deals with the relations which makes the data manipulations easier other than any other database. It has the features of data entry, data deletion, and creating of new entry and records etc. the database provides the ease of accessing and maintaining data easily.

Relational Database Management System is a database where data is represented as a set of relations in which data is stored. RDBSM is the basic for SQL. RDBSM contains a table (Is where the data of RDBMS is stored in) and the table contains a field (It is the smaller pieces of the table/ attributes of the table.), records (Also known as a row. It is a single entry in the table. It lies horizontally on the table) and columns (Columns lie vertical on the table. It contains all of the information related to a single field/ attribute). Constraints (Rules) can be enforced on a RDBSM. Example: Unique constraint (To ensure that all the data in a column is of different values), Not Null constraints (Set in place to ensure that a columns cannot have a null value), Primary key (Ensures uniquely identified records in a table), Foreign key (Ensures that

When geographically dispersed organization, you may choose to store them Databases on a central database server, or to be distributed to local servers (or A combination of both). A distributed database is one logical database that is Spread across computers physically in multiple locations that are linked by Network data connections. We emphasize that a distributed database is really A database. Distributed database is still Centrally managed as a resource to provide local companies with flexibility And customization. The network must allow users to exchange data. And thus the user (Or program) in place A must be able to access (and possibly update) data in Place B. site had spread sites spread over a wide area system that shown in figure below

In recent years, the distributed database system has been emerging as an important area of information processing, and its popularity is increasing rapidly. A distributed database is a database that is under the control of a central DBMS in which not all storage devices are attached to a common CPU. It may be stored on multiple computers located in the same physical location, or may be dispersed over a network of interconnected computers. Collections of data (e.g., in a database) can be distributed across multiple physical locations. In short, a distributed database is a logically interrelated collection of shared data, and a description of this data is physically distributed over a computer network. A

A:- STORAGE REQUIRMENTS: There are 2 sources of capacity requirements:- business and technical requirements of the organization. The technical requirements are dictated by need and availability. You should also determine the business goals of the organization for which you’re developing the database infrastructure. Without knowing those, you cannot analyse or forecast its capacity needs, any more than you can make the best possible house without knowing what it will be used for.

Scenario: As the DBA for your company, you have decided to install a new version of the Oracle Enterprise database to replace the current database version being used. The old database has become a constant headache and seems to be causing an overload on the disk drive's I/O channels. Further analysis has also shown that two primary large tables are the main points of access. These tables are CUST_REC and ACCT_RECV tables. You also have a new server with three large-capacity disk drives: F, G, and H. Briefly, provide the following information.

My work at Oracle has given me practical insights into the world of storage, the industrial standards, the methods and practices and made me realize the importance of the role that storage technology will play in the future. This is the backbone of new

All hardware and software have differing platforms and models, are guided by differing policies, have varying versions, and have different compatibilities. Standardization helps in bringing the various hardware and software on the same page in terms of configuration and compatibility. This makes it easier to identify problems, seek support, and resolve issues as standardized components are guided by common standards. This helps in saving a lot of time and money on support and troubleshooting. By standardizing software and hardware, problem investigation and resolution becomes easier, replacing parts or devices is convenient, and it helps save time, money, and

The staging area can be partitioned in any format/manner. This format is generally decided by the data warehousing team. The staged tables may contain indexes needed (post load) in order to provide Data Vault loads with performance downstream. Staging area data should be backed up regularly with regular intervals, otherwise it can also be backed up with scheduled intervals.