Member Login

E-mail:    Password:  




 TitleDate AddedCompany
whitepaper Microsoft Office Business Scorecard Manager 2005 Deployment Considerations2006-12-29 01:00:26 Microsoft
  In the rapidly changing, complex economic landscape, organizations must be able to link performance measurement to strategy. Although institutional and departmental scorecards, or "Performance indicators," are now being used by a number of organizations to both monitor performance and trigger improvement initiatives. When these improvement initiatives are not supported by reliable data, they are sometimes misguided and fail to achieve the desired results. Therefore, many aspects of scorecard development and deployment depend on an effective use of technology to be successful. With the Business Scorecard Manager 2005, Microsoft brings to the market a solution that allows a more effective collaboration between information technology and business and faster deployment of performance management solutions.   
whitepaper New Life for Old Microsoft Access Data2006-10-17 01:00:14 Oracle
  One of the sad facts about people's relentless journey forward in the world of computers and software is that they sometimes find themselves abandoning old data. People move from one word processing office package to another, only to discover that their old documents can no longer be opened. The same is true of databases. A small shop may find that storing information on a PC database is sufficient, but what happens when it's time to move? People may gripe about leaving their valuable information behind, but they often do leave it.   
whitepaper The DeployPHP Series, Part 1: Optimizing PHP and Oracle2006-10-17 01:00:14 Oracle
  The open-source language PHP: Hypertext Preprocessor (PHP) powers some of the most popular Web sites in the world, such as Yahoo!, Lufthansa, and Disney Online. This fact is even more remarkable when a person considers that PHP does so much with so little. As a PHP developer, one knows that the database is probably the most important component with which he or she will be interacting. In this first paper in the DeployPHP Series, the author discusses the checklist for developing and deploying powerful and scalable PHP applications on Oracle.   
whitepaper XML Schema: Understanding Datatypes2006-10-13 01:00:15 Oracle
  The W3C XML Schema Datatype Specification defines numerous datatypes for validating the element content and the attribute value. These datatypes can be used to validate only the scalar content of elements, and not the non-scalar or mixed content. The text enclosed between the and element tags, and the value of the attributes are often referred to as scalar data, but it can also be a list of scalar data. These datatypes are intended for use in XML Schema definition and other XML-related documents. Initially, Document Type Definition (DTD) was the only grammar available for validating XML instances.   
whitepaper Strings Attached2006-10-13 01:00:15 Oracle
  Many PL/SQL programs manipulate data, often by using SQL to work with that data directly in the database. Yet a person often needs to declare and manage data within PL/SQL programs themselves. This program data might consist of individual values (scalars). In many other situations, however, one may deal with much more complex data structures, from records to objects (instances of object types) to lists. Lists (and, in their more complex manifestation, arrays) are crucial elements in a programmer's toolbox. To create and manage these lists, PL/SQL offers a variety of structures - called collections: nested tables, varying arrays, and associative arrays. Associative arrays were introduced in Oracle9i Release 2 to replace index-by tables (which replaced PL/SQL tables in Oracle8).   
whitepaper Crafting Service Providers: Packages With Focused Functionality2006-10-13 01:00:15 Oracle
  This paper takes a look at the lower end of the hierarchy of OverloadCheck software, where there are several packages that are relatively small, focused units. These offer services to higher-level packages. One important element of software design is to identify these distinct services and craft individual packages (or perhaps object types) that consolidate information related to those services. The cc_arguments package is a much smaller, simpler unit than cc_smartargs. It has a clear mission in life: to extract information from ALL_ARGUMENTS and DBMS_DESCRIBE so that the maximum, and most accurate, data about arguments is available through a clean, simple Application-Programming Interface (API).   
whitepaper New CONNECT BY Features in Oracle Database 10g2006-10-13 01:00:15 Oracle
  This paper details the three new CONNECT BY features in Oracle Database 10g. The new CONNECT BY features in Oracle Database 10g - CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, and CONNECT_BY_ISCYCLE - are well thought out and welcome improvements to Oracle's hierarchical query support. These features solve common and longstanding problems inherent in querying hierarchical data, problems that are difficult to solve otherwise. Using these features, a person can focus less on implementation details and more on the big picture of what he or she needs to accomplish, getting work done that is needed to be done simply and without fuss.   
whitepaper Querying Hierarchies: Top-of-the-Line Support2006-10-13 01:00:15 Oracle
  The first databases were hierarchical, not relational, a reflection of how common hierarchies are in the modern world. Hierarchical databases proved cumbersome, and relational databases, with their tables and columns, and their implementations of the common SQL interface, eventually won the day. However, hierarchical data is still around, and will always be. Unfortunately, the relational model doesn't deal well with hierarchical data. Most implementations of SQL provide no support for querying tables recursively. But Oracle bucks this trend, recognizes the reality of hierarchical data, and provides powerful support for querying tables containing such data.   
whitepaper Oracle9i Business Intelligence Beans: Making the Move2006-10-13 01:00:15 Oracle
  Before decision makers at all levels can quickly respond to changes in the business climate - the ultimate goal of business intelligence - businesses themselves need to analyze their own mechanisms and performance. But to do so, they have to examine the often overwhelming amount of information stored in databases. Of course, these analytical queries require the use of an OnLine Analytical Processing (OLAP) solution. Oracle customers have long used Oracle Express databases and the application platforms that go with them - Oracle Web Agent and Oracle Express Objects (OEO) - to meet their business intelligence needs. Oracle has now merged its relational database with the Express multidimensional database to create Oracle9i Database Release 2 with the OLAP Option.   
whitepaper Writing Better SQL Using Regular Expressions2006-10-13 01:00:15 Oracle
  A new feature of Oracle Database 10g vastly improves the ability to search and manipulate character data. This feature, regular expressions, is a notation for describing textual patterns. It has long been available in many programming languages and a number of UNIX utilities. Oracle's implementation of regular expressions comes in the form of various SQL functions and a WHERE clause operator. For those who are unfamiliar with regular expressions, this paper gives a glimpse into this new and extremely powerful yet seemingly cryptic capability. Readers already familiar with regular expressions can gain an understanding of how to apply this functionality within the context of the Oracle SQL language.