2. Object-oriented database (OODB) stores data in objects.
An object is an item that contains data, as well as the actions that read or process the data.
Advantages of Object-oriented Database:
Object Query Language (OQL) manipulates and retrieves data. It is similar to SQL. And they both use many of the same rules, grammar, and keywords.
An object is an item that contains data, as well as the actions that read or process the data.
Advantages of Object-oriented Database:
- It can store more types of data, access this data faster, and allow programmers to reuse objects.
- It stores unstructured data more efficiently than a relational database.
- When users query an object-oriented database, the results often are displayed more quickly than the same query of a relational database.
- If an object already exists, programmers can reuse it instead of recreating a new object — saving on program development time.
Object Query Language (OQL) manipulates and retrieves data. It is similar to SQL. And they both use many of the same rules, grammar, and keywords.
3. Multid
allow users to access and analyze any view of the database data. It can consolidate this type of data from multiple dimensions at very high rates of speed. Nearly every multidimensional database has a dimension of time. The content of other dimensions varies depending on the
subject. No standard query language exists for multidimensional databases. Each database
uses its own language. Mostly is SQL.
Data Warehouses
It is a huge database that stores and manages the
data required to analyze historical and current transactions. It has a user-friendly interface, so that users easily can interact with its data.
Through a data warehouse:
- Managers and other users access transactions and summaries of transactions quickly and efficiently
- Some major credit card companies monitor and manage customers’ credit card transactions
- Consumers can access their own transactions in the data warehouse via the Web.
imensional Databases stores data more than two dimensions. These multiple dimensions allow users to access and analyze any view of the database data. It can consolidate this type of data from multiple dimensions at very high rates of speed. Nearly every multidimensional database has a dimension of time. The content of other dimensions varies depending on the
subject. No standard query language exists for multidimensional databases. Each database
uses its own language. Mostly is SQL.
Data Warehouses
It is a huge database that stores and manages the
data required to analyze historical and current transactions. It has a user-friendly interface, so that users easily can interact with its data.
Through a data warehouse:
- Managers and other users access transactions and summaries of transactions quickly and efficiently
- Some major credit card companies monitor and manage customers’ credit card transactions
- Consumers can access their own transactions in the data warehouse via the Web.
Data Mart
It is a smaller version of a data warehouse that contains a database that helps a specific group or department make decisions.