425:. IBM subsequently acquired the database division of Informix in April 2001, making UniVerse and UniData part of IBM's DB2 product family. IBM subsequently created the Information Management group of which Data Management is one of the sub-areas under which the IBM U2 family comprised UniData and UniVerse along with the tools, SystemBuilder Extensible Architecture (SB/XA), U2 Web Development Environment (U2 Web DE) and wIntegrate.
184:
36:
138:
587:
Thus the first three fields of this record, including the record ID and trailing field mark, would use 49 bytes of storage. A given value uses only as many bytes as needed. For example, in another record of the same file, JOHN JONES (10 bytes) may be replaced by MARJORIE Q. HUMPERDINK (21 bytes) yet
721:
Rocket
Software Universe and Unidata have limited ability to create web-based front-ends to Universe/UniData content. Since Rocket Software provides SQL access to its database products, a SQL-based product can be used to build a web-based UI to the databases; regardless of using Files or Tables in
643:(UniVerse Basic and UniBasic, respectively), similar to Pick/BASIC which naturally operates on the structures of the MultiValue database. They also have a structured database query language (RetrieVe and UniQuery) used to select records for further processing and for ad hoc queries and reports.
548:
Files are made of records, which are similar to rows within tables of a relational database. Each record has a unique key (called a "record ID") to distinguish it from other records in the file. These record IDs are typically hashed so that data can be retrieved quickly and efficiently.
689:
Both UniVerse and UniData support TLS transport level data encryption and record and file level encryption of data at rest using OpenSSL. Additional API encryption functionality is also available to allow custom solutions or meet specific regulatory requirements.
591:
Fields may be broken down into values and even subvalues. Values are separated by value marks (character xFD); subvalues are separated by subvalue marks (character xFC). Thus, if John Jones happened to get a second email address, the record may be updated to:
556:
strings; there is no binary data stored in U2. For example, the hardware representation of a floating-point number would be converted to its ASCII equivalent before being stored. Usually these records are divided into
520:. When searching for data in a hashed file, the system only searches the group where the record ID is stored, making the search process more efficient and quicker than searching through the whole file.
421:
and are embedded into the vertical software applications. In 1997, the
Unidata Corporation merged with VMark Systems to form Ardent Software. In March 2000, Ardent Software was acquired by
999:
699:
500:
Files are made of two parts: a data file and a file dictionary (DICT). The data file contains records that store the actual data. The file dictionary may contain
540:. This type of file is stored as a subdirectory within the account directory on the host operating system and may be read or edited using appropriate tools.
428:
On 1 October 2009 it was announced that Rocket
Software had purchased the entire U2 portfolio from IBM. The U2 portfolio is grouped under the name RocketU2.
417:
UniVerse was originally developed by VMark
Software and UniData was originally developed by the Unidata Corporation. Both Universe and Unidata are used for
920:
490:
441:
Systems are made of one or more accounts. Accounts are directories stored on the host operating system that initially contain the set of
156:
119:
736:
1034:
470:
458:
57:
646:
RocketU2 provides a set of Client Tools to allow software developers to access U2 databases from other software languages.
913:
252:
820:
580:
as the second field and $ 4321.00 as a monthly salary stored in the third field. (The up-arrow (^) above is the standard
844:
100:
561:(which are sometimes called "attributes" in U2). Each field is separated by a "field mark" (hexadecimal character FE).
1019:
1014:
215:
72:
328:
53:
46:
79:
577:
might represent a record in the EMPLOYEE file with 123-45-6789 as the Record ID, JOHN JONES as the first field,
1009:
906:
418:
244:
808:
631:. e.g. an employee record will have data stored in the form of fields/attributes like his name, address etc.
1024:
1004:
86:
731:
581:
371:
348:
68:
296:
493:
in that each file has a unique name to distinguish it from other files and zero to multiple unique
450:
279:
963:
466:
375:
259:
973:
558:
272:
486:
474:
363:
291:
528:
Nonhashed files are used to store data with little or no logical structure such as program
929:
793:
781:
462:
379:
367:
332:
196:
868:
1029:
494:
324:
93:
615:; in U2 terms, a "translate"), this provides the reason why U2 may be classified as a
611:
Since each email address can be the ID of a record in separate file (in SQL terms, an
993:
513:
442:
183:
832:
722:
U2. A third-party application framework, can be used to build such web interfaces.
628:
601:
598:
578:
570:
529:
35:
856:
221:
UniData 8.1, UniVerse 12.1.1, SB+ 6.5.6, Web DE 5.1.2 / January 7, 2022
958:
953:
616:
612:
588:
each name uses only as much storage as it needs, plus one for the field mark.
537:
517:
446:
336:
284:
191:
445:
needed for the system to function properly. This includes the system's VOC (
948:
769:
968:
501:
454:
422:
978:
892:
360:
17:
757:
885:
248:
898:
640:
553:
390:
383:
356:
264:
473:. Each of these classes of VOC entries can also be created by a
352:
268:
902:
307:
533:
504:
to describe the contents or to output the contents of a file.
402:
131:
29:
627:
Raw information is called Data. A record is a set of logical
552:
Records (including record IDs) store the actual data as pure
516:
to allocate the file's records into groups based on the
152:
680:
Python (available as of UniVerse 11.3 and UniData 8.2)
608:
where the close bracket (]) represents a value mark.
936:
596:
568:
302:
290:
278:
258:
240:
214:
202:
190:
60:. Unsourced material may be challenged and removed.
702:designations related to the U2 product family.
157:sources that evaluate within a broader context
914:
833:'Rocket Software U2 Acquisition Announcement'
794:'UniVerse Guide for Pick Users, Version 10.3'
8:
331:(DBMS) and supporting software now owned by
176:
782:'UniVerse System Description, Version 10.3'
921:
907:
899:
497:that are logically related to each other.
182:
175:
845:'Rocket Software to purchase U2 from IBM'
584:notation of a field mark; that is, xFE).
120:Learn how and when to remove this message
804:
802:
753:
751:
1000:Proprietary database management systems
895:, a recognized international user group
747:
512:For hashed files, a U2 system uses a
147:focuses too much on specific examples
7:
58:adding citations to reliable sources
717:Web-based applications for U2 data
25:
677:JSON (JavaScript Object Notation)
639:Both UniVerse and UniData have a
649:Client Tool interfaces include:
419:vertical application development
136:
34:
706:Rocket U2 Application Developer
45:needs additional citations for
709:Rocket UniVerse Administration
395:U2 Web Development Environment
347:. Both of these products are
1:
712:Rocket UniData Administration
409:terminal emulation software.
449:) file that contains every
374:. The family also includes
1051:
700:professional certification
694:Professional certification
27:Database management system
796:page 1-3, Rocket Software
784:page 1-3, Rocket Software
641:structured BASIC language
236:
210:
181:
847:, International Spectrum
177:Rocket U2 Product Family
659:UniOLEDB - OLEDB Driver
597:123-45-6789^JOHN JONES^
569:123-45-6789^JOHN JONES^
382:technologies including
698:RocketU2 offers three
349:operating environments
1035:Divested IBM products
821:'Informix Definition'
732:Pick operating system
485:Files are similar to
372:Pick operating system
351:which run on current
223:; 2 years ago
859:, Rocket Corporation
391:SB+ or SystemBuilder
339:database platforms:
153:improve this article
54:improve this article
869:'U2 Certifications'
809:'Ardent Definition'
770:'U2 Product Matrix'
758:'U2 Product Family'
491:relational database
335:. It includes two
329:database management
178:
1020:Database companies
1015:Big data companies
937:Historical entries
564:Thus this string:
388:sometimes known as
987:
986:
974:Folio Corporation
964:SystemBuilder/SB+
871:, Rocket Software
835:, Rocket Software
760:, Rocket Software
668:UniObjects (Java)
665:UniObjects (.NET)
656:Intercall (C/C++)
514:hashing algorithm
366:. They are both
364:operating systems
318:
317:
174:
173:
130:
129:
122:
104:
16:(Redirected from
1042:
923:
916:
909:
900:
889:
888:
886:Official website
872:
866:
860:
854:
848:
842:
836:
830:
824:
818:
812:
806:
797:
791:
785:
779:
773:
767:
761:
755:
662:UniObjects (COM)
604:
573:
432:System structure
314:
311:
309:
231:
229:
224:
186:
179:
169:
166:
160:
140:
139:
132:
125:
118:
114:
111:
105:
103:
62:
38:
30:
21:
1050:
1049:
1045:
1044:
1043:
1041:
1040:
1039:
1010:NoSQL companies
990:
989:
988:
983:
932:
930:Rocket Software
927:
884:
883:
880:
875:
867:
863:
855:
851:
843:
839:
831:
827:
819:
815:
807:
800:
792:
788:
780:
776:
772:Rocket Software
768:
764:
756:
749:
745:
728:
719:
696:
687:
674:U2 Web Services
637:
635:Programmability
625:
546:
526:
524:Nonhashed files
510:
483:
439:
434:
415:
333:Rocket Software
306:
232:
227:
225:
222:
203:Initial release
197:Rocket Software
170:
164:
161:
150:
141:
137:
126:
115:
109:
106:
63:
61:
51:
39:
28:
23:
22:
15:
12:
11:
5:
1048:
1046:
1038:
1037:
1032:
1027:
1025:Data companies
1022:
1017:
1012:
1007:
1005:1990s software
1002:
992:
991:
985:
984:
982:
981:
976:
971:
966:
961:
956:
951:
946:
940:
938:
934:
933:
928:
926:
925:
918:
911:
903:
897:
896:
890:
879:
878:External links
876:
874:
873:
861:
857:'Client Tools'
849:
837:
825:
813:
798:
786:
774:
762:
746:
744:
741:
740:
739:
734:
727:
724:
718:
715:
714:
713:
710:
707:
695:
692:
686:
683:
682:
681:
678:
675:
672:
669:
666:
663:
660:
657:
654:
636:
633:
624:
621:
606:
605:
575:
574:
545:
542:
525:
522:
509:
506:
482:
479:
438:
435:
433:
430:
414:
411:
316:
315:
308:rocketsoftware
304:
300:
299:
294:
288:
287:
282:
276:
275:
262:
256:
255:
242:
238:
237:
234:
233:
220:
218:
216:Stable release
212:
211:
208:
207:
204:
200:
199:
194:
188:
187:
172:
171:
144:
142:
135:
128:
127:
110:September 2014
42:
40:
33:
26:
24:
14:
13:
10:
9:
6:
4:
3:
2:
1047:
1036:
1033:
1031:
1028:
1026:
1023:
1021:
1018:
1016:
1013:
1011:
1008:
1006:
1003:
1001:
998:
997:
995:
980:
977:
975:
972:
970:
967:
965:
962:
960:
957:
955:
952:
950:
947:
945:
942:
941:
939:
935:
931:
924:
919:
917:
912:
910:
905:
904:
901:
894:
891:
887:
882:
881:
877:
870:
865:
862:
858:
853:
850:
846:
841:
838:
834:
829:
826:
822:
817:
814:
811:, PC Magazine
810:
805:
803:
799:
795:
790:
787:
783:
778:
775:
771:
766:
763:
759:
754:
752:
748:
742:
738:
735:
733:
730:
729:
725:
723:
716:
711:
708:
705:
704:
703:
701:
693:
691:
684:
679:
676:
673:
670:
667:
664:
661:
658:
655:
652:
651:
650:
647:
644:
642:
634:
632:
630:
622:
620:
618:
614:
609:
602:
599:
595:
594:
593:
589:
585:
583:
579:
571:
567:
566:
565:
562:
560:
555:
550:
543:
541:
539:
535:
531:
523:
521:
519:
515:
507:
505:
503:
498:
496:
492:
488:
480:
478:
476:
472:
468:
464:
460:
456:
452:
448:
444:
436:
431:
429:
426:
424:
420:
412:
410:
408:
404:
401:connectivity
400:
396:
392:
389:
385:
381:
377:
373:
369:
365:
362:
358:
354:
350:
346:
342:
338:
334:
330:
326:
322:
313:
305:
301:
298:
295:
293:
289:
286:
283:
281:
277:
274:
270:
266:
263:
261:
257:
254:
250:
246:
243:
239:
235:
219:
217:
213:
209:
205:
201:
198:
195:
193:
189:
185:
180:
168:
165:February 2015
158:
154:
148:
145:This article
143:
134:
133:
124:
121:
113:
102:
99:
95:
92:
88:
85:
81:
78:
74:
71: –
70:
66:
65:Find sources:
59:
55:
49:
48:
43:This article
41:
37:
32:
31:
19:
943:
864:
852:
840:
828:
816:
789:
777:
765:
720:
697:
688:
648:
645:
638:
629:grouped data
626:
610:
607:
590:
586:
576:
563:
551:
547:
527:
511:
508:Hashed files
499:
484:
469:, and other
440:
427:
416:
406:
398:
394:
387:
380:web-enabling
344:
340:
320:
319:
251:, UniBasic,
192:Developer(s)
162:
151:Please help
146:
116:
107:
97:
90:
83:
76:
64:
52:Please help
47:verification
44:
823:PC Magazine
653:ODBC / JDBC
617:MultiValued
603:^432100^...
572:^432100^...
530:source code
368:derivatives
297:Proprietary
69:"Rocket U2"
994:Categories
959:DataMirror
954:Aldon Inc.
671:Native XML
619:database.
613:outer join
538:plain text
518:record IDs
447:vocabulary
407:wIntegrate
399:UniObjects
337:MultiValue
285:MultiValue
241:Written in
228:2022-01-07
155:by adding
80:newspapers
949:Model 204
944:Rocket U2
397:(WebDE),
376:developer
321:Rocket U2
969:AeroText
726:See also
685:Security
502:metadata
471:pointers
455:filename
437:Accounts
423:Informix
345:UniVerse
260:Platform
979:OpenKBM
737:Reality
544:Records
495:records
459:keyword
451:command
413:History
370:of the
361:Windows
341:UniData
303:Website
292:License
273:Windows
226: (
94:scholar
559:fields
487:tables
467:script
253:Python
96:
89:
82:
75:
67:
18:IBM U2
1030:NoSQL
743:Notes
554:ASCII
489:in a
481:Files
463:alias
443:files
384:SB/XA
357:Linux
325:suite
323:is a
265:Linux
101:JSTOR
87:books
893:U2UG
623:Data
582:Pick
475:user
405:and
378:and
359:and
353:Unix
343:and
310:.com
280:Type
269:Unix
206:1987
73:news
536:or
534:XML
403:API
393:),
327:of
312:/u2
249:C++
56:by
996::
801:^
750:^
532:,
477:.
465:,
461:,
457:,
453:,
355:,
271:,
267:,
247:,
922:e
915:t
908:v
600:]
386:(
245:C
230:)
167:)
163:(
159:.
149:.
123:)
117:(
112:)
108:(
98:·
91:·
84:·
77:·
50:.
20:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.