sábado, mayo 29, 2010

Mapfront Manager PPT


Mayo 29, 2010.
Presentación Mapfront Manager.


COPYRIGHT © 2010 DePapaya.com
All rights reserved.

Mapfront Triplog PPT


Mayo 29, 2010.
Presentación Mapfront Triplog.


COPYRIGHT © 2010 DePapaya.com
All rights reserved.

Procesos ETL


Junio 11, 2008, Rev. Septiembre 8, 2009; Mayo 29, 2010.
Proceso ETL.(Extract, Transform, Load), para productos Mapfront.
Por: Vicente A.Aragón D.

Aplica en los productos Manager y Triplog


Extract, Transform, and Load (ETL),
Es un proceso de bodegaje de datos que Wikipedia define cómo: "ETL is a process in data warehousing that involves extracting data from outside sources, transforming it to fit business needs (which can include quality levels), and ultimately loading it into the end target, i.e. the data warehouse."" ETL is important, as it is the way data actually gets loaded into the warehouse." "Extract, Transform, and Load (ETL), in article assumes that data is always loaded into a data warehouse, whereas the term ETL can in fact refer to a process that loads any database."


Esquema de la arquitectura ETL utilizada por las aplicaciones MapFront.
Agrandar la imágen, hacer click aquí.

Nótese que para el "llenado" de la base de datos del cliente, (en el esquema "base de datos espacial"; la cual es utilizada para la producción de reportes finales en formato de mapas geo-referenciados); el software motor de las aplicaciones Mapfront,(en el esquema i-Maps Server) es quién ordena la extracción, transformación y carga de la información, mediante aplicaciones ETL (desarrolladas por Geinsys). Esta operación se efectúa en el área operativa de las ETL. ( en el esquema área ETT con el relojito).

El hecho que los datos para obtener la información,(para la producción de los reportes de mapas georeferenciados en los produtos Mapfront),puedan ser alimentados, accesados, trabajados y distribuidos; desde cualquier dispositivo digital conectado a Internet, operando en cualquier lugar del mundo y a cualquier hora; es la razon primordial del uso de uso de aplicaciones ETL en los productos MapFront.


COPYRIGHT © 2010 DePapaya.com
All rights reserved.

miércoles, mayo 26, 2010

La empresa más valiosa en en campo de la tecnología: Apple.


Business.
Published: May 26, 2010
New King of Technology: Apple Overtakes Microsoft
By MIGUEL HELFT and ASHLEE VANCE



Jim Wilson/The New York Times
Apple fans crowded the iPad demo area at the company's downtown San Francisco store.

SAN FRANCISCO — Wall Street has called the end of an era and the beginning of the next one: The most important technology product no longer sits on your desk but rather fits in your hand.

The moment was marked Wednesday when Apple, the maker of iPods, iPhones and iPads, shot past Microsoft, the computer software giant, to become the world's most valuable technology company.

This changing of the guard caps one of the most stunning turnarounds in business history for Apple, which had been given up for dead only a decade earlier, and its co-founder and visionary chief executive, Steven P. Jobs. The rapidly rising value attached to Apple by investors also heralds an important cultural shift: Consumer tastes have overtaken the needs of business as the leading force shaping technology.

Microsoft, with its Windows and Office software franchises, has dominated the relationship most people had with their computers for almost two decades and that was reflected in its stock market capitalization. But the click-clack of the keyboard has ceded ground to the swoosh of a finger across a smartphone's touch screen.

And Apple is in the right place at the right time. Although it still sells computers, a greater portion of its revenue is coming from handheld devices. Overall, the technology industry sold about 172 million smartphones last year, compared with 306 million PCs, but smartphone sales grew at a five times faster pace.

Microsoft depends more on maintaining the status quo, while Apple is in a constant battle to one up itself and create something new, said Peter A. Thiel, the co-founder of PayPal and an early investor in Facebook. "Apple is a bet on technology," he said. "And Apple beating Microsoft is a very significant thing."

As of Wednesday, Wall Street valued Apple at $222.12 billion and Microsoft at $219.18 billion. The only American company valued higher is Exxon Mobil, with a market capitalization of $278.64 billion.

The revenue of the two companies are comparable with Microsoft at $58.4 billion and Apple at $42.9 billion. But Microsoft is sitting on far more cash, $35.7 billion to Apple's $23 billion, which makes the value assigned by the market to Apple — essentially a bet on its future prospects — all the more remarkable.

Microsoft and Apple declined to comment.

Apple's climb to the top of the heap cements the reputation of Mr. Jobs, who once operated in the shadow of Microsoft's co-founder William H. Gates.

"It is the single most important turnaround that I have seen in Silicon Valley," said Jim Breyer, a venture capitalist who has invested in some of the most successful technology companies.

While Apple is at the top of its game, it faces a new and powerful rival in Google, which is battling Apple in mobile devices with its Android operating system, and mobile advertising. Google, with a market cap of about $151.43 billion, also appeared to leap ahead of Apple in a new, potentially important area, Internet-connected televisions. And Google is steering consumers toward yet a new model of computing in which Internet applications, rather than iPhone or desktop applications, rule.

"The battle has shifted from Microsoft against Apple to Apple against Google," said Tim Bajarin, a technology analyst who has been following Apple since 1981. "Apple has a significant lead. But Google is going to be a powerful competitor."

Apple and Microsoft initiated the personal computing revolution in the late 1970s, but Microsoft quickly outflanked Apple and grew to become one of the most profitable businesses ever created.

A little more than a decade ago, Apple, which had pushed out Mr. Jobs in 1985, was widely believed to be on the path to extinction.

Michael S. Dell, the founder and chief executive of Dell computer, went so far as to suggest that Apple should shut itself down and return any money to shareholders. (The computer maker is now worth about a 10th of Apple.) Around the same time, Microsoft's chief technology officer called Apple "already dead." But with the return of Mr. Jobs to Apple in 1996 — and an investment by Microsoft of $150 million — the company began a slow path to recovery. Apple's rebirth began in earnest with the introduction of the iPod music players and Mr. Jobs began to gain a reputation for anticipating what consumers want. The company elbowed aside Sony and came to dominate the music distribution business with the iTunes online music store. It later upstaged Nokia, the dominant brand in mobile phones, by introducing the iPhone in 2007. And earlier this year, Mr. Jobs shook things up again, with the introduction of the iPad, a table computer that has the potential to create a new category of computers and once again reshape the way people interact with their devices.

Mr. Jobs helped create "the best desktop computer, the best portable music device, the best smartphone and also now the best tablet," said Steve Perlman, a serial entrepreneur who was an executive at both Apple and Microsoft and is now the chief executive of OnLive, an online gaming company.

As Apple grew increasingly nimble and innovative, Microsoft has struggled to build desirable updates to its main products and to create large new businesses in areas like game machines, music players, phones and Internet search. Microsoft, which is a component stock of the Dow Jones Industrial Average, has lost half its value since 2000.

Still, Microsoft is a hugely powerful and profitable company in the tech world. Its Windows software runs 9 out of every 10 computers, while more than 500 million people use its Office software to perform their daily tasks like writing letters or sending e-mail messages. These two franchises account for the bulk of Microsoft's $58.4 billion in annual revenue.

But it is Apple that has the momentum. "Steve saw way early on and way before Microsoft that hardware and software needed to be married into something that did not require effort from the user," said Scott G. McNealy, the co-founder and longtime chief executive of Sun Microsystems, which almost merged with Apple. "Apple's products are shrink-wrapped and ready to go."


COPYRIGHT © 2010 DePapaya.com
Reproduction in whole or in part, without written permission is prohibited.
All rights reserved.

viernes, mayo 21, 2010

Reseña de Google Docs. (2010) PC Magazine.

Review Date: May 19, 2010
Google Docs (2010)
By Edward Mendelson

If you want cloud-based document editing and storage, Google Docs (free for personal use, $50 per seat per year for business users, as Google Apps) is your best choice, even though other services may offer more tools or a greater depth of features. Features aren't everything. When I use a cloud-based app, I value speed and ease of use far more. Although Zoho(Free, ) offers more features, Google Docs is smoother and more reliable in overall operation.

As for Microsoft's Office Web Apps, Microsoft still hasn't made the full suite publicly available, so we'll have to wait for a full comparison. Cloud-based applications work best when they're fast enough to work over a slow connection and compact enough to work well in your browser.

Google Docs excels at both, and the result is an impressive balance of efficient operation and elegant design. Google Docs isn't perfect—far from it, as you'll see—but overall, it's the best cloud-based application suite we've got.

The Google Docs Suite

