Database books Page20

1. Introduction of Oracle XML Cheatsheet
   Oracle posesses a variety of powerful XML features. A tremendous amount of documentation exists regarding Oracle's XML features. This resource is intended to be a cheatsheet for those of us who don't have time to wade through the hundreds of pages of documentation, but instead wish to quickly understand how to create simple XML output and input XML into a database. Gets the XML document by fetching the maximum number of rows specified. It appends the XML document to the CLOB passed in. Use this version of GETXML Functions to avoid any extra CLOB copies and to reuse the same CLOB for subsequent calls. Because of the CLOB reuse, this GETXML Functions call is potentially more efficient.
                        
2. The Sybase Power Designer
   PowerDesigner, a business process modeling approach to align business and IT, is an enterprise data modeling and database design solution that helps implement effective Enterprise Architecture and brings a powerful conceptual data model to your application development life cycle. PowerDesigner uniquely combines several standard data modeling techniques together with leading development environments such as .NET, Workspace, PowerBuilder, Java™, Eclipse, etc., to bring business analysis and formal database design solutions to the traditional software development lifecycle. And it works with all modern RDBMS.
     
3. What is SQL
   SQL is used to communicate with a database. According to American National Standards Institute (ANSI), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database.
                                        
4. Oracle XML DB and J2EE features Security Implementation
   The XMLNews application has adopted Form-based-authorization to customize the user authentication interface. In form-based authentication, you can customize the login screen and error pages that are presented to the end user by an HTTP browser. Also, the content of the user dialog box is sent as plain text, and the target server is not authenticated. In XMLNews application, authentication is only for the UI (JSPs) i.e Views layer and not for the underlying EJBs. From the security perspective, there are two types of web pages in the application; authenticated and non-authenticated pages. To access the authenticated pages, end-users have to be authenticated. In the current sample application, user validation for username/password is done against Oracle database table using custom UserManager class. Apart from the username/password validation, role validation is also done. With this, the application is implemented in such a way that content of the authenticated page will also depend on the role of the user. 
                 
5. The oracle XML DB and J2EE features
   Web services are a set of emerging standards that describe service-oriented, component-based application architecture. Web Services enable loosely coupled, reusable software components that semantically encapsulate discrete functionality and are distributed and programmatically accessible over standard Internet protocols. Web Services as they stand today comprise of open Internet standards like WSDL(Web Services Description Language), Simple Object Access Protocol (SOAP), and Universal Description Discovery and Integration (UDDI). WSDL is used to describe the Web Service, UDDI is used to publish and query Web Services described in WSDL, and finally SOAP is used to invoke the Web Service. This is the common Web Services programming model.
   
   
6. Introduction of Microsoft Access Tutorial
   This tutorial is designed to get the user up and running with MS Access in a rapid fashion. The four basic modules of Access are demonstrated: Tables, Forms, Reports and Queries. A business example is discussed first which provides a background for developing a simple database. It is assumed that users of this tutorial are proficient in working with Microsoft Windows '95, Windows '98, Windows NT, Windows 2000 or Windows XP and with MS Excel. This includes the use of the keyboard and mouse. The tutorial is based on Microsoft Access which is part of the Microsoft Office Professional suite that also includes MS Excel, MS Word and MS Powerpoint.  The original tutorial was developed specifically for MS Access '97 (part of the MS Office '97 release). Now that MS Access 2000 is widely available, this tutorial has been amended to include explanations of where Access '97 and Access 2000 differ. Most of the basic features and functions are the same between the two versions.