answersLogoWhite

0


Best Answer

The Star & Snowflake are two common type of database Schema.

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are the Types of database schema architecture?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is schema object of database?

We know that schema in the database is refer to the basic design of that database and is stored in an object . That object is known as schema object of database.


What is a database schema?

A database schema is described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables. Schemas are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure Levels of database schema 1. Conceptual schema, a map of concepts and their relationships 2. Logical schema, a map of entities and their attributes and relations 3. Physical schema, a particular implementation of a logical schema 4. Schema object, Oracle database object 5. Schema is the over all structure of the database


What is a document that describes database objects and their data types?

Describe what would happen if there were no data dictionary for a given database.


The three level database architecture?

Three-Schema architecture is to separate the user applications and physical database.Internal level :- Describes the physical storage structure of the database.Conceptual level :- Describes the entities, data types, relationships, user operations, and constraints.External level :- It describes a particular user group is interested in and hides the rest of the database from that user group.


How does one read a database schema?

One can easily read a database schema through any software available currently. Simpy because a database schema is a blueprint which can be read by a software.


What do you mean by logical schema in database?

tablespace,segment,extent,oracle blocks.. are the logical schema of a database


Explain the three schema architecture of DBMS?

Physical schema,logical schema and sub schemas


What are database schema and sub-schemas?

A database schema is an actual plan for a database system. Sub-schemas are separate divisions that are used to achieve the plan for the database system.


What is the difference between schema and database?

Database schema are the logical structure of entities (tables or object classes) and their relationships (keys, or object associations) in a database. Schema can exist at different levels of abstraction (see: en.wikipedia.org/wiki/Database_schema). Schema themselves may or may not exist as such in a database. In general schema at the higher levels of abstraction are design models that are captured in printed documents, and authored by business analysts and database designers, rather than created by database programmers and stored in the database itself. But in some types of databases, schema at any level of abstaction can be realized physically. In Oracle databases, schema can be realized as schema objects, which are a part of an Oracle database. These schema objects may represent a human user's conceptual model of the knowledge captured in an enterprise database. Thus defined, there can be many schema that can be associated with one physical database. In other kinds of relational database, an abstract user's schema can be represented by logically linked metadata, views, and stored procedures assocated with a user class. In object-oriented databases, especially those based on the highly self-referential language Smalltalk (e.g. Gemstone/S), schema are realized as "physical" objects in the database as a matter of course, as well as in the logical models captured in design documents. The schema objects in such databases are, in essence, the classes comprising the infrastructure of the database or application. Oracle-style user schema are readily created; these would be realized as user interface orchestrator classes.


Functions of schema?

The schema (pronounced skee-ma) of a database system is its structure described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields, relationships, views, indexes, packages, procedures, functions, queues, triggers, types, sequences, materialized views, synonyms, database links, directories, Java, XML schema's and other elements.Schema's are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure.Hope this helps!Inclus - We provide indivdual and coporate trainingsEducate, Learn & Servewww.Inclus.net


How is data organized in a database?

In the manner described in the database schema.


What language Enables a database administrator to define schema components?

Schema DDL