Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ganotedp

    Anyone can explain null in database concept?

    I don't know if NULLs are simple: however, the NULL concept is fundamental to understanding RDBMSs, and there is additional logic that must used to handle them correctly. Oh, if you completely control the domain you can add values that mean "Dunno" and "Not Applicable", but then those values...
  2. ganotedp

    New database design with ganotedp's party structure

    Well, I'm pleased that the article was thought-provoking. I've been mulling those notions over for years. Data models run the spectrum from concrete to abstract: from the concrete "Customer" to the abstract "Party". In my mind, one goal of data modeling is to select an reasonable point on...
  3. ganotedp

    Normalization: 'Entities' table, one-to-zero-or-many considerations

    The generally accepted term for the entity you're discussing is "Party", which is a data structure/pattern in a "universal" data model. You can read about it at http://www.tdan.com/i021ht04.htm Party is used by the United Nation's EDI standard (EDIFACT). You can read about EDIFACT at...
  4. ganotedp

    Design Question: Too much normalization? Where do you draw the line?

    fgambit has it correct. 2nd-3rd normal forms are the mantra that NON-KEY attributes must depend "on the key, the whole key and nothing but the key, so help me Codd". 4th-5th normal forms are intimidating because of terms like multi-value dependency (MVD). However, I think that 4th/5th forms...
  5. ganotedp

    Materialized views Vs Aggregate Tables

    A materialized view may be an aggregate table, or a simple, non-aggregate table (formerly known as a snapshot), or more complex multi-table join. You can have Oracle create materialized views, or register existing aggregate tables (perhaps created by an ETL tool) with Oracle as a materialized...
  6. ganotedp

    Warehouse? Hub? What do I call it?

    Both the architect and developers are right, from Bill Inmon's perspective. Inmon defines data warehouses as normalized and data marts as dimensional/denormalized for reporting. To me, the "data warehouse" is a persistent integration hub that consolidates data and feeds datamarts and...
  7. ganotedp

    Creating a multi-Valued table in Oracle ver > 8.15 using SQL PLUS

    A key point is that parties (persons/organizations) don't "just" have several phone numbers. Phone numbers have various functions, relative locations, and attached devices; for example: home fax, office fax, office voice, home voice, mobile voice, mobile fax, etc. A single...
  8. ganotedp

    What is EAI Architecture?

    Enterprise Application Integration (EAI) typically divides the world into "point-to-point" or "hub-and-spoke". Organizations often have developed piecemail integrations incrementally from one application to another, that is, so-called "point-to-point" application integrations. These...
  9. ganotedp

    What is ETL Architecture?

    ETL architecture connects three areas: source, staging, and target. Sources are typically one or more OLTP systems. Staging is a common holding and work area. Targets are typically a data warehouse or mart. "The source to stage component is intended to focus the efforts of reading the...
  10. ganotedp

    What is Data Architecture?

    Data architecture is "the blueprint of the data within your company." It "includes things like enterprisewide data models, the meta-data catalog, and notions of data ownership." Data infrastructure, on the other hand, covers the physical data structures and data transport mechanisms. From...
  11. ganotedp

    What is Architecture?

    "Often, architecture and infrastructure are used interchangeably. ThereÆs a subtle difference. Infrastructure consists of applications, hardware, and software. Architecture, on the other hand, refers to the overlying principles and processes that lead the organizationÆs infrastructure...
  12. ganotedp

    Should the Data Architect be a business expert or a DBA?

    Data Architects should comfortably work in both worlds, and more. DAs should be know enough (or be able to learn about the business in the usual discovery process) to represent the requirements in a logical model from an enterprise vantage, trace down data stewardship, etc. DAs should know...
  13. ganotedp

    Monster dimension

    Partitioning may be helpful for very large tables; one of our DAs experimented and said that Oracle 8i partitioning was useful when each partition was 1-million or more rows. We didn't have that kind of volume, so we unpartitioned our tables, and just used Oracle parallel query, which was very...
  14. ganotedp

    How to Update the Data required for Datawarehousing / Data Analysis

    You have a at least a couple of options to determine what's changed when you lack a datetime field for the transactions in OLTP environment. 1. Batch solution: Make periodic snapshots of the OLTP data, then after every snapshot do comparisons to see what's changed. 2. Low-latency solution...

Part and Inventory Search

Back
Top