Group items tagged

A Schema crosswalk is a table that shows equivalent elements (or "fields") in more than one database schema. It maps the elements in one schema to the equivalent elements in another schema.

This type of "translating" from one format to another is often called "metadata mapping" or "field mapping," and is related to "data mapping," and "semantic mapping."

var projectSchema = new Schema({ access: { type: String, enum: ACCESS_MODES, required: true, default: 'public' }, owner: { type: Schema.Types.ObjectId, ref: 'User' }] });

A cube can be considered a generalization of a three-dimensional spreadsheet.

Each cell of the cube holds a number that represents some measure of the business

OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a special-purpose data management system.

{ _id: ..., public: true, groups: ['group1', 'group2',...], users: ['user1','user2',...], } You could now query for all documents visible to user X if you have a list of groups user X belongs to by querying: db.documents.find( { $or : [ { public : true }, { users : X }, { groups : { $in : [list-of-X's-groups] } } ] } )

Cameo Data Modeler plugin provides data-related modeling for MagicDraw. It includes entity-relationship, database and XML schema modeling features.

racle SQL Developer Data Modeler provides a model driven approach for database design and generation, implemented by integrated set of models – Logical, Data types, Dimensional, Relational, Data Flow diagrams and Physical models for supported Oracle Databases, Microsoft SQL Server 2000 and 2005

Cube Views metadata

Dimensional Models   Dedicated full featured Dimensional model – star and snowflake schema easily can be built and expressed on detailed and compact diagrams   Dimensions – support for merging (level can belongs to more than one dimension), shared, fact and role playing dimensions   Hierarchies – value based hierarchies (parent-child), and regular and ragged level based hierarchies   Measures – fully, semi and none additive; different aggregation functions on different dimensions ; fact dimension; calculated measures   Query wizard allows Select statements to be generated from the dimensional model   Support for Oracle OLAP. This includes specifics like cube partitioning, sparse dimensions, and compressed measures   Built-in wizards help to define all required object types and view definitions that enable SQL access to dimensional data in Oracle AW (using the OLAP_TABLE interface)   Bidirectional integration with Oracle physical model - Dimensional model can be created using SQL dimension definitions in physical model or the definitions can be created from the dimensional model

SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams.

Document a database in a couple of clicks, from within SSMS

you can add further descriptions to your database objects if necessary.