Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Mike

Pages: 1 ... 115 116 [117] 118 119 ... 122
1741
PSOUG / Working with BLOB and CLOB
« on: September 11, 2009, 08:57:56 AM »
Working with BLOB and CLOB

LOB basics
LOB stands for Large OBject, a stream of data stored in a database. Maximum capacity of a LOB is (4 gigabytes-1) bytes.In Oracle three kinds of LOB data type exist:

1) BLOB datatype stores unstructured binary large objects.   BLOB objects can be thought of as bitstreams with no character set semantics.

2) The CLOB datatype stores single-byte and multibyte character data. Both   fixed-width and variable-width character sets are supported, and both use the database character set.

3) The NCLOB datatype stores Unicode data.

dotConnect for Oracle supports all three datatypes.

You can retrieve values of LOB fields using OracleDataReader as well as other types like LONG and LONG RAW. The difference with usage of LOB data type becomes evident when you need to access these fields in DML and PL/SQL statements. For BLOB and CLOB data types only LOB locators (pointers to data) are stored in table columns; actual BLOB and CLOB data is stored in separate tablespace. This is the difference to the way that data of LONG or LONG RAW types is stored in database - tables hold their immediate values.

Another issue you should be aware of is temporary LOBs. This kind of object is not referenced by any table yet. It exists in current transaction only. You have to use temporary LOBs when inserting new data to a table. In dotConnect for Oracle, you can create temporary LOBs using OracleLob constructors. Once you create an OracleLob instance, the corresponding temporary LOB appears on the server and any data you insert into the object is sent immediately to server. An example of using temporary LOBs you will see later in the article.

Working with BLOB data
Binary data is generally represented as stream of bytes, or buffers. dotConnect for Oracle allows manipulating BLOB data in most convenient ways. You can work with OracleLob.Value property or use OracleLob.Read() and OracleLob.Write() methods to transfer data to and from the server. Both ways are presented in the samples below. Note that when OracleLob.LobType property is OracleDbType.Blob the OracleLob.Value is treated as an array of bytes (byte[]), whereas OracleDbType.Clob and OracleDbType.NClob representOracleLob.Value as string.

The next sample routines show how to upload a file from hard disk to server and download it back.To execute these routines you have to create a table that is described as follows:

Code: [Select]
CREATE TABLE PICTURES (
ID NUMBER(12),
PICNAME VARCHAR2(20),
PICTURE BLOB
)

[C#]

Code: [Select]
static void UploadBlob(OracleConnection myConnection)
{
  //Open file on disk
  FileStream fs = new FileStream("D:\\Tmp\\test.bmp", FileMode.Open, FileAccess.Read);
  BinaryReader r = new BinaryReader(fs);
  myConnection.Open();
  //Create temporary BLOB
  OracleLob myLob = new OracleLob(myConnection,OracleDbType.Blob);
  int streamLength = (int)fs.Length;
  //Transfer data to server
  myLob.Write(r.ReadBytes(streamLength), 0, streamLength);
  //Perform INSERT
  OracleCommand myCommand = new OracleCommand(
   "INSERT INTO Pictures (ID, PicName, Picture) VALUES(1,'pict1',:Pictures)", myConnection);
  OracleParameter myParam = myCommand.Parameters.Add("Pictures", OracleDbType.Blob);
  myParam.OracleValue = myLob;
  try
  {
    Console.WriteLine(myCommand.ExecuteNonQuery() + " rows affected.");
  }
  finally
  {
    myConnection.Close();
    r.Close();
    fs.Close();
  }
}

static void DownloadBlob(OracleConnection myConnection)
{
  OracleCommand myCommand = new OracleCommand("SELECT * FROM Pictures", myConnection);
  myConnection.Open();
  OracleDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.Default);
  try
  {
    while (myReader.Read())
    {
//Obtain OracleLob directly from OracleDataReader
OracleLob myLob = myReader.GetOracleLob(myReader.GetOrdinal("Picture"));
if (!myLob.IsNull)
{
   string FN = myReader.GetString(myReader.GetOrdinal("PicName"));
   //Create file on disk
   FileStream fs = new FileStream("D:\\Tmp\\" + FN + ".bmp", FileMode.Create);
   //Use buffer to transfer data
   byte[] b = new byte[myLob.Length];
   //Read data from database
   myLob.Read(b,0,(int)myLob.Length);
   //Write data to file
   fs.Write(b,0,(int)myLob.Length);
   fs.Close();
   Console.WriteLine(FN + " downloaded.");
}
    }
  }
  finally
  {
    myReader.Close();
    myConnection.Close();
  }
}


