Results 1 to 6 of 6
  1. #1
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419

    Data modeling meaning and purpose ?

    Hello,

    I am trying to understand what data modeling really means. I only have a vague understanding because I think the word or phrase is misuse in a lot of sentence and discussion. Could someone help me clarify.

    Data modeling or different model when creating a software does it mean that we create a database and program that is for different audience and different use and bc of this is base on different design.



    For example in one model we create where the user can interact and upload the data in db, in another model we have the data already in the db. Can we say we designed two model ?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See the info in this link
    Search with google using this criteria youtube conceptual data model

  3. #3
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    Thanks for the link and response but can modeling be not just database design but how is use by the audience or the purpose of who is it for ?

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Sounds like you want to make a presentation to the user. This link should provide more than enough information:
    http://www.omsar.gov.lb/ICTSG/01.%20..._Databases.htm

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    John,

    Please provide some context for your question. What exactly is the issue and who is the audience.

    A model could be as simple as "an artist's conceptual model of a new shopping centre".

    You can research conceptual data modelling, logical data modelling, physical data model, use case, Entity relationship diagramming.....

    You could also search for things such as --a system overview, business analysis and design, business model, business process modelling...

    Entity-relationship modeling is a relational schema database modeling method, used in software engineering to produce a type of conceptual data model (or semantic data model) of a system, often a relational database, and its requirements in a top-down fashion.

    Data modeling is the act of exploring data-oriented structures. Like other modeling artifacts data models can be used for a variety of purposes, from high-level conceptual models to physical data models. From the point of view of an object-oriented developer data modeling is conceptually similar to class modeling.


    Data model wikipedia

    You may find this free course on models and modelling of interest.

    Update: I found a slide presentation (ppt) on data modeling here.

    Good luck.

  6. #6
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    data model, in db design, refers to the tables. Which fields/columns go into which table and how the tables relate to each other.

    the easiest/best example is applications that begin as excel sheets by relative novices; they typically put lots of fields/columns in single sheets all side by side. When the time comes for this to be set up in a database then one usually reorganizing into a true relational format involving multiple tables.

    more typically in advanced situations now one has reporting requirements - and in order to create the report/dashboard one must know the data model as to what & how information is stored in its more granular way in order to create accurate displays of aggregated data.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Meaning of Prefixes
    By Lou_Reed in forum Access
    Replies: 6
    Last Post: 03-23-2017, 05:22 PM
  2. Database modeling
    By TS21 in forum Database Design
    Replies: 8
    Last Post: 09-14-2016, 11:09 AM
  3. rs.EOF Meaning
    By jo15765 in forum Modules
    Replies: 2
    Last Post: 03-18-2015, 06:34 PM
  4. Some help with conceptual modeling
    By Benji in forum Database Design
    Replies: 2
    Last Post: 09-10-2014, 03:43 PM
  5. What is the meaning of this query?
    By doci4a in forum Queries
    Replies: 2
    Last Post: 03-15-2011, 07:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums