Changing dataand its supporting structures: tables and databases. Edit Mode When we browse a table or view results from a search on any single-table query, small icons appear on the left or right of each table row: The row can be edited with the pencil-shaped icon and deleted with the X-shaped icon. The exact form and location of these controls are governed by:...
32 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1908 | Lượt tải: 0
Mysql server administration with phpmyadminExample has only one running process, the process created by the SHOW PROCESSLIST command itself. This process is not killable because it is no longer running when we get to see the page. We would normally see more processes running on a server. Storage Engines Information about the various storage engines is available on a two-level format. First,...
24 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1798 | Lượt tải: 0
Relational SystemBenefits of the Defined Relations In this section we will look at the benefits that we can currently test; other benefits will be described in Chapter 13 (The Multi-Table Query Generator) and Chapter 15 (System Documentation). Some other benefits of the linked-tables infrastructure will appear in Chapter 14 (Bookmarks) and Chapter 16 (MIME-Based Tr...
32 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2054 | Lượt tải: 0
Searching DataSelection of Display Fields The first panel facilitates selection of the fields to be displayed in the results: All fields are selected by default, but we can control-click other fields to make the necessary selections. Chapter 9 [ 143 ] Here are the fields of interest to us in this example: We can also specify the number of rows per page in the te...
32 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1858 | Lượt tải: 0
Exporting Structure and DataThe options in Structure section are: Add custom comment into header: We can add our own comments for this export (for example, 'Monthly backup') which will show in the export headers (after the PHP version number). If the comment has more than one line, we must use the special character \n to separate each line. Enclose export in a transaction: St...
32 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2093 | Lượt tải: 0
Comparison of Data Warehouse MethodologiesFor the MD approach, the multidimensional or star schema data model is easy to understand by the business community. The data model is generally less complex and resembles the way many business community members think about their data—that is, they think in terms of multiple dimensions, for example, “Give me all the sales revenues for each store, i...
44 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1816 | Lượt tải: 0
Maintaining the Modelscorrespond to each subject area. (This technique cannot be used if the tool does not provide the ability to divide the model into subject area views.) This technique facilitates the grouping of the data entities by subject area and the provision of views accordingly. The major advantages of this technique are: ■■ Each entity is assigned to a subjec...
46 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1769 | Lượt tải: 0
Data warehouse optimizationPerformed by the database’s optimizer, and as a result it would either look at all rows for the specific date and scan for customer or look at all rows for the customer and scan for date. If, on the other hand, you defined a compound b-tree index using date and customer, it would use that index to locate the rows directly. The compound index would ...
46 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1813 | Lượt tải: 0
Modeling transactionsDelta Snapshot Interface The delta snapshot is a commonly used interface for reference data, such as a customer master list. The basic delta snapshot would contain a row or transaction that changed since the last extraction. It would contain the current state of all attributes without information about what, in particular, had changed. This is the ...
46 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1880 | Lượt tải: 0
Modeling hierarchiesThe lowest level of the customer’s distribution hierarchy is the ship-tocustomer location. These are grouped under sold-to customers, which represent the customer’s purchasing representatives. These are further grouped into planning customers, which is the lowest level at which sales plans are estimated. Figure 7.9 shows the full hierarchy. Capacit...
46 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1838 | Lượt tải: 0
