Managing the database

Since community buildings are a large group of assets managed by local city councils, current research has the potential to identify asset management deficiencies and assist in improving an integrated management model by: Establishing deterioration trends in building components for community buildings; Validating proposed deterioration using case-study data; Developing a database of costs to facilitate optimisation of maintenance; Developing a methodology to integrate deterioration and cost to optimize maintenance requirements.

186p runthenight05 01-03-2023 6 3   Download

The research objectives of the thesis: To establish the scientific basis and methodology to build WebGIS database in order to improve the efficiency of mineral exploitation management and activities.

27p dolphintaletale 23-04-2021 35 6   Download

In this chapter you will: To understand how firms create an internal database, to learn about building a database from a Web site, to become familiar data mining, to understand the advantages and disadvantages of of using secondary data, to understand the role of the Internet in obtaining secondary data, to learn about types of information management systems.

13p allbymyself_06 28-01-2016 63 4   Download

Lecture "Chapter 13: Designing databases" provides students with the knowledge: Learning objectives, databases and database management systems, components of a DB and DBMS, DBMS important capabilities, relational databases, partial display of relational database,... Invite you to consult.

10p doinhugiobay_04 27-11-2015 59 2   Download

Quản lý dữ liệu là một phần không thể thiếu đối với việc phát triển các hệ thống thông tin, quản lý dữ liệu theo thời gian trong các hệ thống thông tin ứng dụng trong các lĩnh vực thay đổi thường xuyên và đòi hỏi nhiều yêu cầu như tài chính, ngân hàng, viễn thông, y tế ...

110p tangtocmuathi 30-05-2013 182 32   Download

After completing this lesson, you should be able to do the following: Use the Oracle tuning methodology to diagnose and resolve performance problems Use Oracle tools to diagnose performance problems Understand the goals of the workshop

14p trinh02 28-01-2013 69 5   Download

After completing this lesson, you should be able to do the following: Describe different system architectures Describe the primary steps of OS tuning Identify similarities between OS and DB tuning Understand virtual memory and paging Explain the difference between a process and a thread

14p trinh02 28-01-2013 47 5   Download

After completing this lesson, you should be able to do the following: Interpret the concept of a hierarchical query Create a tree-structured report Format hierarchical data Exclude branches from the tree structure

18p trinh02 28-01-2013 45 3   Download

Auditing If an unauthorized user is deleting data, then the DBA might decide to audit all connections to the database and all successful and unsuccessful deletions from all tables in the database. The DBA can gather statistics about which tables are being updated, how many logical inputs/outputs (I/Os) are performed, and how many concurrent users connect at peak times.

16p trinh02 28-01-2013 52 9   Download

After completing this lesson, you should be able use the following datetime functions: TZ_OFFSET CURRENT_DATE CURRENT_TIMESTAMP LOCALTIMESTAMP DBTIMEZONE SESSIONTIMEZONE EXTRACT FROM_TZ TO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL

20p trinh02 28-01-2013 48 2   Download

Users and Security Security domain The database administrator defines the names of the users who are allowed to access a database. A security domain defines the settings that apply to the user. Authentication mechanism A user who requires access to the database can be authenticated by one of the following: Data dictionary Operating system Network The means of authentication is specified at the time the user is defined in the database and can be altered later. This lesson covers authentication by database and by operating system only.

20p trinh02 28-01-2013 82 3   Download

This workshop covers: Creating tables and sequences Modifying data in the tables Modifying table definitions Creating views Writing scripts containing SQL and iSQL*Plus commands Generating a simple report

14p trinh02 28-01-2013 74 4   Download

After completing this lesson, you should be able to do the following: Identify issues associated with managing users in an Oracle Shared Server environment Configure the Oracle Shared Server environment to optimize performance Diagnose and resolve performance issues with Oracle Shared Server processes

14p trinh02 28-01-2013 61 5   Download

After completing this lesson, you should be able to do the following: Monitor and size the redo log buffer Monitor and size the Java pool Control the amount of Java session memory used by a session

16p trinh02 28-01-2013 49 5   Download

Control File The control file is a small binary file necessary for the database to start and operate successfully. Each control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine whether the database is in a valid state to use. A control file is updated continuously by the Oracle server during database use, so it must be available for writing whenever the database is open. The information in the control file can be modified only by the Oracle server; no database administrator or end user can edit the control file....

16p trinh02 28-01-2013 56 2   Download

Built-In Database Objects In addition to creating the database files, several other structures are created. Data dictionary: Contains descriptions of the objects in the database Dynamic performance tables: Contains information used by the database administrator (DBA) to monitor and tune the database and instance PL/SQL packages: Program units adding functionality to the database. These packages are created when the catproc.sql script is run after the CREATE DATABASE command. PL/SQL packages will not be discussed within the scope of this course.

20p trinh02 28-01-2013 63 4   Download

After completing this lesson, you should be able to do the following: Implement dynamic SGA allocation Dynamically adjust the buffer caches Dynamically adjust the shared pool

12p trinh02 28-01-2013 34 4   Download

After completing this lesson, you should be able to do the following: Define the roles associated with the database tuning process Describe the dependencies between tuning in different development phases Describe service level agreements Identify tuning goals Identify common tuning problems Employ tuning activities during developmentand production Balance performance and safety trade-offs

16p trinh02 28-01-2013 49 5   Download

Before a database is created, the UNIX environment must be configured and the Oracle9i server must have already been installed. Four environment variables must be set: ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH. ORACLE_HOME is the full path to the top directory in which the Oracle9i Server is installed. The directory for ORACLE_HOME should be supplied by the person who installed the server, usually the UNIX administrator or the DBA. ORACLE_SID is a user-definable name assigned to an instance of a database.

10p trinh02 28-01-2013 62 6   Download

Course Objectives This course is the first in a series of courses that cover the core database administrator tasks. The tasks covered in this course are: Outlining the Oracle architecture Planning and creating databases Managing the memory, process, physical, and logical structures Managing database users by controlling and monitoring their actions Using the Globalization Support features

4p trinh02 28-01-2013 60 4   Download