Admin Linux ... MySQL DBA

Techniques to Boost Your Data Modeling : ·          Understand the Business Requirements and Results Needed - get a clear understanding of the requirements by asking people about the results they need from the data. Then start organizing your data with those ends in mind. ·          Visualize the Data to Be Modeled - Most people are far more comfortable looking at graphical representations of data that make it quick to see any anomalies or using intuitive drag-and-drop screen interfaces to rapidly inspect and join data tables. Data visualization approaches like these help you clean your data to make it complete, consistent, and free from error and redundancy. ·          Start with Simple Data Modeling and Extend Afterwards: Keeping data models small and simple at the start makes it easier to correct any problems or wrong turns. When you are sure your initial models are accurate and meaningful you can bring in more datasets, eliminating any inconsistencies as you go. ·

Data Modelling : - How data to be stored in a Database, A Data Model is used to document, define, organize, and show how the data structures within a given database, architecture, application, or platform are connected, stored, accessed, and processed within the given system and between other systems. Its conceptual representation of Data objects The associations between different data objects The rules. Data model emphasizes on what data is needed and how it should be organized instead of what operations need to be performed on the data. Data Model is like architect's building plan which helps to build a conceptual model and set the relationship between data items   The two types of Data Models techniques are Entity Relationship (E-R) Model UML (Unified Modelling Language) Types of Data Models : There are mainly three different types of data models: Conceptual: This Data Model defines WHAT the system contains. This model