|
|
|
|
|
|
|
|
Research Articles and Updates about Database. |
|
|
|
|
 |
Can Oracle kick SQL Server's behind?
: Oracle versus SQL Server in the Enterprise Edition. Oracle expert David Hull throws down the gauntlet to
Microsoft devotees. |
|
|
Load XML TYPE From File Using Oracle : In a recent forum thread I was asked how I would load an
XMLTYPE column in a table from a file. This
article explain one way of doing this. |
|
|
10 things you can do to make sure your data doesn't walk out
the door : Hacker attacks that bring down the network
get a lot of attention, so companies concern themselves with
protecting against those threats |
|
|
Parse XML Documents :
The use of XML for data transfer has increased dramatically
over the last few years. Since most applications still rely
on structured relational data it is necessary to explode the
non-structured XML data into relations tables. |
|
|
ANSI/ISO SQL
Support In Oracle9i : Oracle9i now supports the ANSI/ISO SQL: 1999 standards. This allows easier
product migration and a reduced learning curve when cross-training, but there is
no performance increase compared to the existing syntax. |
|
|
Advanced Queuing In Oracle9i
: This article is a basic primer to get you started using Advanced Queuing in
Oracle9i and Oracle8i: |
|
|
|
|
|
Send Email From An Oracle Procedure Using
UTL_SMTP : As of Oracle 8.1, you can now send email from within an
Oracle application. This is done by using the UTL_SMTP package. |
|
|
Automating Database Startup and
Shutdown on Linux : When using RAC or ASM under Oracle 10g Release 2, the Oracle Clusterware
automatically starts and stops the Oracle database
instances, so the following procedures are not necessary. |
|
|
Handling email addresses in SQL Server
: SQL Server databases is quite common, especially in
those tables, that store information about customers,
clients, subscribers etc. |
|
|
Oracle, MySQL and PostgreSQL
feature comparison : With the ever-burgeoning feature
sets available in modern databases, it's difficult to
separate the wheat from the chaff. There are plenty of
high-level data warehousing features in Oracle for instance
that you might never need. |
|
|
Physical and logical structuring
of Oracle : An Oracle database system comprises
at least one instance of the application, along with data
storage. An instance comprises a set of operating-system
processes and memory-structures that interact with the
storage. |
|
|
Top 20
mistakes a DBA can make: Do one of the
20 things seasoned DBA and Oracle expert Rachel Carmichael
of Dragonfly Consulting LLC listed in her presentation at
the Oracle user event International Oracle Users Group (IOUG)
Live!, and you could find yourself holding a pink slip
faster than you can say "Victoria's Secret on Fox Tonight at
Nine." |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Data compliance and Archiving. |
|
|
|
|
Oracle 8i, 9i, 10g
Articles
|
|
|
Oracle 10g a Flashback Database: Oracle 10g’s brilliant alternative to database point in time recovery
is the the Flashback Database feature. With this feature in place you
can do almost everything that you can do with point in time recovery,
|
|
|
SQL Tuning made easy in Oracle 10g: “Find out how to use DBMS_SQLTUNE package to tune SQL Statements in Oracle 10g”
Have you ever been frustrated with SQL Tuning?
Did you get lost in the maze of /+ HINTS +/ and analysis paralysis?
Pre-10g you have to be either a SQL tuning expert or should have a
license to expensive tuning tools available in the market to effectively tune
SQL Statements. Not the case anymore.
|
|
|
Simulating ASM with 10g Database by faking the hardware: Most of the Oracle 10g databases are using
ASM for storage as it's very simple to maintain the storage w.r.t. to Disks, Datafiles etc.
|
DB2 Articles
|
|
|
New Features in DB2 UDB V9: One of the new features in DB2
version 9 which got a lot of attention is certainly 'Row Compression'.
While compression algorithms are in place already in DB2 before version 9
(for instance backup compression, value compression), row compression is
unique for several reasons.
|
|
|
Use DB2 native XML with PHP: Learn about the effectiveness of using
the native XML capabilities coming in the next version of DB2® Universal
Database™ for Linux®, UNIX®, and Windows® to simplify application code and
the relational schemas. This article looks at the impact of schema evolution
on the application
|
|
|
Optimization of DB2 The
optimizer is the heart and soul of DB2. It analyzes SQL statements and determines
the most efficient access path available for satisfying each statement.
DB2 UDB accomplishes this by parsing the SQL statement to determine which tables
and columns must be accessed.
|
MS SQL Server Articles
|
|
|
Microsoft SQL Server Support: The objective
of the Microsoft SQL (MSSQL) port is to provide another
database alternative to MYSQL to take advantage of SQL server
in business environments where Mysql may be a barrier to entry.
The goal was to provide the ability for GL1.4.0 to work in either
Mysql or MS SQL server
|
|
|
Options and Analysis - Exclusive Database Access : Probluems and solutions. Do
any other options exist? What are the advantages and disadvantages
to these approaches? When should one approach be used over another?
|
|
|
Die Sucker - Killing SQL Server Process Ids (spids): I have
noticed some of my processes are failing because spids are already
connected to the database. This happens specifically when I need to
a restore database. I catch this problem pretty quick when I am working
on it during the data and can fix it, but during nightly processing existing
spids become problematic.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SQL (Structured Query Language)
is a computer language used to store, manipulate,
and retrieve data stored in databases. Learn SQL at Global GuideLine.
Almost all modern Relational Database Management Systems like MS SQL Server, Microsoft Access, MSDE, Oracle, IBM DB2, Sybase, MySQL, Postgres and Informix use SQL as standard database language.
Standards for SQL exist. However, the SQL that can be used on each one of the major RDBMS today is
in different flavors. In this
SQL Tutorial, such differences are noted where appropriate. All details are available
in SQL Tutorial section.
Click here to learn about SQL basics and developed your skills.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
XML is a markup language.
XML stands for eXtensible Markup Language. The XML standard was formed
by W3C to provide an easy to use and identical way to store self-describing data
self-describing data is data that describes both its content and its formation we
will learn, and the difference between HTML and XML
and Guide how to work together our application with XML.
Learn XML from beginning to advance.
|
|
|
|
|
|
|
|
Home