Oracle9i and SYBASE ASE12.5 inadequate compared to a few
Oracle9i and SYBASE ASE12.5 inadequate compared to a few
Oracle9i and ASE12.5 are the mainstream of the world ORACLE database vendors, the company's flagship product, SYBASE, with a large market share. This paper set aside in between architecture, the differences in technical route, purely from the point of view of users, compiled Oracle9i and SYBASE Adaptive Server Enterprise 12.5 (ASE12.5) compared to less than a few, as ASE12. 5 compared with the lack of Oracle9i not in the scope of the discussion in this paper.
1 do not support regular expressions: familiar with the Unix / Linux and ASE12.0/12.5 the people know that the expression is a flexible and powerful. Like "Find all the names of the table contains figures" such a demand, ASE12.5 an extremely simple:
Select name from sysobjects where type = "U" and name like "%% [0-9]" (here in the sysobjects all_objects Oracle9i equivalent), and Oracle9i to the realization of a lot of twists and turns, many people under normal circumstances write a function is achieved, the following is just the time to write Oracle in the realization of the function of a function:
CREATE OR REPLACE function is_number (p_str in varchar2)
Return number
As
W_char char (1);
I number: = 1;
Begin
While i <= length (p_str) loop
W_char: = substr (p_str, i, 1);
If w_char> ='0 'and w_char <='9' then
Return 1;
End if;
I: = i +1;
End loop;
Return 0;
End;
/
Oracle9i call in a self-definition of PL / SQL function will be spending a great and far from the internal ASE12.5 achieve.
UPDATE 2 statements "clumsy" in the database and the application of two related tables update is very common, if the following two tables: t_a (id, name, point,…), t_b (id, point,… ) id were mainly key or unique index is to be achieved in accordance with the corresponding id t_b relations will be on the table and point to point t_a table. We view the achievement of Oracle9i and ASE12.5:
/ ** For Oracle9i ** /
Update t_a a
Set a.point a.point + = (select b.point from t_b b where b.id = a.id)
Where exists (select one from from t_ b where b.id = a.id)
/
/ ** For ASE12.0/12.5 ** /
Update t_a
Set point a.point + = b.point
From t_a a, t_b b
Where a.id = b.id
Go
Oracle9i statement seems to be ignoring the clear, easily misunderstood, and the Plan of Implementation of Show found t_b table or index scan 2 times! ASE12.5 only one scan times. Although the first two times is a logical reading, but the overall feel satisfied;
If t_b table sometimes smaller, and there is no index id, I prefer the cursor, repeated experiments show that
+ Create INDEX association than UPDATE much faster. The other is using the Oracle9i OLAP features merge with statements to complete.
Table 3 temporary technical comparison:
ITEM
Storage location
DDL
Data life cycle
ORACLE9i
Any table space
User's own maintenance, is the overall table (database users) only
Session / Transaction
ASE12.5
Tempdb library
Users create; users drop or drop system, the table-only Session
Session
Although both strengths, but I think that the realization of ASE12.5 seem to be more in the "temporary" the essence - in each session, "The response to that is," not to worry and others Chongming, # 11 # 22 # aa # bb with the creation of personal preference, "global warming is" to the end of the session, not necessarily explicit deleted by the system do the work for them, and not have to worry about garbage sheet.
Count 4 Distinct problem is the problem? Use in the select statement to return to the distinct keywords modified only Collection, in the statistical analysis, remove duplication of data is particularly important, but sometimes only to a total number of statistics? This is the first time I wrote:
Select count (distinct a, b, c) from my_table results grammar wrong, but is amended as follows:
Select count (*) from (select distinct a, b, c from my_table) to be passed, I thought this was something distinct blame bad, but was subsequently found innocent distinct, because even if:
Select count (a, b, c) from my_table is infeasible. Only wrote:
Select count (*) from (select a, b, c from my_table)
But in ASE12.5 on both the Select count (distinct a, b, c) from my_table or Select count (a, b, c) from my_table can arrive at a correct result.
5 Data Import and Export tools comparison: Exp / Imp in the backup and recovery of more use, and the version (version level, 32 bit/64bit), a greater impact on language, and can only be counted as sqlldr import tools, strict Oracle9i data table, not the text-derived tools! On the contrary, the bcp ASE12.5 data in the form of Import and Export very flexible format is also very simple, very easy to make the application's input. Also view, stored procedures, triggers the export tool defncopy also very good; As Oracle9i, N +1, I encountered the following:
Q: I have a memory of how the code ah?
A: There are not equipped client Afghanistan?
Q: loaded!
Answer: Open Enterprise Manager Console, login below Boa in the programme
……
Q: A how trouble?
A: Then you have installed Toad or PL / Develop Azerbaijan, these tools useful point
Q: There is no ah!
Answer: L
Or
Q: I have a memory of how the code ah?
A: There are not equipped client Afghanistan?
Q: installed, I console ah!
A: So, you used sqlplus Kanba,
Set long 300
Select text from all_source where name = 'YourName'
Go
Q: wow, how troublesome Afghanistan
Answer: L
If the ASE12.0
Q: I have a memory of how the code ah?
Answer: it defncopy
Q: how to ah
A: I rely on, and so simple! Azerbaijan also to ask you! J
6 online backups: Although Oracle9i provides cold and hot backup technology, but with ASE12.5 Open Server technology based on the on-line real-time backup Backup Server seems to be inferior compared to a lot of backup media directly ASE12 get another one. 5 for Load soon will be able to obtain a very simple aging of the strong "mirror" database environment. I think Exp / Imp relatively trivial, and also more restrictions.
Oracle9i with command line tools such as sqlplus exp / imp sqlldr, will be implemented without exception output time, version, copyright information, such as myself like to use the results of the shell increased the people a lot of trouble, compared with ASE12.5 the isql bcp defncopy the neat, Oracle9i is the boredom and the "Narcissus", or the domineering Eriksson?
0 Comments to “Oracle9i and SYBASE ASE12.5 inadequate compared to a few”
No Comments. Send your comment.
Leave a Reply
You must be logged in to post a comment.