Google Docs includes a word processor, a spreadsheet tool, and a presentations application, just like traditional desktop suites. It also has a drawing application and a nifty form-creator application that lets you create fill-in-the blank forms, send them out by e-mail, and store the results when other people fill in the forms in their e-mail client. At press time, Google also announced that it'll also include Google Wave for all users, too.

I tested the free version of Google Docs. Users of the subscription-based Google Apps services get the same core productivity features as freeloading users like me, as well as the same 1GB of Google Docs storage. However, Google Apps subscribers also get enhanced Gmail security and interoperability with Exchange calendars and contacts, plus options to share Google video and get advanced features for other Google services.

Google Docs offers the cleanest, most usable interface I've found in any cloud-based suite, and it opens documents faster than any rival—a feature that matters when I have only a few minutes to get some work done in an airport lounge.

Most of the time, I can edit in Google Docs almost as quickly as I can on a desktop machine, but if I have multiple documents open in separate tabs of my browser, editing slows to a painful crawl. Google's suite has a minimalist look and feel, but that's exactly what I want when I'm editing in a browser.

Only Google gets the balance right between simplicity and power in cloud-based suites; Zoho easily beats Google in the feature race, but, in my experience, Zoho is less reliable and infinitely more confusing to use. Google Docs has some flaws and weaknesses—more about that later—but, on the whole, I like what it does now, and because it's a free service, the price is right.

The collaboration features built into Google Docs are what distinguish it from desktop suites like Microsoft Office.

From within Google Docs, you can send out links that let friends and colleagues edit or view your documents and collaborate with them in real-time, commenting on each other's contributions in a chat interface. Google Docs allows up to ten people collaborate on word-processing files or presentations at the same, and allows up to fifty people collaborate on a worksheet. I doubt you'll often want that many people piling onto your documents, but it's good to know they can.

New Google Docs vs. Old Google Docs

As I write this review, Google Docs is in transition. It lets you choose between older and newer versions of its word processor and spreadsheet applications by clicking a link at the top of the worksheet window.

The older version of Google Docs is the original word processor. The new one looks better than the original, but doesn't support all the features of the old one, such as the ability to store documents for offline use using Google Gears, inserting art using the Google Docs drawing application, and the ability to edit the HTML code that underlies the visible document. (All these features will gradually get added to the new version.)

The new editor adds a ruler to the page view, which I don't need, so I use an option on the View menu that hides it. For me, the major advantage of the new editor is that it uses curly "typographic" quotation marks instead of the ugly straight-up quotation marks of the original editor.

The word processor doesn't let you can't create a document in one version and then switch to the other—every document stays in the editor that first created it. Still, you can export documents saved in the old version to your computer, then choose an option on the Settings menu that tells Google Docs to create documents in the new word-processor version.

Then, you'd then import the exported file into the new editor.

Google's Word

Don't expect the Google Docs word processor to give you even half of what Microsoft Word offers, but don't expect it to leave you searching for features the way you probably do in Word.

Google Docs' word processor does a good job with basic editing. You can insert comments and footnotes, images, hyperlinks, and equations, using an easy-to use toolbar.

Export formats include Word, OpenOffice, and HTML, and you can create a PDF version of a document from the Print menu. Keyboard shortcuts—listed on a separate page accessible from the Help menu—let you perform almost any task without touching the mouse.

I like the feature that saves my work automatically at frequent intervals, but offers a "Save Now" button if I want to save before Google Docs gets around to saving the file for me. A "Revision History" menu item lets me view saved versions of my work, and I can either revert to an earlier version or copy text from an older version and paste it into the current one.

The new word processor has a few minor annoyances that I wish Google could weed out. For example, if I type a word that isn't in Google's spelling dictionary (including, for example "Google's" with an apostrophe-s), Google Docs puts a red-dotted underline underneath the word, and doesn't give me any way to clear it out—not even an option to ignore the word or add the word to a custom dictionary.

Another, stranger problem sometimes occurs when I select text with the mouse, and the first few letters that I select suddenly disappear from the selected block, although they remain on the page. These are the sorts of problems that Google typically fixes a few days after they crop up, so they may be solved by the time you read this.

Google's Spreadsheet

The spreadsheet in Google Docs doesn't come close to Excel's feature depth, but it has every function you need for managing all but the most advanced worksheets, with about 200 available functions, including a frivolous one that runs Google's calculations of NCAA tournaments. A new feature makes it possible to build scripts that work more or less like Excel's VBA macros, although you can't convert Excel macros into Google Docs scripts.

