Christian Mancas
Conceptual Data Modeling and Database Design: A Fully Algorithmic Approach, Volume 1 (eBook, PDF)
The Shortest Advisable Path
139,95 €
139,95 €
inkl. MwSt.
Sofort per Download lieferbar
70 °P sammeln
139,95 €
Als Download kaufen
139,95 €
inkl. MwSt.
Sofort per Download lieferbar
70 °P sammeln
Jetzt verschenken
Alle Infos zum eBook verschenken
139,95 €
inkl. MwSt.
Sofort per Download lieferbar
Alle Infos zum eBook verschenken
70 °P sammeln
Christian Mancas
Conceptual Data Modeling and Database Design: A Fully Algorithmic Approach, Volume 1 (eBook, PDF)
The Shortest Advisable Path
- Format: PDF
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
Bitte loggen Sie sich zunächst in Ihr Kundenkonto ein oder registrieren Sie sich bei
bücher.de, um das eBook-Abo tolino select nutzen zu können.
Hier können Sie sich einloggen
Hier können Sie sich einloggen
Sie sind bereits eingeloggt. Klicken Sie auf 2. tolino select Abo, um fortzufahren.
Bitte loggen Sie sich zunächst in Ihr Kundenkonto ein oder registrieren Sie sich bei bücher.de, um das eBook-Abo tolino select nutzen zu können.
This new book aims to provide both beginners and experts with a completely algorithmic approach to data analysis and conceptual modeling, database design, implementation, and tuning, starting from vague and incomplete customer requests and ending with IBM DB/2, Oracle, MySQL, MS SQL Server, or Access based software applications. A rich panoply of s
- Geräte: PC
- mit Kopierschutz
- eBook Hilfe
- Größe: 21.48MB
Andere Kunden interessierten sich auch für
- Jagdish Chandra PatniA Comprehensive Study of SQL (eBook, PDF)72,95 €
- Feyzi BasarSummability Theory and Its Applications (eBook, PDF)52,95 €
- Daniel W. CunninghamReal Analysis (eBook, PDF)46,95 €
- Steven R. BellThe Cauchy Transform, Potential Theory and Conformal Mapping (eBook, PDF)72,95 €
- Advanced Mathematical Analysis and its Applications (eBook, PDF)204,95 €
- Elvis FosterDatabase Systems (eBook, PDF)62,95 €
- Feyzi BasarDouble Sequence Spaces and Four-Dimensional Matrices (eBook, PDF)52,95 €
-
-
-
This new book aims to provide both beginners and experts with a completely algorithmic approach to data analysis and conceptual modeling, database design, implementation, and tuning, starting from vague and incomplete customer requests and ending with IBM DB/2, Oracle, MySQL, MS SQL Server, or Access based software applications. A rich panoply of s
Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.
Produktdetails
- Produktdetails
- Verlag: Taylor & Francis
- Seitenzahl: 698
- Erscheinungstermin: 5. Januar 2016
- Englisch
- ISBN-13: 9781498728447
- Artikelnr.: 43976795
- Verlag: Taylor & Francis
- Seitenzahl: 698
- Erscheinungstermin: 5. Januar 2016
- Englisch
- ISBN-13: 9781498728447
- Artikelnr.: 43976795
- Herstellerkennzeichnung Die Herstellerinformationen sind derzeit nicht verfügbar.
Christian Mancas, PhD, is currently an associate professor with both the Mathematics and Computer Science Departments of Ovidius University, Constanta, Romania, and the Engineering Taught in Foreign Languages Department (Computer Science and Telecommunications in English stream) of Politehnica University, Bucharest, Romania (as an invited professor). Since 2012, he is also a database architect with Asentinel International srl, Bucharest, a subsidiary of Asentinel LLC, Memphis, Tennessee. His specialties include university teaching, R&D, business analysis, conceptual data and knowledge modeling and querying, client-server, hierarchical software architecture, object-oriented, event-driven design, structured development, complex project and small IT company management, Datalog, SQL, C#, XML programming, etc.
Professor Christian Mancas has published dozens of scientific papers (in Romania, USA, Austria, and Greece), which have been indexed by ACM Digital Library, Zentralblatt, Scopus, DBLP, Arnetminer, Researchr, TDGS, SCEAS, etc. He has also published three books in Romanian and dozens of reviews (mostly in USA, including ACM Reviews). He was a program committee member and session chairman for several software conferences in USA, Austria, and Romania, and he is a member of several associations (including ACM, the Romanian Mathematics Sciences Society, and the International Who's Who of Professionals). Since 2006, his biography is included in Marquis Who's Who in the World and Who's Who in Science and Engineering and Hubners' Who's Who in Romania.
Since 1990, he also worked for several IT startups, including his own DATASIS Consult srl (co-owned with his good friend and faculty colleague Ion Draghicescu) and DATASIS ProSoft srl (who had 25 programmers working for the design and development of several ERP-type database applications for customers from France, UK, Switzerland, USA, Israel,
Professor Christian Mancas has published dozens of scientific papers (in Romania, USA, Austria, and Greece), which have been indexed by ACM Digital Library, Zentralblatt, Scopus, DBLP, Arnetminer, Researchr, TDGS, SCEAS, etc. He has also published three books in Romanian and dozens of reviews (mostly in USA, including ACM Reviews). He was a program committee member and session chairman for several software conferences in USA, Austria, and Romania, and he is a member of several associations (including ACM, the Romanian Mathematics Sciences Society, and the International Who's Who of Professionals). Since 2006, his biography is included in Marquis Who's Who in the World and Who's Who in Science and Engineering and Hubners' Who's Who in Romania.
Since 1990, he also worked for several IT startups, including his own DATASIS Consult srl (co-owned with his good friend and faculty colleague Ion Draghicescu) and DATASIS ProSoft srl (who had 25 programmers working for the design and development of several ERP-type database applications for customers from France, UK, Switzerland, USA, Israel,
Chapter 2. The Quest for Data Adequacy and Simplicity: The
Entity-Relationship Data Model (E-RDM)
2.1 Entity and relationship type object sets
2.2 Attributes and surrogate keys
2.3 Entity-Relationship Diagrams (E-RDs)
2.4 Functional relationships and the Key Propagation Principle (KPP)
2.5 Relationship hierarchies
2.6 Higher arity non-functional relationships
2.7 Restriction sets
2.8 Case study: a public library (do we know exactly what a book is?)
2.9 The algorithm for assisting the data analysis and modeling process
(A0). An E-R data model of the E-RDM
2.10 Best practice rules
2.11 The math behind E-RDs and restriction sets. The danger of
"many-to-many relationships" and the correct E-RD of E-RDM
Chapter 3. The Quest for Data Independence, Minimal Plausibility, and
Formalization: The Relational Data Model (RDM)
3.1 First normal form tables, columns, constraints, rows, instances
3.2 The five basic relational constraint types
3.3 The algorithm for translating E-R data models into relational schemas
and non-relational constraint sets (A1-7). An RDM model of the E-RDM
3.4 Case study: the relational scheme of the public library data model
3.5 The reverse engineering algorithm for translating relational schemas
into E-R data models (REA1-2)
3.6 The algorithm for assisting keys discovery (A7/8-3)
3.7 RDBMS metacatalogs. Relational and E-R data models of the RDM
3.8 Relational schemas definition. SQL DDL
3.9 Relational instances manipulation. SQL DML. Relational calculi and
algebra
3.10 Higher and the highest RDM normal forms
3.11 Best practice rules
3.12 The math behind RDM
Chapter 4: Relational Schemas Implementation and Reverse Engineering
4.1 The algorithm for translating relational schemas into SQL DDL ANSI-92
scripts (A8)
4.2 Relevant differences between IBM DB2, Oracle Database and MySQL,
Microsoft SQL Server and Access
4.3 Case study: implementing the public library RDB into DB2, Oracle,
MySQL, SQL Server, and Access
4.4 The reverse engineering algorithm for translating Access 2013 RDB
schemas into SQL ANSI DDL scripts (REA2013A0), a member of REAF0'
4.5 The algorithms for translating E-R data models into RDBs and associated
non-relational constraint sets (AF1-8)
4.6 The reverse engineering family of algorithms for translating RDB
schemas into E-R data models (REAF0-2)
4.7 Case study: reverse engineering of an Access Stocks DB scheme into both
an ANSI standard SQL DDL script and an E-R data model
4.8 Best practice rules
4.9 The math behind the algorithms presented in this chapter
Chapter 5: Conclusion
5.1 Database axioms
5.2 Why do we need another conceptual level for expert DB design?
5.3 What are the most important things that we should be aware of in DBs?
Appendix: Mathematic prerequisites for the math behind
Index
Entity-Relationship Data Model (E-RDM)
2.1 Entity and relationship type object sets
2.2 Attributes and surrogate keys
2.3 Entity-Relationship Diagrams (E-RDs)
2.4 Functional relationships and the Key Propagation Principle (KPP)
2.5 Relationship hierarchies
2.6 Higher arity non-functional relationships
2.7 Restriction sets
2.8 Case study: a public library (do we know exactly what a book is?)
2.9 The algorithm for assisting the data analysis and modeling process
(A0). An E-R data model of the E-RDM
2.10 Best practice rules
2.11 The math behind E-RDs and restriction sets. The danger of
"many-to-many relationships" and the correct E-RD of E-RDM
Chapter 3. The Quest for Data Independence, Minimal Plausibility, and
Formalization: The Relational Data Model (RDM)
3.1 First normal form tables, columns, constraints, rows, instances
3.2 The five basic relational constraint types
3.3 The algorithm for translating E-R data models into relational schemas
and non-relational constraint sets (A1-7). An RDM model of the E-RDM
3.4 Case study: the relational scheme of the public library data model
3.5 The reverse engineering algorithm for translating relational schemas
into E-R data models (REA1-2)
3.6 The algorithm for assisting keys discovery (A7/8-3)
3.7 RDBMS metacatalogs. Relational and E-R data models of the RDM
3.8 Relational schemas definition. SQL DDL
3.9 Relational instances manipulation. SQL DML. Relational calculi and
algebra
3.10 Higher and the highest RDM normal forms
3.11 Best practice rules
3.12 The math behind RDM
Chapter 4: Relational Schemas Implementation and Reverse Engineering
4.1 The algorithm for translating relational schemas into SQL DDL ANSI-92
scripts (A8)
4.2 Relevant differences between IBM DB2, Oracle Database and MySQL,
Microsoft SQL Server and Access
4.3 Case study: implementing the public library RDB into DB2, Oracle,
MySQL, SQL Server, and Access
4.4 The reverse engineering algorithm for translating Access 2013 RDB
schemas into SQL ANSI DDL scripts (REA2013A0), a member of REAF0'
4.5 The algorithms for translating E-R data models into RDBs and associated
non-relational constraint sets (AF1-8)
4.6 The reverse engineering family of algorithms for translating RDB
schemas into E-R data models (REAF0-2)
4.7 Case study: reverse engineering of an Access Stocks DB scheme into both
an ANSI standard SQL DDL script and an E-R data model
4.8 Best practice rules
4.9 The math behind the algorithms presented in this chapter
Chapter 5: Conclusion
5.1 Database axioms
5.2 Why do we need another conceptual level for expert DB design?
5.3 What are the most important things that we should be aware of in DBs?
Appendix: Mathematic prerequisites for the math behind
Index
Chapter 2. The Quest for Data Adequacy and Simplicity: The
Entity-Relationship Data Model (E-RDM)
2.1 Entity and relationship type object sets
2.2 Attributes and surrogate keys
2.3 Entity-Relationship Diagrams (E-RDs)
2.4 Functional relationships and the Key Propagation Principle (KPP)
2.5 Relationship hierarchies
2.6 Higher arity non-functional relationships
2.7 Restriction sets
2.8 Case study: a public library (do we know exactly what a book is?)
2.9 The algorithm for assisting the data analysis and modeling process
(A0). An E-R data model of the E-RDM
2.10 Best practice rules
2.11 The math behind E-RDs and restriction sets. The danger of
"many-to-many relationships" and the correct E-RD of E-RDM
Chapter 3. The Quest for Data Independence, Minimal Plausibility, and
Formalization: The Relational Data Model (RDM)
3.1 First normal form tables, columns, constraints, rows, instances
3.2 The five basic relational constraint types
3.3 The algorithm for translating E-R data models into relational schemas
and non-relational constraint sets (A1-7). An RDM model of the E-RDM
3.4 Case study: the relational scheme of the public library data model
3.5 The reverse engineering algorithm for translating relational schemas
into E-R data models (REA1-2)
3.6 The algorithm for assisting keys discovery (A7/8-3)
3.7 RDBMS metacatalogs. Relational and E-R data models of the RDM
3.8 Relational schemas definition. SQL DDL
3.9 Relational instances manipulation. SQL DML. Relational calculi and
algebra
3.10 Higher and the highest RDM normal forms
3.11 Best practice rules
3.12 The math behind RDM
Chapter 4: Relational Schemas Implementation and Reverse Engineering
4.1 The algorithm for translating relational schemas into SQL DDL ANSI-92
scripts (A8)
4.2 Relevant differences between IBM DB2, Oracle Database and MySQL,
Microsoft SQL Server and Access
4.3 Case study: implementing the public library RDB into DB2, Oracle,
MySQL, SQL Server, and Access
4.4 The reverse engineering algorithm for translating Access 2013 RDB
schemas into SQL ANSI DDL scripts (REA2013A0), a member of REAF0'
4.5 The algorithms for translating E-R data models into RDBs and associated
non-relational constraint sets (AF1-8)
4.6 The reverse engineering family of algorithms for translating RDB
schemas into E-R data models (REAF0-2)
4.7 Case study: reverse engineering of an Access Stocks DB scheme into both
an ANSI standard SQL DDL script and an E-R data model
4.8 Best practice rules
4.9 The math behind the algorithms presented in this chapter
Chapter 5: Conclusion
5.1 Database axioms
5.2 Why do we need another conceptual level for expert DB design?
5.3 What are the most important things that we should be aware of in DBs?
Appendix: Mathematic prerequisites for the math behind
Index
Entity-Relationship Data Model (E-RDM)
2.1 Entity and relationship type object sets
2.2 Attributes and surrogate keys
2.3 Entity-Relationship Diagrams (E-RDs)
2.4 Functional relationships and the Key Propagation Principle (KPP)
2.5 Relationship hierarchies
2.6 Higher arity non-functional relationships
2.7 Restriction sets
2.8 Case study: a public library (do we know exactly what a book is?)
2.9 The algorithm for assisting the data analysis and modeling process
(A0). An E-R data model of the E-RDM
2.10 Best practice rules
2.11 The math behind E-RDs and restriction sets. The danger of
"many-to-many relationships" and the correct E-RD of E-RDM
Chapter 3. The Quest for Data Independence, Minimal Plausibility, and
Formalization: The Relational Data Model (RDM)
3.1 First normal form tables, columns, constraints, rows, instances
3.2 The five basic relational constraint types
3.3 The algorithm for translating E-R data models into relational schemas
and non-relational constraint sets (A1-7). An RDM model of the E-RDM
3.4 Case study: the relational scheme of the public library data model
3.5 The reverse engineering algorithm for translating relational schemas
into E-R data models (REA1-2)
3.6 The algorithm for assisting keys discovery (A7/8-3)
3.7 RDBMS metacatalogs. Relational and E-R data models of the RDM
3.8 Relational schemas definition. SQL DDL
3.9 Relational instances manipulation. SQL DML. Relational calculi and
algebra
3.10 Higher and the highest RDM normal forms
3.11 Best practice rules
3.12 The math behind RDM
Chapter 4: Relational Schemas Implementation and Reverse Engineering
4.1 The algorithm for translating relational schemas into SQL DDL ANSI-92
scripts (A8)
4.2 Relevant differences between IBM DB2, Oracle Database and MySQL,
Microsoft SQL Server and Access
4.3 Case study: implementing the public library RDB into DB2, Oracle,
MySQL, SQL Server, and Access
4.4 The reverse engineering algorithm for translating Access 2013 RDB
schemas into SQL ANSI DDL scripts (REA2013A0), a member of REAF0'
4.5 The algorithms for translating E-R data models into RDBs and associated
non-relational constraint sets (AF1-8)
4.6 The reverse engineering family of algorithms for translating RDB
schemas into E-R data models (REAF0-2)
4.7 Case study: reverse engineering of an Access Stocks DB scheme into both
an ANSI standard SQL DDL script and an E-R data model
4.8 Best practice rules
4.9 The math behind the algorithms presented in this chapter
Chapter 5: Conclusion
5.1 Database axioms
5.2 Why do we need another conceptual level for expert DB design?
5.3 What are the most important things that we should be aware of in DBs?
Appendix: Mathematic prerequisites for the math behind
Index