Slashdot Mirror


SAP and MySQL Join Forces

An anonymous reader writes "Heise Online is reporting that SAP and MySQL are going to cooperate (German article, you may want to use Google's translation). Short summary: MySQL and SAP are going to develop a new database server. 'The primary responsibility for the development and product management is with MySQL' says SAP spokesperson Karl-Heinz Hess. Until the new database is released, SAP will continue to develop its own free database system SAP DB, however it will now use the MySQL brand name." On a related note, IBM is introducing a low-end version of DB2.

54 of 229 comments (clear)

  1. SAP? by TheRaven64 · · Score: 4, Interesting

    Isn't SAP the database formerly known as Abadas? I was under the impression that it was already vastly superior to MySQL. What exactly is MySQL contributing to this?

    --
    I am TheRaven on Soylent News
    1. Re:SAP? by jdh-22 · · Score: 5, Informative

      SAP DB is pretty much equivalent to Oracle 7.3.4 which is to say that it's a solid product for many real-world applications, but lacks many of the features for truly high-end deployment, like clustering, complex replication, guaranteed messaging, etc. I'd take Sapdb over MySQL any day, and probably over Postgres too. Another nice thing about SAP DB is that it can emulate Oracle's system tables, so an Oracle DBA can administer a SAP DB system very easily.

      --
      Every Super Villan uses Linux.
    2. Re:SAP? by red_dragon · · Score: 4, Insightful

      Isn't SAP the database formerly known as [Adabas]?

      Kind of; IIRC, it is a fork of Adabas.

      What exactly is MySQL contributing to this?

      My guess is that the new database will be much easier to set up and manage than SAPDB in its current form. Have you ever tried installing it from source? Saying that it is nearly impossible to get it to compile is an understatement. Setting up a MySQL database is absolutely trivial by comparison, which is (IMHO) the primary reason for its popularity. I'd love to use SAPDB, but I don't have time to deal with the frustration that its installation involves; any improvement in that area would be a welcome change.

      --
      In Soviet Russia, Jesus asks: "What Would You Do?"
    3. Re:SAP? by davidkw · · Score: 4, Informative

      SAP isn't a database. It is a software package, a collection of programs like PeopleSoft and Oracle Applications, which allows for the management HR, payroll, and industry specific applications... SAP software still runs best on Oracle databases, although they will never limit themselves to that statement. SAP is database independent and mySql is just another tool that they can use for marketing

      --
      DKW
  2. So does this mean... by zutroy · · Score: 4, Funny

    ...that MySQL will now simulcast in Spanish?

  3. SAP and MySQL - The Difference is in the Name! by Anonymous Coward · · Score: 2, Funny

    SAP's lack of success can be contributed to their name. Who wants to be called a "SAP"? No one! Coversely, MySQL's success is also due to its name. It's MySQL, and not YourSQL. Everyone loves owning things and calling them theirs.

    1. Re:SAP and MySQL - The Difference is in the Name! by mikewhittaker · · Score: 2, Interesting

      Despite SQL guru (and number 2 to Ted Codd) Chris Date stating that it's pronounced S-Q-L, because "SEQUEL" was an earlier database language ?

    2. Re:SAP and MySQL - The Difference is in the Name! by MattRog · · Score: 2, Informative

      Although this is off-topic I've wanted to use this link for a long time so, well, here it is.

      "..the INGRES project at U.C. Berkeley. The INGRES project had a language called QUEL. They started a company that implemented QUEL. QUEL fought SQL tooth-and-nail, and explained how QUEL was better than SQL in many different ways, and in fact it is better at doing aggregates. There are lots of areas where QUEL is better."

      "..Tom Price: Although the first code they [Ingress] shipped was SQL on top of QUEL ...

      Mike Blasgen: It was see-QUEL. [laughter] That's right."
      http://www.mcjones.org/System_R/SQL_Reuni on_95/sql r95-Teradata.html

      --

      Thanks,
      --
      Matt
    3. Re:SAP and MySQL - The Difference is in the Name! by grub · · Score: 3, Funny


      It's MySQL, and not YourSQL. Everyone loves owning things and calling them theirs

      Ohh.. so that's why Windows owns the desktop, because of the My Computer icon. All this time I thought it was because of robust coding and rock solid performance.

      --
      Trolling is a art,
    4. Re:SAP and MySQL - The Difference is in the Name! by Sxooter · · Score: 2, Informative

      huh. I guess the docs on the mysql site must be wrong then.
      http://www.mysql.com/doc/en/What-is.html
      s ays:

      The official way to pronounce MySQL is ``My Ess Que Ell'' (not ``my sequel''), but we don't mind if you pronounce it as ``my sequel'' or in some other localised way.

      but hey, who reads the docs anyway, not a MySQL guru like you eh? :-)

      --

      --- It is not the things we do which we regret the most, but the things which we don't do.
  4. Actuality by DreadSpoon · · Score: 5, Insightful

    A lot of code "mergers" tend to be announced, but nothing ever comes of it. The idea of a merged feature set sounds promising, but it is often difficult to merge the underlying code, which can be severely different even for features present in both code bases.

    Additionally, for open-source or largely community developed projects, it's easy for the leaders to announce a merger or roadplan, but a whole 'nother game when it comes to getting the volunteer coders to actually do it; switching codebases or doing the grunt work of merges isn't the kind of this most hackers find sexy or appealing.

    Point being, how much of this merger is something that's actually going to happen, how much is just a transfer of resources (versus merging of code), and so on?

    1. Re:Actuality by m0nkyman · · Score: 2, Insightful

      From the MySQL website:
      "MySQL AB employs about 70 staff around the globe, and thousands more contribute to the success of MySQL by testing the software, integrating it into other software products, and writing about it."

      There are actually a fair whack of people at MySQL and SAP that are paid to do this. Like most of the major open source projects, a fair amount of the programming is done by people whose job it is. The myth of people doing it for free is just that. A myth. There are people who write code as a hobby, but the ones who day in day out contribute code are usually paid to do it by a company who finds the software useful.

      --
      ~ a low user id is no indication I have a clue what I'm talking about.
    2. Re:Actuality by brer_rabbit · · Score: 4, Funny

      The UNION of these two databases can't JOIN? Maybe they didn't PREPARE? If they can't COMMIT what they brought to the TABLE then perhaps they should DROP dead.

  5. Lets hope they dont call it by sfraggle · · Score: 5, Funny

    "SAP and MySQL announced that they would call the new database 'MySQL Firebird'.."

    --
    were you expecting to see a sig here? perhaps you'd rather see the inside of an ambulance!
    1. Re:Lets hope they dont call it by zoid.com · · Score: 4, Funny

      They have already decided to call it Mozilla.

    2. Re:Lets hope they dont call it by Pharmboy · · Score: 2, Funny

      Firebird = "Firebird Isn't Really Expected to Be an Ingenious or Real Database"

      Another recursive acronym.....

      --
      Tequila: It's not just for breakfast anymore!
  6. predicting the future.... by DailyGrind · · Score: 4, Funny

    Oracle sues SAP for $1Billion dollars claiming that SAP, which had previously licenced Oracle technology, is transferring Oracle's IP to mySQL.

    L.Ellison is heard saying: "There is no way that mySQL could become enterprise ready so quickly without help from SAP and through the use of Oracle's IP"

    --
    You will have to pry my proprietary software $$$ from my cold dead hands!
  7. Benefits? by Anime_Fan · · Score: 2, Interesting

    I don't see how this would benefit SAP.

    Then again, at work I'm just a normal office worker, and don't get to see the inner periphelas of SAP - I'm just using it.

    This might be a good move, however, as SAP databases are (if I remember correctly) quite large. Two large corporations working together on one databse should benefit all of us - It sure beats competition database to database. In some time, we'll see how much impact such a cooperation will have on large-scale databases. Maybe complex operations in SAP will be faster at that time. We'll just have to wait and see.

  8. Never heard of SAP... by Anonymous Coward · · Score: 2, Funny

    I was kind of hoping MySQL would partner with IBM or some other high-visibility company that could deploy it at the enterprise level... you know, do for MySQL what has been done for Linux. It's a nice project, and seems to be working out pretty well here on Slashdot, but outside of that I don't think anybody is really familiar with it, which is unfortunate because I've been able to do a lot with it (OTOH, everybody seems to have heard of IBM DB, Oracle, or Microsoft SQLServ).

    So, nice to see somebody else forming some kind of partnership where perhaps the companies can prop each other up marketing-wise, but doesn't seem like that big of a deal.

    1. Re:Never heard of SAP... by stratjakt · · Score: 3, Flamebait

      Why would IBM hitch its wagon to MySQL?

      IBM has DB2, which is vastly superior to MySQL.

      MySQL has improved, but it really is still pretty crappy. No subselects, no triggers, and it doesnt even use real standard SQL.

      Its fine for most web applications, which are just simple table lookups, but for more complicated data management systems, it cant remotely cut it.

      Oracle, SQL Server and DB2 have a lock on the enterprise DMBS market, and for good reason. They are the best pieces of software in the field right now.

      There simply is no free enterprise class DBMS.

      It would be nice to see MySQL eventually evolve into one. I remember when it couldnt hold more than 2 million records per table, which wasnt too long ago. It still has a long ways to go, at least before I can consider it a replacement to what we use SQL Server for right now.

      --
      I don't need no instructions to know how to rock!!!!
    2. Re:Never heard of SAP... by ctve · · Score: 2, Insightful

      AFAIK It's a business package, although to describe it as "a business package" doesn't really do it justice. It's really something more akin to a business platform. It has a whole bunch of components for things that many businesses need, like purchasing, that sort of thing. It's also very programmable. My wife used to raise purchase orders on it. Is this a good thing? You betcha. MySQL is a good database, and this should help it grow - business perception will grow that this is a serious product.

    3. Re:Never heard of SAP... by afidel · · Score: 4, Interesting

      SAP is one of the biggest businesses in the world. Basically they are business consultants that re-form businesses into more effecient forms from a workflow perspective. They do this around a central core of business process modules that are interlinked and which are well suited for integrating with customers current systems. The core of the system is their database so this is a HUGE deal. btw why would IBM hook up with MySQL, they are already the worlds biggest database vendor, unlike their OS which actually costs considerably more to maintain then they make off of it DB2 is a large profit center. DB2 is available for basically every platform that could conceivably run it, from VMS, to S/390, Solaris, Linux, Windows, etc.

      --
      There are 4 boxes to use in the defense of liberty: soap, ballot, jury, ammo. Use in that order. Starting now.
    4. Re:Never heard of SAP... by jas79 · · Score: 2, Interesting

      everybody seems to have heard of IBM DB, Oracle, or Microsoft SQLServ

      Shouldn't that be everybody who knows about databases?
      SAP is one of the tree big players on the ERP,CRM,HRM(or whatever TLA they use now). I suspect that more users know that they use SAP than that they know which database there ERP program uses.

  9. SAP setzt auf MySQL by rwiedower · · Score: 4, Funny

    Does this mean MySQL will now only accept SQL commands in german? That might increase the querytimes significantly....

    1. Re:SAP setzt auf MySQL by caluml · · Score: 3, Funny
      Hehe - English to German:
      * von der Tabelle IN DER somefield = "eine Last des Textes" UND des something_else > 4 VORWÄHLEN Sie;

      And back to English:
      * of the table IN somefield = "the load of the text" AND something_else > 4 PRESELECTING it;

    2. Re:SAP setzt auf MySQL by tundog · · Score: 2, Funny

      You joke about this, but have you ever tried to debug an SAP R/3 program? The comments aren't so bad, some of 'em you can even translate, but it's the variable names that are a bitch. Theey're not even words, they're 12-letter abbreviations for words like Gegengewichtsgabelstapler [fork lift].

      --
      All your base are belong to us!
  10. What is holding SAP-DB back? by jdh-22 · · Score: 2, Interesting

    Glad to see such a movement between the two companies. Older ./ story here
    http://developers.slashdot.org/developers/02/08/02 /1830245.shtml?tid=99

    --
    Every Super Villan uses Linux.
  11. Didn't Microsoft... by Inverarity · · Score: 2, Insightful

    ...use SAP's db at their corporate site? If Microsoft still does, I can't imagine that this would help the relationship.

    1. Re:Didn't Microsoft... by Christopher+B.+Brown · · Score: 2, Interesting
      The MSFT deployment of R/3 was actually quite interesting back when it was the "big news" of 1996. I actually got email from a recruiter at MSFT when they were looking for people. (I was a little stunned at the time by that...)

      At any rate, the "platform politicking" was a big deal. That was the same year when MSFT was heavily marketing that Windows NT was an excellent platform for running R/3. At that point, on Oracle, because it wasn't 'til about '97 or '98 that Microsoft's version of Sybase became supported.

      The richly entertaining part was that Microsoft wasn't "eating their own dogfood," even though they were promoting it, heavily. It would have been a marketing disaster had they run their system on Unix + Oracle, so they sidestepped it by initially going with IBM AS/400 + DB/2. And then invested heavily in the systems integration projects to get R/3 to run on Windows NT + MS SQL Server.

      If you search the web, you'll have a HARD time finding any evidence of the AS/400 installation; that's the sort of information that Microsoft's "Winston Smiths" would be expected to work overtime to expunge from public record...

      --
      If you're not part of the solution, you're part of the precipitate.
  12. welcome translation, liking this am I by Linux_ho · · Score: 3, Funny

    Goods are I, for on, delights to see this. Collaboration between information technology firms is always reception. Ears love I pieces of less important by approximately large firms as well as SAP releasing its intellectual property to the open source partnership.

    --
    include $sig;
    1;
  13. Features? by m0rph3us0 · · Score: 5, Interesting

    I didnt know the loosing the ability to have foriegn keys and the ability to easily define functions and data types was an improvement. Why would anyone want to move from a database to a suped up version of Excel.

  14. A theory on why they've done this... by coupland · · Score: 4, Insightful

    This may be a low-cost gamble, considering SAP-DB is technically quite good but not very popular. MySQL still lacks a lot technically, but it sure has a big hacker following. SAP no doubt wants a piece of the enterprise DB pie and maybe they see Linux and Apache's success and think, "hell it costs peanuts to support the MySQL team and even though it's a long shot there's a slim chance we could start another revolution." Obviously this is pure conjecture but not an unreasonable explanation for what several people seem to be calling a strange move.

    1. Re:A theory on why they've done this... by Troll_Kamikaze · · Score: 2, Informative

      SAP no doubt wants a piece of the enterprise DB pie...

      They've been at pains to claim otherwise. According to material on the SAPDB web site, they *are not* interested in selling a relational database system. Rather, they want an enterprise-class, royalty-free database they can use as the basis for their core apps.

      SAPDB is trying to popularize its main applications (ERP, CRM) in smaller businesses than those in which they have traditionally been popular. Microsoft is just now entering this same space; SAP will never be able to compete with Microsoft in the small(ish) business market if the price of SAP's software must include an expensive relational database license.

      Here's a quote from the whitepaper.

      A significant motivation for the Open Source initiative is the price structure for database licenses. This affects not only SAP, but every provider of database-based solutions that must procure database licenses in order to sell them on as part of their own solution, therefore imposing costs on the end licensee. SAP AG hopes to enliven the market through the Open Source initiative and to encourage users to critically examine the high-price policies of the market-leading database providers.
  15. Re:SAP? - resume by mikewhittaker · · Score: 5, Insightful

    Plus, if you've got anything with "SAP" on your CV/resume, you can get a higher-paid job.

    One of my colleagues has this theory that packages with (very) high entry costs - such as SAP - attract higher pay for experience than those with low/zero entry cost - such as most open source stuff and MySQL, which anyone and their dog can download for free & run on a $100 Linux box.

  16. Kind of, but there's a lock-in there, too by msouth · · Score: 4, Insightful

    It's true that you can make good money doing something like SAP, but you sort of have to sell your soul to it. I did it for about a year and a half, I was very good at it, etc, etc, but it was really boring. Right now I would like a job in anything, even something boring :). But since I have been out of the market for a while, I am unlikely to be able to get an SAP job. They want to know what the latest implementation job you were on was, stuff like that. They will ask for experience with a specific version, for example.

    So basically, if you want to work in it, you have to keep working in it. That is somewhat true in other fields, but I think stuff like SAP is exceptional that way--very closed. Hard to get into, and hard to get back into if you've been out.

    Mind you this is not because you can't just jump in and pick right back up--you can. but there's a whole mentality surrounding all the work that says "sorry, you can't come back in". So something along those lines.

    --
    Liberty uber alles.
  17. oh no! by bgs4 · · Score: 2, Funny

    SAP is turning the nose!

    we're all doomed.

  18. Uh oh... by zulux · · Score: 2, Interesting

    I hope MySQL doesen't change too much...

    It a easy to use, psudo-database thats really fast.

    It's not a real database - but it's two strength (ease and speed) make it ideal for many projects.

    I love PostgreSQL for all sorts of real database reasons, but for some tasks MySQL is superior (like PHP websites).

    --

    Moneyed corporations, non-working 'poor' and criminal prisoners are turning productive citizens into tax-slaves.

  19. MySQL is a non-free product AND a free product by Sxooter · · Score: 4, Interesting

    So how should we refer to it?

    funny thing is, they FUD the GPL on their own site, basically saying that if you write a commercial app that uses MySQL you HAVE to buy the commercial version.

    Last I checked, trying to limit the scope of use of software covered by the GPL was in fact a violation of the GPL.

    but MySQL is a favored child, so the FSF says nothing.

    --

    --- It is not the things we do which we regret the most, but the things which we don't do.
    1. Re:MySQL is a non-free product AND a free product by Anonymous Coward · · Score: 2, Insightful


      funny thing is, they FUD the GPL on their own site, basically saying that if you write a commercial app that uses MySQL you HAVE to buy the commercial version.


      The statement that you bump into the most:

      You need to purchase commercial non-GPL MySQL licenses:

      * If you distribute MySQL Software with your non open source software,
      * If you want warranty from MySQL AB for the MySQL software,
      * If you want to support MySQL development.

      is both reasonable and accurate. Are you talking about some other statement on the site?

  20. Reminds me of another system.... by pjdepasq · · Score: 4, Funny
    I don't usually post this kind of stuff, but thinking that mySAP would be a good name for a new server made me think of this old Internet email I've been saving:
    Manufacturing Information Access Software System (MIASS)

    This memo is to announce the development of a new plant-wide software system. We are currently building a data warehouse that will contain all plant manufacturing data. The program is referred to as the "Manufacturing Information Access Software System" (MIASS).

    Next Monday at 9:00 there will be a meeting in which I will show MIASS. We will continue to hold demonstrations throughout the month so that all employees will have an opportunity to get a good look at MIASS. As for the status of the implementation of the program, I have not addressed the networking aspects so currently only one person can be in MIASS at a time. This should change as MIASS expands.

    Several people are using the program already and have come to depend on it. Just this morning I walked into a subordinate's office and was not surprised to find that he had his nose buried in MIASS. I've noticed that some of the less technical personnel are somewhat afraid of MIASS. Just last week, when asked to enter some information into the program, I had a secretary say to me "I'm a little nervous, I've never put anything in MIASS before." I volunteered to help her through her first time and when we were through she admitted that it was relatively painless and she was actually looking forward to doing it again. She went so far as to say that after using SAP and Oracle, she was ready to kiss MIASS.

    I know there are concerns over the virus that was found in MIASS upon initial installation, but I am pleased to say the virus has been eliminated and we were able to save MIASS. In the future, however, protection will be required prior to entering MIASS.

    We planned this database to encompass all information associated with the business. So as you begin using the program, feel free to put anything you want into MIASS. As MIASS grows larger, we envision a time when it will be commonplace to walk by an office and see a manager hand a paper to an employee and say "Here, stick this in MIASS".

    This program has already demonstrated great benefit to the company during recent OSHA and EPA audits. After requesting certain historical data the agency representatives were amazed at how quickly we provided the information. When asked how the numbers could be retrieved so rapidly our Environmental Manager proudly stated "Simple, I just pulled them out of MIASS".

    1. Re:Reminds me of another system.... by micromoog · · Score: 2, Informative
      ...thinking that mySAP would be a good name for a new server...

      Brilliant.

  21. Re:SAP? - resume by Khalid · · Score: 4, Interesting

    Indeed it's very difficult to become a SAP consultant. What you say is not a theory but a basic economic law. The more a market is difficult enter, the more you can keep your prices high. A market with low entry barriers becomes quickly a commodity market and prices are droved towards production costs. This is why MS and the like intentionally introduces artificial barriers into their Markets, one of the most famous example is Word data format.

  22. Re:As an aside... by Anonymous Coward · · Score: 2, Insightful

    right, mysql is going to kick some ass thru this partnership.

    Do you have any idea how much a typical SAP implementation costs? I'd bet the median price is $10 million dollars. In an implementation of that size you could probably trim 1% by shifting from DB2 to mysql. Nobody worth their salt would recommend such a rediculous move.

    By the time they get SAP running reliably on mysql it will be four years down the road and the product will be completely reengineered.

    In the meanwhile, I suppose there's some marketing benefit to being able to say "we'll be good enough to run financials off - some day".

  23. Then MySQL should reclassify itself. by Ayanami+Rei · · Score: 2, Insightful

    There should be different classes of DBs for different purposes. You have Sleepy Cat's BerkelyDB which, from a RDBMS standpoint, is incredibly crippled, yet is uber-fast, requires little resources, and is iron-clad.

    You have MySQL which is like BerkeleyDB but with more sugar, with a network-centric view, and meta-data. But it does not skimp on speed for features or safety.

    I don't know if Microsoft Access is in the first class or second, I'd have to say first.

    Then you have the true RDBMS, MSSQL, Oracle, DB2, and Postgres.
    There is another class, object oriented databases (Versant, Intersystems Cache, ozone).

    MySQL should revel in the fact that it is NOT a true RDBMS and often that isn't needed for many applications that are forced onto RDBMSs unnecessarily. A partner ship with SAP will not help, and I think it may raise the bar of expectations to high for MySQL. I just hope it's as fast and easy to deploy in the end.

    --
    THIS THING CAN TURN ON A DIME, MACROSSZERO STYLE ALSO FUCK BETA, ~NYORON
  24. Google Translation by pruneau · · Score: 4, Funny
    ...or "Easy acces to the surreal for dummies"

    My two favorite:

    The chess move fits well into the Walldorfer concept to reduce the commercial meaning from data base servers to. SAP turns the nose, data bases actually the all world commodity became already longer and no cause, users enormous license costs abzuverlangen.
    Just in the mood of wasting bandwidth.
    --
    [Pruneau /\o^O/\ warranty void if this .sig is removed]
  25. Ugly move, if true--current users had no warning by Monkius · · Score: 4, Interesting

    The SAP people have been utterly silent on the SAPDB list.

    I guess that tends to confirm this story, though for myself (and this is the view expressed by everyone who's commented on the SAPDB list) I can't see how this works technically. The two systems are virtually nothing alike, for all they both speak SQL.

    Worse, if true, this is far from the right way to treat the user community that has grown up around SAPDB. In that they found out about this in the Heise story--just like Slashdot.

    Not nice.

    For the past 2 years, it's seemed like there was a slow process of opening-up on the SAPDB list. The internal SAP developers finally this year provided external CVS access, and although they still seemed to value the fact that the code was difficult for non-SAP people to understand and work on--riddled with strange interfaces like COM migrated to Unix sans comments, and intentionally undocumented areas--I got the sense that things were improving.

    For all the above, SAPDB as a project felt (perhaps due to its status as the less-known, more featureful GPL'd dbms) like a community resource that _came from_ a company, rather than like the property of a company you can download for free, which is how I've always seen mysql.

    I still can't figure out what to feel about the vaporware merger of the systems, with development done by (yikes!) the Mysql folks, who a few years ago said we had no nead for transactions...

    --
    Matt
  26. Re:no more RDBS? by etcshadow · · Score: 2, Insightful

    Where are my mod points when I need them... seriously. I am sick of hearing people say that RDBMSs are crap or whatever because they can't deal with the fact that DOING HARD STUFF IS HARD.

    In the development of a transactional processing system, once the volume of data becomes large and the needs for data integrity and manageability becomes overwhelming... you had soooo better be using a relational database. Object databases just aren't suited for the kind of work that is really important to the majority of applications (unless, at least, the object database is really just an access layer on top of a relational database).

    --
    :Wq
    Not an editor command: Wq
  27. Platform Agnostic by simon_aus · · Score: 3, Interesting

    Most seem to be missing the point here. SAP is pretty committed to being platform agnostic and standards compliant. The main R/3 ERP runs on NT, AIX, HP-UX, OS390, Solaris, Linux etc and databases such as SQL server, DB2, Oracle, Informix and SAPDB

    SAP sells to the users management, not the IT department, and have you tried to dictate to them what platform to run? Especially a big corporate data centre with mainframes etc.

    If you ask SAP for a recommended platform for a component, they'll tell you to use one of the supported platforms and not a specific vendor. That's how they maintain the relationships with all vendors like MS, IBM and Oracle.

    SAP has been making a concerted effort to support linux (well Red Hat) for about five years and almost all components are supported, I only know of one in beta and not supported for productive use. If there is demand to run on linux, then they will meet that demand. The last thing they want is to be only MS or IBM, cutting off potential sales and the associated TCO issues affecting the product's sales viability.

    This becomes especially important as they approach market saturation in the Fortune 1000 space and look towards SME's.

    This could represent a big opportunity to the open source community as SAP spends serious $$$ on platform support and R&D (not games consoles and Bluetooth Keyboards). SAP support of an Open Source database WILL give the platform some serious datacentre cred.

    --
    Stopping myself...Abort (core dumped)
  28. Re:A dynamite combination? by PizzaFace · · Score: 3, Funny
    A database with the features that SAP DB has and the ease-of-use that MySQL offers could be very interesting indeed.
    Let's hope it doesn't end up with the features of MySQL and the ease-of-use of SAP DB.
  29. Next Generation SQL: PQL by Fweeky · · Score: 2, Funny
    Words may be longer, true, but the commands so much more authoritative!

    Sigh, when will people realise that computers work better if you're polite, meek and gentle around them; just think how much more data would be lost without people around the world repeating words to the effect of "Please, Please don't fail until this backup's complete" when hard drives start to fail!

    In this vein, I have started development of a next generation data processing language, aimed at harnessing the hugely underused power of politeness in this field, where data integrity is paramount.

    Here's an example query:
    DEAR PQL_SERVER. -- begin transaction

    ALLOW_ME_TO_INTRODUCE_MYSELF AS Mr username password. -- authenticate;
    -- username is a maximum of 1 letter, and password must be a suitably respected surname.
    -- Mrs and Ms are of course also allowed, and may have impacts on the exact
    -- speed and quality of the results, depending on server configuration and orientation.

    PLEASE_ACCEPT UPTO 20% OF MY_QUOTA. -- enable certain optimizations.

    IF (it_would_not_be_too_much_bother) COULD_YOU_PLEASE
    FETCH any_columns_you_can FROM MyTable
    AND MAYBE(IF (you_have_time))
    FILTER OUT ANY WHERE MyTable.ID IS NOT SOMEWHERE_AROUND 50.

    -- enable consistency checks in result
    PLEASE_TAKE_CARE.

    THANK_YOU_VERY_MUCH. -- end transaction; expect response within 3-4 days.
    -- Don't forget to acknowledge (THANK) the server sufficiently
    -- once it has been received, or server errors may result later.
  30. This is why SAP and mySQL would want this. by johndavid · · Score: 3, Interesting

    A SAP mySQL merger/technology sharing agreement (what have you) makes a lot of sense for both groups. SAP's database is robust, and offers features that mySQL does not. msSQL is popular. msSQL could gain quite a bit of big-time features from SAP's DB (real tansactions, ACID compliance, etc.)SAP gains mind share and a real developers community (which equals growth and continuation of the platform.) IMHO it's a good fit. jd

  31. Re:no more RDBS? by defile · · Score: 3, Interesting

    MySQL is pretty professional enough for us.

    We have MySQL managing a 30+GB dataset with InnoDB tables, receiving approximately 700 queries/second average.

    It's running on a dual P3-1.4GHz with 2GB of RAM on 36GB RAID-1 array. We're about to replace it with a dual P4-Xeon at 2.4Ghz, 3GB of RAM, and two 72GB RAID-5 volumes.

    It operates 24/365.

  32. Why Join Indeed. by Christopher+B.+Brown · · Score: 4, Interesting
    I think this hits the nail on the head. There are benefits to both sides in the deal:
    • MySQL contributes "name recognition" and popularity;
    • SAP-DB contributes a whole lot of functionality
    Correspondingly, they also may have some ability to cover one anothers' weaknesses:
    • Compiling SAP-DB is, as you say, nearly impossible.

      The code base is exceedingly obscure, and having the MySQL folk do some work on it may relieve that problem somewhat.

    • MySQL has some severe functionality deficiencies from the perspectives of anyone accustomed to DBMSes with mature transaction support, relational capabilities, and support for SQL features that go beyond minimal "entry level" stuff.

      SAP-DB has fairly mature answers for all those deficiencies.

    Of course, the code bases are presently entirely separate, so that ripping things down to build them back up is likely to be a multi-year project. Compare with Mozilla; when its source was "opened," they had to rip out all sorts of code from Rogue Wave, The Open Group, and others, and the results weren't useful until a LOT of work got done.

    In that interim, "mindshare competitors" such as PostgreSQL and Firebird ("the database, not the web browser" :-)) aren't likely to stand still, so it seems likely to me that a major result will be for them to get a lot more popular.

    --
    If you're not part of the solution, you're part of the precipitate.
  33. Re:SAP? - resume by Christopher+B.+Brown · · Score: 4, Insightful

    But these issues aren't relevant to this thread.

    The discussion is not about the "huge, complex application," R/3, it is about the database.

    And in the context of R/3, the database is essentially an embedded component, a tiny part of the overall system, and one that isn't used with immense sophistication. Most big R/3 installs use Oracle, but, for the most part, not in a terribly sophisticated way. There is little if any use of "advanced stuff" like foreign keys, triggers, or stored procedures; the DBMS is used as a "data store," and isn't expected to be terribly smart.

    There lies an interesting connection; that description historically describes MySQL fairly well, as a relatively unsophisticated data store. Make MySQL more robust and it might well make a nice "cheap" data store for R/3 . (Mind you, commercial licenses for MySQL cost hundreds of dollars more, per CPU, than, say, PostgreSQL...)

    But the "resume connection" certainly doesn't appear to be the point...

    --
    If you're not part of the solution, you're part of the precipitate.