OBJECT- ORIENTED RELATIONAL MODELLING E-MONOGRAPH, By J. Ashraf, and M. Khan
OBJECT- ORIENTED RELATIONAL MODELLING E-MONOGRAPH, By J. Ashraf, M. Khan, and H. Mir
The cost of human development and specialized trainings on job and off the job are too expensive to be affordable by any curious with amorous interest in skills for professional enrichment. This e-monograph is aiming to economize the efforts to embarking career as relational database applications’ designer and so the developers’ aggressive periphery.
The unyielding efforts out of long course of leading author’s Applied Computer Science career spread over 40 years in different cross sections from legacy systems to-date, has resulted in producing this scared instrumental drill on designing. The e-monograph will lure readers through the curtailed learning path, in order to augment the professional analytics and practices. Often smart Oil professionals’ skillfulness proclaims instincts to discover offshore or onshore oil (most demanding substance of the day). Their practices are poles apart than academics, and likewise the e-monograph is comprised too comprised too.
The evolution of this e-monograph was an ongoing process starting in the form of training material for those who wanted to master crux of relational designing instrumental practices a bottom line. To keep up the nucleus of the database technology as crystal clear, one needs to grip the steps discoursed here, as algebraic phenomena.
WHY THIS INDUSTRIAL E-MONOGRAPH?
The Object-oriented Relational Modeling (ORM) skills are avant-garde evolution for advancement of application development technologies of information corporate resource.
This is also in pursuit of the key concept of economic order nisi; reusability vertically and horizontally embedding the integrated values of relational technology with objects notion.
Further, these knacks provide the degree of stability and strength to maintainability and sustainability of info resource.
While the focus of this industrial e-monograph begins on review of relational data modeling as instrumental engineering, and is extended at this stage to its highly pertinent amalgamation with the class level approach of analysis, and design what is called Object-oriented Relational Modeling (ORM). Because the widespread acceptance of relational databases and the popularity of Object-oriented design and programming techniques often require the object models be dealt and supported by physical relational database design and tools. Therefore, the techniques of Object-Oriented Modeling (OOM) and Relational Data Modeling (RDM) necessitate coexisting in the form ORM.
In practice, one is required concurrently to support an object development process and relational database in software development scenarios at varying level. This industrial e-monograph is split into three parts, while Part-I is direct review and enhancement of Relational Model instrumental design, Part-II and Part-III are attempt in the same manner leading to ORM.
The unyielding efforts of authors’ outcome, this industrial e-monograph to prepare human resource on fast track discourse. Such strife hubs to economize the cost of rare professional dexterity in order to outfit the demands of the worldwide reusability of design reflexion objects and processing software.
PREFACE
The subject of data modeling is centric to the applications development industry and to those who are embarking career in application systems. In this regard, engraved core knowledge is imperative to develop elegance of system design skills as rational policy and reduce the efforts and cost of competitive edge in industry.
The methods advocated in this industrial e-monograph is an urge of authors long course as practicing consultant on real world business system applications and academia strictly inline with the state-of-the art RDBMS technology analytical genius evolutions.
This industrial e-monograph authoring is second in the series while the first was inscribed for the beginners transliterated on the link “datamodeling.info”. That is mainly outlining the basic concepts of building blocks for transforming interwoven business processes/ task and events into analytically transparent logical breakdown of atomic components.
The idea underlying in this document is simple, but the elegancy of design axiomatic is greatly facilitated by the clarity of fundamentals’ rational grounds. Critically, it is compiled in the form of natural course equitable drill for variety of readers from novice to experience.
The coverage of this document is devised imparting state-of-the art skills of business systems perception “what to do and how to do?” in trivial and non-trivial paradigms dealing with data modeling reflexions of software engineering. The entirety of compass begins upfront conjuring expressive version of a business system and goes through the standard drill of Object Oriented Modeling (OOM) to-do-list and ends up at a point delivering the data model a design manifest.
AUTHORS TEAM
Prof. S. J. Ashraf, FBCS, FSS, CMILT, was the leader of the authors’ team compiling and composing these e-monographs. He is a veteran educator of computer science and consultant designer of business application systems paradigms, witnessing evolution of the industry since late 1960s, citations in MARQUIS WHO’S WHO USA.
Muqeem, Khan., MS, an Oracle Financial Functional Consultant, and a seasoned practicing professional who testified the contents of document on filed problems.
Hasan Mir, the Brock University Honors Graduate, Canada, an Oracle Financials Technical/ Functional Consultant, a reputed trainer, and a practicing professional since 1998 on various platforms including the Gurusoft Consultants Inc., Canada, and handsonerp.com scrutinized this made easy contents and coverage.
ACKNOWLEDGEMENT
Enormous exercises and ideas are compiled from variant sources and also engineered in origin, over authors’ long practicing era, which are embedded here. Hardly, these can be acknowledged to each and every knowledge sources independently, so thanks and acknowledgement are expresses in anonymity.
The material incorporated in this industrial e-monograph represents the best advice on the part of the team, and it is issued by them and other users, neither the publisher nor the authors shall be responsible for absolute correctness and sufficiency of any piece of information illustrated here.
HOW TO USE THIS INDUSTRIAL E-MONOGRAPH?
The basic idea in this industrial e-monograph is an engineering continuum, at least conceptually, of the renowned works of E. F. Codd, C.J. Date and Relational Database selective publications describing the relational models.
This industrial e-monograph prescribes an instrumental design methodology from E-R data modeling to Object Oriented Relational Databases as upgrade of modeling and enforcement of business rules at class level.
The business rules are the hindsight of business dynamics and backbone of business systems. This has three integrated parts; Part-I, II, and III compassing software engineering; E-R data modeling, and Object-oriented Relational Modeling (ORM) for intensifying analytical skills and certain tools with limited objectives. Accordingly, referencing of the parts may be made, either way;
PART-I: “E-R MODELING Foundation Review” is mainly intensifying essentials and reusable reflexions of Business Rules Instrumental Modeling in continuum on fast track to of E-R data modeling contesting business application paradigms. On need basis, it may be jumped over to next part by convenience.
Part-II: “OBJECT-ORIENTED MODELING Foundation” is concentric to fundamentals of Object Oriented Modeling using in context with the benchmark of E-R data modeling of the Part-I free industrial e-monograph endorsed at the link ‘datamodeling.info’. It envisages the Object-oriented Relational Modeling (ORM) Foundation for prescribing modular engineering steps as instrumental.
Part-III: “OBJECT-ORIENTED MODELING Pragmatic Approach” is specific “to-do-action list” to accomplish Object Oriented Relational Database going through the prescribed instrumental steps in Part-II above indicated.
Finally, this industrial e-monograph is a made easy form of ORM of business system paradigms without stressing the practitioners’ stability and strength on mind chewing design philosophy and acumen even for non-trivial paradigms. Its grasp boosts confidence in dealing with application system ORM designs quality and quantity, to combat the real world system challenges instrumentally.
Correspondingly each part further concentrates
MESSAGE: Dedicated to Anonymous Combatants of Knowledge
Email Contact: sun_education@yahoo.com
PART-I: E-R MODELING (Foundation Review)
CONTENTS
LESSON-1 DATABASE TERMINOLOGY REVIEW LESSON-2 DATABASE ARCHITECTURES LESSON-3 COMPONENTS OF BUSINESS SYSTEMS LESSON-4 SOFTWARE CONSTRUCTIONS BY PARTS LESSON-5 DATABASE DEVELOPMENT PROCESSES LESSON-6 RELATIONAL DATABASES
LESSON-7 ADVANCED E-R MODELING
LESSON-8 E-R MODELLING BY RULES
LESSON-9 NORMALIZATION OF ENTITIES
LESSON-10 A CASE FOR NORMALIZATION
LESSON-11 TIPS ON DE-NORMALIZATION OF TABLES
LESSON-12 BUSINESS TRANSACTION RULES
LESSON-13 INSTRUMENTAL MODELLING OF BUSINESS RULES
REFLEXIONS
REFLEXIONS
APPENDICES 1 & 2
NOTE: It is a reviewed version authored earlier by the above indicated team, on data modelling (relational system designing) intellect, in industrial monographic structure, merely analytic concept for instant use of system practitioners and freshman to state-of-the art designing tools. Over the last decade it has facilitated to enormous application systems career embarking professionals and is reproduced on common insistence.
MORE LINK ON OBJECT ORIENTED RELATIONAL DATA MODELLING:
OBJECT- ORIENTED RELATIONAL DATA MODELLING E-MONOGRAPH, By J. Ashraf, and M. Khan, https://be4gen.wordpress.com/2012/09/21/2055/
LESSON-1 DATABASE TERMINOLOGY REVIEW (Cont’d; Ashraf, Khan, and Mir) https://be4gen.wordpress.com/2012/09/21/2064/
LESSON-2 DATABASE ARCHITECTURES (Cont’d; Ashraf, Khan, and Mir) https://be4gen.wordpress.com/2012/09/21/lesson-2-database-architectures-contd-ashraf-khan-and-mir/
LESSON-3 COMPONENTS OF BUSINESS SYSTEMS (Cont’d; Ashraf, Khan, and Mir) Posted on September 21, 2012 https://be4gen.wordpress.com/2012/09/21/lesson-3-components-of-business-systems-contd-ashraf-khan-and-mir/
LESSON-4 SOFTWARE CONSTRUCTION BY PARTS (Cont’d; Ashraf, Khan, and Mir) Posted on September 21, 2012 https://be4gen.wordpress.com/2012/09/21/lesson-4-software-construction-by-parts-contd-ashraf-khan-and-mir/
LESSON-5: DATABASE DEVLOPMENT PROCESSES (Cont’d; Ashraf, Khan, and Mir) Posted on September 21, 2012 https://be4gen.wordpress.com/2012/09/21/lesson-5-database-devlopment-processes-contd-ashraf-khan-and-mir/
LESSON-6 RELATIONAL DATABASES(Cont’d; Ashraf, Khan, and Mir) Posted on October 3, 2012 https://be4gen.wordpress.com/2012/10/03/relational-databases-contd-ashraf-khan-and-mir/
LESSON-7 ADVANCED E-R MODELING (Cont’d; Ashraf, Khan, and Mir) Posted on September 21, 2012 https://be4gen.wordpress.com/2012/09/21/2109/
LESSON-8 E-R MODELLING BY RULES (Cont’d; Ashraf, Khan, and Mir) Posted on September 21, 2012 https://be4gen.wordpress.com/2012/09/21/lesson-8-e-r-modelling-by-rules-contd-ashraf-khan-and-mir/
LESSON-9 NORMALIZATION OF ENTITIES(Cont’d; Ashraf, Khan, and Mir) Posted on September 21, 2012 https://be4gen.wordpress.com/2012/09/21/lesson-9-normalization-of-entities-contd-ashraf-khan-and-mir/
LESSON-10 A CASE FOR NORMALIZATION (Cont’d; Ashraf, Khan, and Mir) Posted on September 22, 2012 https://be4gen.wordpress.com/2012/09/22/lesson-10-a-case-for-normalization-contd-ashraf-khan-and-mir/
LESSON-11 TIPS ON DENORMALIZATION OF TABLES (Cont’d; Ashraf, Khan, and Mir) Posted on September 22, 2012 https://be4gen.wordpress.com/2012/09/22/lesson-11-tips-on-denormalization-of-tables-contd-ashraf-khan-and-mir/
LESSON-12 BUSINESS TRANSACTION RULES(Cont’d; Ashraf, Khan, and Mir) Posted on September 22, 2012 https://be4gen.wordpress.com/2012/09/22/lesson-12-business-transaction-rules-contd-ashraf-khan-and-mir/
LESSON-13 INSTRUMENTAL MODELING OF BUSINESS RULES REFLEXIONS (Cont’d; Ashraf, Khan, and Mir) Posted on September 22, 2012 https://be4gen.wordpress.com/2012/09/22/lesson-13-instrumental-modeling-of-business-rules-reflexions-contd-ashraf-khan-and-mir/
PART-II: ”OBJECT-ORIENTED MODELING Foundation”
PART-II: LESSON-1, OBJECT ORIENTED MODELING- Foundation http://www.relationalmodeling.com/takelesson.jsp?l=21
PART-II: LESSON-2, Business Rules Versus Object Technology http://www.relationalmodeling.com/takelesson.jsp?l=22
PART-II: LESSON-3, Object-Oriented Modeling Implementation http://www.relationalmodeling.com/takelesson.jsp?l=23
PART-II: LESSON-4, Comparison Of E-R & UML Modeling http://www.relationalmodeling.com/takelesson.jsp?l=24
PART-II: LESSON-5, TIPS on Enterprise Modeling http://www.relationalmodeling.com/takelesson.jsp?l=25
PART-III: ”OBJECT-ORIENTED MODELING Pragmatic Approach”
PART-III, LESSON-1, OBJECT ORIENTED REALTIONS MODELING
Pragmatic Approach http://www.relationalmodeling.com/takelesson.jsp?l=26
Pragmatic Approach http://www.relationalmodeling.com/takelesson.jsp?l=26
PART-III, LESSON-2, OBJECT ORIENTED REALTIONS MODELING
Pragmatic Approach http://www.relationalmodeling.com/takelesson.jsp?l=27
Pragmatic Approach http://www.relationalmodeling.com/takelesson.jsp?l=27
PART-III, LESSON-3, E-R Modeling Engineering- A Case http://www.relationalmodeling.com/takelesson.jsp?l=28
PART-III, LESSON-4, Object-Oriented Design Down-to-earth Approach http://www.relationalmodeling.com/takelesson.jsp?l=29
PART-III, LESSON-5, E-R & UML Data Models- A Case http://www.relationalmodeling.com/takelesson.jsp?l=30
APPENDICES: O.O.R.M (Cont’d; Ashraf, Khan, and Mir) Posted on September 27, 2012
APPENDICES: O.O.R.M (Cont’d; Ashraf, Khan, and Mir) https://be4gen.wordpress.com/2012/09/27/appendices-o-o-r-m-contd-ashraf-khan-and-mir/
APPENDIX-1: ERD Basic Graphical Constructs http://www.relationalmodeling.com/takelesson.jsp?l=31
APPENDIX-2: Advanced E-R Constructs http://www.relationalmodeling.com/takelesson.jsp?l=32
APPENDIX- 3: Data Warehouse Modeling http://www.relationalmodeling.com/takelesson.jsp?l=33
APPENDIX-4: Thesaurus E-R & UML Modeling http://www.relationalmodeling.com/takelesson.jsp?l=34
APPENDIX-5: Thesaurus Of UML Modeling http://www.relationalmodeling.com/takelesson.jsp?l=35
*******
- MESSAGE: DEDICATED TO ANONYMOUS COMBATANTS OF KNOWLEDGEمکتب علم الل مہد منل لحد Learning continues from birth to death
No comments:
Post a Comment