[Visual Basic]

Code: [Select]
Public Sub UploadBlob(ByVal myConnection As OracleConnection)
'Open file on disk
Dim fs As FileStream = New FileStream("D:\Tmp\test.bmp", FileMode.Open, FileAccess.Read)
Dim r As BinaryReader = New BinaryReader(fs)
myConnection.Open()
'Create temporary BLOB
Dim myLob As OracleLob = New OracleLob(myConnection, OracleDbType.Blob)
Dim streamLength As Int32 = fs.Length
'Transfer data to server
myLob.Write(r.ReadBytes(streamLength), 0, streamLength)
'Perform INSERT
Dim myCommand As OracleCommand = New OracleCommand(
"INSERT INTO Pictures (ID, PicName, Picture) VALUES(1,'pict1',:Pictures)", myConnection)
Dim myParam As OracleParameter = myCommand.Parameters.Add("Pictures", OracleDbType.Blob)
myParam.OracleValue = myLob
Try
Console.WriteLine(myCommand.ExecuteNonQuery() & " rows affected.")
Finally
myConnection.Close()
r.Close()
fs.Close()
End Try
End Sub

Public Sub DownloadBlob(ByVal myConnection As OracleConnection)
Dim myCommand As New OracleCommand("SELECT * FROM Pictures", myConnection)
myConnection.Open()
Dim myReader As OracleDataReader = & _
  myCommand.ExecuteReader(System.Data.CommandBehavior.Default)
