1 / 5

Normalization

Normalization. Normalization is the process of simplifying the relationship between data elements in a record[12]

kaylee
Download Presentation

Normalization

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Normalization Normalization is the process of simplifying the relationship between data elements in a record[12] Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them[13] normalization is the process of organizing it into tables in such a way that the results of using the database are always unambiguous and as intended. 

  2. Normalization • 1) Avoids data modification (INSERT/DELETE/UPDATE) anomalies as each data item lives in One place • 2) Greater flexibility in getting the expected data in atomic granular • 3) Normalization is conceptually cleaner and easier to maintain and change as your needs change • 4) Fewer null values and less opportunity for inconsistency • 5) A better handle on database security • 6) Increased storage efficiency • 7) The normalization process helps maximize the use of clustered indexes, which is the most powerful and useful type of index available. As more data is separated into multipletables because of normalization, the more clustered indexes become available to helpspeed up data access.[15]

  3. Conclusion the concept of controlling electric devices on Customer Side System based on the behavior in Smart home that had two sources for power both Renewable Energy and General Utility. Two main points considering for this are the way to manage storage battery unit and data management of CS by using normalization however in long term relationship between customer activity and Utility system service will get more benefit for each other ( reduce the consumption at peak hour etc.).

  4. Reference [1]Ralph m, IEEE PES “ Demand response the other side of the curve” Vol8 No.3 [2] Brdiczka, O., et al., Detecting Human Behavior Models From Multimodal Observation in a Smart Home. Automation Science and Engineering, IEEE Transactions on, 2009. 6(4): p. 588-597 [3]Steven B, IEEE power & energy magazine “ Behavior Modification” [4]Bahmani, A.H., M. Naghibzadeh, and B. Bahmani. Automatic database normalization and primary key generation. in Electrical and Computer Engineering, 2008. CCECE 2008. Canadian Conference on. 2008 [5]Hassan F, IEEE power & energy magazine “ The Evolution of Tomorrow’s Technology” [6] Chin-Hua, H. and W. Song-Lin. An efficient method of human behavior recognition in smart environments. in Computer Application and System Modeling (ICCASM), 2010 International Conference on. 2010 [7] Cowie, R. Building the databases needed to understand rich, spontaneous human behaviour. in Automatic Face & Gesture Recognition, 2008. FG '08. 8th IEEE International Conference on. 2008 [8] Poujaud, J., N. Noury, and J.E. Lundy. Identification of inactivity behavior in Smart Home. in Engineering in Medicine and Biology Society, 2008. EMBS 2008. 30th Annual International Conference of the IEEE. 2008 [9] Shih-Fan W. Internet-of-Thing based smart home appliance electricity management and environmental monitoring design. July 2012 [10] Son K A, Ling J M. Bio-inspired computing approach to solve the optimal planning problem applied to SPV, STUT [11] Shun-Chung Lee, Li-Hsing Shih, “Enhancing renewable and sustainable energy development based on and Taiwan,” Renewable and Sustainable EnergyReviews, Vol.15, pp. 2185–2198, 2011. [12]http://www.dotnetfunda.com/interview/exam5135-what-is-normalization.aspx [13] http://en.wikipedia.org/wiki/Database_normalization [14] http://searchsqlserver.techtarget.com/definition/normalization [15] http://sql-databases.blurtit.com/q362724.html

  5. Thanks for your attention

More Related