0
What is the difference between data administrator and database designer?
Wiki User
∙ 14y ago
(Additional answers or links to help answer the question are welcome.)
AnswerWell, assuming that you are not a IT person, my answer is that the administrator is someone that manages the information(data) and databases(the boxes) and the designer creates the database schema (the way the data should be stored in the database, logic and physic). In my opinion, this two concepts should be always together, I mean, the DBA must know administration and design of databases.
AnswerThe database administrator (DBA) should know something of database design, and in a small shop the DBA might handle both the administration and the data design. But since both areas (database administration and database design) require a lot of different and extensive knowledge and experience, best results can be had when there are experts in both areas. The DBA will work closely with the system administrator and may in fact also be an SA. The database designer will work closely with the software developers, as the data structure is integral to the software application. Of course, the database administrator and the database designer must coordinate with each other throughout the project.
The DBA works with the RDBMS (relational database management system) itself and should know how to install and configure the RDBMS application. The DBA will work with the SA on tuning the system to best support the database engine and the database usage. The DBA and SA will work on sizing, storage, and backup management. The DBA is ultimately responsible for backups and everything else to do with data integrity (at the database level). The DBA will monitor data handling operations and either make database-level changes to improve performance or, through analysis, capture information to pass back to the data designer or development staff for their use in improving their usage of the database.
The database designer should understand something of software development and applications structure. The designer will learn from the applications designers the data types, quantities, relationships, and desired operations (searches, sorts, updates, etc.) and work with the developers to design a structure/schema that will meet the requirements of the software application in terms of function and performance and at the same time assure data integrity. The designer will be considering matters such as unique keys, primary and foreign keys, data types, counters, naming, table relationships, search and sort elements, database normalization, search and sort efficiency, and data integrity.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is the difference between database and database administrator?
Database is the data stored in the server and Database administrator is the person who designs the database.
What is the difference between oracle and oracle?
Oracle is one of the popular database and DBA (DataBase Administrator) is the person who maintain the database (install oracle software, create,setup,maintain database)
Difference between database administrator and system administrator?
A System Administrator is generically responsible for all parts of the computer network, such as user accounts, computer accounts, domain trusts, email accounts, etc. The System Administrator is probably specialized in the network server operating systems and user administration. A Database Administrator would deal specifically and in depth with all aspects of one or more databases. The Database Administrator will be highly specialized with the specific database server and client software.
What's the average database administrator salary?
The average database administrator's salary can range anywhere between; $30,000 and above. If you don't have a degree and a lot of experience you can start at the salary above.
What is the difference between an inventor and a designer?
an inventor is a designer but a designer is not an inventor
What is the difference between database administrator and database analyst?
An administrator can manage, create, delete and update a database. The manager can just update and manage (complete fields). He can't create or delete database. I am a database administrator. An Administrator takes care of the database--having privileges to do anything to a database. Create objects, delete objects, drop objects. A Database Manager is a supervisor over the Database Administrator. Usually a database manager does not know the specifics of an administrator position--but must have high level knowledge of how a database works. That is not to be confused with the database manager that is the non-human engine for the database that provides authorization control, makes integrity checks, and commands the processor.
What is Difference between real time database and simple database?
the difference is about the transactions. the normal database is not included deadline, but the real time database is.
Can any one please tell me the difference between database management and data warehousing in brief?
Database management involves designing the actual tables in a database and making sure that the database is up and running smoothly. This is performed by a database administrator (DBA). Data warehousing involves storing data in a database. The DBA designed the database, but someone else (or a program that someone else is running) is actually inserting the data into the database.
What is the difference between administrator and administrators?
Administrators is a group of administrator administrator is a user ans cab be a part of administrators group
What is the difference between a secretary and an administrator?
An Administrator manages paperwork, whilst a secretary deals with paperwork.
What is the difference between a textile designer and a fashion designer?
,I want to ask you that what is the difference between fashion designing and textile desiging,plz reply me,,,
What are difference between cache database and sql database?
CACHE is multidimensional and postconsonantal database and its supporting scripting
