Killexams.com 000-911 Dumps and true Questions
100% true Questions - Exam Pass Guarantee with lofty Marks - Just Memorize the Answers
000-911 exam Dumps Source : System and Administration: Informix Dynamic Server
Test Code : 000-911
Test cognomen : System and Administration: Informix Dynamic Server
Vendor cognomen : IBM
: 142 true Questions
Right set to find 000-911 true question paper.
Hats down the fine 000-911 exam preparation option. I surpassed my 000-911 exam ultimate week, and this set of examination questions and solutions has been very helpful. these items from killexams.com is actual. before creating a purchase, I contacted customer back with questions on how up to date their substances are, and they showed that they update bar null exams on almost every day basis. They add updates where vital, or honestly double check the content to fabricate inevitable its updated. It justifies buying an examination brain sell off. With killexams.com, I recognise that i will depend on the cutting-edge exam substances, now not some e bespeak which can emerge as obsolete a week after its posted. So I assume this is the attribute exam preparation option. I suppose im able to expand my certification portfolio into a few different providers, Im just not positive which of them but. but what Im sure approximately is that I may subsist the consume of killexams.com as my predominant training resource.
000-911 certification exam is quite irritating.
Hearty thanks to killexams.com crew for the query & respond of 000-911 exam. It furnished exquisite routine to my queries on 000-911 I felt confident to stand the assume a peer at. observed many questions inside the exam paper much fancy the guide. I strongly experience that the lead is quiet valid. respect the endeavor with the aid of your crew contributors, killexams.com. The routine of dealing subjects in a unique and uncommon manner is awesome. wish you humans create greater such examine publications in proximate to future for their convenience.
Get fee percent state-of-the-art expertise to prepare 000-911 exam.
I surpassed the 000-911 exam ultimate week and fully relied on this sell off from killexams.com for my coaching. that is a fantasticmanner to gain certified as attain what may the questions attain from the actual pool of exam questions utilized by dealer. This way, almost bar null questions I were given at the exam seemed familiar, and i knew solutions to them. this is very dependable and honest, in particular given their money again guarantee (i Have a chum who attain what may failed an Architect degree exam and were given his money again, so that is for actual).
Unbelieveable! however prerogative source modern day 000-911 true test questions.
I cleared 000-911 exam with immoderate marks. On every occasion I had registered with killexams.Com which helped me to achieve greatermarks. Its notable to Have aid of killexams.Com query pecuniary institution for such sort of tests. Thanks to all.
amazed to appearance 000-911 dumps!
ive renewed my club this time for 000-911 examination. I assume delivery of my involvement with killexams.com is so crucial it is not practicable give up via not having a club. im able to just consider killexams.com exams for my examination. simply this web page can assist me achieve my 000-911 accredition and assist me in getting above 95% marks inside the examination. You bar null are honestly making an top notch showing. maintain it up!
nice to pay interest that true test questions concurrent 000-911 examination are available.
To fabricate inevitable the fulfillment in the 000-911 examination, I sought assist from the killexams.Com. I selected it for numerous motives: their assessment on the 000-911 exam thoughts and policies changed into superb, the material is in reality user friendly, superb attribute and very imaginative. Most significantly, Dumps removed bar null of the issues at the related subjects. Your fabric supplied generous contribution to my practise and enabled me to succeed. I can firmly nation that it helped me congregate my fulfillment.
No problem! 24 hrs preparation of 000-911 exam is required.
i was trapped inside the complex subjects most efficacious 12 earlier days the exam 000-911. Whats extra it was extremely beneficial, as the expeditiously answers can subsist effects remembered internal 10 days. I scored ninety one%, endeavoring bar null inquiries in due time. To reclaim my planning, i used to subsist energetically looking down some speedy reference. It aided me a extremely obedient deal. by no means notion it is able to subsist so compelling! At that factor, by course of one manner or another I came to deem about killexams.com Dumps.
great experience with , bypass with lofty rating.
im ranked very immoderate among my class pals at the listing of wonderful college students but it handiest occurred after I registered in this killexams.com for a few exam assist. It changed into the lofty ranking analyzing application in this killexams.com that helped me in joining the lofty ranks at the side of different incredible students of my magnificence. The sources on this killexams.com are commendable due to the fact theyre specific and extremely beneficial for practise thru 000-911, 000-911 dumps and 000-911 books. im gay to establish in writing these phrases of appreciation due to the fact this killexams.com deserves it. thanks.
neglect approximately everything! virtually forcus on those 000-911 Questions and solutions in case you requisite to pass.
It become a totally brief conclusion to Have killexams.com QA as my examine associate for 000-911. I couldnt maneuver my happiness as I started out seeing the questions on parade screen; they were fancy copied questions from killexams.com dumps, so accurate. This helped me to pass with 97% inside 65 mins into the examination.
a gross lot much less effort, top notch information, assured success.
im now 000-911 certified and it couldnt subsist viable without killexams.com 000-911 testing engine. killexams.com testing engine has been tailor-made keeping in thoughts the requirements of the scholars which they confront at the time of taking 000-911 examination. This checking out engine may subsist very a lot exam consciousness and each topic matter has been addressed in constituent just to maintain apprised the students from every and each records. killexams.com group knows that that is the course to hold college students confident and ever equipped for taking exam.
Obviously it is difficult assignment to pick solid certification questions/answers assets concerning review, reputation and validity since individuals gain sham because of picking incorrectly benefit. Killexams.com ensure to serve its customers best to its assets concerning exam dumps update and validity. The vast majority of other's sham report objection customers attain to us for the brain dumps and pass their exams cheerfully and effectively. They never trade off on their review, reputation and attribute because killexams review, killexams reputation and killexams customer certitude is vital to us. Uniquely they deal with killexams.com review, killexams.com reputation, killexams.com sham report grievance, killexams.com trust, killexams.com validity, killexams.com report and killexams.com scam. In the event that you perceive any mistaken report posted by their rivals with the cognomen killexams sham report grievance web, killexams.com sham report, killexams.com scam, killexams.com dissension or something fancy this, simply recall there are constantly terrible individuals harming reputation of obedient administrations because of their advantages. There are a powerful many fulfilled clients that pass their exams utilizing killexams.com brain dumps, killexams PDF questions, killexams hone questions, killexams exam simulator. Visit Killexams.com, their specimen questions and test brain dumps, their exam simulator and you will realize that killexams.com is the best brain dumps site.
Google About me
000-779 braindumps | 000-150 exam questions | 156-215-80 braindumps | 920-257 rehearse test | HP2-B80 rehearse exam | 98-365 braindumps | 9A0-084 examcollection | 70-331 free pdf | 920-270 free pdf download | HP2-B67 cram | 000-R25 brain dumps | HP0-262 true questions | HP0-876 study guide | C9510-418 rehearse questions | RH302 dump | 050-704 cheat sheets | 000-714 dumps questions | BCP-222 questions and answers | A2180-607 true questions | JN0-410 test prep |
000-911 exam questions | 000-911 free pdf | 000-911 pdf download | 000-911 test questions | 000-911 real questions | 000-911 practice questions
000-911 Dumps and rehearse programming with true Question
We are doing powerful struggle to provide you actual System and Administration: Informix Dynamic Server exam questions and answers, alongside explanations. Each question on killexams.com has been confirmed by IBM certified specialists. They are exceptionally qualified and confirmed people, who Have numerous times of expert experience identified with the System and Administration: Informix Dynamic Server exam. Memorizing their true questions is enough to pass 000-911 exam with lofty marks.
Is it upright that you are searching for IBM 000-911 Dumps containing true exams questions and answers for the System and Administration: Informix Dynamic Server Exam prep? killexams.com is here to give you one most updated and attribute wellspring of 000-911 Dumps that is http://killexams.com/pass4sure/exam-detail/000-911. They Have aggregated a database of 000-911 Dumps questions from true exams with a specific discontinue goal to give you a random to gain ready and pass 000-911 exam on the very first attempt.
killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for bar null exams on website
PROF17 : 10% Discount Coupon for Orders greater than $69
DEAL17 : 15% Discount Coupon for Orders greater than $99
OCTSPECIAL : 10% Special Discount Coupon for bar null Orders
If you are looking for 000-911 rehearse Test containing true Test Questions, you are at prerogative place. They Have compiled database of questions from Actual Exams in order to aid you prepare and pass your exam on the first attempt. bar null training materials on the site are Up To Date and verified by their experts.
killexams.com provide latest and updated rehearse Test with Actual Exam Questions and Answers for current syllabus of IBM 000-911 Exam. rehearse their true Questions and Answers to improve your knowledge and pass your exam with lofty Marks. They ensure your success in the Test Center, covering bar null the topics of exam and build your knowledge of the 000-911 exam. Pass 4 sure with their accurate questions.
100% Pass Guarantee
Our 000-911 Exam PDF contains Complete Pool of Questions and Answers and Brain dumps checked and verified including references and explanations (where applicable). Their target to assemble the Questions and Answers is not only to pass the exam at first attempt but Really improve Your knowledge about the 000-911 exam topics.
000-911 exam Questions and Answers are Printable in lofty attribute Study lead that you can download in your Computer or any other device and start preparing your 000-911 exam. Print Complete 000-911 Study Guide, carry with you when you are at Vacations or Traveling and Enjoy your Exam Prep. You can access updated 000-911 Exam from your online account anytime.
nside seeing the bona fide exam material of the brain dumps at killexams.com you can without a lot of an extend develop your claim to fame. For the IT specialists, it is basic to enhance their capacities as showed by their toil need. They fabricate it basic for their customers to carry certification exam with the aid of killexams.com confirmed and honest to goodness exam material. For an awesome future in its domain, their brain dumps are the best decision.
A best dumps creating is a basic segment that makes it straightforward for you to assume IBM certifications. In any case, 000-911 braindumps PDF offers settlement for candidates. The IT assertion is a captious troublesome attempt if one doesnt find genuine course as obvious resource material. Thus, they Have genuine and updated material for the arranging of certification exam.
It is fundamental to collect to the lead material in case one needs toward reclaim time. As you require packs of time to peer for revived and genuine exam material for taking the IT certification exam. If you find that at one place, what could subsist better than this? Its simply killexams.com that has what you require. You can reclaim time and maintain a strategic distance from trouble in case you buy Adobe IT certification from their site.
killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for bar null exams on website
PROF17 : 10% Discount Coupon for Orders greater than $69
DEAL17 : 15% Discount Coupon for Orders greater than $99
OCTSPECIAL : 10% Special Discount Coupon for bar null Orders
Download your System and Administration: Informix Dynamic Server Study lead immediately after buying and Start Preparing Your Exam Prep prerogative Now!
000-911 Practice Test | 000-911 examcollection | 000-911 VCE | 000-911 study guide | 000-911 practice exam | 000-911 cram
Killexams 000-436 study guide | Killexams TOEFL exam prep | Killexams C2090-621 brain dumps | Killexams FM0-302 rehearse test | Killexams DNDNS-200 brain dumps | Killexams C5050-285 test prep | Killexams ISSAP rehearse questions | Killexams 920-330 dumps | Killexams 190-849 VCE | Killexams C2020-645 cram | Killexams 000-M02 mock exam | Killexams 500-005 free pdf | Killexams 000-427 pdf download | Killexams HP0-S17 study guide | Killexams E22-214 free pdf download | Killexams 70-489 rehearse test | Killexams E20-555 braindumps | Killexams 310-220 dump | Killexams 1Z0-532 dumps questions | Killexams C8010-250 true questions |
killexams.com huge List of Exam Study Guides
Killexams C9520-929 exam questions | Killexams 00M-670 pdf download | Killexams 310-600 rehearse Test | Killexams HP0-J11 true questions | Killexams 700-260 dumps | Killexams COG-700 exam prep | Killexams C2010-507 dumps questions | Killexams 1Z0-061 test prep | Killexams 000-266 true questions | Killexams 000-M249 free pdf | Killexams LOT-828 rehearse exam | Killexams TT0-101 questions and answers | Killexams P2050-007 rehearse questions | Killexams HP0-M52 brain dumps | Killexams 000-565 braindumps | Killexams 000-184 examcollection | Killexams CHA rehearse test | Killexams HPE2-K43 mock exam | Killexams HP2-H01 study guide | Killexams DHORT test prep |
System and Administration: Informix Dynamic Server
Pass 4 sure 000-911 dumps | Killexams.com 000-911 true questions | https://www.textbookw.com/
July 05, 2007 12:00 ET
New Server Studio and Sentinel R. 6.1 to Enable Rapid Adoption of IDS 11 "Cheetah"
ARMONK, NY and current YORK, NY--(Marketwire - July 5, 2007) - IBM (NYSE: IBM) and AGS Ltd., a privately held purveyor of management solutions for data servers, today announced that the current Server Studio and Sentinel R. 6.1 -- the principal suite of integrated system management tools for IBM Informix Dynamic Server (IDS) -- is now available, with editions offered by both IBM and AGS.
The IDS data server is a strategic constituent of IBM's Information Management software portfolio and the recently announced IDS 11 -- code named Cheetah -- delivers increased performance, reliability and scalability, along with the competence to handle massive volumes of complex data at very lofty speeds. IDS 11 is likewise the industry's first data server to provide clustered data centers with continuous data availability and disaster recovery regardless of the geographic location or distance between backup data seat sites.
Server Studio and Sentinel together configuration a powerful infrastructure of multi-platform tools that aid both seasoned database professionals and novices alike manage IBM Informix data server environments with an unprecedented ease and productivity. native back of IDS 11 current functionality in the Release 6.1 of Server Studio and Sentinel further enhances competence to deliver optimal performance, availability and maintainability of Informix databases throughout their entire operational life cycle.
"Our long-term partnership with AGS underscores IBM's steadfast commitment to providing IDS clients with the performance optimization, availability and compliance management solutions they need," said Bernie Spang, director IBM data servers. "The current Release 6.1 of Server Studio and Sentinel will aid protect the investment that their customers Have made in their Informix data server infrastructures."
The versatility, rich functionality and ease-of-use provided by Server Studio and Sentinel build on the legendary reliability and simple administration of IDS. The current instrument set offered by AGS helps companies and organizations ensure that captious database applications remain up and accomplish at peak levels, allowing them to effectively manage change, handle regulatory compliance and assure availability of vital industry information.
Bank of America recently selected Server Studio and Sentinel for its IDS environment -- one of the world's largest distributed data centers processing online pecuniary transactions.
"The latest release of Server Studio and Sentinel provide a collection of integrated, highly productive system management tools that developers and DBAs working with IBM's Informix data servers Have been demanding and waiting for. Informix now has very powerful graphical tools that exceed the capabilities of native and third party offerings available for any other database platform. pair this with outstanding technical back and you gain products with excellent value and a quick ROI," said Kevin Kleinhomer, Vice President at Bank of America. "In their big distributed environment, Server Studio and Sentinel Have simplified and automated many DBA tasks. With these additions, IBM's Informix data servers Have been made significantly easier to administer and monitor."
Server Studio provides a comprehensive collection of easy-to-use, proven tools for DBAs and developers that improve efficiency of performing common database tasks such as: SQL progress and debugging, schema management, configuration auditing and change management, performance tuning, data storage management and reorganization, security administration and more -- bar null from an integrated graphical console that unites development, administration and maintenance activities for an entire Informix infrastructure at a central point of control.
Sentinel provides 24 × 7 operational monitoring, alerting, issue discovery, analysis and autonomic response automation infrastructure for IBM Informix data servers' environment. It's facile to deploy agent-less architecture equips DBAs with sophisticated diagnostics and remediation facilities which aid pinpoint and resolve the underlying causes of performance bottlenecks and resources contention issues that adversely influence databases' availability and impact discontinue users.
Smaller companies and organizations that accomplish not Have big IT staffs to manage big data servers infrastructure Have likewise benefited from the robust application progress and administration capabilities provided by IDS and Server Studio.
"As a software developer and DBA, Server Studio is a instrument that I consume every day, and it is exactly what I exact from my tools -- stable, reliable, and powerful," said Sean Durity, Manager of IT for CornerCap Investment Counsel. "Even the 'small' features of Server Studio are majestic timesavers. I can't imagine working with Informix and not using Server Studio. I won't toil with anything less."
The relationship between AGS and IBM began in 2000 when IBM began distributing AGS' Server Studio as the primary database progress and administration tools suite with Informix data servers. Product management, engineering and QA teams of both companies toil closely on product direction, technology progress and QA testing of Server Studio and Sentinel.
"We are disdainful of and greatly value their strategic partnership with IBM. Selection of AGS data servers' management solutions by IBM is a testament to their industry-leading technology," said Anatole Vishon, CEO of AGS Ltd. "We understand the vital weight of Informix, particularly in the retail, financial, telecommunications, healthcare, government and SMB sectors. AGS is committed to supporting existing capabilities and developing current technologies for Informix data servers to add value for IBM customers."
Pricing and Availability
The Release 6.1 of Server Studio and Sentinel are available now through IBM and AGS worldwide. The Core Edition of Server Studio is provided by IBM to Informix customers at no additional cost. Its basic functionality can subsist extended by purchase of various premium editions available directly from AGS.
Additional information about Server Studio is available at: http://www.ibm.com/software/data/informix/serverstudio/, or http://www.serverstudio.com/products/serverstudio/
Additional information about Sentinel is available at: http://www.ibm.com/software/data/informix/sentinel/, or http://www.serverstudio.com/products/sentinel/
Additional information about Informix Dynamic Server is available at: http://www.ibm.com/software/data/informix/ids/
AGS, Server Studio and Sentinel are trademarks or registered trademarks of Advanced Global Systems, Ltd. For a list of additional AGS trademarks, gladden perceive http://www.ags.com
IBM, Informix Dynamic Server and the IBM e-business logo are trademarks or registered trademarks of International industry Machines Corporation. For a list of additional IBM trademarks, gladden perceive www.ibm.com/legal/copytrade.shtml
All other company, product or service names may subsist trademarks or registered trademarks of others. Statements concerning IBM's future progress plans and schedules are made for planning purposes only, and are topic to change or withdrawal without notice. Reseller prices may vary.
Nov 10, 2011
Although it is practicable to develop an efficient Vehicle Tracking System using any database server, and many such solutions are already available in the market, Informix offers many advantages. Informix can reduce your disk space requirement, improve your query performance, and reduce your application progress efforts, without special training or buying additional technology. The built-in technologies of Informix will reduce your total cost of ownership, so if these benefits are notable to you, maintain reading!
A Vehicle Tracking System (VTS) tracks vehicles and provides different analytics, such as the total distance travelled, the total fuel consumption, the best routes, and so on. Certainly having more and more different kinds of alerts improves the efficiency of system. This system encompasses three phases of implementation: instrumentation, integration, and intelligence.
Instrumentation: Each vehicle has a special device that records different parameters related to a vehicle, such as, speed, current location, fuel status, ignition status, and so on.
Integration: Devices implemented in the domain transmit information through an integrated system that includes a GPRS system and stores the information in a database.
Intelligence: The intelligence on the information collected from the domain is stored in a database, including different kinds of MIS reports, dashboards, current locations of vehicles, travel information, and reports of exceptions fancy geo-fence violations and fuel theft.
Some of the characteristics of a VTS are:
Information about vehicles is collected every few minutes or as often as every minute
The volume of the data is huge
Performance is critical
Accuracy of the data matters the most
The application logic is specific to the industry (for example, geo-fencing, distance calculations, and so on)
Now let's perceive the advantages of Informix built-in technologies over the traditional relational approach.
Disk Space Saving (62%)
A vehicle tracking system collects the vehicle-related information, including a time stamp, with a specific frequency. Informix provides a data character that stores this character of time progression information more efficiently than any traditional RDBMS approach. The following tables compare both approaches.
Traditional RDBMS approach
This table shows the structure of the tracking table in a traditional RDBMS.
Informix TimeSeries data character approach
Informix stores time progression data in a specialized data type, called TimeSeries, which stores bar null the time progression data for a particular vehicle in the same row. Informix supports two different types of time series: regular time progression that stores the data with a fixed frequency, and irregular time progression that stores the data for arbitrary points in time. A regular time progression is the most suitable for a VTS. In a regular time series, the time stamp is stored only once as the origin of the time progression and the time stamps of the comfort of the rows are calculated using the offset from the origin.
This table shows the structure of the tracking table in Informix, using the TimeSeries data type.
[(72.844060, 19.116280,85.00,40.00), (72.853800, 19.113470,84.90, 39.00)....]
[(72.855370, 19.116570, 100.00,45.00), (72.885120, 19.106000, 99.90, 45.00)..]
The data for each vehicle is stored in contiguous disk space on a page.
Traditional RDBMS approach
We create the traditional RDBMS table for storing vehicle tracking information, called vehicle_tracking:
create table vehicle_tracking
vehicle_number integer, - 4 (bytes)
timestamp datetime year to fraction(5) - 11(bytes)
longitude decimal(10,8), - 6(bytes)
latitude decimal(10,8) - 6(bytes)
speed decimal(5,2) - 4(bytes)
We create an index on the vehicle_number and timestamp columns.
Suppose they Have 10,000 vehicles to subsist tracked every minute and they requisite to store information for 90 days. Let's device the storage requirements.
Record size = 4+11+6+6+4 = 31
Record/slot overhead = 4 bytes
Total size of record = 31 + 4 = 35 bytes
Page overhead for maintaining page information = 28bytes per page
Total free space on 2 K page size = 2048-28 = 2020byte
Total records on each page = 2020/35=57
Total number of records = 10000*60*24*90 = 1296000000
Total number of pages used = 1296000000 / 57 = 22736842
Total space required for data = 22736842 * 2 KB = 43 GB
Total space required for the index = 34 GB
The total space required for the vehicle_tracking table = 43 + 34 = 77GB
Informix TimeSeries data character approach
We create a TimeSeries data type, named vehicle_tracking_rt, and then create a table, named vehicle_tracking_ts, that includes the vehicle_tracking_rt column:
create row character vehicle_tracking_rt
timestamp datetime year to fraction(5)
create table vehicle_tracking_ts
We create an index on only the vehicle_number column.
We store the vehicle number only once, hence the space required for the vehicle_number column = 10000*4 = 40000bytes=39 KB.
We create the index on only the vehicle_number column, hence the total space required for the index = 10000*4=40000 bytes = 39 KB.
We store the time stamp only once for each vehicle, hence the space required for the time stamp = 10000*11 = 110000 bytes = 107 KB.
The space required for bar null remaining columns is:
Record size = 6+6+4 = 16
Record/slot overhead = 4 bytes
Total size of record = 16 + 4 = 20 bytes
Page overhead for maintaining page information = 28bytes + 16 bytes slot overhead Total free space on 2 K page size = 2048-44 = 2004 bytes
Total records on each page = 2004/20=100
Total number of pages used per vehicle per day = 1440 / 100 = 15
Total pages used per day = 10000*15 = 150000
Total space required for data on first day = 150000 * 2 KB = 0.29 GB
Daily increment in data = 0.27 GB
Total space required for data of 90 days = 25 GB
The total space required for the vehicle_tracking_ts table = 25 GB +39 KB +29 KB+ 107 KB = 25 GB
This is a 68% disc space saving compared to a traditional RDBMS approach.
Performance (up to 54 times faster)
Let's consider few consume cases:
Fuel theft information
Total fuel consumption
For bar null of these consume cases, the application scans through the data for one day.
Traditional RDBMS performance
The report generation requires the following disk reads:
At least 5 disk reads through the index to attain to leaf nodes
Each vehicle has 60*24 records per day = 1440
Each vehicle needs 1440 non-cached disk reads
Total non-cached distributed disk reads = 1440 * 10000 = 14.4 million
Informix TimeSeries data character performance
Because the index is only 39 KB, the scan endeavor is minimal.
Because the TimeSeries data character stores data in contiguous space on a page, for a 2 K page size each page contains at least 2004/20 = 100 rows.
Each vehicle needs 1440/100 = 15 pages = 15 disk reads.
Total non-cached distributed disk reads = (15+ 1) * 10000 = 160,000
Informix TimeSeries type
68% space saving
54 times faster
The advantages of using the Informix TimeSeries implementation are:
Disk space reduction: almost 62% disc space saving
Performance improvement is multifold: up to 110 times faster
Faster development: Informix has more than 80 built-in SQL functions to accomplish different operations on time progression data, such as, aggregation, running average, slimming algorithms, interpolation and extrapolation, and so on.
Customized development: Informix provides C and Java APIs to let developers develop their own time progression functions.
Because many operations in a VTS application are time based, the available built-in routines for the Informix TimeSeries data character makes progress facile and fast.
If they want to perceive the mediocre speed of vehicle every 30 minutes, the RDBMS approach requires a big programming endeavor and a performance challenge. Whereas, with the Informix TimeSeries data type, they consume the simple AggregateBy duty to roll-up the information to any required time frequency.
If they want to perceive the mediocre speed of vehicle in eventual 30 days, the best routine is to examine its running mediocre (not its traditional average). Again, showing the running mediocre speed of vehicles with the RDBMS approach is a majestic programming and performance challenge. Whereas with the Informix TimeSeries data type, they consume the simple TSRunningAvg duty with the period and frequency that they want.
Another basic requisite of VTS is storing location-related information. Location information can subsist in the configuration of a point specifying the location of vehicle, a LineString specifying the route, or a Polygon specifying the geo-fence of the vehicle. The easiest course to handle this character of information is by using the Informix spatial data types. Informix spatial data types not only optimally maintain the data, but likewise provide built-in routines that improve the accuracy and ease the progress of your solution.
Let's examine the consume case of geo-fencing. Geo-fencing refers to the rehearse of limiting the vehicle movements to a specific geographical belt by defining the latitude and longitude of the belt in the configuration of a LineString or polygon.
A geo-fence system raises an alarm if one of the vehicles leaves the fenced belt and deviates from its designated route. This might betide because of the personal interest of the vehicle driver or because the vehicle is stolen.
Traditional RDBMS approach
We identify the different locations on the route the vehicle is putative to travel and insert multiple rows into a fence table, comprising information fancy the vehicle ID and its location (latitude and longitude) information. If they requisite to track 200 different locations on the designated route for a particular vehicle, they insert 200 rows for that vehicle. To check if the vehicle is outside the fence area, they develop their own logic and rush the cursor through these 200 rows to check if the current location is within any two points.
To parade the geo-fence on an online map, they create an XML file by running a cursor through bar null 200 records and then parse through the XML to parade each point on the map.
Informix spatial data types approach
We define a column called geofence in the master table with a data character of either polygon or LineString. They store bar null 200 location co-ordinates in this solitary column.
To check if the vehicle is within the fence area, they consume the SQL duty ST_Within (curr_loc,geofence). If the duty returns "True," the vehicle is within the fence area; if it returns "False," the vehicle is outside the fence area.
To parade the geo-fence on an online map, they consume SE_askml(geofence) function, which creates a KML file that they can import into the map.
Advantages of using Informix spatial data types
Faster development: functions fancy ST_within and SE_askml are readily available
Better performance: they don't requisite to rush through multiple records
Assured accuracy: they are using Open GIS Consortium-compliant function
More analytics: they can find the nearest location or the distance between any two locations using functions fancy Nearest and ST_distance
Systems fancy a Vehicle Tracking System can subsist developed using any kindhearted of database as a back-end. But using by the Informix TimeSeries and spatial built-in data types, the same system can subsist many times more efficient. The disk space saving of 60% and up to 54 times faster performance compared to traditional relational approach can enable you to augment the frequency of data collection, which means better accuracy. The built-in functions for the TimeSeries and spatial data types makes the application progress stint easier and provides for increased accuracy.
About the author:
Vaibhav Dantale is a software engineer within IBM Information Management division. He has been working on Informix for eventual 12 years, in various development, QA and technical management roles. Currently, Dantale focuses on evangelizing Informix product in ASIA Pacific region. He is one of the Informix TimeSeries technical experts and has been involved in several customer engagements on Informix TimeSeries. He has patents under his cognomen and is co-author of a red bespeak on Informix security features.
Establishing a usable database environment requires a powerful deal of skill, knowledge, and consideration. This chapter will outline the principles involved in establishing a usable database environment.
This chapter is from the bespeak
One of the primary tasks associated with the job of DBA is the process of choosing and installing a DBMS. Unfortunately, many industry executives and IT professionals without database management background assume that once the DBMS is installed, the bulk of the toil is done. The verity is, choosing and installing the DBMS is hardly the most difficult partake of a DBA’s job. Establishing a usable database environment requires a powerful deal of skill, knowledge, and consideration. This chapter will outline the principles involved in establishing a usable database environment.
The process of choosing a suitable DBMS for enterprise database management is not as difficult as it used to be. The number of major DBMS vendors has dwindled due to industry consolidation and domination of the sector by a few very big players.
Yet, big and medium-size organizations typically rush multiple DBMS products, from as few as two to as many as ten. For example, it is not uncommon for a big company to consume IMS or IDMS and DB2 on the mainframe, Oracle and MySQL on several different UNIX servers, Microsoft SQL Server on Windows servers, as well as pockets of other DBMS products such as Sybase, Ingres, Adabas, and PostgreSQL on various platforms, not to mention single-user PC DBMS products such as Microsoft Access, Paradox, and FileMaker. Who chose to install bar null these DBMSs and why?
Unfortunately, often the respond is that not much thought and planning went into the decision-making process. Sometimes the conclusion to purchase and install a current DBMS is driven by a industry requisite or a current application. This is reasonable if your organization has no DBMS and must purchase one for the first time. This is rarely the case, though. Regardless of whether a DBMS exists on-site, a current DBMS is often viewed as a requirement for a current application. Sometimes a current DBMS product is purchased and installed without first examining if the application could subsist successfully implemented using an existing DBMS. Or, more likely, the DBAs know the application can subsist implemented using an existing DBMS but want the organizational power or back to reject a current DBMS proposal.
There are other reasons for the being of multiple DBMS platforms in a solitary organization. Perhaps the company purchased a commercial off-the-shelf application package that does not rush on any of the current DBMS platforms. Sometimes the conclusion to buy a current DBMS is driven by the wish to back the latest and greatest technology. For example, many mainframe shops poignant from a hierarchic (IMS) or CODASYL (IDMS) database model to the relational model deployed DB2, resulting in an additional DBMS to learn and support. Then, when client/server computing became popular, additional DBMSs were implemented on UNIX, Linux, and Windows servers.
Once a DBMS is installed, removal can subsist difficult because of incompatibilities among the different DBMSs and the necessity of converting application code. Furthermore, when a current DBMS is installed, frail applications and databases are usually not migrated to it. The frail DBMS remains and must continue to subsist supported. This complicates the DBA’s job.
So what should subsist done? Well, the DBA group should subsist empowered to fabricate the DBMS decisions for the organization. No industry unit should subsist allowed to purchase a DBMS without the leave of the DBA group. This is a difficult provision to implement and even more difficult to enforce. industry politics often toil against the DBA group because it frequently possesses less organizational power than other industry executives.
Choosing a DBMS
The DBA group should set a policy regarding the DBMS products to subsist supported within the organization. Whenever possible, the policy should minimize the number of different DBMS products. For a shop with multiple operating systems and multiple types of hardware, elect a default DBMS for the platform. discourage aberration from the default unless a compelling industry case exists—a industry case that passes the technical inspection of the DBA group.
Most of the major DBMS products Have similar features, and if the feature or functionality does not exist today, it probably will within 18 to 24 months. So, exercise caution before deciding to elect a DBMS based solely on its competence to back a specific feature.
When choosing a DBMS, it is sane to select a product from a tier-1 vendor as listed in Table 2.1. Tier 1 represents the largest vendors having the most heavily implemented and supported products on the market. You cannot recede wrong with DB2 or Oracle. Both are well-liked and back just about any character of database. Another major player is Microsoft SQL Server, but only for Windows platforms. DB2 and Oracle rush on multiple platforms ranging from mainframe to UNIX, as well as Windows and even handheld devices. Choosing a DBMS other than these three should subsist done only under specific circumstances.
Table 2.1. Tier-1 DBMS Vendors
New Orchard Road
Armonk, NY 10504
Phone: (914) 499-1900
500 Oracle Parkway
Redwood Shores, CA 94065
Phone: (650) 506-7000
One Microsoft Way
Redmond, WA 98052
Phone: (425) 882-8080
After the majestic three attain MySQL, Sybase, Teradata, and Informix. Table 2.2 lists these tier-2 DBMS vendors. bar null of these offerings are attribute DBMS products, but their installed groundwork is smaller, their products are engineered and marketed for niche purposes, or the companies are smaller with fewer resources than the majestic Three (IBM, Oracle, and Microsoft), so there is some risk in choosing a DBMS from tier 2 instead of tier 1. However, there may subsist solid reasons for deploying a tier-2 solution, such as the lofty performance offered by Informix or the data warehousing and analytics capabilities of Teradata.
Table 2.2. Tier-2 DBMS Vendors
Informix Dynamic Server
New Orchard Road
Armonk, NY 10504
Phone: (914) 499-1900
Sybase Inc. (an SAP Company)
Adaptive Server Enterprise
6475 Christie Avenue
Emeryville, CA 94608
Phone: (510) 922-3500
10000 Innovation Drive
Dayton, OH 45342
Phone: (937) 242-4030
MySQL (a subsidiary of Oracle Corporation)
Phone: (208) 338-8100
Of course, there are other DBMS products on the market, many of which are fine products and worthy of consideration for specialty processing, inevitable predefined needs, and niche roles. If your company is heavily into the open-source software movement, PostgreSQL, EnterpriseDB, or MySQL might subsist viable options. If an object DBMS is notable for a specific project, you might consider ObjectDesign or Versant. And there are a variety of NoSQL DBMS offerings available, too, such as Hadoop, Cassandra, and MongoDB.1
However, for the bulk of your data management needs, a DBMS from a tier-1, or perhaps tier-2, DBMS vendor will deliver enough functionality with minimal risk. A myriad of DBMS products are available, each with inevitable features that fabricate them worthy of consideration on a case-by-case basis. Choosing any of the lower-tier candidates—even such major names as Software AG’s Adabas and Actian’s Ingres—involves incurring additional risk. advert to Appendix B for a list of DBMS vendors.
I accomplish not want it to sound as if the selection of a DBMS is a no-brainer. You will requisite a strategy and a scheme for selecting the arrogate DBMS for your specific situation. When choosing a DBMS, subsist sure to consider each of these factors:
Operating system support. Does the DBMS back the operating systems in consume at your organization, including the versions that you are currently using and scheme on using?
Type of organization. assume into consideration the corporate philosophy when you elect a DBMS. Some organizations are very conservative and fancy to maintain a tense rein on their environments; these organizations attend to gravitate toward traditional mainframe environments. Government operations, pecuniary institutions, and insurance and health companies usually attend to subsist conservative. More-liberal organizations are often willing to consider alternative architectures. It is not uncommon for manufacturing companies, dot-coms, and universities to subsist less conservative. Finally, some companies just accomplish not trust Windows as a mission-critical environment and prefer to consume UNIX; this rules out some database vendors (Microsoft SQL Server, in particular).
Benchmarks. What performance benchmarks are available from the DBMS vendor and other users of the DBMS? The Transaction Processing Performance Council (TPC) publishes official database performance benchmarks that can subsist used as a guideline for the basic overall performance of many different types of database processing. (Refer to the sidebar “The Transaction Processing Performance Council” for more details.) In general, performance benchmarks can subsist useful as a broad indicator of database performance but should not subsist the only determinant when selecting a DBMS. Many of the TPC benchmarks are rush against database implementations that are not representative of most production database systems and therefore are not indicative of the actual performance of a particular DBMS. In addition, benchmarks are constantly updated to note current and improved performance measurements for each of the major DBMS products, rendering the benchmark “winners” obsolete very quickly.
Scalability. Does the DBMS back the number of users and database sizes you intend to implement? How are big databases built, supported, and maintained—easily or with a lot of pain? Are there independent users who can verify the DBMS vendor’s scalability claims?
Availability of supporting software tools. Are the supporting tools you require available for the DBMS? These items may embrace query and analysis tools, data warehousing back tools, database administration tools, backup and recovery tools, performance-monitoring tools, capacity-planning tools, database utilities, and back for various programming languages.
The Transaction Processing Performance Council is an independent, not-for-profit organization that manages and administers performance benchmark tests. Its mission is to define transaction processing and database benchmarks to provide the industry with objective, verifiable performance data. TPC benchmarks measure and evaluate computer functions and operations.
The definition of transaction espoused by the TPC is a industry one. A typical TPC transaction includes the database updates for things such as inventory control (goods), airline reservations (services), and banking (money).
The benchmarks produced by the TPC measure performance in terms of how many transactions a given system and database can accomplish per unit of time, for example, number of transactions per second. The TPC defines three benchmarks:
TPC-C, for planned production workload in a transaction environment
TPC-H, a conclusion back benchmark consisting of a suite of business-oriented ad hoc queries and concurrent data modifications
TPC-E, an updated OLTP workload (based on pecuniary transaction processing)
Additional information and in-depth definitions of these benchmarks can subsist create at the TPC Web site at www.tpc.org (see device 2.1).
Technicians. Is there a enough supply of skilled database professionals for the DBMS? consider your needs in terms of DBAs, technical back personnel (system programmers and administrators, operations analysts, etc.), and application programmers.
Cost of ownership. What is the total cost of ownership of the DBMS? DBMS vendors suffuse wildly varying prices for their technology. Total cost of ownership should subsist calculated as a combination of the license cost of the DBMS; the license cost of any required supporting software; the cost of database professionals to program, support, and administer the DBMS; and the cost of the computing resources required to operate the DBMS.
Release schedule. How often does the DBMS vendor release a current version? Some vendors Have rapid release cycles, with current releases coming out every 12 to 18 months. This can subsist obedient or bad, depending on your approach. If you want cutting-edge features, a rapid release cycle is good. However, if your shop is more conservative, a DBMS that changes frequently can subsist difficult to support. A rapid release cycle will cause conservative organizations either to upgrade more frequently than they would fancy or to live with outdated DBMS software that is unlikely to Have the same level of back as the latest releases.
Reference customers. Will the DBMS vendor supply current user references? Can you find other users on your own who might provide more impartial answers? talk with current users to elicit issues and concerns you may Have overlooked. How is support? Does the vendor respond well to problems? accomplish things generally toil as advertised? Are there a lot of bug fixes that must subsist applied continuously? What is the attribute of current releases? These questions can subsist answered only by the folks in the trenches.
When choosing a DBMS, subsist sure to assume into account the complexity of the products. DBMS software is very complex and is getting more complex with each current release. Functionality that used to subsist supported only with add-on software or independent programs is increasingly being added as features of the DBMS, as shown in device 2.2. You will requisite to scheme for and back bar null the features of the DBMS. Even if there is no current requirement for inevitable features, once you implement the DBMS the programmers and developers will find a judgement to consume just about anything the vendor threw into it. It is better to scheme and subsist prepared than to allow features to subsist used without a scheme for supporting them.
Figure 2.2. Convergence of features and functionality in DBMS software
The supporting architecture for the DBMS environment is very captious to the success of the database applications. One wrong option or poorly implemented component of the overall architecture can cause indigent performance, downtime, or unstable applications.
When mainframes dominated enterprise computing, DBMS architecture was a simpler concern. Everything ran on the mainframe, and that was that. However, today the IT infrastructure is distributed and heterogeneous. The overall architecture—even for a mainframe DBMS—will probably consist of multiple platforms and interoperating system software. A team consisting of industry and IT experts, rather than a solitary person or group, should fabricate the final architecture decision. industry experts should embrace representatives from various departments, as well as from accounting and legal for software constrict issues. Database administration representatives (DA, DBA, and SA), as well as members of the networking group, operating system experts, operations control personnel, programming experts, and any other interested parties, should subsist included in this team.
Furthermore, subsist sure that the DBMS you select is arrogate for the nature and character of processing you scheme to implement. Four levels of DBMS architecture are available: enterprise, departmental, personal, and mobile.
An enterprise DBMS is designed for scalability and lofty performance. An enterprise DBMS must subsist capable of supporting very big databases, a big number of concurrent users, and multiple types of applications. The enterprise DBMS runs on a large-scale machine, typically a mainframe or a high-end server running UNIX, Linux, or Windows Server. Furthermore, an enterprise DBMS offers bar null the “bells and whistles” available from the DBMS vendor. Multiprocessor support, back for parallel queries, and other advanced DBMS features are core components of an enterprise DBMS.
A departmental DBMS, sometimes referred to as a workgroup DBMS, serves the middle ground. The departmental DBMS supports tiny to medium-size workgroups within an organization; typically, it runs on a UNIX, Linux, or Windows server. The dividing line between a departmental database server and an enterprise database server is quite gray. Hardware and software upgrades can allow a departmental DBMS to tackle tasks that previously could subsist performed only by an enterprise DBMS. The steadily falling cost of departmental hardware and software components further contributes to lowering the total cost of operation and enabling a workgroup environment to scale up to serve the enterprise.
A personal DBMS is designed for a solitary user, typically on a low- to medium-powered PC platform. Microsoft Access, SQLite, and FileMaker2 are examples of personal database software. Of course, the major DBMS vendors likewise market personal versions of their higher-powered solutions, such as Oracle Database Personal Edition and DB2 Personal Edition. Sometimes the low cost of a personal DBMS results in a misguided attempt to elect a personal DBMS for a departmental or enterprise solution. However, accomplish not subsist lured by the low cost. A personal DBMS product is suitable only for very small-scale projects and should never subsist deployed for multiuser applications.
Finally, the mobile DBMS is a specialized version of a departmental or enterprise DBMS. It is designed for remote users who are not usually connected to the network. The mobile DBMS enables local database access and modification on a laptop or handheld device. Furthermore, the mobile DBMS provides a mechanism for synchronizing remote database changes to a centralized enterprise or departmental database server.
A DBMS designed for one character of processing may subsist ill suited for other uses. For example, a personal DBMS is not designed for multiple users, and an enterprise DBMS is generally too complex for solitary users. subsist sure to understand the differences among enterprise, departmental, personal, and mobile DBMS software, and elect the arrogate DBMS for your specific data-processing needs. You may requisite to elect multiple DBMS types—that is, a DBMS for each level—with usage determined by the needs of each progress project.
If your organization requires DBMS solutions at different levels, favor the selection of a group of DBMS solutions from the same vendor whenever possible. Doing so will minimize differences in access, development, and administration. For example, favor Oracle Database Personal Edition for your single-user DBMS needs if your organization uses Oracle as the enterprise DBMS of choice.
Clustering is the consume of multiple “independent” computing systems working together as a single, highly available system. A modern DBMS offers clustering back to enhance availability and scalability. The two predominant architectures for clustering are shared-disk and shared-nothing. These names accomplish a obedient job of describing the nature of the architecture—at least at a lofty level.
Shared-nothing clustering is depicted in device 2.3. In a shared-nothing architecture, each system has its own private resources (memory, disks, etc.). The clustered processors communicate by passing messages through a network that interconnects the computers. In addition, requests from clients are automatically routed to the system that owns the resource. Only one of the clustered systems can “own” and access a particular resource at a time. In the event a failure occurs, resource ownership can subsist dynamically transferred to another system in the cluster. The main advantage of shared-nothing clustering is scalability. In theory, a shared-nothing multiprocessor can scale up to thousands of processors because they accomplish not meddle with one another—nothing is shared.
In a shared-disk environment, bar null the connected systems partake the same disk devices, as shown in device 2.4. Each processor quiet has its own private memory, but bar null the processors can directly address bar null the disks. Typically, shared-disk clustering does not scale as well for smaller machines as shared-nothing clustering. Shared-disk clustering is better suited to large-enterprise processing in a mainframe environment. Mainframes—very big processors—are capable of processing enormous volumes of work. powerful benefits can subsist obtained with only a few clustered mainframes, while many PC and midrange processors would requisite to subsist clustered to achieve similar benefits.
Shared-disk clustering is usually preferable for applications and services requiring only modest shared access to data and for applications or workloads that are very difficult to partition. Applications with hefty data update requirements are probably better implemented as shared-nothing. Table 2.3 compares the capabilities of shared-disk and shared-nothing architectures.
Table 2.3. Comparison of Shared-Disk and Shared-Nothing Architectures
Quick adaptability to changing workloads
Can exploit simpler, cheaper hardware
Almost unlimited scalability
Performs best in a hefty read environment
Works well in a high-volume, read-write environment
Data requisite not subsist partitioned
Data is partitioned across the cluster
The major DBMS vendors provide back for different types of clustering with different capabilities and requirements. For example, DB2 for z/OS provides shared-disk clustering with its Data Sharing and Parallel Sysplex capabilities; DB2 on non-mainframe platforms uses shared-nothing clustering. Oracle’s true Application Clusters provide shared-disk clustering.
For most users, the primary benefit of clustering is the enhanced availability that accrues by combining processors. In some cases, clustering can aid an enterprise to achieve five-nines (99.999 percent) availability. Additionally, clustering can subsist used for load balancing and failover.
As a rule of thumb, create a policy (or at least some simple guidelines) that must subsist followed before a current DBMS can subsist brought into the organization. Failure to accomplish so can cause a proliferation of different DBMS products that will subsist difficult to support. It can likewise cause confusion regarding which DBMS to consume for which progress effort.
As mentioned earlier, there is a plethora of DBMS vendors, each touting its benefits. As a DBA, you will subsist bombarded with marketing and sales efforts that attempt to convince you that you requisite another DBMS. Try to resist unless a very compelling judgement is given and a short-term revert on investment (ROI) can subsist demonstrated. Even when confronted with sound reasons and obedient ROI, subsist sure to double-check the arguments and ROI calculations. Sometimes the reasons specified are outdated and the ROI figures accomplish not assume everything into account—such as the additional cost of administration.
Remember, every DBMS requires database administration support. Moreover, each DBMS uses different methods to accomplish similar tasks. The fewer DBMS products installed, the less complicated database administration becomes, and the better your chances become of providing efficacious data management resources for your organization.
When establishing a database environment for application development, selecting the DBMS is only partake of the equation. The hardware and operating system on which the DBMS will rush will greatly impact the reliability, availability, and scalability (RAS) of the database environment. For example, a mainframe platform such as an IBM zEC12 running z/OS will probably provide higher RAS than a midrange IBM xSeries machine running AIX, which in gyrate will probably exceed a Dell server running Windows. That is not to narrate everything should rush on a mainframe; other issues such as cost, experience, manageability, and the needs of the applications to subsist developed must subsist considered. The bottom line is that you must subsist sure to factor hardware platform and operating system constraints into the DBMS selection criteria.
Cloud Database Systems
Cloud computing (see the sidebar) is increasing in usage, especially at tiny to medium-size businesses. A cloud implementation can subsist more cost-effective than edifice an entire local computing infrastructure that requires management and support.
A cloud database system delivers DBMS services over the Internet. The trade-off essentially comes down to trusting a cloud provider to store and manage your data in revert for minimizing database administration and maintenance cost and effort. Using cloud database systems can enable organizations, especially smaller ones without the resources to invest in an enterprise computing infrastructure, to focus on their industry instead of their computing environment.
By consolidating data sources in the cloud, it is practicable to improve collaboration among partners, branch offices, remote workers, and mobile devices, because the data becomes accessible as a service. There is no requisite to install, set up, patch, or manage the DBMS software because the cloud provider manages and cares for these administrative tasks. Of course, the downside is that your data is now stored and controlled by an external agent—the cloud provider. Another inherent risk of cloud computing is the possibility of nefarious agents posing as legitimate customers.
An case of a cloud database platform is Microsoft SQL Azure. It is built on SQL Server technologies and is a component of the Windows Azure platform.