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: 1899 | 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: 2135 | 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: 1951 | 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: 2205 | 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: 1912 | 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: 1857 | 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: 1920 | 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: 1970 | 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: 1924 | Lượt tải: 0
Modeling the Calendarmaintain calendars on these terms, allowing the user to see April 18, 2002 instead of day 198, and yet internally, such systems continue to count days based on working and nonworking days. By their very nature, factory calendars are localized. That is, each production facility may have its own factory calendar to reflect the workdays and shifts wit...
46 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1840 | Lượt tải: 0