Try
While myReader.Read()
  Dim myLob As OracleLob = myReader.GetOracleLob(myReader.GetOrdinal("Picture"))
  If Not myLob.IsNull Then
   Dim FN As String = myReader.GetString(myReader.GetOrdinal("PicName"))
   Dim fs As FileStream = New FileStream("D:\Tmp\" + FN + ".bmp", FileMode.Create)
   Dim w As BinaryWriter = New BinaryWriter(fs)
   w.Write(myLob.Value)
   w.Close()
   fs.Close()
   Console.WriteLine(String.Concat(FN, " downloaded."))
  End If
End While
Finally
myReader.Close()
myConnection.Close()
End Try
End Sub

Working with CLOB data
Working with CLOB data generally is same as working with BLOB data. The difference is in representation of Value property. For CLOB and NCLOB data types when you read from OracleLob.Value property, you get strings. The data is transparently decoded so you do not have to take care about its character set. If you need raw data however you can use streaming capabilities of OracleLob, that is OracleLob.Read and OracleLob.Write methods. Note that since OracleLob.Value is a read-only property, you can write data to LOB only with OracleLob.Write method, and no encoding is performed.

For example, consider this table definition.

Code: [Select]
CREATE TABLE ClobTable (
Id NUMBER,
Name VARCHAR2(30),
Value CLOB
)

If you need to perform simple tasks like fetch record set in most cases you do not needto know about OracleLob. When calling OracleDataReader.GetValue on fetch you get array of bytesfor BLOB column and string for CLOB one. In addition you can use OracleDataReader.GetChars,OracleDataReader.GetBytes to get pieces of LOB value.

For example,

[C#]

Code: [Select]
OracleCommand oraCommand = new OracleCommand("SELECT * FROM ClobTable", oraConnection);
OracleDataReader reader = oraCommand.ExecuteReader();
while (reader.Read())
  Console.WriteLine(reader.GetValue(2));


[Visual Basic]

Code: [Select]
Dim oraCommand As OracleCommand = new OracleCommand( _
"SELECT * FROM ClobTable", oraConnection)
Dim reader As OracleDataReader = oraCommand.ExecuteReader()
while (reader.Read())
Console.WriteLine(reader.GetValue(2))
end while

You can do the same thing using OracleLob object directly.

[C#]

Code: [Select]
OracleCommand oraCommand = new OracleCommand("SELECT * FROM ClobTable", oraConnection);
OracleDataReader reader = oraCommand.ExecuteReader();
OracleLob clob;
while (reader.Read()) {
clob = reader.GetOracleLob(2);
Console.WriteLine(clob.Value);
}



[Visual Basic]

Code: [Select]
Dim oraCommand As OracleCommand = new OracleCommand( _
"SELECT * FROM ClobTable", oraConnection)
Dim reader OracleDataReader = oraCommand.ExecuteReader()
Dim clob As OracleLob
while (reader.Read())
clob = reader.GetOracleLob(2)
Console.WriteLine(clob.Value)
end while

As we see first code cut was shorter. So, usually, you need to access OracleLob directly in more complicated cases (e.g using temporary LOBs, advanced streaming operations).

Inserting LOBs on Oracle server 8.0.5 and older
Temporary LOBs are not supported in Oracle servers version 8.0.5 and older,so you have to create and initialize LOB locator for Value parameter.To initialize LOB locator you must use EMPTY_BLOB or EMPTY_CLOB Oracle function.To return initialized locator in the same statement use RETURNING clause.

For example,

Code: [Select]
UPDATE ClobTable
SET
Name = :Name,
Value = EMPTY_CLOB()
WHERE
Id = :Id
RETURNING
Value
INTO
:Value


Here is the sample code:

[C#]

Code: [Select]
string sql = "UPDATE ClobTable SET Name = :Name, Value = EMPTY_CLOB() +
   WHERE Id = :Id RETURNING Value INTO :Value";
OracleCommand oraCommand = new OracleCommand(sql, oraConnection);
oraCommand.Parameters.Add("Id", 1);
oraCommand.Parameters.Add("Name", "First");
OracleParameter param = oraCommand.Parameters.Add("Value", OracleDbType.Clob);
param.Direction = ParameterDirection.Input;
param.Value = "The CLOB test value.";
oraCommand.ExecuteNonQuery();


[Visual Basic]
Code: [Select]
Dim sql As string = "UPDATE ClobTable SET Name = :Name, Value = EMPTY_CLOB() & _
    WHERE Id = :Id RETURNING Value INTO :Value"
Dim oraCommand As OracleCommand = new OracleCommand(sql, oraConnection)
oraCommand.Parameters.Add("Id", 1)
oraCommand.Parameters.Add("Name", "First")
Dim param As OracleParameter = oraCommand.Parameters.Add("Value", OracleDbType.Clob)
param.Direction = ParameterDirection.Input
param.Value = "The CLOB test value."
oraCommand.ExecuteNonQuery()


dotConnect for Oracle writes LOB data to Oracle and then returns initialized Value field in :Value parameter. Stored procedures allow you to automate initialization process of LOB values as follows.

Code: [Select]
CREATE OR REPLACE
PROCEDURE ClobTableUpdate (p_Id NUMBER, p_Name VARCHAR2,
   p_Value OUT CLOB)
is
begin
UPDATE ClobTable
SET
Name = p_Name,
Value = EMPTY_CLOB()
WHERE
Id = p_Id
RETURNING
Value
INTO
p_Value;
end;


Note that p_Value parameter is declared as OUT. At the same time set Direction property for parameter of Lob data type to ParameterDirection.Input and assign it with required data prior to actual call to stored procedure. Having previous procedure declaration we may execute it as this:

[C#]

Code: [Select]
OracleCommand oraCommand = new OracleCommand("ClobTableUpdate", oraConnection);
oraCommand.CommandType = CommandType.StoredProcedure;
oraCommand.CreateParameters();
oraCommand.Parameters["p_Id"].Value = id;
oraCommand.Parameters["p_Name"].Value = name;
oraCommand.Parameters["p_Value"].Direction = ParameterDirection.Input;
oraCommand.Parameters["p_Value"].Value = "The CLOB test value.";
oraCommand.ExecuteNonQuery();


[Visual Basic]

Code: [Select]
Dim oraCommand As OracleCommand = new OracleCommand("ClobTableUpdate", oraConnection)
oraCommand.CommandType = CommandType.StoredProcedure
oraCommand.CreateParameters()
oraCommand.Parameters("p_Id").Value = id
oraCommand.Parameters("p_Name").Value = name
oraCommand.Parameters("p_Value").Direction = ParameterDirection.Input
oraCommand.Parameters("p_Value").Value = "The CLOB test value."
oraCommand.ExecuteNonQuery()

It is important to use Direction property of OracleParameter in LOB operations.If Direction is ParameterDirection.Input OracleCommand writes data to a server, if Directionis ParameterDirection.Output it reads data.

You can also use OracleDbType.Long and OracleDbType.LongRaw data types with LOB parametersto write ordinary DML statements. In this case Oracle automatically converts LONG andLONG ROW values to CLOB or BLOB data.

1742
PSOUG / Looking to find an Oracle-based job or an Oracle-ready employee?
« on: September 10, 2009, 09:50:10 AM »
Looking to find a great Oracle-based job or the perfect Oracle-ready employee?

The PSOUG Job Board is your solution!

Make your job search easy. The PSOUG Job Board was created specifically for candidates with Oracle talent and those companies looking to hire them. Don't waste time searching through the clutter of other job banks- the PSOUG Job Board has what you are looking for! Advanced features and functions assist job seekers in searching and applying to open positions and help employers get the most out of the hiring process.

Candidates: New jobs are posted to the PSOUG Job Board almost every day, including positions for Oracle Database Administrators, Oracle Systems Engineers, Senior Oracle  Analyst, BI Analysts, Consulting Directors and many more. Sign up today to create your candidate profile and upload your resume to find the job you have been waiting for!

Employers: Currently it costs only $49 per job posting — compare that to the cost of Monster.com or other employment sites and see how far your budget can go!

Join the many companies that are already using the PSOUG Job Board including:
 Fred Hutchinson Cancer Research Center, Comforce, Excel, General
Electric, and many more.

Hiring organizations can save time and money by streamlining the hiring process and gaining access to qualified Oracle professionals through the PSOUG Job Board. Candidates can browse jobs and build profiles in this easy-to-use job search resource.

1743
PSOUG / Oracle Database 11gR2 has been released
« on: September 06, 2009, 05:56:31 PM »
Oracle Database 11gR2 has been officially released

Download a copy here: http://www.oracle.com/technology/index.html

Direct Link: Download:Oracle Database 11g Release 2 on Linux
   
The latest generation of database innovation is now available to help lower your IT costs, and improve the quality of service you deliver to your users. (More platforms coming soon.)

Also, check out the New Features Guide and the microsite forwhite papers, video, podcasts, and more product info.

1744
PSOUG / Oracle Delays Security Updates for User Conference
« on: September 04, 2009, 07:25:21 AM »
Oracle Delays Security Updates for User Conference
Thursday, September 03, 2009 3:30 PM PDT

Oracle database administrators who are worried they might have toskip Oracle's user conference next month to fiddle with security updates can relax. Oracle is cutting them a break and releasing its next set of patches a week later than planned.

The updates, which are released on a set schedule every three months, had been due for release on Oct. 13, slap in the middle of Oracle's OpenWorld conference in San Francisco. But after thinking things over, Oracle has decided to delay the patches. They're now due on Oct. 20.

Oracle announced the change Thursday on its Web site, saying it was moving the patches back because"many Oracle customers with responsibility for deploying the CriticalPatch Update within their respective organizations will be attendingOracle OpenWorld."

The database vendor plans to release its advance notification information, detailing which products will be affected by the updates, a week later than expected too. It's due onOct. 15.

Admins responsible for Windows systems will still have some work to do during the conference, however. Oct. 13 is the day Microsoft is expected to release its set of security updates for the month.

1745
PSOUG / Oracle, MySQL Not Competitors, Says Ingres CEO
« on: September 04, 2009, 07:22:44 AM »
Oracle, MySQL Not Competitors, Says Ingres CEO

Sun's ownership of the MySQL open source database is being viewed as a potential anti-competitive issue by the European Commission.

By Charles Babcock
InformationWeek
September 4, 2009 08:25 AM

A European Commission investigation will delay Oracle's takeover of Sun but not stop it, predicted Roger Burkhardt, CEO of Ingres Corp., supplier of the open source Ingres database system.

"In the end, it will go through, I think," said Burkhardt upon hearing about the Commission's announcement of a Phase Two investigation into Oracle's $5.6 billion purchase.

Sun's ownership of the MySQL open source database is being viewed as a potential anti-competitive issue by the commission, the administrative body of the European Union. But Burkhardt said MySQL rarely competes head-to-head with Oracle in the existing database market.

"Oracle makes money by being the corporate transaction processing system, the mission-critical production system. It's not realistic to say MySQL is a competitive database with Oracle. It's not like the commission can make that argument," he said.

MySQL got its start as a relational system that specialized in the high speed serving of Web pages and was implemented on several leading Web sites, including eBay, Facebook and Slashdot.com.

Full Article: http://www.informationweek.com/news/software/database/showArticle.jhtml?articleID=219501280

1746
PSOUG / Slow Oracle Merger Leads To Outflow of Sun Projects, Coders
« on: September 03, 2009, 02:00:38 PM »
Slow Oracle Merger Leads To Outflow of Sun Projects, Coders

Sun Microsystems might have had a chance if the Oracle merger had gone through quickly, but between the DoJ taking its time and the European Commission, which seems to get off on abusing American firms, just plain dragging its feet, that won't happen now.

As Sun twists in the wind, unable to defend itself, and Oracle is unable to do anything until the deal closes, IBM is pretty much tearing Sun to shreds. By the time this deal closes, there may not be much left for Oracle. This is not how a Silicon Valley legend should end.

Note: The summary places a lot of blame on regulators. But in fact, the article quotes IBM claiming the announcement of the acquisition is what drove people to IBM; that obviously has nothing to do with subsequent delays.

As for talent leaving, the article provides one example of 3 employees who left because they were unsure of Oracle's commitment to their work. However, there is no reason to assume the EU or DOJ have anything to do with this. Oracle could have reassured them at any time, if they knew, and cared, which isn't a very realistic expectation for a small team in a big merger.

1747
PSOUG / Pittsburgh Area to Host Oracle BI Report & Dashboard Workshop
« on: September 01, 2009, 09:07:20 AM »
Pittsburgh Area to Host Oracle BI Report & Dashboard Workshop

The Free Hands-on Business Intelligence Workshop is being conducted by BI Consulting Group and Oracle

Coraopolis, PA, USA September 01, 2009 -- BI Consulting Group announced today that they will be partnering with Oracle for a one-day technology briefing on enterprise performance management, featuring an interactive hands-on workshop with the latest on Oracle Business Intelligence Suite Enterprise Edition (OBIEE).

The workshop will take place at the Oracle Corporation office in Coraopolis, Pennsylvania on Monday, September 14th and will showcase OBIEE, as designed for pervasive use, with new levels of usability for reaching and empowering the broadest audiences with complete and timely insight. Oracle BI EE is also the technology foundation for business intelligence in Oracle Fusion applications.

WHO:
BI Consulting Group, Oracle’s premier consulting partner focused exclusively on Oracle Business Intelligence and Enterprise Performance Management.

WHAT:
BI Consulting Group to host free workshop highlighting OBIEE Report/Dashboards.

Oracle BI Suite Enterprise Edition (EE) is a comprehensive and innovative next-generation BI platform that offers the best foundation for building enterprise BI solutions from data spanning heterogeneous data sources, including Oracle and non-Oracle systems.

WHEN:
Monday, September 14th, 2009
8:30am to 2:00pm EDT

WHERE:
Oracle Corporation
1550 Coraopolis Heights Rd., Suite 400
Coraopolis, PA 15108-2973

To view complete conference details please visit: Free Oracle Hands-on Business Intelligence Workshop

ABOUT Oracle
Oracle is the world’s largest enterprise software company. For more information about Oracle, please visit http://www.oracle.com.

ABOUT BI CONSULTING GROUP
BI Consulting Group (BICG) is Oracle's premier consulting partner focused exclusively on Oracle Enterprise Performance Management (EPM) and Business Intelligence (BI). Service offerings include consulting services, support, and education. The experts at BI Consulting Group have successfully completed some of the most complex implementations of Oracle BI in the world. Along the way, BICG has been honored with Oracle's Most Valuable Partner Award for Business Intelligence and the Oracle Excellence Award for the creation of innovative and standards-based technology solutions. BICG has also been named the #1 consulting firm for customer satisfaction by VendorRate. www.biconsultinggroup.com.

Contact:
Jeremiah Johnson
BI Consulting Group
Coraopolis, PA
651.403.6527
jeremiah.johnson@biconsultinggroup.com
http://www.biconsultinggroup.com

1748
PSOUG / Top Ten Mistakes Found in Oracle Systems
« on: August 27, 2009, 10:35:48 PM »
Top Ten Mistakes Found in Oracle Systems

These are the top 10 most common mistakes found in Oracle systems. By following Oracle's performance improvement methodology, you should be able to avoid these mistakes altogether. If you find these mistakes in your system, then re-engineer the application where the performance effort is worthwhile.

   1. Bad Connection Management
    The application connects and disconnects for each database interaction. This problem is common with stateless middleware in application servers. It has over two orders of magnitude impact on performance, and it is totally unscalable.


   2. Bad Use of Cursors and the Shared Pool
    Not using cursors results in repeated parses. If bind variables are not used, then there is hard parsing of all SQL statements. This has an order of magnitude impact in performance, and it is totally unscalable. Use cursors with bind variables that open the cursor and execute it many times. Be suspicious of applications generating dynamic SQL.


   3. Getting Database I/O Wrong
    Many sites lay out their databases poorly over the available disks. Other sites specify the number of disks incorrectly, because they configure disks by disk space and not I/O bandwidth.


   4. Redo Log Setup Problems
    Many sites run with too few redo logs that are too small. Small redo logs cause system checkpoints to continuously put a high load on the buffer cache and I/O system. If there are too few redo logs, then the archive cannot keep up, and the database will wait for the archive process to catch up.


   5. Serialization of data blocks in the buffer cache due to lack of free lists, free list groups, transaction slots (INITRANS), or shortage of rollback segments.
    This is particularly common on INSERT-heavy applications, in applications that have raised the block size to 8K or 16K, or in applications with large numbers of active users and few rollback segments.


 6. Long Full Table Scans
    Long full table scans for high-volume or interactive online operations could indicate poor transaction design, missing indexes, or poor SQL optimization. Long table scans, by nature, are I/O intensive and unscalable.


   7. In Disk Sorting
    In disk sorts for online operations could indicate poor transaction design, missing indexes, or poor SQL optimization. Disk sorts, by nature, are I/O-intensive and unscalable.


   8. High Amounts of Recursive (SYS) SQL
    Large amounts of recursive SQL executed by SYS could indicate space management activities, such as extent allocations, taking place. This is unscalable and impacts user response time. Recursive SQL executed under another user ID is probably SQL and PL/SQL, and this is not a problem.


   9. Schema Errors and Optimizer Problems
    In many cases, an application uses too many resources because the schema owning the tables has not been successfully migrated from the development environment or from an older implementation. Examples of this are missing indexes or incorrect statistics. These errors can lead to sub-optimal execution plans and poor interactive user performance. When migrating applications of known performance, export the schema statistics to maintain plan stability using the DBMS_STATS package.

    Likewise, optimizer parameters set in the initialization parameter file can override proven optimal execution plans. For these reasons, schemas, schema statistics, and optimizer settings should be managed together as a group to ensure consistency of performance.


  10. Use of Nonstandard Initialization Parameters
    These might have been implemented based on poor advice or incorrect assumptions. In particular, parameters associated with SPIN_COUNT on latches and undocumented optimizer features can cause a great deal of problems that can require considerable investigation.

1749
http://www.learn-Oracle-OLAP.com

Pittsburgh, PA–August 22, 2009 - Multidimensional analysis lies at the heart of modern business intelligence systems. The multidimensional approach to working with data yields user interfaces to slice-and-dice summarized data- and to navigate up and down hierarchies. This translates into the ability to display business performance as a function of key variables and to view results at selectable levels of detail.

The Multidimensional Data Modeling Toolkit: Making your Business Intelligence Applications Smart with Oracle OLAP is the only book that takes the developer under the covers to show exactly what happens inside of Oracle's analytic workspaces where the multidimensional magic occurs.

Business intelligence developers who want in-depth understanding and expert skill levels with OLAP will find that the book takes them significantly beyond product documentation and a wizard-based exposure to the technology. The book puts the reader on a learning path beginning with a definition and explanation of the benefits of OLAP, and ending with a comparison of multidimensional analysis techniques to other the analytical approaches used in business intelligence applications: data mining and statistics. On this path the reader learns the syntax and programming techniques, and discovers the information analysis principles that motivate its use

The reader will gain a detailed knowledge of the Oracle OLAP DML programming language, they will see a plethora of analytical devices specific to the OLAP approach, they will learn the relationship between the tables in a relational data warehouse and the storage devices employed by OLAP cubes. The presentation is couched in terms of practical examples that will benefit any application area, including sales and marketing, finance, customer analysis, and manufacturing.

The content of the book is based on the Oracle 10g database, however, most of the programming statements shown will work with other editions of the database, such as Oracle 9i and 11g, and even earlier editions of the technology found in stand-alone products such as the Express database, Oracle Financial Analyzer, and Oracle Sales Analyzer. So if you are developing business intelligence systems in Oracle or porting from one of these platforms this book gives you helpful information you will use to get the job done.

The analysis principles presented are universal and can be applied to any OLAP system, for example Essbase, Cognos, Business Objects, and Microsoft Analysis Services. So whether you are new to business intelligence or a seasoned practitioner, you should find The Multi-dimensional Data Modeling Toolkit with plenty of valuable insights to offer. e book is available on Amazon directly from the publisher's website at http://www.learn-Oracle-OLAP.com.

1750
PSOUG / Free Virtualization Webcast
« on: August 26, 2009, 10:30:25 PM »
Quest Software, a leader in virtualization and application management, and Evelyn Hubbert, our featured guest analyst from Forrester, invite you to attend the Sept. 1 webcast, "Great Virtual IT Management - Learn from the Best!"
      
This webcast, the second in a series, will highlight best practices for mitigating the risks created by combining virtualization and business-critical applications. As a senior analyst at Forrester who consults with companies like yours every day, Ms. Hubbert will provide real-life examples of how great IT organizations are approaching virtualization management.


1751
PSOUG / DOJ Gives Oracle Approval To Buy Sun
« on: August 23, 2009, 10:49:35 PM »
The BBC is reporting that the US Justice Department has approved Oracle's takeover of Sun Microsystems.

The acquisition gives Oracle control over (or a leading role in), among other things, Java, MySQL, (Open) Solaris, ZFS, OpenOffice, and the NetBeans IDE.

'The European Commission has still to rule on the deal, a step that will be required before it can close.That body has indicated it will issue an initial opinion on Sept. 3,according to the Wall Street Journal.

It may OK the deal at that time or launch a four-month probe of it. ... The Justice Department ruling came earlier than expected, a possible response to Sun's declining revenues and precarious business position in a steep recession, as the required reviews proceeded.'

The deal was widely discussed back when it was announced in April.

1752
PSOUG / PSOUG October User Group Meeting
« on: August 20, 2009, 09:05:23 AM »
PSOUG's October meeting will be held on Wednesday, October 14th, from 5 to 7 pm (venue to be announced). Admission is free to registered PSOUG members and dinner will be served.

We will have a technical presentation on screening out internet security threats to protect your database.

Please register for your free 2010 membership and please let us know if you'll be attending the October meeting so that we can plan the food and seating requirements.


1753
PSOUG / Join the OAUG SIG Community at Oracle OpenWorld 2009
« on: August 20, 2009, 07:38:30 AM »

If you’re headed to Oracle OpenWorld 2009, be sure to set aside some time to join the OAUG Special Interest Group (SIG) User Community on Sunday, October 11, 2009.

The OAUG SIG community serves to facilitate discussion and information sharing among like-minded peers. With more than 50 SIG meetings scheduled, you’re sure to find a group that is discussing a topic of interest to you, such as:

    • Business Intelligence (BI)
    • Middleware
    • Hyperion
    • Service Oriented Architecture (SOA)
    • General Ledger and Financial Reporting
    • Enterprise Performance Management
    • Payables and Receivables
    • Customer Relationship Management (CRM)
    • Governance, Risk and Compliance
    • Workforce Planning
    • Enterprise Supply Chain Management[/FONT]

    … and much more.
    Check the full OAUG SIG meeting schedule(PDF file) for specific meetings, times and room locations. If you have any questions or require additional information, contact Regina Robuck, OAUG manager, affiliate communities, at +1 404.760.2887 or at rrobuck@oaug.com.

    SIG meetings are free and open to all Oracle OpenWorld attendees.Don't miss this great opportunity to connect with other users who share your interests, challenges and experiences.

    OAUG Fusion Council Explores Oracle Fusion Applications at Oracle OpenWorld 2009

    The OAUG Fusion Council will host a face-to-face meeting on Sunday, October 11, 2009, from 2 - 3 p.m. during Oracle OpenWorld2009. OAUG Fusion Council Chair Floyd Teter will provide information about his recent experience testing Oracle Fusion Applications and the council will facilitate an interactive Q&A session.

    Everyone is welcome. The OAUG Fusion Council meeting at Oracle OpenWorld 2009 will be held in Room 3001 in Moscone West, Moscone Center, San Francisco, Calif.

    Visit the OAUG Web site for regular updates about the OAUG’s activities and events at Oracle OpenWorld 2009.

    1754
    PSOUG / Free Download: SQL Developer Data Modeler
    « on: August 14, 2009, 09:58:58 AM »
     Oracle SQL Developer Data Modeler

    Oracle SQL Developer Data Modeler is the latest product offering from the Oracle Database Tools group. SQL Developer Data Modeler is an independent, standalone product with a full spectrum of data and data base modeling tools and utilities, including modeling for Entity Relationship Diagrams (ERD), Relational (database design), Data Type and Multi-dimensional modeling, full forward and reverse engineering and DDL code generation.

    The Data Modeler imports from and exports to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of design rules.

    Oracle SQL Developer Data Modeler can connect to any supported Oracle Database and is platform independent. A read-only SQL Developer Data Modeler Viewer is also available for download. The viewer allows users to open models created in the Data Modeler.

    More info: http://www.oracle.com/technology/products/database/datamodeler/index.html
    Free Download: http://www.oracle.com/technology/software/products/sql/datamodeler.html

    1755
    PSOUG / Back to Work: Practice Interviews with WTIA Board Members
    « on: August 14, 2009, 08:06:53 AM »
    Back to Work

    F5 Networks
    September 15, 2009
    8:30am-4:30pm

    Admission to this event is free to all attendees.

    REGISTER | ADD TO CALENDAR
    This event is geared towards current job seekers as well as anyone who wants to stay up to date with the most current job search techniques in the market today. Attendees will benefit from this event's rich content matter as well as the collective experience and support of the other workshop participants.

    • 1-on-1 Mock Interviews with WTIA Board Members and HR Professionals.
      Check out the mock interviewers that we have lined up!
    Speakers & Topical Areas:
    • Change is Inevidable - Embrace It: Christie Miller - Career Coach, SeattleJobs.org
    • Job Search 101 - Basics Boot Camp: Debbie Faulker - Vice President People Support, Sound Inpatient Physicians
    • Marketing Yourself Successfully: Matt Youngquist - President & Founder, Career Horizons, LLC
    • Real Life Successes & Failures to Learn From: Kathi Jones - President Prodcuts, Swift HR Solutions
    Check out the agenda and register to attend today!

    Pages: 1 ... 115 116 [117] 118 119 ... 122