A gallery of user-supplied scripts gets you started, but in most cases you'll have to edit scripts by hand in a pop-up editor. If you want to enter cell addresses in your script, you'll need to type them in by hand—you can't select a cell in a worksheet and have its address appear in the editor—but if you're willing to expend some effort, you can create complex functions that would normally require Excel-level scripting. I had to bang my head on the desk a few times before I figured out how to use this feature, but true spreadsheet experts may have an easier time of it.

The new spreadsheet adds a formula bar where you can edit formulas as you can in Excel, not just view them. It also finally adds the autofill feature that, after you type the first few letters of text in one cell, automatically suggests that you enter matching text that you entered earlier. The new version also adds drag-and-drop column editing.

Google's Presentations

The presentations application is the most minimal of Google Doc's components, but it gets the job done. You can create a background image to use for all your slides, insert bullet points, images, tables, and charts.

Don't get too excited by the menu item that lets you insert videos—you can only insert videos from YouTube, and you can only find the video you want by searching for keywords in the YouTube index (if you uploaded your video a few minutes ago, and YouTube hasn't indexed it yet, you're out of luck).

Don't even think of using fancy transitions between slides—no transitions are provided. At least you get a pane in which you can enter speaker's notes. Imagine PowerPoint with about ninety percent of its features removed, and you get an idea of what you get from Google Docs' presentation program. Of course, if you're creating simple slides with bullet points, tables, and images, Google Docs is all you need



View Google Doc´s 2010 Slideshow
at PC Magazine´s Web Site.

Compatibility With Microsoft Office and OpenOffice

Google Docs imports Word documents and Excel worksheets in all recent formats (including the Office 2007/2010 formats), but don't rely on the export to work correctly if you create complex documents.

The newer versions of the word-processor and spreadsheet have fewer export/import problems than the older versions, but they're still not good enough.

When I exported a file from the new version of the Google Docs word processor into OpenOffice.org format, the results were mostly excellent, although the page breaks in my document disappeared.

When I exported to Word 2003 format, page breaks were preserved, but a line of highlighted text turned into a large colored rectangle with the text at the bottom. None of my attempts to round-trip a complex document by exporting from Google Docs (to any format), and then importing it again into Google Docs produced perfect results.

Similar issues occurred when I imported Excel worksheets.

Formatting that Excel supports but Google Docs doesn't support simply gets omitted, so, for example, conditional formatting in an Excel worksheet doesn't appear at all in the worksheet imported into Google Docs.

The presentations application, by the way, imports files only in the Office 2003 (and earlier) format.

When Do I Use Google Docs?

Cloud-based application suites let you edit documents in a browser on any computer that has Internet access. That's great for on-the-road convenience. It's not so great for my sense of security. The only documents I'm willing to trust to the cloud are ones I can live without if Google suffers one of its occasional outages or if someone hacks into my account and keeps me out—something that's happened to a few too many of my friends.

I typically use the Google Docs word processor for editing documents that I want to edit when I don't have my laptop but I have access to someone else's computer—and then I download these documents to my office desktop and print them from there.

I know students who use Google Docs for writing their homework assignments during breaks from their part-time office jobs—and I hope the boss approves, though I don't want to ask.

I also rely on Google Docs when I have a worksheet or document which is going to get data entered into it by people I work with in addition to myself. This is one situation where a cloud-based app is ideal.

So Should You Use Google Docs?

I think everyone ought to have a Google Docs account to use when you need the collaboration features that Google Docs offers. If you're a student, or if you work mostly on the road, and if you you're optimistic enough to trust your data to the cloud, then Google Docs might be your primary application suite.

But if you've graduated from college and you work in the real world, I think Google Docs is probably still best viewed as an adjunct to a desktop suite. For me, that means Microsoft Office 2010, but you can also certainly get by with OpenOffice.org if money is tight.

Use of this site is governed by our Terms of Use and Privacy Policy Copyright © 1996-2010 Ziff Davis Publishing Holdings Inc. All Rights Reserved. PC Magazine is a registered trademark of Ziff Davis Publishing Holdings Inc. Reproduction in whole or in part in any form or medium without express written permission of Ziff Davis Media Inc. is prohibited.

COPYRIGHT © 2010 DePapaya.com
Reproduction in whole or in part, without written permission is prohibited.
All rights reserved.