Database Administration

A database administrator (short form DBA) is a person responsible for the design, implementation, maintenance and repair of an organization's database. They are also known by the titles Database Coordinator or Database Programmer, and is closely related to the Database Analyst, Database Modeller, Programmer Analyst, and Systems Manager. The role includes the development and design of database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database. Employing organizations may require that a database administrator have a certification or degree for database systems (for example, the Microsoft Certified Database Administrator).

This book is your ultimate resource for Database Administration. Here you will find the most up-to-date information, analysis, background and everything you need to know.

In easy to read chapters, with extensive references and links to get you to know all there is to know about Database Administration right away, covering: Database administration and automation, Database management system, Comparison of database tools, Comparison of object-relational database management systems, ACID, ANSI-SPARC Architecture, Armstrong's axioms, Associative model of data, AutoNumber, Bidirectionalization, Big data, Bitemporal data, Block contention, Candidate key, Citrusleaf database, Column-oriented DBMS, Commit (data management), Comparison of relational database management systems, Connection pool, Correlation database, Create, read, update and delete, Cursor (databases), Data Control Language, Data Definition Language, Data Manipulation Language, Data mart, Data masking, Data redundancy, Data retrieval, Data store, Database, Database design, Database dump, Database engine, Database model, Database normalization, Database storage structures, Database system, Database theory, Database transaction, Database trigger, Database tuning, Datasource, Deductive database, Distributed database management system, Document-oriented database, Enterprise database management, Expression index, Federated database system, Foreign key, Formatted File System, Heterogeneous Database System, Hierarchical query, In-database processing, In-memory database, Index (database), InfinityDB, Integrated Data Management, ISBL, Least number bits, Life cycle of a relational database, List of object database management systems, List of relational database management systems, Mariposa (database), Master data management, Metadatabase, Microsoft Access, MultiValue, Nested SQL, No-force, Object database, Object Exchange Model, Object-based spatial database, Object-relational database, Online transaction processing, Oracle Database, Oracle Exadata, Partial index, Partition (database), Polyinstantiation, Pool (computer science), Precedence graph, Probabilistic database, QUEL query languages, Query language, Query optimization, Query optimizer, Query plan, Quorum (distributed computing), Referential integrity, Materialized view, Relation (database), Synonym (database), Relational algebra, Relational calculus, Relational database, Relational database management system, Relational model, Remote Database Access, Resources, Events, Agents, Rollback (data management), Sargable, Secondary database server, Shard (database architecture), Shared read lock, Smart variables, Spatiotemporal database, SQL, Microsoft SQL Server, Stored procedure, Superkey, Surrogate key, Table (database), Tablespace, Tactical Munitions Recording System, Temporal database, The Third Manifesto, Transaction Control Language...and much more

This book explains in-depth the real drivers and workings of Database Administration. It reduces the risk of your technology, time and resources investment decisions by enabling you to compare your understanding of Database Administration with the objectivity of experienced professionals.