• Oracle: XSQL Combining SQL, Oracle Text, XSLT, and Java to Publish Dynamic Web ContentOracle: XSQL Combining SQL, Oracle Text, XSLT, and Java to Publish Dynamic Web Content

    About the Author xix Chapter 1 Introducing Oracle XSQL 1 What XSQL Solves 2 The Problems of Web Application Development 2 XSQL as a Keystone Technology 5 XSQL and Other Oracle Technologies 11 Oracle Text 12 XMLSupport 12 Oracle JDeveloper 13 Introduction to XML 13 The Role of XML 13 Well-Formed versus Valid Documents 15 Document Structure 15 Proces...

    pdf60 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2081 | Lượt tải: 0

  • Oracle sql internals handbookOracle sql internals handbook

    You can store SQL in the application itself (Java side) and access the database directly from the applet via a SQL statement. Or the programmer can make a request from the applet to the servlet, which then sends the SQL to the database. Another option within Java is to simply make a procedure or function call (Callable Statement in JDBC Driver) and...

    pdf20 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2239 | Lượt tải: 0

  • Changing dataChanging data

    and 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:...

    pdf32 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1999 | Lượt tải: 0

  • Mysql server administration with phpmyadminMysql server administration with phpmyadmin

    Example 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,...

    pdf24 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1897 | Lượt tải: 0

  • Relational SystemRelational System

    Benefits 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...

    pdf32 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2132 | Lượt tải: 0

  • Searching DataSearching Data

    Selection 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...

    pdf32 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1949 | Lượt tải: 0

  • Exporting Structure and DataExporting Structure and Data

    The 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...

    pdf32 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2202 | Lượt tải: 0

  • Comparison of Data Warehouse MethodologiesComparison of Data Warehouse Methodologies

    For 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...

    pdf44 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1910 | Lượt tải: 0

  • Maintaining the ModelsMaintaining the Models

    correspond 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...

    pdf46 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1855 | Lượt tải: 0

  • Data warehouse optimizationData warehouse optimization

    Performed 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 ...

    pdf46 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1918 | Lượt tải: 0