Enterprise Data Copyright

One of the first things you should do is to place the Site Map in your Favorites or Bookmarks. It will help you navigate the site, which is broad and deep.

Enterprise Data Architecture is a how-to text published to the web instead of a book. The advantage of the web environment is that information is organized in hierarchical, drill-down fashion rather than serial, turn-the-page fashion. This allows the reader to browse across a layer in the hierarchy and assimilate the information at the conceptual level and then drill-down to the detail level or read each section from the top to the bottom before proceeding to the next section.

The reader is advised to read the Database/OLTP sections before the Data Warehouse/OLAP sections, since the OLAP architecture uses OLTP architectural components.

The key to both architectures are the components. The nine components are used to produce databases and data warehouses, so make sure you read and understand "Components" in the Database/Enterprise Database/Architecture section. By understanding the components well and recognizing them in legacy database tables, the data warehouse architecture and methodology will work for you even if you do not implement the enterprise database concept.

The components are combined to produce database patterns. Patterns are proven solutions to known problems. The patterns are documented, by class, using data model notation. There are eight data classes documented in this web text. They are Organization, Person, Activity, Location, Property, Item, BusinessObject and Code.

The eight patterns are combined into an enterprise schema and implemented as a prototype containing the enterprise/application database pair. The prototype exists both as a "proof of concept" and as a seed enterprise database. The prototype is also used to mitigate concerns over the performance of the enterprise/application database pair.

Please note that this website has evolved from the website that existed as dbstuff.com since 1997.

Copyright notice ~ Copyright © 1997 through 2007, Parker Shannon, all rights reserved

You are encouraged to copy and otherwise use any and all these designs, models, components, patterns, graphics, text and software products for inclusion in your own, "not for profit", products or products you produce for your employer. Please include proper attribution and the original copyright somewhere in your work product. For example:

From Enterprise Data Architecture
https://home.comcast.net/~parkershannon/index.html

These registered copyright materials may not be included in "for profit" commercial software products without the written permission of the author. If you do wish to include these components, patterns, prototypes or tools in a commercial product, contact Parker Shannon at parkershannon-at-comcast.net substituting the "@" sign for "-at-"

If you have any questions about the copyright, please contact Parker at parkershannon-at-comcast.net substituting the "@" sign for "-at-"