Có 40+ tài liệu thuộc chủ đề "giáo trình sql cơ bản"
tailieu.vn Xem trực tuyến Tải xuống
Encoding Business Rules for the OLTP Database Model. LISTING# CHAR(10) NOT NULL,. BUYER_ID INTEGER FOREIGN KEY REFERENCES BUYER NOT NULL, BID_PRICE MONEY. CHECK(VERIFY_BID(LISTING#, BID_PRICE)) NOT NULL,. BID_DATE DATE FORMAT “DD MON, YEAR” NOT NULL, CONSTRAINT PRIMARY KEY (LISTING#, BUYER_ID). 18_574906 ch12.qxd PM Page 373. Encoding Business Rules for the Data Warehouse Database Model. Try It Out Field Level Business Rules...
tailieu.vn Xem trực tuyến Tải xuống
Both are somewhat out of date in the larger-scale relational database engines. Clusters are used to contain fields from tables, usually a join, where the cluster contains a physical copy of a small portion of the fields in a table — perhaps the most commonly accessed fields. A clustered index (index organized table, or IOT) is a more complex type...
tailieu.vn Xem trực tuyến Tải xuống
Metadata —The tables and the fields defining the structure of the data. Microsoft Windows — The Microsoft Windows operating system.. A foreign key field can contain a NULL value, and it can’t be a part of the primary key because a primary key requires uniqueness.. Normal Forms —The steps contained within the process of Normalization. Normalization — The process of...
tailieu.vn Xem trực tuyến Tải xuống
MUSICIAN_ID INTEGER FOREIGN KEY REFERENCES MUSICIAN WITH NULL, DATE DATE NOT NULL,. CREATE TABLE INSTRUMENT. INSTRUMENT_ID INTEGER PRIMARY KEY NOT NULL,. SECTION_ID INTEGER FOREIGN KEY REFERENCES INSTRUMENT WITH NULL, INSTRUMENT CHAR VARYING(32) NOT NULL. CREATE TABLE MUSICIAN. MUSICIAN_ID INTEGER PRIMARY KEY NOT NULL, MUSICIAN CHAR VARYING(32) NOT NULL, PHONE CHAR VARYING(32) NULL, EMAIL CHAR VARYING(32) NULL. CREATE TABLE GENRE. GENRE_ID...
tailieu.vn Xem trực tuyến Tải xuống
data warehouse database model, 374 OLTP database model, 373–374 end-users. client-server database, 195 data warehouse database, 196 OLTP database, 194. simple database model, 25. with referential integrity, 279–282 snowflake schema, 179. business rules. data warehouse database model described, 364. OLTP database model data warehouse database sample, 349–352 described . OLTP database sample, 346–348 restricting values. data warehouse database model, 323–329...
tailieu.vn Xem trực tuyến Tải xuống
Oracle® Database. 2 Day DBA. Oracle Database 2 Day DBA 11g Release 1 (11.1) Part No. If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:. About This Guide. 1-1 What This Guide Is Not. 1-1 About Oracle Database. 1-2 Tools...
tailieu.vn Xem trực tuyến Tải xuống
Installing Oracle Database and Creating a Database. This chapter describes how to install Oracle Database software and create a database.. If you are using an earlier release of Oracle Database and want to install a later release of the Oracle Database software, you can upgrade your existing Oracle Database and use it with the new release of the database software....
tailieu.vn Xem trực tuyến Tải xuống
Starting and Stopping the Database Control Console Process. Navigational features of the Database Home page include the following:. These links take you to the various Database Control subpages that organize management tasks into distinct categories. For example, clicking the link next to the label Host provides additional detail about the computer on which the database runs.. To access Oracle Enterprise...
tailieu.vn Xem trực tuyến Tải xuống
Managing the Oracle Instance. Overview of the Oracle Instance and Instance Management. Oracle database—An Oracle database contains a set of operating system files that store data entered by users or applications, and structural information about the database itself called metadata. An instance must be started to read and write information to the database. Also, it is the instance that actually...
tailieu.vn Xem trực tuyến Tải xuống
Oracle By Example (OBE) has a series on the Oracle Database 2 Day DBA guide. Oracle Database Performance Tuning Guide for more information about memory parameters and their tuning. Managing the Redo Log. An Oracle database is made up of physical and logical structures. Logical structures are created and recognized by Oracle Database and are not known to the operating...
tailieu.vn Xem trực tuyến Tải xuống
About the Segment Advisor. Online segment shrink operates on table segments and on the segments of the dependent objects of the table, such as indexes and partitions. For each segment, data is compacted to the front of the segment. Free space can either be returned to the tablespace or kept in the segment for future insert operations. no additional free...
tailieu.vn Xem trực tuyến Tải xuống
In the Name field, enter APPDEV. In the Available System Privileges list, double-click privileges to add them to the Selected System Privileges list. The APPDEV role now appears in the table of database roles.. In the Select column, click APPDEV role, and then click Edit.. In the Available Roles list, double-click the roles AQ_ADMINISTRATOR_ROLE and AQ_USER_ROLE to add them to...
tailieu.vn Xem trực tuyến Tải xuống
You can configure table compression on the Storage subpage of the Create Table page.. In the Database Objects section, click Tables.. In the Schema field, enter the name of a schema. Leave the Object Name field blank to search for and display all tables in the schema. If you enter a search string in the Object Name field, all tables...
tailieu.vn Xem trực tuyến Tải xuống
Managing Program Code Stored in the Database. About Program Code Stored in the Database. Oracle Database offers the ability to store program code in the database. You access administration pages for these objects by clicking links in the Programs section of the Schema subpage.. Database Control notifies you when schema objects become invalid by displaying an alert in the Alerts...
tailieu.vn Xem trực tuyến Tải xuống
On the Database Home page, click Availability to display the Availability subpage.. In the Availability page, click Perform Recovery.. In the User-Directed Recovery section, select Datafiles or Tablespaces from the Recovery Scope list, depending on what you want to validate.. In the Backup Selection section, specify which backups should be restored.. In the Backup Validation section, select Validate the specified...
tailieu.vn Xem trực tuyến Tải xuống
This is the start time of the time period most recently analyzed by ADDM. This is the timestamp of the most recent alert log entry that describes an ORA- error.. View the SQL Response Time section.. A reference collection, or SQL Tuning Set, is set of SQL statements that represents the typical SQL workload on your production system. Click the...
tailieu.vn Xem trực tuyến Tải xuống
In the Top SQL section, select one or more SQL statements, and then click the Go button next to Schedule SQL Tuning Advisor.. A Processing page appears. Go to the Database Home page.. on page 3-4.. On the Advisor Central page, click SQL Advisors.. On the SQL Advisors page, click SQL Access Advisor.. Adequate physical memory has a significant impact...
tailieu.vn Xem trực tuyến Tải xuống
As part of the patching procedure, the database instance and Database Control are shut down and then restarted. Click the Database tab.. Using Database Control, on the Database Home page, in the Policy Violations section, view the count for Critical Security Patches.. Oracle home for the database. Also, a warning icon appears corresponding to the Oracle Home link on the...
tailieu.vn Xem trực tuyến Tải xuống
Administering Automatic Storage Management A-11 To drop one or more disks from a disk group:. See "Accessing the Automatic Storage Management Home Page". If the Automatic Storage Management Login page appears, log in as the SYS user, connecting as SYSASM. Click a link in the Name column to select the disk group from which you want to drop disks.. The...
tailieu.vn Xem trực tuyến Tải xuống
Microsoft ® SQL Server ™ 2005. any other use of the work is strictly prohibited. Michael Otey is Senior Technical Editor of SQL Server Magazine and co-author of SQL Server 2000 Developer’s Guide, SQL Server 7 Developer’s Guide, and ADO.NET: The Complete Reference. She has extensive experience developing commercial software products, and is the co-author of ADO.NET: The Complete Reference.....